executeSQL in Paraodx 7 
Author Message
 executeSQL in Paraodx 7

Quote:

> I used to use executeSQL(database, TCursor) method to retrieve
> a SQL Server table in Paradox 5 and it worked well.
> Now I purchased Paradox 7 Client/Server Edition for NT, but
> this statement failed to access SQL Server, the error message
> showed that the table can not be found. But it can access a
> local Paradox table.
> If anyone can tell me the reason? Thans in advance.

> Jiayong



Try using table names, index names and fields names in UPPER
case, because version 7 is now case-sensitive for SQL calls.


Sat, 16 Oct 1999 03:00:00 GMT
 executeSQL in Paraodx 7

I used to use executeSQL(database, TCursor) method to retrieve
a SQL Server table in Paradox 5 and it worked well.
Now I purchased Paradox 7 Client/Server Edition for NT, but
this statement failed to access SQL Server, the error message
showed that the table can not be found. But it can access a
local Paradox table.
If anyone can tell me the reason? Thans in advance.

Jiayong




Sun, 17 Oct 1999 03:00:00 GMT
 
 [ 2 post ] 

 Relevant Pages 

1. Win95 Refresh problem with TQuerys on Paraodx

2. Why does my Paraodx app call OBDC?

3. ODBC driver for Paraodx for Windows 1

4. HELP NEEDED ON OBJECT PAL PARAODX 1.0

5. Multiple task in ExecuteSql Task

6. Global Variables + paramters in an ExecuteSQL task

7. Error using parameters in ExecuteSQL task

8. CDatabase->ExecuteSQL() returns nothing??????

9. ExecuteSQL task called from within DataTransformationTask

10. ExecuteSQL / ODBC API does not return row count

11. Sp in an ExecuteSQL Task

12. Access Global Variables from an ExecuteSQL Task


 
Powered by phpBB® Forum Software