The BDE appears to be truncating SQL Server 7 varchar fields that are
greater than 255. Is this a know limitation? ADO does not truncate these
fields. Is there a way around this problem other than switching to ADO?

Thanks

Scot,
  The reason this is happening is because the BDE is treating your SQL
Server 7 as a 6.5 database, which means that you are limited to 6.5 data
types. In MS SQL Server 6.5 the largest char size was 255, now it is much
larger in 7; however, the BDE doesn't care.
  The suggested way to connect to SQL Server 7 is via ADO. I am going to
talk to the marketing team and the BDE R&D, because the readme file states
that the BDE supports MSSQL7 and it doesn't.

Gardner Bickford
Delphi Developer Assist

news:8505b2$ne213@bornews.borland.com...

Thanks for your response and your honesty.

Are there other compatibility issues between the BDE and MSSQL7?

Thanks

Gardner Bickford (Borland) <gbickf...@borland.com> wrote in message
news:8511op$pg923@bornews.borland.com...
...

Well the BDE supports MSSQL 7, but the MS DB-Lib doesn't support the new
field types, and the BDE relies on DB-Lib. We use the BDE with SQL 7 and
it works fine, so it does "support" it in that sense...

 I am going to

Using Delphi 4 and MSSQL 7:

Contrary to the messages below, I just successfully tested using a
varchar(5000) data type and SQL insert, update, and select statements.
I could insert or update a length up to 5000. Then, after my select
statement, I checked the string length to verify that nothing was lost
and put the text into a regular TMemo to see it.

I did not try using any Delphi data-aware controls for this. Nor did I
try using any commands such as TDataSet.Post or a TUpdateSQL control.
Maybe that's what the person below was doing. Just guessing.

Gardner Bickford (Borland) <gbickf...@borland.com> wrote in message
news:8511op$pg923@bornews.borland.com...