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
