Relational view to VB program
Posted: Fri Aug 07, 2009 11:29 am
by Shameer >> Thu, 18 Sep 2003 10:29:10 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 Security Info=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
Please help to solve...Thanks in advance ...cheers
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 Security Info=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
Please help to solve...Thanks in advance ...cheers