USING {PROP:SQL} with TPS files

[newtoclarion]

Hello everybody

is it possible to use {PROP:SQL} with TPS file to run SQL statements using TPS files instead of SQL to find sums, counts,max,.... etc.



thanx

 

[ShankarJ]

Hi!

No. You cannot. To use SQL against TPS files you need to access those files using the ODBC database driver in Clarion and have the Topspeed ODBC Driver installed (

http://softvelocity.com/Drivers/TSODBC.htm).

A Developer edition of TSODBC does ship with the Clarion EE edition but it does not install itself automatically since C6 and there is no separate installer for that.

Regards