Hi all,
I'm having problems getting a stored procedure to work in Visual
Studio 2005 Pro. Have managed to get basic queries working, but no
luck with a very simple stored proc...
SET TERM ^ ;
ALTER PROCEDURE "SurnamesContaining"
(
Txt VARCHAR(100)
)
RETURNS
(
"NameId" INTEGER,
"Name" VARCHAR(100),
"Prob" FLOAT,
"Rank" INTEGER
)
AS
BEGIN
FOR select "NameId", "Name", "Prob", "Rank"
from "Surnames"
where "Name" containing :"Txt"
into :"NameId", :"Name", :"Prob", :"Rank"
DO
BEGIN
SUSPEND;
END
END
^
SET TERM ; ^
I've added a fill method for the the stored procedure using the visual
data designer. I know the stored proc works and that visual studio is
able to run it because if I right click on "Preview data" I can run
the stored proc and see that it returns the correct results.
(Screenshot of data preview:
http://logicalgenetics.com/assorted/upload/namesprev.png)
But when I run the following code in my application...
---
namesDataset.SurnamesDataTable ndt = new namesDataset.SurnamesDataTable();
surnamesTableAdapter.FillBySurnameContaining(ndt, "TAY");
---
...it throws a firebird -206 dynamic SQL exception claiming that
column TXT is unknown.
Has anyone got any ideas what I'm doing wrong? Please help!
Dan
--
Dan Taylor BSc MIET
Software Development Engineer
PhD Student, Heriot Watt University, UK
http://www.logicalgenetics.com
-------------------------------------------------------------------------
Using Tomcat but need to do more? Need to support web services, security?
Get stuff done quickly with pre-integrated technology to make your job easier
Download IBM WebSphere Application Server v.1.0.1 based on Apache Geronimo
http://sel.as-us.falkag.net/sel?cmd=lnk&kid=120709&bid=263057&dat=121642
_______________________________________________
Firebird-net-provider mailing list
[email protected]
https://lists.sourceforge.net/lists/listinfo/firebird-net-provider
