Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
SQL - Like
Message
From
29/10/1999 13:44:27
Joao Godinho
Fredesenvolv, Lda
Lisbon, Portugal
 
 
To
All
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Title:
SQL - Like
Miscellaneous
Thread ID:
00283960
Message ID:
00283960
Views:
58
Olá !!

I create o connectin to mymdb.mdb and it work perfectly, but i want to do something like this

_like_find = '"*EUREKA*"'
_sql = "select name from censos where censos.name like ?_like_find"

myconnection = SQLCONNECT("regifreg")
= SQLPREPARE(myconnection, _sql, "c_regifreg")
_d = SQLEXEC(myconnection)

the cursor c_regifreg is eof()
what´s wrong in the sql like clause???

Thank you all
Next
Reply
Map
View

Click here to load this message in the networking platform