Jim, I'm still getting to know the nooks and crannies of Toad for MySQL. Sorry for the confusion. This might be something that is beyond our control, since we...
Hey Jim, sorry that I didn't respond to this thread sooner. Yes, our Team in St. Pete (that does the Schema Compare) is aware of the DPI issues. We switched...
attempt to connect to any host with Toad for MySQL 4.0 ********************************************************************** Exception Information ...
Update: I've heard from the developer for the Schema Compare that he has fixed it, so hopefully you should see it in the next Beta. We'll let you know more...
I spent 13 years programming with Paradox ... and now learning the ropes w/MySQL and Toad. I've got a large table of customers and wish to be able to offer...
Allan, First of all, these 3 fields should be index in the customer table. Here I have couple of questions for you: Are you going to look for one field at the...
Ernest, I'd like to have one unique code represent a combination of city, state, zip and county. I would like to be able to give the customer a means by which...
I've got the latest BETA of Toad and am trying to find if it includes a GUI-based ( or any other automated code generator ) for an INSERT INTO table_name (...
When I build a query in the editor as such select from foo f, bar b where f. I wait for the column list to pop up, but the system crashes. I cannot get at the...
I have a Beta user on the Toad for Data Analysis board that has the same issue but I an not reproduce. What are the column names for the foo table? I would...
Hey Debbie: If you mean meta-data driven (i.e. table defn) then the exact DDL is below. If you mean data in the table, the table was empty. Be sure to...
Here are two things that bug me that were not true before build 111 and are still true with the new build: 1. I have the output and connection manager windows...
Thank you very very much for getting it to work. I really appreciate it. Now, how is it supposed work? I don't see anywhere in the Schema Compare help about...
The previous build had this too. When viewing a table's details, the tab bar above it that shows Columns | Data | Information |... Often does not paint and I...
A bit more info. Correction: Table comments *are* preserved, column comments are *not*. I dumped the schema with mysqldump and the tables marked as different ...
Now that I've set up a Lookup Table for one of my other tables. Now ... How do I take advantage of that feature ? For background, I'm familiar with PARADOX and...
Allan, I think, you're talking about two different things here. Paradox is a GUI development system for business applications implementation. Toad for MySQL is...
Ernest, In the HELP INDEX, you will be able to find "lookup tables (Toad)". And here's a blurb from a website about what Look Up Tables allow / accomplish in...
The lookup table utility is designed to help you find the description value for a number id column. For Example: You are selecting column Part_ID and want to...
The buttons on the connection toolbar for commit and rollback have mysteriously disappeared and I cannot get them back. Resetting the toolbar does not work,...
I am having difficulty creating the foreign keys. I created tables for customer and student but keep getting a errno: 150. Using your style of sql on this...
That is a bug in the current Beta and will be fixed for the next release. We are planning to not have the commit/rollback on the connection toolbar by default...
Could you direct me to documentation ( anywhere on the internet or withint Toad for MySQL ) which tells me how to implement / use the Lookup Tables and what I...
Lookup Table Example 1) I am using the Query Builder and need to select from order_item table but only want some specific item_id’s and do not know what they...
Allan, I still do not understand your question. Is your question for a DBA or for an Application Developer? If your question is for a DBA, you can go to the...
I'm concerned that the term "lookup table" may mean one thing in some database contexts and either differently or extremely differently in another database...
I already has a CALL statement with parameters filled in so I pasted it into the Debug Start Parameters dialog. It prompted me with a dialog saying do I want...