James-
This works great but this would seem to advocate using textmerge instead of SPT parameters.
Dan
>Dan,
>
>I have not worked with MySql but I have done a lot of work with Sybase ASA. I was curious if the following made a difference?
>
>
> lcSql = textmerge("Select * From User Where UserId = <<pnUserId>>")
>
>
>
>>I'm using parameters but I am finding some disturbing quirks w/MySql and Fox.
>>
>>Take the following simple query.
>>
>>Select * From User Where UserId = ?pnUserId
>>
>>
>>This works in most cases but not all.
>>In one case when the user id is 253 it will not bring down a record.
>>
>>But if I change the code to this:
>>
>>Select * From User Where UserId = Cast( ?pnUserId As Signed )
>>
>>
>>This works every time but this is a PITA to add to all integer parameters.
>> snip >>