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!

PB 10.2.1 build 9823 corrupts PB 9.0.2 build 7661 Tables

Status
Not open for further replies.

DilbertPCer

Programmer
Feb 7, 2003
17
US
In Migrating pbls from PB9 to PB10 the new PBL compiled OK and an exe was created.
When it was run in the IDE it displayed the table data correctly.
No data was saved or updated.
Now the PB9 application gives a "Database Problem 2 select error database processing error" when it tries to display data from the same table.
So, it seems the PB10 application corrupted the data in the PB9 table.
This is probably because PB10 is Unicode whereas the original table data was DBCS in PB9.
Apparently, I have missed some setting in either Powerbuilder or in the SYC Sybase Adaptive Server Enterprise to prevent this corruption.
Our Adaptive Server Enterprise version is 11.5.1, I think.
We are not using any new version of the SYC ASE, yet.
Does anyone more capable in this type of conversion and/or more capable in SYC ASE have some suggestions or leads for me.
Presently I am re-reviewing my documentation.
 
The PB9 datawindows had to have the table re-connected to work; which solved the PB9 problems. PB10; however, is still dysfunctional.
 
My problem is that I thought that when a DB Profile was Exported from PB9 and Imported into PB10; that it changed the PB10 ini file. This is not the case-
possible PB Bug!?
While the new profile allows you to interact with the database and tables in the database painter; it doesn't change the PB10 pb.ini file; which means that if you look for your db specifications programmatically in the pb.ini file - then you are out of luck.
So, I will find a way to update the PB 10 pb.ini file.
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top