Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Why doesn't this work?
Message
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:
01138265
Vues:
11
>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...
See corrected 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 ts < "+TTOC(settings.lastupdate,1), "remote_cursor")
*** Should here we use {} ??

**! Compare the two tables & eliminiate 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 :^).
If it's not broken, fix it until it is.


My Blog
Précédent
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform