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