Re: tables locked for no apparent reason

2005-04-30 Thread Gleb Paharenko
Hello. Not enough information to make a suggestion. You have a very old version. Upgrade it. Jeff Schwartz <[EMAIL PROTECTED]> wrote: > [-- text/plain, encoding 7bit, charset: us-ascii, 12 lines --] > > I'm running MySQL 4.0.14 and it's locking tables for everything including > counti

RE: tables locked

2001-07-10 Thread Patrick Premartin
Hello I use TQuery for select requests and TTable for update, insert and delete, it's easier than typing an SQL sentence :-) My problem has been resolved by a checkbox on the MyODBC driver: I checked "Safety (check this if you have problems)" and I've no problem anymore. Strange or magic, isn

RE: tables locked

2001-07-09 Thread Noel Clarkson
How are you updating in delphi and what is the error? if you are running a query, setting the edit state and request live (either at design or run time) and then updating the data and it complains that someone else has changed the record then check the TQuery settings, there is one that determ

Re: tables locked

2001-07-09 Thread "Patrick Prémartin"
>> I use Delphi 5 and MyODBC to access a MySQL database. >> >> In my program, I've sometimes a tables locked and I don't understand why >! I am the only user on this database and I change records correctly (as I >do it for other programs on other databases). >> >> Does somebody have this problem ?

Re: tables locked

2001-07-06 Thread Tonu Samuel
Patrick Prémartin wrote: > I use Delphi 5 and MyODBC to access a MySQL database. > > In my program, I've sometimes a tables locked and I don't understand why ! I am the >only user on this database and I change records correctly (as I do it for other >programs on other databases). > > Does so