Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Question about Datawindow union being editable 1

Status
Not open for further replies.

koopaboy

MIS
May 3, 2010
13
PH
let's say i made a datawindow with union and during runtime i want the items i have retrieved to be editable when the user click on it the question is can you edit datawindow with a union? if so how please?
 
Union has no problem during editing the column.In the Update Property Dialog Box,you need to specify which table you want to update. Let say if there are two table in the UNION and if you see only one table in the update property table list, just enter the table name in the table to update list box and save it.Now make the column as editable by changing the tab order from 0 to any positive number resulting making that column editable.
Now when you will point the cursor over that column, it will let you change the value. Change with new value and update. It will update your new value in the table.
 
thank you very much vipinhcl you have helped alot now i know how to do it thank you! :)
 
it didn't work when i tried it my problem is i have 1main datasource and 2unions, what if i had to update more then 1table? you did meant that i go to rows > update properties... right? I put a tab order and done what you said but when i click them at runtime i can't edit them at all please help me again :) here's the deal at runtime i retrieved customer information but i want to edit them when i click on them at runtime how do i make edit with union?
 
ok to put it simply i just want to edit the datawindow after i retrieve now normally that's not a problem but when i add a union it's different if you guys know how please tell me i really need help thank you :)
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top