Hi!

For some reason, I did not managed to make "ad-hoc" work in VFP. I do not remember what the cause was, but I remember that we solved problem by creating a custom message. I do not know SQL Server adminitrsation well, so I can suppose it was SQL Server configuration problem, though I have nothing to prove it < s >

Thanks anyway for this note.

>>Try to do not use RaiseError command in SP, or prepare everything required for it. Accordingly to SQL Server help on RaiseError command, you require to create a custom error first, and then use RaiseError o raise that custom error.
>
>Not true. RAISERROR will allow you to specify an ad-hoc message or reference an error message created with sp_addmessage.