Am I going beyond the limits?

[Mark!]

I have created a table with about 740 fields. Most of them are CHAR types with a length of 1 or 2. However long before I got finished creating the table, whenever I hit the ALTER TABLE button, I would get the error message “This program has performed an illegal option and will be shut down.” I would be forced to start over, but my added fields would still be there, although any CHAR types with a length greater than 1 would be changed to VARCHAR types.

Any help/advice on this?

Thanks,

Mark!

[Ritesh]

Can you give us the complete steps which you are following when SQLyog crashes?

Are you using the Insert Table dialog box or Alter Table dialog box….

Waiting for your response :huh:

[Mark!]

Here are the steps I'm taking:

Open Database

Open Table

Select Alter Table Structure (or click F6)

Use slider bar to go to bottom of Structure table.

Click on empty bottom row

Type Field Name -tab over- type Datatype -tab over- type Length -tab over 8X- type Field Name -tab over- type Datatype -tab over- type Length -tab over 8x- …..

After I have added some fields, I will invariably be called away, if I click the close box my changes will be lost and it tells me this, so I click the ALTER TABLE button. It processes for a few minutes then pops up the error message.

Let me know if I can help you more.

Thanks,

Mark!

[Ritesh]

Hello

How many columns were present in the table before you started the Alter Table option….

[Mark!]

I don't really know. I started this with MySQL – Front Version 1.16 Knowing I had a lot to add, and not liking the constant moving and clicking I had to do, I went looking for a better tool. I came across NAVICAT Version 5.1.1 I probably had 50 fields in my table, and added 50 more with Navicat. Then I found SQLyog Version 3.11 and added the rest of the fields with it. By tabbing thru I was able to get some speed.

[Author]

Posts