Visual Systems AB \(Martin Arvidsson\)
15-Mar-2006, 09:11 AM
Hi!
I'm getting an error 12305 when using the Send SQLSetArgument procedure.
Everything works just fine, until i set the parameters. I use Odbc version
2.2.
The MAX_ACTIVE_STATEMENTS is set to 0 (Zero)
My Stored proecedure is very simple, see below...
What could be wrong?
Regards
Martin
Code...
CREATE STORED PROCEDURE ChangeCustomerID (IN :NewCust INT, IN :OldCust INT);
Begin
Update Customers
Set Customers.ID = :NewCust
Where Customers.ID = :OldCust;
End;
Procedure OnClick
Handle hoSQLManager hdbc hstmt
Handle hoConnected
Object oSQLManager is a cSQLHandleManager
Move Self to hoSQLManager
end_object
Send SQLSetConnect of hoSQLManager "ODBC_DRV" "DSN=MarkBric10"
Get SQLConnect of hoSQLManager "" "" to hoConnected
// We have connection
if (hoConnected <> 0) begin
get SQLOpen of hoConnected to hstmt
// Connection to database was successfull
if (hstmt <> 0) begin
Send SQLSetProcedureName of hstmt "ChangeCustomerID"
Send SQLSetArgument of hstmt 1 "5" // New customer id
Send SQLSetArgument of hstmt 2 "3" // Old Customer ID
Send SQLCall of hstmt
send stop_box "We have lift off"
end
end
End_Procedure // OnClick
I'm getting an error 12305 when using the Send SQLSetArgument procedure.
Everything works just fine, until i set the parameters. I use Odbc version
2.2.
The MAX_ACTIVE_STATEMENTS is set to 0 (Zero)
My Stored proecedure is very simple, see below...
What could be wrong?
Regards
Martin
Code...
CREATE STORED PROCEDURE ChangeCustomerID (IN :NewCust INT, IN :OldCust INT);
Begin
Update Customers
Set Customers.ID = :NewCust
Where Customers.ID = :OldCust;
End;
Procedure OnClick
Handle hoSQLManager hdbc hstmt
Handle hoConnected
Object oSQLManager is a cSQLHandleManager
Move Self to hoSQLManager
end_object
Send SQLSetConnect of hoSQLManager "ODBC_DRV" "DSN=MarkBric10"
Get SQLConnect of hoSQLManager "" "" to hoConnected
// We have connection
if (hoConnected <> 0) begin
get SQLOpen of hoConnected to hstmt
// Connection to database was successfull
if (hstmt <> 0) begin
Send SQLSetProcedureName of hstmt "ChangeCustomerID"
Send SQLSetArgument of hstmt 1 "5" // New customer id
Send SQLSetArgument of hstmt 2 "3" // Old Customer ID
Send SQLCall of hstmt
send stop_box "We have lift off"
end
end
End_Procedure // OnClick