I agree with you. The Lookup wizard needs to display the existing information when it is opened on an existing lookup. The "Add Relationship" is suppose to add...
Hey Dwight, Just curious! - how are we doing with the TFM 4.0 stored procedure debugger? I'm very excited about this new feature - you know! Thank you very...
I can see Tables in MySQL just fine. But when I click the Procedures mini-tab I get: "MySQL Database error. SELECT command denied to user" [my user id] "@" ...
Todd: I am almost certain this is the same bug I have been griping about in the past. I am also pretty sure that is has to do with Insight. I get the same ...
I am not sure if you did this on purpose, but the regular green right pointing arrow has always been "execute statement (f5)" up until the last beta, now it is...
Jim, Double clicking one of the items from the Code Completion menu works on my Toad 4.0.0.288 Beta. I'm starting to get concerned that you guys are seeing...
Jim, This one took me a little bit of time to figure out, but I see what you are talking about. If you manually change the default database using the drop down...
Ernest, It's going slowly. Henrik is working on six or seven different projects at the same time, and stored procs is just one little fix of one project. I'm...
Dwight, Thank you so much for this info. I know the meaning of working with many projects at the same time – no time at all! Thanks again, Ernest Bonat,...
twzdpear, We welcome all newbie questions. I think your user does not have rights to the mysql database. You need to login to mysql as the root user (or ...
Jim, I finally managed to reproduce the error. I had to run Toad on a clean VMware image of Windows XP. I see what you are talking about, now. Apparently our...
Started using Toad (4.0.0.288) with mysql a couple of weeks ago. 1. Occasionally Toad starts using 50% of the cpu and maintains this level until I quit and...
Dwight Fowler wrote: twzdpear, We welcome all newbie questions. I think your user does not have rights to the mysql database. You need to login to mysql as the...
dffmyco, Have you been able to figure out what triggers the 50% utilization? I'm very interested in finding this. I can't write it up until I know how to ...
That was me. Oddly, I have the commit/rollback buttons on one of my connections in the beta, but cannot get it on the others. I need to have this button back...
I am running this query select concat(cl.Season,lpad(cl.Year,2,"0"),cl.ClassID) as `ID`, g.Name as `Category`, cl.Name as `Class Name`, group_concat(distinct...
Here is a hack for the group_concat issue below ... select concat(cl.Season,lpad(cl.Year,2,"0"),cl.ClassID) as `ID`, g.Name as `Category`, cl.Name as `Class...
While Dwight's advice will work I want to make sure a newbie doesn't shoot a foot! Look up "The Principal of Least Privilege" (PoLP) on Wikipedia. Live by it....
Extremely helpful. Many thanks for the guidance and direction. very respectfully, Mike Wertz Boyd Hemphill wrote: While Dwight's advice will work I want to...
Okay, I did some checking with our resident guru, Henrik. Here's the scoop on the new Auto-Commit and the old Commit/Rollback buttons: 3.x (And before that...
Boyd, I ran the following script. It returned the dates as plainly displayed strings: Create Table GroupConcat( id bigint not null auto_increment key, category...
Boyd, I suspect that this has more to do with the third party component that we use to talk to the MySQL database. I don't think we are doing anything 'smart'...
Solution to tabbing through grid! Go to: Tools|Options|Environment|Grid Check the box labeled "Move cell focus with TAB key". I've been looking for this one...
The way I use it is turn off the AutoCommit button in the lower left, run some DML, then I want to commit it, or roll it back. The new way 4.0 uses server-side...
I'm afraid it didn't. In addition, there are a couple of other applications that do allow the user to see Stored Procedures on the same machine. Very...
Dwight: Here is the behavior that I see: If I leave the option for an editable grid checked and open at table in the browser and look at the data, it appears...
Dwight: In beta 288, I followed your directions and learned that I have that box checked. I ran the query I posted earlier and it was still a blob also did not...
Sorry, I should have specified that the date concat is coming back as a blob. It is annoying to have to click in the cell, b/c group_concat is used to bring...