List:MySQL on Win32« Previous MessageNext Message »
From:Randy Clamons Date:September 22 2004 9:41pm
Subject:Re: Unable to edit rows in Query Browser
View as plain text  
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
> 
> 

Thread
HELP with "INSERT SELECT"Daniel Bronzeri Barbosa22 Sep
  • Re: HELP with "INSERT SELECT"SGreen22 Sep
    • RE: HELP with "INSERT SELECT"Jordan Sparks22 Sep
      • undefined function mysql_connect()Catapult Webmaster22 Sep
        • Re: undefined function mysql_connect()Randy Clamons22 Sep
          • Unable to edit rows in Query BrowserMichael Crowl22 Sep
            • Re: Unable to edit rows in Query BrowserRandy Clamons22 Sep
              • Re: Unable to edit rows in Query BrowserMichael Crowl22 Sep
RE: HELP with "INSERT SELECT"Hernando Patino22 Sep
  • Re: [BRMA-ALTO-RISCO] RE: HELP with "INSERT SELECT"Daniel Bronzeri Barbosa22 Sep