MSSQL - How to call store procedure

Hi to all!

If I wrote my query inside Xojo It works well but can you explain me how can I call a MS SQL store procedure?

Thanks in advance,

I suggest reading here and here if you are using ODBC.

If you are using ADODB, this old VB6 tutorial will largely be applicable with Xojo.

I assume that you already created your procedure using MS SQL Server Management Studio or other similar tool and you already tested it to work.

Does the procedure return result rows or not ?
If it returns results use SQLSelect - seems odd but this really is “execute this & get result rows”
If not use SQLExecute
Your query would be the normal “exec …” syntax

Thanks a lot !!