Problem with date when calling a store procedure 1

[Lekar]

I'm connecting to MS SQL Server and there is a store procedure that returns a value using an output variable.
I declared the store procedure in the Local External
Functions of a Transaction object.
Where PB calls the store procedure, PB changes the month and the day. Here is an example:

// On the PB debugger, ldt_Fec has
// the value: '2006-Feb-05'

SQLCA.proc_NewInvoic(ldt_Fec, lde_CodInv)

On the Profiler after the previous sentence:

Exec proc_NuevaFact 'May 2 2006', 0

I've changed the Control Panel, also I've execute "Set DateFormat" in my PB program but the problem persists. If I run Exec proc_NuevaFact 'Feb 5 2006', 0 from the Query Analyzer it works.
Anyone has a suggestion?

 

[mbalent]

Forget the output variable. Send the date back in a result set.

Matt

"Nature forges everything on the anvil of time

 

[Lekar]

That's a great idea. I used a DataWindow. Thanks mbalent.