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!

PB started erasing random lines in SQL Script

Status
Not open for further replies.

Delphiwhat

Programmer
Apr 1, 2003
74
EU
Hi folks

I have a strange problem here which has only started happening.

basically i have a build of code when i run this code it pops up a window showing me the SQL statement that it is going to be executed.

The problem is that for some reason powerbuilder (i presume) has decided to delete the last line of my SELECT and the last line of my WHERE statement hence when i press the OK button to run the query i get an error.


Even if i try running a build of code several versions earlier this problem still appears even though everyone else can run the builds of code on their own PCs without any problem. Any ideas?? could this be a few dll's missing or something ? or a windows 2000 problem ?

thanks in advance for your help
 
Which DB and how are you connecting? I have reported a bug to Sybase similar to this for versions 8.0.4 and 9.0.1 of Powerbuilder connecting to SQL2000 via OLE DB.
 
hi

Powerbuilder 7.03 and oracle 7.3

did you get a fix for this? My application is now totally useless because of this problem.

I've tried uninstalling and reinstalling powerbuilder but it still poses the same problems.

Missing lines of sql script and missing icons in the File->New->application window
 
PROBLEM SOLVED

INSTALLED WINDOWS 2000 SERVICE PACK 4

some of the windows dlls must have become corrupt
 
Anyone looking for a full time Powerbuider position in a suberb on New York City please feel free to contact me. Ms Sql Server is the primary database that's used. Please only candidates that are truley ready and willing to move withing a few weeks time. No relocation expenses will be given.

This is a major company and the benefits are tremendous.


Eric Sherman
eric@tribecastaffing.com
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top