Subject | Array and UDF |
---|---|
Author | blahclayton |
Post date | 2003-05-13T10:29:29Z |
I am trying to write a UDF in C to pass all the fields of different
tables as function parameters. e.g I may have a one table with 3
fields and another table with 5 tables and I want to call the same
udf function when an update occurs on either table.
Can I pass an array to a UDF using a trigger or stored procedure? How
do I declare the array in the stored procedure and pass the array in
udf?
If not can I achieve the same functionality using Blob's? If so does
anyone how I would add each field to the declared blob in the stored
procedure?
Any other Ideas and help would be much appreciated.
Thanks in Advance
tables as function parameters. e.g I may have a one table with 3
fields and another table with 5 tables and I want to call the same
udf function when an update occurs on either table.
Can I pass an array to a UDF using a trigger or stored procedure? How
do I declare the array in the stored procedure and pass the array in
udf?
If not can I achieve the same functionality using Blob's? If so does
anyone how I would add each field to the declared blob in the stored
procedure?
Any other Ideas and help would be much appreciated.
Thanks in Advance