Re: Sql Query as an Item formula

[Quoted] "Aaron V" <Tinkerist_at_hotmail.com> wrote in message news:OuWdnebtT7-Ml0yiRVn-hA_at_comcast.com...
| Thanks Frank,
| After a bit of frustration in Forms, I think I've got it working now,
| although not directly in Forms, I don't think Forms supports Execute
| Immediate (no underscore). I finally put the Function onto the Server
Side,
| and then Execute Immediate works, (why is that? can forms not compile the
| Dynamic sql?).
|

[Quoted] forms has its on PL/SQL engine and processes PL/SQL locally, sending individual SQL statements to the database

in forms, look into FORMS_DDL or EXEC_SQL

• mcs