"1. Does your table have a primary key defined?"
BAHHHahahahaha... Why didn't I see that?
Well done. Thank you very much!
-- mike
Randy Clamons wrote:
>Mike,
>
>I would need to know a little more about your table structure to give you a definitive
> answer to your question. For this reaseon, you might want to include your table structure
> information when posting a question.
>
>My first questions would be:
>1. Does your table have a primary key defined?
>2. Does your query include the primary key?
>
>If your answer is no to either question, that is the problem.
>
>Randy Clamons
>Systems Programming
>Astro-auction.com
>
>
>
>
>>------------Original Message------------
>>From: Michael Crowl <octopus@stripped>
>>To: win32@stripped
>>Date: Wed, Sep-22-2004 2:11 PM
>>Subject: Unable to edit rows in Query Browser
>>
>>
>>Problem with MySQL Query Browser on Win2k...
>>
>>I have an InnoDb table called "linkorderevents", with foreign keys like
>>
>>an OrderID and EventID. I wanted to throw a couple of sample rows in
>>there - but Edit wouldn't appear for this table. I tried removing the
>>foreign key constraints, and that changed nothing. I can Edit rows in
>>all other tables in the database except for the two tables that started
>>
>>with "link". I renamed one of them - no change, so that wasn't it. I
>>can, of course, INSERT. I can't think of why this table is producing a
>>
>>resultset that isn't editable.
>>
>>Just wondering if anyone has run across this problem... found nothing
>>in
>>the MySQL bugs database.
>>
>>-- mike
>>
>>--
>>MySQL Windows Mailing List
>>For list archives: http://lists.mysql.com/win32
>>To unsubscribe:
>>http://lists.mysql.com/win32?unsub=1
>>
>>
>>
>>
>
>
>
>
