Hello!
Thanks for the reply. The problem is a bit strange.
As you know I am also using phpMyadmin. Now somethings as not OK in phpMyadmin and some not enough in editor.cgi! I made a conclosion.
CASE :
I keep on deleting all the fields by editor.cgi until ID is reached. Then ofcourse it would not be possible to delete it. Go to phpMyAdmin then. And drop the table itself. So it should have deleted the entire table including the remaining ID primary key.
Then Import the table via SQL monitor. A table is created correctly and the listing is also correct. Then import the data.txt with the help of SQL monitor. it is not able to import as the field names are not added to that table correct but remains like a ghost. The active key is still the earlier ID key!!!
With the help of editor.cgi add anathor field. It will create without problems and also show the two new keys. Now at this instance the phpMyadmin shows the newly created table listings.
This means the old and the new table gets created with the database having the same name.
Conclusion for you to check on MySQL
:
CREATE TABLE TEST having a primary key only.
ID autoincrement primary key,
index ID
DROP TABLE TEST
CREATE TABLE TEST
ID autoincrement primary key,
Name1 varchar(1) default not null,
Name2 varchar(1) default not null,
Name3 varchar(1) default not null,
Name4 varchar(1) default not null,
index ID
phpMyAdmin will show different than editor.cgi delete field link!!!
The problem seems to be in MySQL and my head rather than in both the scripts
Also Robert,
Did you see the work by Mr. Momoto? I would be interested to find out more about him and his scripts. Seems to be killing, isnt it? I think if Links SQL gets all those powers on spawning of processes it would be the only program on the entire internet capable to generate such things in the category.
Further what Alex term current version as beta is not true. Its not. I havent found a single problem absolutely anywhere. Beta by Alex only means there that in the final versions there may be many new splendid surprises of entirely new routines and new features. I have used many Betas. And Ofcourse, I am having a hard time geting along with Links SQL and its power of development. One feels its necessary and a must but takes time to digest them. PHOOOH!!!
------------------
rajani
[This message has been edited by rajani (edited October 10, 1999).]
Thanks for the reply. The problem is a bit strange.
As you know I am also using phpMyadmin. Now somethings as not OK in phpMyadmin and some not enough in editor.cgi! I made a conclosion.
CASE :
I keep on deleting all the fields by editor.cgi until ID is reached. Then ofcourse it would not be possible to delete it. Go to phpMyAdmin then. And drop the table itself. So it should have deleted the entire table including the remaining ID primary key.
Then Import the table via SQL monitor. A table is created correctly and the listing is also correct. Then import the data.txt with the help of SQL monitor. it is not able to import as the field names are not added to that table correct but remains like a ghost. The active key is still the earlier ID key!!!
With the help of editor.cgi add anathor field. It will create without problems and also show the two new keys. Now at this instance the phpMyadmin shows the newly created table listings.
This means the old and the new table gets created with the database having the same name.
Conclusion for you to check on MySQL
: CREATE TABLE TEST having a primary key only.
ID autoincrement primary key,
index ID
DROP TABLE TEST
CREATE TABLE TEST
ID autoincrement primary key,
Name1 varchar(1) default not null,
Name2 varchar(1) default not null,
Name3 varchar(1) default not null,
Name4 varchar(1) default not null,
index ID
phpMyAdmin will show different than editor.cgi delete field link!!!
The problem seems to be in MySQL and my head rather than in both the scripts
Also Robert,
Did you see the work by Mr. Momoto? I would be interested to find out more about him and his scripts. Seems to be killing, isnt it? I think if Links SQL gets all those powers on spawning of processes it would be the only program on the entire internet capable to generate such things in the category.
Further what Alex term current version as beta is not true. Its not. I havent found a single problem absolutely anywhere. Beta by Alex only means there that in the final versions there may be many new splendid surprises of entirely new routines and new features. I have used many Betas. And Ofcourse, I am having a hard time geting along with Links SQL and its power of development. One feels its necessary and a must but takes time to digest them. PHOOOH!!!
------------------
rajani
[This message has been edited by rajani (edited October 10, 1999).]
