Compatibility between wwSQL and wwADOSql

The two classes are designed to be interchangeable so you can switch as needed. However, there are a few things that work slightly differently in terms of VFP Sql Passthrough SQL syntax.

Most syntax should work fine with either class. The exception are stored procedure calls which with wwADOSql require explicit parameter passing or parsing.

The following will work with wwSQL but not with wwADOSql:

oSQL.Execute("exec sp_NewId 'wws_tlineitems',?@pnId)

Instead Store Procedure calls should be made with Named parameters and a call to CallStoredProcedure:

oSQL.AddParameter('wws_LineItems','cTable')
oSQL.AddParameter(pnId,'pnID')

Specifically Stored Procedure calls with ADO require that you use the CallStoredProcedure


  Last Updated: 4/30/2008 | © West Wind Technologies, 2008