Information générale
Catégorie:
Codage, syntaxe et commandes
>>SELECT *FROM mytable WHERE mytable.ctitle LIKE '%'+cname+'%' into cursor temp.
>>This always creates a cursor with 0 records. The same code executed outside of the form from a .prg works fine. Could someone please tell me how to get it to work?
>
>Is cursor temp already taken in your form?
>
>You don't have a space after *.
>
>Have you tried SELECT * FROM MYTABLE WHERE CTITLE=CNAME INTO CURSOR TEMP?
Forgive me if this is a repeat, I didn't see my last reply...
I have not used cursor temp anywhere in the form.
What I'm trying to do is retrieve all records that match a word. If the user enters 'John', and the ctitle looks something like 'this is test data
(sybil,john,sue)' it should put it in the cursor. Thats the reason I'm using '%'+cname+'%'. % is a wild card, yes? This works great outside of the form from a .prg but doesn't from the page. Is this a bug?
Précédent
Suivant
Répondre
Voir le fil de ce thread
Voir le fil de ce thread à partir de ce message seulement
Voir tous les messages de ce thread
Voir tous les messages de ce thread à partir de ce message seulement