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
Next
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only