Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Select not going into cursor specified
Message
 
 
À
18/04/2008 10:13:28
Information générale
Forum:
Visual FoxPro
Catégorie:
Codage, syntaxe et commandes
Versions des environnements
Visual FoxPro:
VFP 8 SP1
OS:
Windows 2000 SP4
Database:
Visual FoxPro
Divers
Thread ID:
01311654
Message ID:
01311681
Vues:
23
Or just use PRETEXT 15 instead of PRETEXT 7.

>Or addd one line of code to replace CRLF with a space
>
>TEXT TO lcstrsql TEXTMERGE NOSHOW PRETEXT 7
>      SELECT * from <<lcTable>>
>        ORDER BY <<lcTag>> <<lcDirection>>
>        INTO CURSOR <<lcNTable1>> nofilter
>ENDTEXT
>lcstrsql = STRTRAN(lcstrsql, CHR(13)+ CHR(10), SPACE(1))
>&lcstrsql.
>
>
>>Missing a ";" at the end of each lines:
TEXT TO lcstrsql TEXTMERGE NOSHOW PRETEXT 7
>>      SELECT * from <<lcTable>>;
>>        ORDER BY <<lcTag>> <<lcDirection>>;
>>        INTO CURSOR <<lcNTable1>> nofilter
>>ENDTEXT
>>&lcstrsql
>I have a select statement that is working off of a readwrite cursor that I created. I build the select statement within a Text...endText statement like this:
Rick Borup, MCSD

recursion (rE-kur'-shun) n.
  see recursion.
Précédent
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform