Page 1 of 1

ODBCDBE Problem with Alias

Posted: Tue Aug 07, 2012 8:38 am
by rdonnay
The Alaska ODBCDBE docs imply that the function DbUseArea() or the USE command can be used with the ODBCDBE, however I cannot make this work with a SQL SELECT statement.

I need to be able to assign an Alias() to a result set.
The only function that seems to allow a SQL SELECT statement is the following:

SqlStmtExec( cSQLStatement, oSession,,,.F.)

The function SqlStmtExec() is not documented.

Does anyone have experience with the ODBCDBE?