Very Computer

1. Insert query results don't show until I reopen the database

Hello, all !

I 've got the following problem. I use DAO classes and I have an insert
query ( a query that insert records in the table,based on values,user
enters). When I call Execute on this query, values are succesfully added to
the table, but if I right after that open that table and begin to retrieve
it's records, one by one, I realize,that the newly added record is not
there. If I close the database and open it again,the record is there.
What should I call besides CDaoQueryDef's Execute to make records visible
right after inserting?

Thanks,
    Svetlana

--
----------------------------------

http://galaxy.assert.ee
----------------------------------

2. 'Freezing' a database

3. Update Trigger - Updates don't show up in pane view

4. export error

5. Updating or Inserting a record in one query

6. changing sa password on SQL 6.5 - how ?

7. Parallel SQL and Access back ends record counts don't match

8. Finding records in one table that don't have a match in another

9. SP1 for sql 7.0 don't solve the UPDATE() Bugs in Insert Triggers

10. need a query to return records which don't exist

11. Record count from different queries in one common way

12. forming ratios of count()'s with one query