Re: SQL*FORMS3.0 trigger to Duplicate a record?

> I am just starting to use Sqlforms30 for simple applications.
> Could someone post on this group a trigger ( or a procedure ) to
> duplicate a record of data , which is already in database, on a Form.
> Also let me know where I can write it.
> Thanks a lot.
> Raj Rairao

Assuming that you have a multirecord block displayed on the screen and that you want to MANUALLY initiate the duplication. Pick a KEY- trigger that you can spare (for example KEY-CQUERY) and write the following trigger:

	CREATE_RECORD;
	DUPLICATE_RECORD;

When you press the count-query key, Forms will open a new record immediately below the current record and then replicate all information from the current record into the new entry.

 | Frank Greene DELPHI SYSTEMS Inc    |          _/_/_/  _/_/_/             |
 | Telephone [615] 458-6032           |           _/_/    _/_/              |
 | Internet 74200.427_at_compuserve.com  |          _/_/    _/_/  _/_/_/       |
 | Compuserve 74200,427               |         _/_/    _/_/    _/_/        |
 | 324 Ootsima Way                    |        _/_/    _/_/    _/_/         |
 | Loudon, TN 37774                   |       _/_/_/  _/_/_/  _/_/_/        |
 ----------------------------------------------------------------------------
 |         Of course, any opinions or suggestions are strictly my own       |
 ----------------------------------------------------------------------------