>>>Thanks, Larry. That's good to know. Any idea why Fox tables don't just do the same?
>>
>>Not sure why. It's just one of the many (sometimes PITA) differences from VFP SQL and SQL Server SQL. And we won't even go near Oracle SQL.
>
>I've really got to start compiling a list of these "gotcha's". We've already taken the step of breaking down all of our SELECTS into it's component parts (WHERE, ORDER BY, JOIN, etc.) so we can construct a syntactically correct SQL statement as needed through our SQL object. I guess there's just no way to write a generic SQL statement that works for all back-ends. :(
>So much for the "SQL Standard". HA!
A friend of mine did something similar. His data object takes a SQL command embedded in an XML string and then translates that into whatever back-end they happen to be connected to today and sends it on.
Larry Miller
MCSD
LWMiller3@verizon.netAccumulate learning by study, understand what you learn by questioning. -- Mingjiao