Hi
What is the command to add a record to a table?
Thanks

soni1000 (AT) webmail (DOT) co.za (Yatin Soni) wrote in
news:7be6da7c.0410110536.48130027 (AT) posting (DOT) google.com:

Create

insert

http://www.w3schools.com/sql/sql_insert.asp
"Yatin Soni" <soni1000 (AT) webmail (DOT) co.za> wrote

In article <7be6da7c.0410110536.48130027 (AT) posting (DOT) google.com>,
soni1000 (AT) webmail (DOT) co.za (Yatin Soni) wrote:

/* This will create a database record in the 4GL */
/* The default buffer name is the same as the table, */
/* Otherwise you need to do a DEF BUFFER x FOR y. */

CREATE MyTableName.

/* Once this statement is executed, a transaction is */
/* opened automatically. You assign values with the */
/* ASSIGN statement. */

ASSIGN MyTableName.Field1 = "some character"
MyTableName.Field2 = 23.

/* End of program causes transaction to automatically */
/* commit. If you need to undo a block, use the DO */
/* TRANSACTION statement. */
/* The end of a transaction block statement will com- */
/* mit the record also. */

There is a bunch of source code available here:

http://amduus.com/OpenSrc/SrcLib/

It should give you some ideas about what is going on.

You can also subscribe to a list of progress programmers at www.peg.com.
There is also progresstalk.com which is more web based with a seperate
base of people.

Scott Auge <scott_auge (AT) yahoo (DOT) com> wrote



Thanks guys..
Appreciate the guidance!!