When you pass an argument to SQL SP
you can do it this way (other ways will work too)
PRIVATE ln_vehiclekey,
ln_vehiclekey = 1
iResult = ;
SQLEXEC(._iSQLConnHandle,"EXEC sp_GetVehicle ?ln_vehiclekey", "curresult")
>This code:
>
>
>
>iResult = SQLEXEC(._iSQLConnHandle, [EXEC sp_GetVehicle @vehiclekey=1], sTableName)
>
>
>generates the error "Could not find stored procedure 'EXEC sp_GetVehicle @vehiclekey=1'"
>
>I can run this from SQL console:
>
>
>EXEC sp_GetVehicle 1
>
>
>
>Anyone know what I'm doing wrong?
>
>Thanks
Anyone who does not go overboard- deserves to.
Malcolm Forbes, Sr.