TSQLDataSet with paramters

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

Article #129

Back to borland.public.cppbuilder.database.dbexpress Previous Next

#129

From: 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

Technical Details

Message-ID: <41fdba7d@newsgroups.borland.com>

Path:

arc1-ca.pugleaf.net!g2news1.google.com!news3.google.com!news.glorb.com!logbridge.uoregon.edu!newsfeeds.ihug.co.nz!ihug.co.nz!newsgroups.borland.com!not-for-mail

Show Full Headers

Complete Article Headers

X-Google-Thread: fb4e2,c4188cb7f7991ef2,start
X-Google-Attributes: gidfb4e2,public
X-Google-Language: ENGLISH,ASCII-7-bit
Reply-To: "David" <david.boyd@studentmail.newcastle.edu.au>
From: "David" <david.boyd@studentmail.newcastle.edu.au>
Newsgroups: borland.public.cppbuilder.database.dbexpress
Subject: TSQLDataSet with paramters
Date: Mon, 31 Jan 2005 15:56:27 +1100
Lines: 32
X-Priority: 3
X-MSMail-Priority: Normal
X-Newsreader: Microsoft Outlook Express 6.00.2900.2180
X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2900.2180
X-RFC2646: Format=Flowed; Original
NNTP-Posting-Host: 203.12.146.18
Message-ID: <41fdba7d@newsgroups.borland.com>
X-Trace: newsgroups.borland.com 1107147389 203.12.146.18 (30 Jan 2005 20:56:29 -0800)
Path: arc1-ca.pugleaf.net!g2news1.google.com!news3.google.com!news.glorb.com!logbridge.uoregon.edu!newsfeeds.ihug.co.nz!ihug.co.nz!newsgroups.borland.com!not-for-mail