Board index » delphi » A Large and interesting BUG of BDE or TTable (needn't any code)

A Large and interesting BUG of BDE or TTable (needn't any code)

I am using:
C++Builder 5. + SP1
MS Access 2000 (MS Office 2000)

Needn't any code just please follow these steps:
1. Using Access2000 to create a Blank Database, then creat a table in it.
This table only need one field: "Email" and please index the field.

2  Enter a record in it "Young<yo...@example.com>", then add any aother
record.
For example: "s...@ljlkj.com", or "l...@test.net". Then Save this Database.

3 Open C++Builder. establish a new application, drop a TTable: Table1, a
TDataSource: DataSource1, a TDBGrid: DBGrid1 on the Form.
Point the DBGrid1->DataSource to DataSource1
Point the DataSource->DataSet to Table1
Point the Table1 to the Database and the Table above.
Set the Table1->Active to True.

Then you can find intersting thing: the count of records in DBGrid is not
equal to the actual of the database, some duplicated records has been added
and all recorder is not sorted.

There is not any code, you can do all of them in the Object Inspector.

Now if you directly delete the index in the database, re-Active Table1 you
will find the DBGrid show normal data. But when you use:

Table1->IndexFieldNames="Email";
The DBGrid show the same wrong data again.

 

Re:A Large and interesting BUG of BDE or TTable (needn't any code)


Thank you!
Is there a way to use ODBC without BDE nor ADO?
And supports Ms Access2000?

Quote
"Bill Todd" <b...@notthis.dbginc.com> wrote in message

news:0871ougb490o88gd2bl61uosikas03bhh6@4ax.com...
Quote
> The BDE MSACCESS driver does not support Access versions > 97. You
> should use ADO for later versions.

> On Thu, 12 Sep 2002 10:31:45 +0800, "Frank" <shang...@yahoo.com>
> wrote:

> >I am using:
> >C++Builder 5. + SP1
> >MS Access 2000 (MS Office 2000)

> >Needn't any code just please follow these steps:
> >1. Using Access2000 to create a Blank Database, then creat a table in it.
> >This table only need one field: "Email" and please index the field.

> >2  Enter a record in it "Young<yo...@example.com>", then add any aother
> >record.
> >For example: "s...@ljlkj.com", or "l...@test.net". Then Save this
Database.

> >3 Open C++Builder. establish a new application, drop a TTable: Table1, a
> >TDataSource: DataSource1, a TDBGrid: DBGrid1 on the Form.
> >Point the DBGrid1->DataSource to DataSource1
> >Point the DataSource->DataSet to Table1
> >Point the Table1 to the Database and the Table above.
> >Set the Table1->Active to True.

> >Then you can find intersting thing: the count of records in DBGrid is not
> >equal to the actual of the database, some duplicated records has been
added
> >and all recorder is not sorted.

> >There is not any code, you can do all of them in the Object Inspector.

> >Now if you directly delete the index in the database, re-Active Table1
you
> >will find the DBGrid show normal data. But when you use:

> >Table1->IndexFieldNames="Email";
> >The DBGrid show the same wrong data again.

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

Re:A Large and interesting BUG of BDE or TTable (needn't any code)


There are third party tools. See www.kylecordes.com .

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

Other Threads