Hi folks, I've been posting on the normal mysql toad board because I didn't know this one existed. David asked me to move this post to this board since it may...
I am trying to create a table and have run into a couple of problems. 1. I cannot seem to specify the primary key (except in the script. 2. It seems the...
I am getting one error on startup of toad. I first noticed it after the issues I experienced with having an invalid view (that I fixed by dropping the bad...
I have experienced this problems several times, so I included the script I am running: If I try to run this migration, it will execute the create table, but ...
I am one of those who loves/depends on syntax highlighting. The editor does not seem to have many of the reserved words like engine and innodb. I would like...
Yes, you can add keywords. Go to you application direction and in the Templates\Languages directory find Language.SQL.MySQL.xml. Add keywords to the...
Can we get the creation script for the 'job_posting' table? Without it your script doesn't run. Thanks, Steve ... From: toad_mysql_beta@yahoogroups.com ...
Follow these steps: Click on the current db, then on the tables and you will see a list of tables in the right pane. (So far so good). Expand the tables node...
This weeks Beta build 313 is ready for your suggestions, critique, and praise. :^) http://www.toadsoft.com/toadmysqlbeta.html Your mission, should you accept...
I've created a simple table like this: /* Formatted on 2006/04/06 08:26 (MySQL Formatter v5.34) */ CREATE TABLE `test` ( `a` int(11) NOT NULL default '0', `b`...
Simone Tellini
toad@...
Apr 6, 2006 6:38 am
293
Simone, I cannot replicate the first issue you're having inserting data into the `test` table. If you can get me any more info on how you replicate this issue...
On Thu, 6 Apr 2006 08:54:31 -0700 "Steve Moody" <steve.moody@...> wrote: SM> I cannot replicate the first issue you're having inserting data SM> into...
Simone Tellini
toad@...
Apr 6, 2006 5:00 pm
295
Simone, I am now able to replicate the exception. I have created CR0168177 to track this issue. If you start to see this error again a workaround is to refresh...
Got Error "Index was outside bounds of array" When selected Flush and reset with Local selected and Tables with read lock ...
tariq.rahiman@...
Apr 10, 2006 1:51 pm
297
Got error when I selected Object palette When I clicked on Variable it expanded.. When I clicked again on variable it showed me error Similar behavior when I...
tariq.rahiman@...
Apr 10, 2006 1:59 pm
298
I connected to a server without specifying a database (4.1.12). I then selected the database in the drop down window. When I type a query, it does not give...
Hi, I tried to replicate this issue and could not. I can successfully connect without a database, open an editor, select a database from the dropdown, and...
I cannot recreate it. I think it may be an issue where I need memory for my machine. I will let you know if I can get a handle on it otherwise. Thanks Boyd...
The editor is driving me nuts because the auto indent feature does not work like anything that I am used to. It seems that it returns to the last tabstop on...
This is the way that the Visual Studio editor works so I imagine the author of the component emulated that editor. I know this doesn't really answer your...
I pasted the query below into the editor and clicked the formatter. Nothing happens except the comment being added at the top. select q.question_num,...
It doesn't like the 'as' in this part of the script: ...group by r.participant_id) as fr If you take out that one 'as' it formats fine. I'll create a CR to...
Steve: Sorry for the delay. As an FYI, the "as" is required for this query because it names a virtual table. There would be no other way to reference the...
Boyd, I believe that the "AS" keyword is optional when aliasing in the select statement. If you change the code to this is should still run and format: ...