Forums

by shameer >> Fri, 19 Sep 2003 4:46:42 GMT

we have created relational view(RV) for jade DB,and we need to extract the some date from the jade DB(version 5.2) from our VB 6 program.we can able to get the connection to the Jade RV and we can access the tables but we are facing some Peculiar problem :-

Table A :-

amt amtCurrency batchNumber
138.38 0 4
-1252385.45 0 5
-51662.65 0 5


Query:-

query = "SELECT A.amt , A.batchNumber FROM A WHERE batchNumber =5"


VB program using ADO:-

conn.ConnectionString = "DRIVER ={JADE ODBC Driver 5.2};Persist SecurityInfo=False;User ID=sa;DSN=JADERV"
conn.open
rs.Open query, conn, 3, 2

we are geting the resultset with no records in it, when we remove the amt filed from the query like

query = "SELECT A.batchNumber FROM A WHERE batchNumber =5"

we can see the record set with 2 records in it .

This problem occurs if only amt field included in the query,otherwise its fine.

Please suggest .... as we need the amt column in query....while Jade RV creation the amt field/class is included and inside Jade Class amt property is Decimal as mentioned below:-

Name: amt (8)
Class: ABC
Type: Decimal
Access: readonly (0)
non-virtual embedded
Length: 16
Scale Factor: 2


we can see this amt field from crystal reports and with MS Acesses Database Link....

Please help to solve...Thanks in advance ...cheers