General information
Category:
Databases,Tables, Views, Indexing and SQL syntax
>Why don't you post the SQL code you are trying to render to Access?
>
>In VFP, you have more freedom than you should when it comes to ordering different parts of a SQL Statement. Other environments, like Access and SQL Server, are more strict.
I do not think the IIF statement works in Access either.... which i like to use in the denormalized mess of a database i must work with....
I am not sure what you mean by 'post'
I issue an SQLSTRINGCONNECT() command to connect to the .mdb
m.lnHandle = SQLSTRINGCONNECT(m.lcConnectionString)
m.lnResult = SQLEXEC(m.lnHandle,"SELECT blah blah","AccessResult")
I'd just like to know the syntax of the SQL SELECT statement when it is sent to an Access97 .mdb backend.
Thanks...
Previous
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