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 Mike Lewis on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Any third party tools to resync datawindow with database?

Status
Not open for further replies.

loupgarou

Technical User
Jun 27, 2002
1
0
0
SG
Hello everyone,

I'm still using powerbuilder 6.5 (changing to 10 soon)

I've expanded a couple of hundred database fields after I successfully migrated database from sql 6.5 to sql 2000.

I now need to sync all my datawindows to take advantage of this.


the tedious way:
go to each and every data window, show sql syntax, add a space bar, return back to datawindow painter, set "update properties" , then go to every single line edit and set the edit.limit

I've already written something that can identify and log which edit.limit needs to be updated after I sync the datawindow (column types), but its still extremely tedious.

any clues?


 
I think there is no other way than that. You can simplify it by exporting all your datawindows to srd, then edit all affected fields, then export again the srd's.
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top