Information générale
Catégorie:
Codage, syntaxe et commandes
If you get this you need to break up your sql into 2 SQL statements making sure they each contain a unique id. Then combine them into one table.... SELECT temp1.* , temp2.* FROM temp1, temp2 WHERE temp1.uniqueid = temp2.uniqueid INTO CURSOR final.
above is most likely does not have the correct syntax...but you should get the idea. I had to do this one time for a report where there werent too many fields but the string itself exceed some limit because each field had to be prefaced with tablename and was written 'tablename.fieldname AS resultname' because i was doing a UNION.
If you cant get it to work...post the actual SQL also what version of Foxpro???
Glenn
Précédent
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