AVFP Sql Class

Topics: User Forum
Jul 11, 2012 at 6:44 AM

Hello Claude,
I took a complete RIA example (from IBM) using DojoToolkit and convert all php code to use AVFP as backend and it works flawlessly.
For the conversion I used dbf tables and now I want to go for MySQL.
I am using your AVFPSql Class but I miss an equivalent to SQLDISCONNECT. Don't you think is necessary this command?

What are the differences to use AVFPSql Class instead of foxpro SQLCONNECT and SQLEXEC commands?

Does AVFPSql has more properties besides Login, Cursor and Execute?

Regards and again congratulations for this excellent work.

Coordinator
Jul 15, 2012 at 3:48 AM
Edited Jul 15, 2012 at 3:48 AM

It's already in the Destroy method:

 

************************************************************************
* AVFPsql :: DESTROY
*********************************
PROCEDURE DESTROY
IF THIS.nsqlres = 0
    =SQLCancel(THIS.nsqlhandle)
ENDIF

IF THIS.nsqlhandle > 0
    =SQLDisconnect(THIS.nsqlhandle)
ENDIF
ENDPROC


other methods:

* AVFPsql :: LOGIN
* AVFPsql :: ERROR
* AVFPsql :: DESTROY
* AVFPsql :: Execute
* AVFPsql :: GetErrors
* AVFPsql :: SQLCancel