I dont know specifically about FMP but most database ive worked with
run with autocommit default on and you use transactions to control
blocks of statements as a group commit
Ben
On May 28, 2006, at 6:42 AM, Dan Stein wrote:
I may be the only one doing this, but does anyone know if the record is
automatically committed when you insert it into FMP 8 via ODBC.
I am having an intermittent error sign up which looks like the insert
records fails without an error so I am thinking it does not get
committed.
I have added a begin and end transaction to the action to force the
commit
but it would be nice to know if this was required ( which it can't be
since
it sometimes works without it) or just a good idea to prevent this
"error".
--
Dan Stein
FileMaker 7 Certified Developer
Digital Software Solutions
799 Evergreen Circle
Telford PA 18969
Land: 215-799-0192
Cell: 610-256-2843
Fax 413-410-9682
FMP, WiTango, EDI,SQL 2000, MySQL, CWP
[EMAIL PROTECTED]
www.dss-db.com
'I wonder why we say that people are of different "races". It seems
to me,
we're all running at the same speed and heading towards the same
destination. The only "winners" are the ones who've made the world a
better
place for having been here.'
From for Better or Worse 2/28/2006
________________________________________________________________________
TO UNSUBSCRIBE: Go to http://www.witango.com/developer/maillist.taf
________________________________________________________________________
TO UNSUBSCRIBE: Go to http://www.witango.com/developer/maillist.taf
