inserting a single field in a custom table

[Former Member]

hi all,

can u tell me hw could i insert a single field in the custom table.

i have abt 6 fields in the custom table.

5 fields are already populated...

i have to insert one field ..i dont want to use insert statement.

thanx in advance

[Former Member]

hi all,

can u tell me hw could i insert a single field in the custom table.

i have abt 6 fields in the custom table.

5 fields are already populated...

i have to insert one field ..i dont want to use insert statement.

thanx in advance

[Former Member]

You wont need to insert a single field, as u said 5 fields are already populated and u need to modify the custom table with 6th field

Use Modify statement

Thanks.

regards

vinsee

[Former Member]

HI,

You can use UPDATE statement

UPDATE ztable SET SIXTH_FIELD = 'value'

WHERE key_field = 'asdf'.

Thanks

Naren

[Former Member]

hi.

insert and update r working good for only one record.wht should be the logic if we have mulitple records. im writing insert and update in a loop.do i need to write commit or use append

[Former Member]

Use Update statement.

if you use modify ,it works like insert ( if no record exists) and also it works Update.

UPDATE dbtab SET f1 ... fn

Thanks

Seshu