Board index » delphi » Will Delphi 4.0 accept VarChars greater than 255.

Phil

Delphi Developer
Wed, 18 Jun 1902 08:00:00 GMT

Will Delphi 4.0 accept VarChars greater than 255.

We use Delphi 4.0 on SQL server 7.0.  I had my DBA change a VarChar field
from 255 to 500.  I used the field editor to delete and add the field back
in but it still reports the size as 255.  I manually changed the size but I
then got a size mismatch when I ran my application.  Does Delphi 4.0 limit
the size of a string field to 255.  Any information about this problem would
greatly appreciated.
 
Bradford C. Mille

Delphi Developer
Wed, 18 Jun 1902 08:00:00 GMT

Re:Will Delphi 4.0 accept VarChars greater than 255.


The BDE works through DB-Lib. DB-Lib was not updated by Microsoft to
work with the new SQLServer 7 field types. Therefore, the BDE cannot
work with those new field types.
Quote
Phil wrote:

> We use Delphi 4.0 on SQL server 7.0.  I had my DBA change a VarChar field
> from 255 to 500.  I used the field editor to delete and add the field back
> in but it still reports the size as 255.  I manually changed the size but I
> then got a size mismatch when I ran my application.  Does Delphi 4.0 limit
> the size of a string field to 255.  Any information about this problem would
> greatly appreciated.

Thomas Werne

Delphi Developer
Wed, 18 Jun 1902 08:00:00 GMT

Re:Will Delphi 4.0 accept VarChars greater than 255.


But you can use the ODBC-driver with BDE. If you install an updated version
of the SQLServer ODBC driver it should work.

--
Thomas Werner
Component Store Ltd. http://component-store.com
/* SQLQuery, the fastest BDE alternative for MS SQL Server  */

"Bradford C. Miller" <millerb...@spicedhamawayaol.com> skrev i meddelandet
news:38B56282.90C98F5A@spicedhamawayaol.com...

Quote
> The BDE works through DB-Lib. DB-Lib was not updated by Microsoft to
> work with the new SQLServer 7 field types. Therefore, the BDE cannot
> work with those new field types.

> Phil wrote:

> > We use Delphi 4.0 on SQL server 7.0.  I had my DBA change a VarChar
field
> > from 255 to 500.  I used the field editor to delete and add the field
back
> > in but it still reports the size as 255.  I manually changed the size
but I
> > then got a size mismatch when I ran my application.  Does Delphi 4.0
limit
> > the size of a string field to 255.  Any information about this problem
would
> > greatly appreciated.

Other Threads

1. problens w/ varchar greater than 255

2. problens with MSSQL 7.0 with varchar greater than 255

3. Varchar greater than 255 characters

4. SQL Server 7 Varchar field greater than 255

5. Varchar(255) vs Varchar(256) and TStrigField vs TMemoField

6. Cannot retrieve MS-SQLServer VARCHAR(n>255) or TEXT field in Delphi program

7. Interbase VARCHAR 255 chars in Delphi 4

8. network broadcast to 255.255.255.255 or x.x.x.255 doesn't work

9. PChar: I need greater than 255

10. Strings greater than 255