Re: form problem

Steve,

> Because somewhere in your form, you are issuing a SQL Update to the same row
> that you have displayed in one of your base-table blocks. Remove the Update
> statement, and instead, put the value you are trying to update into the item
> in the base-table block on the form. The value will be posted to the database
> automatically by the form when the user commits.
>

Well, I'm posting the entries from screen 2 ... so if the user changes one of them
and I post I guess it must be doing an Update. However, I'm doing the post so I
can perform a select sum () from the base table I just updated prior to the commit.
The sum I get from screen 2 goes into a field on screen 1. The error message is
happening when I attempt to do the select sum (). I don't really see how I can
not update if I want the summation to work ...

> In the on-select trigger, you would have to store off the :System.Last_Query
> contents and re-use them in your new query, by setting the blocks
> default_where clause, then issuing Execute_Query. You would bypass the
> Enter_Query command.
>

I'm using sqlforms30. I don't see an on-select trigger as an option. Is it
supposed to be there? And how do I store off the :System.Last_Query contents to
re-use them ... I think you've given me part of the solution ... unfortunately I
don't quite understand your method.

Thanks very much for your help!
Martin Received on Wed May 27 1998 - 19:49:49 CDT