topic Re: inserting a single field in a custom table in Application Development and Automation Discussions

inserting a single field in a custom table

Former Member — Thu, 12 Jul 2007 20:56:46 GMT

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

Re: inserting a single field in a custom table

Former Member — Thu, 12 Jul 2007 21:07:46 GMT

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

Re: inserting a single field in a custom table

Former Member — Thu, 12 Jul 2007 21:10:33 GMT

HI,

You can use UPDATE statement

UPDATE ztable SET SIXTH_FIELD = 'value'

WHERE key_field = 'asdf'.

Thanks

Naren

Re: inserting a single field in a custom table

Former Member — Thu, 12 Jul 2007 21:11:19 GMT

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

Re: inserting a single field in a custom table

Former Member — Mon, 16 Jul 2007 16:10:36 GMT

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