Borland C++ Builder VCL Components >> Update TTable (database) index files after adding a record

by Jim Zirbes » Wed, 06 Aug 2003 04:48:52 GMT

I would appreciate some help on how to update the index files for a Paradox
database using a BCB 5.0 TTable data access component. I can add a data
record with no problem using the TTable->Post() function but this doesn't
update the index files and I can no longer sort the table after doing the
post. There has got to be a way to accomplish this but I can find nothing in
the help files.

Jim Zirbes
XXXX@XXXXX.COM






Borland C++ Builder VCL Components >> Update TTable (database) index files after adding a record

by Paul Embleton » Sat, 16 Aug 2003 17:25:16 GMT


What do you mean by 'sort the table' and what happens when you try?

Indexes are automatically updated (unless they're defined as non-
maintained).

Paul Embleton

"Jim Zirbes" < XXXX@XXXXX.COM > wrote in






Similar Threads

1. Updating TTable (database) index files after posting a new record

I would appreciate some help on how to update the index files for a Paradox
database using a TTable data access component. I can add a data
record with no problem using the TTable Post method but this doesn't
update the index files and I can no longer sort the table after doing the
post. There has got to be a way to accomplish this but I can find nothing in
the help files.

Jim Zirbes
 XXXX@XXXXX.COM 




2. Updating database (ttable) index files - Borland C++ Builder VCL Components

3. add/update records C# Access database

I write a software in C# that updates an Access database. This
database is being updated by other software in parallel.
I would like to add a record or to update a record and I am not sure
what the best way to do it.
As far as I understand there are 3 options:
1.	To open the whole table but in order to add one record do I
really need to read the whole other 2 million records?
2.	To run a query that will return me a part of the table I find in
inefficient to run a query on the whole database so I can add a
record.
3.	To add a record using SQL statement (INSERT INTO) doesn look
elegant to me when having 10 or 20 parameters.

Is there a better way to add/update records?
I would appreciate any help
Thanks in advance,
Oren

4. Open XML file, find record and update record - CSharp/C#

5. Update a record in SQL Database from C#.NET

   I want to update a record into a table in SQL Server 2000 database from 
C#. This table is used concurently for other users too, and I want to be sure 
that from the read of record to the update no other user was updated the 
record.
   Please tell me how can I do this.
   Thank you!

6. how can update and insert new records in the database via datagrid - CSharp/C#

7. Update records in a datagrid and save it in database

Dear,

I have on a form a datagrid (datagrid1) which is filled by a dataset created
in the class Afwezigheid. A button "Alles" show the whole table in the
datagrid and when someone wants to change the data, I have to use a
sqldataadapter which has an Update method. But how can I link this all ?

Thank you very much,

Hugo Lefevre

Filling up the datagrid :
----------------------

Afwezigheid frmAfw = new Afwezigheid( out ds);
dataGrid1.SetDataBinding(ds, "Afwezigheid");

Creation of the dataset in the class Afwezigheid :
------------------------------------------------

public Afwezigheid(out DataSet ds)
{
SqlSelectie = "select * from Afwezigheid; ";
Database db = new Database();
SqlConnection conn = db.Opent();
SqlCommand cmd = new SqlCommand(SqlSelectie, conn);
SqlDataAdapter da = new SqlDataAdapter(SqlSelectie, conn);
ds = new DataSet();
da.Fill(ds, "Afwezigheid");
conn.Close();
}

What have I to do to write this code in the class Afwezigheid :
---------------------------------------------------------------

private void btnUpdate_Click(object sender, System.EventArgs e)
{
            ?????????????????????????????????????
}


public void DbUpdateAfw(DataSet ds)
{
da.Update(ds, "Afwezigheid");
}


8. Adding new record to database C# VS2005 Windows Mobile CF2 PocketSql