Subject | Executing A String |
---|---|
Author | Anand |
Post date | 2003-08-06T08:29:26Z |
I am writing a stored procedure in a FireBird 1.0 database,
where I am trying to accept values for all the fields in a
table, and then either insert a new record or update the
existing record based on the primary key field value. In this
regard, I need to maintain a string variable in which I shall
maintain an SQL string, and at the end of a few checks, I need
to execute this string. Is there any way I can do this in the
Stored Procedure?
Thanks in advance for any tips and suggestions,
Anand.
__________________________________
Do you Yahoo!?
Yahoo! SiteBuilder - Free, easy-to-use web site design software
http://sitebuilder.yahoo.com
where I am trying to accept values for all the fields in a
table, and then either insert a new record or update the
existing record based on the primary key field value. In this
regard, I need to maintain a string variable in which I shall
maintain an SQL string, and at the end of a few checks, I need
to execute this string. Is there any way I can do this in the
Stored Procedure?
Thanks in advance for any tips and suggestions,
Anand.
__________________________________
Do you Yahoo!?
Yahoo! SiteBuilder - Free, easy-to-use web site design software
http://sitebuilder.yahoo.com