BDE PX SQL for widening string field

Tom

Delphi Developer

Sun, 12 Dec 2004 03:03:56 GMT

BDE PX SQL for widening string field

Is there an Alter Table command that will widen a string column from 20 to
40, for example?

Bill Tod

Delphi Developer

Sun, 12 Dec 2004 04:25:22 GMT

Re:BDE PX SQL for widening string field

No. The only way to change the size of an existing column is to use
the BDE API function DbiDoRestructure. See the examples at
www.borland.com/devsupport/bde/bdeapiex .

On Tue, 25 Jun 2002 13:03:56 -0600, "Tom" <tom @ nospam canby.com>
wrote:

Quote

>Is there an Alter Table command that will widen a string column from 20 to
>40, for example?

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

heiko Lüttg

Delphi Developer

Wed, 15 Dec 2004 16:57:15 GMT

Re:BDE PX SQL for widening string field

look at the examples of DbiDoRestructure
http://info.borland.com/devsupport/bde/bdeapiex/dbidorestructure.html

example 3

heiko

Quote

> Is there an Alter Table command that will widen a string column from 20 to
> 40, for example?

Other Threads

1. probably BDE bug: long field names: SQL Server + ODBC + BDE

2. Combining signed and unsigned types - widened both operands

3. Retrieving a string field with more tha 255 chars (MSSQL x BDE)

4. BDE′s problem with huge string field′s (interbase)

5. Retrieving string fields with more than 255 chars (BDE x MSSQL)

6. HELP!!!: BDE Memo/String field problem!?!!?!

7. BDE Memo/String field problems???!

8. BDE - Locating a field with NIL or NULL string fails

9. Sql error - Field can't contained a string of length null

10. Q:SQL:String Field fuzzy search