Subject | IBOQuery - Query Editor |
---|---|
Author | mitch_landor |
Post date | 2006-03-02T08:17:21Z |
I can't find any documentation about various functionality in the
Query Editor and would really appreciate some guidance:
1. What is the function of the first "SQL" tab if there is a place to
put the SQL code for edit, insert & delete on the "UpdateSQL" tab?
2. What is the function of the "Generate for Table" and "Generate for
Procedure" buttons?
3. In the InsertSQL window I want to pass the grid row values back
into the database for an insert. How do I reference the new grid
values to be inserted?
insert into PROJ (remark, created, createdby, lockd, lockdby)
values
???
Many thanks,
Mitch
I can see I'm going to have to purchase Helen's book....
Query Editor and would really appreciate some guidance:
1. What is the function of the first "SQL" tab if there is a place to
put the SQL code for edit, insert & delete on the "UpdateSQL" tab?
2. What is the function of the "Generate for Table" and "Generate for
Procedure" buttons?
3. In the InsertSQL window I want to pass the grid row values back
into the database for an insert. How do I reference the new grid
values to be inserted?
insert into PROJ (remark, created, createdby, lockd, lockdby)
values
???
Many thanks,
Mitch
I can see I'm going to have to purchase Helen's book....