Re: Sequence number when entering an query

In article <2627_at_nikhefh.nikhef.nl> b09_at_nikhef.nl (Jeroen Hermans) writes:
>
>I have made a form with SQLForms 2.3. When I want to enter a query I want
>the cursor to stay at the field where I entered the ENTQRY-key. Now the
>cursor goes to the field with the first sequencenumber which is query
>allowed. Between a ENTQRY and a EXEQRY you can not do a GOFLD .....
>This function should work from all query allowed fields.
>Does anyone have a sollution to my problem
>Please help.
>
>Jeroen Hermans
>Thanks
>

Get a Form-Level (or Block-level, if sufficient) KEY-ENTQRY trigger set up to copy the field name (and block name, for Form-level) to non-displayed, non-database fields, using the #copy directive (step #1).

(Step #2): #exemacro entqry;

(Step #3): #exemacro gofld &block_name.&field_name;

P.S. I haven't written this trigger in quite some time, and am doing this from memory. If this doesn't 'compile' check the examples for variable substitution, or call me at work (803) 256-7322 8-4 eastern.

Scott Received on Tue Nov 16 1993 - 02:51:04 CET