>I think that the main reason they are using parameters that it's more generic approch and doesn't required converting parameters into string to build SQL.
>
>What VFP OLE DB provider are you using? Try one from VFP8beta.

We are not using VFP8 we are using VFP7. Is the OleDb for VFP 8 compatible with VFP 7? IF so can it be downloaded and installed separatly?


>
>>>Your version wouldn't work w/o correction

lcSql = [SELECT User.* FROM User WHERE Usrname LIKE '] + tuUsrname + [']

It explicitly uses single quote as string literal delimiter which may or may not work with all backends.
>>
>>
>>So what you are saying is the PARAMETERS.APPEND is used because it is more compatible with a variety of backends (VFP, Oracle, SQL)?
>>
>>What I have found is that using a VFP backend and OLEDB the PARAMETERS.APPEND does not work with an Integer Parameter. The COMCodeBook example uses:
>>
>>

>>  FUNCTION GetUserByUsrkey( tuUsrkey )
>>    *-----------------------------------------------------
>>    LOCAL loADO, lcSql
>>    loADO = THIS.GetADOAggregateParameter()
>>    WITH loADO.oCommand
>>      .ActiveConnection = loADO.oConnection
>>
>>      ***********************************
>>      .CommandText = [SELECT User.* FROM User WHERE UsrKey = ? ]
>>
>>      *-- CONSTRUCT YOUR PARAMETER(S)
>>      .PARAMETERS.APPEND(.CreateParameter( "UsrKey", adInteger, adParamInput, ,tuUsrkey ))
>>      ***********************************
>>    ENDWITH
>>
>>    THIS.ExecuteSQLQuery( loADO )
>>    RETURN loADO.oRecordSet
>>
>>  ENDFUNC

>>
>
>>But using OleDb the great error:
>
>>Error in USER::GETUSERBYUSRKEY() Line 85
>>Error Number: 1429
>>
>>1429
>>OLE IDispatch exception code 1429 from UserDataSource: ~Error: 1429 Line: 129 UserDataSource::Executesqlquery() OLE IDispatch exception code 0 from Microsoft OLE DB Provider for Visual FoxPro: Index does not accept NULL.....
>>~Error: 1429 Line: 129 UserDataSource::Executesqlquery() OLE IDispatch exception code 0 from Microsoft OLE DB Provider for Visual FoxPro: Index does not accept NULL...
>>UserDataSource
>>UserDataSource
>>0
>>1429