Subject | variable field and table sp's/udf's |
---|---|
Author | martinknappe |
Post date | 2006-06-18T15:04:52Z |
hi,
i'm looking for a way to create an sp or a udf that looks sort of like
the following:
variableselect(field, table)
begin
select :field from :table;
suspend;
end
so a call to variableselect(custNo, customers) would do
select custNo from customers;
is there a way to accomplish something like that??
just asking,
thanx,
martin
i'm looking for a way to create an sp or a udf that looks sort of like
the following:
variableselect(field, table)
begin
select :field from :table;
suspend;
end
so a call to variableselect(custNo, customers) would do
select custNo from customers;
is there a way to accomplish something like that??
just asking,
thanx,
martin