I m using SQL as backend and VB as front end.
Earlier I used MS Access as backend in this project I hv written two queries, both is executing succesfully while I m using in forms loading
1. DataEnvironment1.rsOPDINCOME.Open "SELECT * FROM OPD WHERE OPDDATE =#" & DTPicker1.Value & "# ORDER BY CASENO", CON, adOpenDynamic, adLockOptimistic
2. DataEnvironment1.rsOPDINCOME.Open "SELECT * FROM OPD WHERE OPDDATE BETWEEN # " & DTPicker2.Value & " # AND # " & DTPicker3.Value & " #", CON, adOpenDynamic, adLockOptimistic
But now as I m using SQL as backend, this both query is not running, it shows "Invalid Identifier".
I m in urgent need of solution for this today, so please reply to me immediately
I will be thankful to u. Pleaseeeeeeeeeee
2007-04-13
20:39:32
·
1 answers
·
asked by
PRACTICAL
2