killunix
Beginner
Joined: 18 Nov 2007
Posts: 28
|
 Posted: Sun Oct 25, 2009 4:59 am
Database access question
|
hi,all.
I use the followling code access the MS acees database:
| Quote: |
#VAR Conn %comcreate("ADODB.Connection")
#CALL @Conn.Open("Provider=Microsoft.Jet.OLEDB.4.0;Data Source=D:\CMUDPro\forex\poem.mdb")
#VARIABLE rs @Conn.Execute( %concat( "SELECT poem FROM poem WHERE poem LIKE '%", @word1, "%' and poem LIKE '%", @word2, "%' and poem LIKE'%", @word3, "%' and poem LIKE '%", @word4, "%'"))
#ECHO The right answer is： @rs.GetString
|
It works correct.
But i need i can use the recoder to do other thing such as use :
| Code: |
aa=%len(@rs.GetString)
|
the cmud tell me "either bof or eof is true or the current record has been deleted"
How can i resove this question?
Thank you very much |
|
