Odd Behavior With CommitTrans 
Author Message
 Odd Behavior With CommitTrans

Thanks for your reply. I've posted this question to several groups in search
of an answer, but only included a snipet for
brevity's sake. Every respondant has asked if I declared the variables. So I
guess brevity isn't such a good thing!

I swear that all of the variables shown are scoped properly! We actually
have quite a few developers here working on the problem. No luck
so far. I found someone who has seen this.

Subject: Access97 committrans behavior

Date: 1998/03/18

Newsgroups: borland.public.delphi.database.desktop[More Headers]
I'm working with an Access97 database using DAO3.5 through an OLE automation
connection rather than through the BDE.I'm finding that the statement
invalidates all my dataset objects, which must then be reopened before
proceeding. The objects aren't set to nil--but the next call returns an Ole
'object invalid or no longer set' error. Is this normal? Anyone else
Also, the Microsoft documentation says that the call should be
CommitTrans (dbFlushOSCacheWrites)
but there's no such constant in the type library,
nly{ CommitTransOptionsEnum }
dbForceOSFlush = 1;ThanksBobD

I contacted him and he also has found no resolution to the problem. I've
done some further testing and this bug is very easily reproduced. Not to
mention very frustrating. BTW we are running NT 4.0, I haven't tried to
replicate the problem on Win95.

Yours very befudled,

Tue, 19 Sep 2000 03:00:00 GMT  
 [ 3 post ] 

 Relevant Pages 

1. Odd Behavior With CommitTrans

2. Odd behavior with Dates -A2K

3. Access 2.0 odd transaction behavior

4. odd Add Note behavior

5. Externally adding tasks via SQL gives odd behavior

6. Odd recalc behavior with shapeobj.duplicate

7. Odd behavior when inserting TextBox1 into header

8. Odd behavior by socket.select()

9. Very odd behavior with DataTable.Select

10. odd behavior in Qbasic

11. Help, VFP - List boxes on pageframes with odd behavior

12. Odd printing behavior on Win2000


Powered by phpBB® Forum Software