- Messages
- 126
- Reaction score
- 0
- Points
- 26
Hi mga ka SB help naman dito oh
ganito kasi nasa table ko
Select * from Layout
View attachment 306082
Then need ko pag sama samahin yung apat na Layout ID or imerge sila as one tapos yung code as is na LAYOUT01 para maging isang record lang. what I need is to update the table not just query. ang purpose nitong pag update ko ng table para hindi madami ang record ng LAYOUT01, pwede ko sana sya idelete at gawing isa na lang ang kaso naman bawat layoutid may laman na details like images, data etc. so kung maaari baka pwede silang pag isahin at gawing isang record lang![Big Grin :D :D](/images/smilies/biggrin.gif)
Bali ganito po sana gusto kong output after ma update ang table
View attachment 306094
This code did not worked out
Update Layout
set Layoutid='10000'
where layoutid='216000001'
and layoutid='22000021'
and layoutid='16000001'
and layoutid='20000718'
error sya dahil primary key ang layoutid![Frown :( :(](/images/smilies/frown.gif)
tsaka ang kalalabasan lang nito yung apat na yan magiging 1000 pero apat na record pa din so hindi pa din sya nag merge
ganito kasi nasa table ko
Select * from Layout
View attachment 306082
Then need ko pag sama samahin yung apat na Layout ID or imerge sila as one tapos yung code as is na LAYOUT01 para maging isang record lang. what I need is to update the table not just query. ang purpose nitong pag update ko ng table para hindi madami ang record ng LAYOUT01, pwede ko sana sya idelete at gawing isa na lang ang kaso naman bawat layoutid may laman na details like images, data etc. so kung maaari baka pwede silang pag isahin at gawing isang record lang
![Big Grin :D :D](/images/smilies/biggrin.gif)
Bali ganito po sana gusto kong output after ma update ang table
View attachment 306094
This code did not worked out
Update Layout
set Layoutid='10000'
where layoutid='216000001'
and layoutid='22000021'
and layoutid='16000001'
and layoutid='20000718'
error sya dahil primary key ang layoutid
![Frown :( :(](/images/smilies/frown.gif)
tsaka ang kalalabasan lang nito yung apat na yan magiging 1000 pero apat na record pa din so hindi pa din sya nag merge
Attachments
Last edited: