topic Re: Update the database table using tabstrip in Application Development and Automation Discussions

Update the database table using tabstrip

Former Member — Tue, 06 May 2008 11:59:37 GMT

Hi Guy's,

I am struck up at Update the database table using tabstrip control.( Created one push button name save, using this button trying to update the database table)

Please friends help me.

Thanks and Regards,

Sai.

Re: Update the database table using tabstrip

Former Member — Tue, 06 May 2008 12:13:42 GMT

What is the issue you are facing? Also, please paste the code that is being triggered when you are pressing the SAVE button.

~Sid

Re: Update the database table using tabstrip

Former Member — Tue, 06 May 2008 12:22:40 GMT

Hi Sid,

MODULE STATUS_0100 OUTPUT.

INSERT INTO HRP1001 values wa_p2.---it is

MODULE USER_COMMAND_0100 INPUT.

WHEN 'SAVE'.

INSERT HRP1001.

Please check the code where i did the mistake.

Thanks and Regards,

Sai.

Re: Update the database table using tabstrip

Former Member — Tue, 06 May 2008 12:42:15 GMT

plz check the structure of wa_p2 is same as of db table fields, secondly are you inserting a new record( For new record use INSERT) or updating an existing record (Then use UPDATE).

If you specify a non-table-type work area wa, a row is created from its contents for insertion in the database table. The content of the row to be inserted is taken from the work area wa without taking its data type into consideration and without conversion from left to right according to the structure of the database table

If there is a type mismatch perhaps its being set to initial values.. plz check your db table also for the values after you press enter. Or debug your code to see what value is being transfered.

~Sid

Re: Update the database table using tabstrip

Former Member — Tue, 06 May 2008 12:49:31 GMT

Do you have an OK_CODE on the 100 screen?


MODULE USER_COMMAND_0100 INPUT.

CASE ????.  " <=== Missing
  WHEN 'SAVE'.
    INSERT HRP1001.
ENDCASE.  " <=== Missing

Have you defined the button with an Fuction Code? Is that FC = 'SAVE' ? Save is usually set in the GUI Status, but it is not limited to just one of this value. You could use SAVE in multiple Event Objects.