Python and Clarion (Soft Velocity)
ODBC
ceODBC supports: Clarion, TopSpeed Data files (.tps) via TopSpeed ODBC Driver Ver. 5.00.00.05
python and clarion odbc
db=ceODBC.Connection("DSN=SOMENAME",autocommit=True)
Design - not to
- Stay away from dim fields. Mysql database does not support dimension fields so if you start your code without dimension fields you will be better off. Try using groups instead.
Convert Clarion app from tps to Mysql
- There are some performance issues when it comes to moving from tps to mysql and how the browse windows access the data. The browse statements will beed to be converted to sql in order to take adventage of sql select statements
Clarion if used in tps style will use 100% cpu to get all the record, then filter them internally, instead of using select *... where SOME_CONDITIONS
