firebird-support - RE: [firebird-support] Newbie on SPs: HELP ON STORED PROCEDURE

Subject	RE: [firebird-support] Newbie on SPs: HELP ON STORED PROCEDURE
Author	Carol Milius
Post date	2005-02-03T11:54:03Z

Well,

I was using firebird 1.5.0 and updated to 1.5.2 and now it is wornig..
I really dont know if the error was mine or not.. bu, anyways.. thanks for the tip!

Best Regards,

Carol M.

On Tue, 1 Feb 2005 15:09:44 -0600, "Clay Shannon" <cshannon@...> escreveu:

> De: "Clay Shannon" <cshannon@...>
> Data: Tue, 1 Feb 2005 15:09:44 -0600
> Para: <firebird-support@yahoogroups.com>
> Assunto: RE: [firebird-support] Newbie on SPs: HELP ON STORED PROCEDURE
>
> <html><body><tt>Carol, <error is reported (parser error) The cursor is placed after the number 1 in the first select statement..>> I don't know if that's an IB Expert problem or what. I use Database Workbench (an awesome product) and this: SELECT 1 FROM rdb$database WHERE EXISTS (SELECT 1 FROM CAREGIVERS WHERE ID = 0) works fine for me in the script editor. In the above case, I get an empty result set, because my lowest ID val in that table is 2. If I change the "=" to a "<>", I get a result of "1". Clay Shannon, Dimension 4 Software -----Original Message----- From: Carol Milius [mailto:lista@...] Sent: Tuesday, February 01, 2005 2:32 PM To: firebird-support@yahoogroups.com Subject: RE: [firebird-support] Newbie on SPs: HELP ON STORED PROCEDURE hi Clay, Thanks for the tip! I am using IB Expert personal edition and when I try to compile de SP, an error is reported (parser error) The cursor is placed after the number 1 in the first select statement.. thank again! Carol. >BTW, didn't you used to work with Bob what's... No. On Tue, 1 Feb 2005 13:40:22 -0600, "Clay Shannon" <cshannon@...> escreveu: > De: "Clay Shannon" <cshannon@...> > Data: Tue, 1 Feb 2005 13:40:22 -0600 > Para: <firebird-support@yahoogroups.com> > Assunto: RE: [firebird-support] Newbie on SPs: HELP ON STORED PROCEDURE > > <html><body><tt><exists.>> Carol, Try something like this: SELECT 1 FROM rdb$database WHERE EXISTS (SELECT 1 FROM <a table> WHERE <conditions>) If result = 1, the record exists; otherwise, it doesn't. BTW, didn't you used to work with Bob what's-his-face on "Let's Make a Deal"? Clay Shannon, Dimension 4 Software -----Original Message----- From: Carol Milius [mailto:lista@...] Sent: Tuesday, February 01, 2005 12:58 PM To: firebird-support@yahoogroups.com Subject: [firebird-support] Newbie on SPs: HELP ON STORED PROCEDURE Hi! I am trying to make a SP to check if the record already exists. The SP below is something I am trying but it is not working.. I am reading de IB manuals but can not get an clear exemple.. Any coments are welcome (links too) Best Regards, Carol Input: IN_FIELDNAME, IN_TABLENAME, IN_FIELDVALUE Output: OUT_EXISTS Var: VAR_FIELDVALUE begin OUT_EXISTS = 'No'; For Execute Statement 'Select ' || IN_FIELDNAME || ' From ' || IN_TABLENAME Into :VAR_FIELDVALUE Do if (VAR_FIELDVALUE = IN_FIELDVALUE) Then OUT_EXISTS = 'Yes'; suspend; end Yahoo! Groups Links </tt> <tt><hr width="500">Yahoo! Groups Links <ul><li>To visit your group on the web, go to: <a href="<a href="http://groups.yahoo.com/group/firebird-support/">http://groups.yahoo.com/group/firebird-support/</a>"><a href="http://groups.yahoo.c">http://groups.yahoo.c</a> om/group/firebird-support/</a> <li>To unsubscribe from this group, send an email to: <a href="mailto:firebird-support-unsubscribe@yahoogroups.com?subject=Unsubscrib e">firebird-support-unsubscribe@yahoogroups.com</a> <li>Your use of Yahoo! Groups is subject to the <a href="<a href="http://docs.yahoo.com/info/terms/">http://docs.yahoo.com/info/terms/</a>">Yahoo! Terms of Service</a>.</ul></tt></body></html> Yahoo! Groups Links </tt> <tt><hr width="500">Yahoo! Groups Links <ul><li>To visit your group on the web, go to: <a href="http://groups.yahoo.com/group/firebird-support/">http://groups.yahoo.com/group/firebird-support/</a> <li>To unsubscribe from this group, send an email to: <a href="mailto:firebird-support-unsubscribe@yahoogroups.com?subject=Unsubscribe">firebird-support-unsubscribe@yahoogroups.com</a> <li>Your use of Yahoo! Groups is subject to the <a href="http://docs.yahoo.com/info/terms/">Yahoo! Terms of Service</a>.</ul></tt></body></html>