D5 + BDE +ODBC +SQL 7 - long field names (10th try: no answer)

vadim

Delphi Developer

Wed, 22 Oct 2003 02:38:09 GMT

D5 + BDE +ODBC +SQL 7 - long field names (10th try: no answer)

Hi,
I use D5 + BDE + ODBC + SQL 7.0.
When I create table with field names longer than 25 characters,
my Delphi program behaves unpredictably, regardless of whether it
accesses this particular table or not. So does SQL explorer. I can't even
execute
"alter table drop column" command through SQL explorer, although everything
works fine from Query Analyzer. I suspect it's BDE or ODBC.
Does anybody know what causes this and what's a workaround?

Thank you

Vadim

Bruce Michene

Delphi Developer

Wed, 22 Oct 2003 23:50:39 GMT

Re:D5 + BDE +ODBC +SQL 7 - long field names (10th try: no answer)

I'm not sure what the answer is to your specific problem, but I can tell you
that a number of my unexplained problems went away when I moved off the BDE
to ADO when dealing with SQL7.

Quote

"vadim" <va...@wisetrack.com> wrote in message

news:lGCI6.17504$mg5.1815301@news1.telusplanet.net...

Quote

> Hi,
> I use D5 + BDE + ODBC + SQL 7.0.
> When I create table with field names longer than 25 characters,
> my Delphi program behaves unpredictably, regardless of whether it
> accesses this particular table or not. So does SQL explorer. I can't even
> execute
> "alter table drop column" command through SQL explorer, although
everything
> works fine from Query Analyzer. I suspect it's BDE or ODBC.
> Does anybody know what causes this and what's a workaround?

> Thank you

> Vadim

Other Threads

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

2. long field names severe problem : SQL Server + ODBC + BDE

3. BDE becomes unmanageable with long field names + SQL 7.0

4. SQL server 7/2000 + ODBC + BDE, field name length problem

5. dbase long field names on BDE 4.51 Update

6. Client Access/400 ODBC and Long VARCHAR fields with Delphi and BDE 3.5

7. BDE..ODBC..SQL Server Trying to automatically login to database

8. D5:BDE. ORDER BY (column name = SQL-keyword)

9. ODBC VS. SQL NATIVE - INVALID FIELD NAME

10. MS SQL 6.5 ODBC/BDE - setting application name