I don't know how to update value into the table from another table.

[#1]

Could anyone help me to figure out how to update a value into the table from another table?

As far as I knew, the way I can update is to enable Dynamic Data Update feature in the desktop. So, I already tried on my document. I didn't work on my doc. However, I found some an example file from this excellent QV discussion forum here. It worked on it.  I don't know the reason why the document I created did NOT update anyway.

Below is the example update script I ran. 

UPDATE List60, tbStatus SET List60.Inc_Dec_Flag = tbStatus.CIFStatusLatest

WHERE List60.Cif = tbStatus.Cif;

According to the attached pic below, I wanna replace Inc_Dec_Flag field with CIFStatusLatest field.

Thanks.

[vardhancse]

Hi,

Why can't you try with ApplyMap().

using that based on some ID field you can get the text/value required.

[rahulpawarb]

Hello Natthapol,

You can use below given sample code snippet in your script:

//Add this mapping table before the List60 table load statement
Mapping_Flag:
Mapping LOAD
Cif,
CIFStatusLate
Resident tbStatus;


//Replace Inc_Dec_Flag field in List60 table by below code
ApplyMap('Mapping_Flag', Cif) AS Inc_Dec_Flag

Regards!

Rahul

[#4]

Hi,

I already tried with ApplyMap func. but, it seems like it doesn't work. What I hv done in order is to load data to List60 table first and then do some calculation in tbStatus table by using data from List60 table. That's all.

Thanks

[rahulpawarb]

If this is the situation then create a table with new Inc_Dec_Flag field and join it with List60 table.

//Table containing new Inc_Dec_Flag field will be joined with List60 table
LEFT JOIN (List60)
NewInc_Dec_Flag:  
LOAD  
Cif,  
CIFStatusLate AS Inc_Dec_Flag 
Resident tbStatus;

Hope this will help.

Regards!

Rahul

[#6]

Hi Rahul,

This is such an interesting approach.

Let me try when im available. then , im gonna let you know how it's going to be.

Thanks