large local databases and data-aware controls

large local databases and data-aware controls

Post by Mark Crimmin » Wed, 05 May 1999 04:00:00

I want to use a grid control to show a local (Jet table) database that
gets a new record every second or so.  I would like the user to be able
to scroll through the entire table, but it's a large table, and it can't
fit in memory.  When I just make the table the recordset object of a
data (e.g., ADODC) control, by the delay and disk access I assume it is
trying to read the whole table into memory.  Is there any way to do what
Access does---to have a grid that you can scroll to view the whole
table, without having the whole table in memory?

Thanks for any advice,



1. Data-aware controls that be aware of nothing

I'm puzzled (but I'm not a guru) with this.

I want to insert data into two tables through two TQuery in
a Client/server application. Both tables are related in a
master/detail relationship with a field (NH) that is the
primary key in the master table. The detail table has
another primary key (NI).

I've built a form divided into two moities with data-aware
controls for fields from both Tquery. In the OnCreateForm
procedure  I start a explicit transaction, and prepare, open
and insert on both TQuery.

The problem is that the controls which have to be aware of
the fields of the first TQuery do it OK, but not the others.
And I know that the record in the second TQuery is inserted
and in dsInsert mode, because I can assign values to this
record through code, but not through the data-aware

Can anybody help me?


Sent from RemarQ The Internet's Discussion Network
The fastest and easiest way to search and participate in Usenet - Free!

2. seek

3. URGENT Writing the contents of data-aware controls to the database TOUGH ONE

4. Template for database resource sizing for new application

5. Data Aware OCXs and Data Controls

6. 'Bugs' - ADO

7. Local DataBase table multi-user aware??

8. Data aware (bindable) user control (HOW TO?)

9. Data Aware Controls

10. Questions about data-aware controls

11. Updating data aware controls