sqlforms problem

To: ori645577316_at_emuvax.emich.edu

OO> I have a dummy field and no changes are made in the regular fields.
OO> I am using SYSTEM_CURSOR.RECORD to count the nuber of records which
OO> I am inputting but it is not working.

OO> The fields in Table2 are Serial#, Model, Make

OO> Any suggestions how to handle this.

This is a VERY quick and dirty solution which I'm not sure will solve your problem but it's always worth trying. If you are sure that there has been changes and you want to commit but no base table field has changed (in other words :syrem.record_status is still "QUERY"), then in the KEY-COMMIT trigger, before the "commit;" statement, enter the following statement:
:base table field := :base table field;

(ie. If you assign any database field in a block to itself, that block's status will change to "CHANGED").

• Greetings. Dewald Pretorius Fax: +27-11-3135122
• Internet: dewald.pretorius_at_digitec.co.za Tel: +27-11-3135227
• RM 1.2 01163 * Our bikinis are exciting. They are simply the tops.

  ---

• Digitec Online - 10 Nodes - Johannesburg - South Africa - +27-11-476-7136 -
• _at_digitec.co.za - ILink - Weather - BASNet - RsaNET -