topic how to update database? in Application Development and Automation Discussions

how to update database?

Former Member — Wed, 09 Apr 2008 09:37:11 GMT

hi gurus,

i have created two tables one with name zasset and other with name zbcode.

zasset has 3 fields namely serialno, barcode and description

zbcode has 3 fields namely serialno,location_barcode and location_description.

now i have created a structure with name zst_asset which includdes all the fields of above mentioned tables..

now, there are entries in serialno and i have 2 update my zbcode with entering manually location_barcode and location_description.

but it is not working how do i do it plzzz send in the steps..

first screen allows me to enter location barcode which then takes me to second screen where i enter location description. on third screen it should display that all entries have been updated.. how do i proceed..

sendi in steps..

it's urgent.

POINTS ASSURED.

Regards,

vikram

Re: how to update database?

Former Member — Wed, 09 Apr 2008 09:59:16 GMT

use a modify stmt after u hav entered ur manual values...

dis modify stmt will den update ur DB.

Reward pts if useful

Regards

winnie

Re: how to update database?

Former Member — Wed, 09 Apr 2008 12:07:21 GMT

Can you explain your requiremnt more clearly.

You have to create all these three screen and you should define the filed name in the screen as zst_asset-serialno,zst_asset-location_barcode and zst_asset-location_description.

Now you have to just update your data base table from the structure zst_asset.

ie, modify zbcode from zst_asset.