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't it ?
*********** REPLY SEPARATOR ***********
On 10/07/2001 at 10:21 Noel Clarkson wrote:
>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 determines whether delphi uses the key field(s) or the entire
>row to match when updating. Obviously if you match using the entire row
>(which was the default in my setup) you'll never be able to update the row
>because it will always have changed and so woun't match (I'm still
>confussed as to why you'd even have such an option, but one day I might
>understand).
>
>If it is telling you that there is a lock on the table and that is why you
>can't update then I haven't had that happen but I'd suggest trying to
>update from another client interface and see if it complains about the
>table being locked (if you can try one that runs through odbc that might
>help determine where the problem orrigonates).
>
>good luck,
>
>cheers,
>
>noel
>
>On Monday, July 09, 2001 6:59 PM, Patrick Premartin [SMTP:[EMAIL PROTECTED]]
>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 somebody have this problem ?
>> >> Can you explain me how to unlock tables and records with MySQL ?
>> >> Is it a bug in Borland Delphi ou BDE ? Is it a bug in MyODBC ? Is it a
>> >bug in MySQL ? Is it a bug in my program (I don't see where I could have
>> >make an error... but it's a possibility) ?
>> >
>> >
>> >You did not included enough information to solve your problem. But I
>can
>> >thing we can solve it easily if you give us output of "mysqladmin
>> >processlist" while the problem exists. I think we can read out the
>> >problem from there.
>>
>> Hi
>>
>> Only mine process appears in the list. I think the bug in inside the
>Borland Database Engine and its parameters. I'll try something and let you
>know.
>>
>> cu9
>> --
>> Patrick Premartin
>> contacts perso: [EMAIL PROTECTED], http://www.pprem.net/
>>
>>
>>
>> ---------------------------------------------------------------------
>> Before posting, please check:
>> http://www.mysql.com/manual.php (the manual)
>> http://lists.mysql.com/ (the list archive)
>>
>> To request this thread, e-mail <[EMAIL PROTECTED]>
>> To unsubscribe, e-mail
><[EMAIL PROTECTED]>
>> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
>
>
>---------------------------------------------------------------------
>Before posting, please check:
> http://www.mysql.com/manual.php (the manual)
> http://lists.mysql.com/ (the list archive)
>
>To request this thread, e-mail <[EMAIL PROTECTED]>
>To unsubscribe, e-mail <[EMAIL PROTECTED]>
>Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
--
Patrick Premartin
contacts perso: [EMAIL PROTECTED], http://www.pprem.net/
---------------------------------------------------------------------
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
