What could be possible problem in the Command??

[Former Member]

Hi Gurus!!!

i have 3 push buttons to SAVE CLEAR and CHANGE

save- will save all the field values to DB

clear - has to clear all my field values

change- shud be in a changeable mode when i want to edit provided when i give an id.

now my prob is , i am not able to clear only the addr fields which i have got as 2 flds(str1 and str2) concatenated and stored in a single fiels which is inturn stored in DB

iam able to save my data when i click on save and it get stored in DB,

when i click on clear all other fields except addr(str1 and str2) is getting cleared

when i click on changed iam able to retreive all fields from DB other than ADDR(str1 and str2) when i give the id.

What cud be my problem???pls help me out....

Point will be Rewarded

Thanks in advance

Rachel

[Former Member]

Hi Gurus!!!

i have 3 push buttons to SAVE CLEAR and CHANGE

save- will save all the field values to DB

clear - has to clear all my field values

change- shud be in a changeable mode when i want to edit provided when i give an id.

now my prob is , i am not able to clear only the addr fields which i have got as 2 flds(str1 and str2) concatenated and stored in a single fiels which is inturn stored in DB

iam able to save my data when i click on save and it get stored in DB,

when i click on clear all other fields except addr(str1 and str2) is getting cleared

when i click on changed iam able to retreive all fields from DB other than ADDR(str1 and str2) when i give the id.

What cud be my problem???pls help me out....

Point will be Rewarded

Thanks in advance

Rachel

[Former Member]

hi,

try to move the space to the variable

after concatenation try to clear both str1 str2, target field.

or

move space to l_str.

Thanks & Regards,

Chandralekha.

[Former Member]

hi ,,,

i have used move statement inorder to display in two lines

as STR1 and str2 which is in (ADDR)

but then its not working,

if i do as u said, the two fields get cleared and not getting stored in DB when i click on SAVE but gets cleared when clicked on CLEAR

Regards

RAchel

[Former Member]

Hi,

may be you are storing the concatenated field into DB and you are not clearing that field, please check.

If that is the Case clear that and press save button.

Regards,

Aswini.

[Former Member]

Rache,

Your problem is exactly clearing problem. In wich place you are concatinated the values for addr, i thing after clear statement you are agin assign your concatinated value to you addr find.

I think for change also you had the same problem.

Please check all the places where you assigned the concatinated value to the addr field.

past your code if the problem is not clarified.

Regards,

Mahi.

[former_member217544]

Hi,

Could you cross check whether the addr values is getting stored in the database table when you clicked on SAVE.

If not I think you are clearing the ADDR value just before updating that to database and thats why it is not appearing when you retrive.

Hope it will help.

Regards,

Swarna Munukoti