Do BDE limited the size of vchar Field?

hydonlee

Delphi Developer

Mon, 02 Jan 2006 16:08:49 GMT

Do BDE limited the size of vchar Field?

I have a table in ms sql server with a field type vchar(800).
but when I add Fields to FieldsEditor by a Query, the size of the field is not 800, but 255.

what can i do?

thanks.
Hydon Lee.

heiko Luettg

Delphi Developer

Mon, 02 Jan 2006 18:03:37 GMT

Re:Do BDE limited the size of vchar Field?

bde can only handle ms-sql 7 correctly.
In version 7 I think the vchar was limited to 255.

You have to use ADO to acces the newer data types.

Heiko

"hydonlee" <l...@digitalchina.com> schrieb im Newsbeitrag
news:3f165991$1@newsgroups.borland.com...

Quote

> I have a table in ms sql server with a field type vchar(800).
> but when I add Fields to FieldsEditor by a Query, the size of the field is
not 800, but 255.

> what can i do?

> thanks.
> Hydon Lee.

Ignacio Vazque

Delphi Developer

Mon, 02 Jan 2006 20:53:29 GMT

Re:Do BDE limited the size of vchar Field?

Quote

"hydonlee" <l...@digitalchina.com> wrote in message

news:3f165991$1@newsgroups.borland.com...

Quote

> what can i do?

Drop BDE and migrate to DBX or ADO.

Cheers,
Ignacio

Bill Tod

Delphi Developer

Mon, 02 Jan 2006 21:41:23 GMT

Re:Do BDE limited the size of vchar Field?

Please do not multipost or cross post your messages. It violates
Borland's guidelines for using their newsgroups and wastes everyone's
time. Please post one message in the most appropriate newsgroup.
Answered in b.p.bde.

--
Bill (TeamB)
(TeamB cannot respond to questions received via email)

Other Threads

1. TQuery BLOB Field size limit

2. BLOB field size limit : D3 : SQLAnywhere

3. Blob Field Size Limit?

4. how do limit field size

5. File Size Limit on BDE ASCII Tables?

6. BDE Table/Blob file size limit of 2 GIG

7. file size limits for BDE?

8. file size limit for dBase in BDE?

9. Size limits to bde tables

10. BDE coulden't update a Varchar Field: Size 50, Phisycal Length 51