How's "CREATE RECORD", "FIRST RECORD", "LAST RECORD" command in Oracel Handled in VAGen4

[Mohan]

Hi,

We are using VAGen 4 (FP1) + VAJava 3.0, Windows NT4 (SP6) for SQL*Forms3,
Oracle 7.3.3 conversion project.
I would like to seek information from you as to how "CREATE RECORD", "FIRST
RECORD" and "LAST RECORD" commands in oracle can be taken care off in
VAGen4.
Is there a way to handle such Oracle functions/Commands in VAGen4?

reg
Mohan Thooyamani

[Jungman Sock]

What do u mean by "Create record", "First Record" and "Last Record"?

Are those a kind of functions provided by Oracle such as "DECODE"?
If so, you can use all the Oracle functions in VA Gen programs without any
restrictions since VA Gen just pass through the functions to Oracle.

If you have any question, let me know.

Regards,...jm

Mohan 이(가) <8itcuo$b6q$1...@news.software.ibm.com> 메시지에서
작성하였습니다...

[Mohan]

Hi Sock,

Actually i misquoted FORMS functions as ORACLE
functions.

FIRST / LAST record:
------------------------
In Forms FIRST record navigates to the first record in the block's list of
records and LAST record navigates to the last record

Note:
Sample code:

BEGIN
IF :System.Last_Record <> 'TRUE' THEN
Last_Record;
ELSE;
First_Record;
END IF;
END;

CREATE record:
------------------
Creates a new record in the current block after the current record.Form
builder then navigates to the new record.

We have a Form in which an user can feed in as many records as he/she
wanted, once done with it and committed, those records reflect in the oracle
table.

How do u handle such things in VAGen4?

Reg
Mohan Thooyamani