I'm trying to do a SQL select statement through VFP but keep getting the error message SQL: 'Column 'confirmed' is not found'. The field 'confirmed' does exist in my table and the table is open, the alias is right. I don't understand what's wrong. Is confirmed a reserved word in SQL? Should I just change the field name? Here is the exact code that generates the error:
SELECT * ;
FROM _cdarest ;
WHERE !DELETED() ;
GROUP BY prospectid, clinkflag, addr_num, predir, addr_name, addr_unit ;
ORDER BY confirmed, LEFT(matchtype, 1) ;
INTO TABLE _uniq
Thanx, SETH
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