Subject | SP param/field error |
---|---|
Author | Gediminas |
Post date | 2004-11-04T14:47:30Z |
Have such code:
SQL->Add( "select * from Select(:OtherID);" );
InsertSQL->Add( "execute procedure Insert(:OtherID,:User_ID)" );
MasterSource=otherDS;
MasterParamLinks->Add("OtherID=OtherID");
select SP returns desc_id & desc fields.
Always get error, that OtherID field is not found until I add:
CalculatedFields->Add("OtherID decimal(15,0)");
or comment InsertSQL statement.
Why do I need to add calculated field for the parameter?
More: when calling insert do I need to supply OtherID param value or
is it already is there (from the master param list)?
SQL question: select filters records and one field from the results
depends is this field reside on a another table. How to make such
query?
for example:
select t.id,t.name, case when ( select 1 from table2 t2 where t2.id =
t.id ) is null then "" else "" end as "
from table t
join .... on ....
place in question is where t2.id = t.id <-- how to check, if t
selected id is in the t2?
SQL->Add( "select * from Select(:OtherID);" );
InsertSQL->Add( "execute procedure Insert(:OtherID,:User_ID)" );
MasterSource=otherDS;
MasterParamLinks->Add("OtherID=OtherID");
select SP returns desc_id & desc fields.
Always get error, that OtherID field is not found until I add:
CalculatedFields->Add("OtherID decimal(15,0)");
or comment InsertSQL statement.
Why do I need to add calculated field for the parameter?
More: when calling insert do I need to supply OtherID param value or
is it already is there (from the master param list)?
SQL question: select filters records and one field from the results
depends is this field reside on a another table. How to make such
query?
for example:
select t.id,t.name, case when ( select 1 from table2 t2 where t2.id =
t.id ) is null then "" else "" end as "
from table t
join .... on ....
place in question is where t2.id = t.id <-- how to check, if t
selected id is in the t2?