Thanks Martin.

It seems to return 1 when it went OK.

UPDATE: I seem to get an outright error (1466) if I code a bad handle (eg. 72)

cheers

>Hi Jim,
>
>If you send bad SQL command, the function return -1.
>If handle is invalid, the function return -2.
>
>MartinJ
>
>>The docs on SQLPREPARE say the return is numeric. Unfortunately, it doesn't say what, under which conditions (e.g. bad SQL or handle doesn't exist or all is OK).
>>
>>Does anyone know what it returns, in which cases????
>>
>>Thanks