TSQLDataSet with paramters

Thread View: borland.public.cppbuilder.database.dbexpress

1 messages

[T] Back to Threads [V] Tree View [G] Group Articles

1 total messages Started by David Mon, 31 Jan 2005 04:56

#129

Author: David
Date: Mon, 31 Jan 2005 04:56

30 lines
1643 bytes

Hello all,

i am trying to work with a tsqldataset component as a stored procedure

I have SQL Server as my backend databsae.

the weird thing is if in the command text i have
mySPname parm1,parm2 etc it works no worries

then when i try to set the paramters in the params (TParmams) and then try 
call the ExecSQL() i get the error

odbcsqlsate:42000
native error code :201

procedure 'insertIntoBuild'expects paramter '@minorbuild' , which was not 
supplied.

sql:
insertIntoBuild;1

Paramtesr
1 OUTPUT   (...which is the @RETURN_VALUE parm)
2 INPUT INTEGER: 66(value i gave it)

... and so on


anyone know what might cause this or anywhere that can tut me through 
setting up the params? incase i did it wrong

Thread Navigation

This is a paginated view of messages in the thread with full content displayed inline.

Messages are displayed in chronological order, with the original post highlighted in green.

Use pagination controls to navigate through all messages in large threads.

Back to All Threads