Recent content by tfs

I made another change: select substring(PurComment,1,900) from Pub.JobMtl where JobNum >= "015000" and JobNum <= "017000" and got this error (JobNum is a valid column): === SQL Exception 1 === SQLState=42S22 ErrorCode=-20006 [JDBC Progress Driver]:Column not found/specified (7520) I then...

Here is the command I tried: select substring("PurComment",1,900) from JobMtl where JobNum >= "015000" and <= JobNum "017000" Here is the response. === SQL Exception 1 === SQLState=42S02 ErrorCode=-20005 [JDBC Progress Driver]:Table/View/Synonym not found (7519)

Unfortunately, we can't do this as the program we are using, Vantage, uses Progress exclusively. All 13 tables we are having the problem with have the field set as x(1000). They are all comments, billing of lading discriptions. I assume the error is that somehow it accepted to much data (why...

Oh, BTW I am running Progress 9.1d on an W2K Server.

I am trying to import some of the data in our vantage database to our Sql Server system to run reports and allow our other offices access to the data without letting them have access to the actual data. I have been using DTS to do the move. The problem is that as we were copying the tables...