Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Why doesn't this work?
Message
De
20/07/2006 19:21:53
 
Information générale
Forum:
Visual FoxPro
Catégorie:
Base de données, Tables, Vues, Index et syntaxe SQL
Versions des environnements
Visual FoxPro:
VFP 9 SP1
OS:
Windows XP SP2
Database:
MySQL
Divers
Thread ID:
01138247
Message ID:
01138267
Vues:
11
Lets start with something even simpler then the other's have suggested. You've posted a message to indicate there's an error on line 30, yet you've not supplied enough code to understand where line 30 is.

>When I try to build this code (that someone else wrote, I might add),
>VFP 9 SP1 comes back with: "Error in line 30: Command contains unrecognized
>phrase/keyword."
>
>Here's the code...
>
>
>USE m.lcTableName
>
>SELECT cmpid, ts, IsUpdated FROM m.lcTableName WHERE IsUpdated > 0 INTO CURSOR;
>local_cursor
>	
>**! Form retrieve from server list
>SQLEXEC(this.connhandle,"select cmpid, ts, IdDeleted from companies where; "+TTOC(settings.lastupdate,1)+" > ts", "remote_cursor")
>	
>
>**! Compare the two tables & elminiate depreciate matches
>	
>SELECT x.cmpid, x.ts AS ts_local y.ts AS ts_remote FROM local_cursor x LEFT JOIN; remote_cursor y ON x.cmpid = y.cmpid INTO CURSOR matches_cursor
>
>**! The SELECT command above is the line that nukes :^).
>
>After reading through the on-line help for SELECT and comparing syntax,
>I can't seem to see a problem with this code...or am I blind or something? :^)
>
>TIA,
>Randall

(On an infant's shirt): Already smarter than Bush
Précédent
Répondre
Fil
Voir

Click here to load this message in the networking platform