Thanks Alex and Paul!!!
We have cured the problem!!
Alex - your correction still gave me the SQL Error as before.
Paul - your correction was on the nail!! Worked like a charm and my
RecordID now Auto-Increments!!
I appreciate GREATLY all this help guys!! As I mentioned I'm not - and
don't
Le 22/02/2015 22:36, Ian Whitfield a écrit :
|ALTER TABLE Members CHANGE RecordID1 INT UNSIGNED NOT NULL
AUTO_INCREMENT PRIMARY KEY
Try it again, adding the length of field to the INT definition
ALTER TABLE Members CHANGE RecordID INT(10) UNSIGNED NOT NULL
AUTO_INCREMENT PRIMARY KEY
I just checked on my MySQL, and the correct syntax is modify, not
change, for the alter table statement. Change is for changing the
name, I think.
Also, the size of the int data type isn't necessary, but specifying
primary key if the field is already the primary key results in a
Multiple primary
Le 21/02/2015 22:52, Ian Whitfield a écrit :
Hi Ian,
Any chance you can give us the full output of :
describe FedSaints.Members;
from the mysql command line interface ?
You can also obtain the same information via MyAdmin, I'm just not sure
which tab you have to click on (as it varies
On 02/22/2015 03:20 PM, Alex Thurgood wrote:
You could try using :
ALTER TABLE Members CHANGE RecordID1 INT UNSIGNED NOT NULL
AUTO_INCREMENT PRIMARY KEY;
Thanks Alex
I gave this a try in MyAdmin and got ...
Error
*SQL query:*
||
|ALTER TABLE Members CHANGE RecordID1 INT
Thanks Alex
But I fear this is getting nowhere.
As per your suggestion I built a new ODB file and it showed the same
problem.
i have run the MySQLcheck program and it confirms the DB is OK.
Maybe it is a funny in Base itself??? And it may come right with the
next release??
In itself the
Le 20/02/2015 22:24, Ian Whitfield a écrit :
FedSaints.Members OK
So, on the face of it, your data tables are consistent and error free
(with regard to their definitions).
The problem then, would appear to lie with your ODB file. Something,
some setting, or
Le 19/02/2015 15:00, Ian Whitfield a écrit :
Hi Ian,
But when I go back into my Database with the Base Front End the RecordID
is still marked as 'No Auto-Increment' and still will not change!!
What am I doing wrong and how do I urgently fix this??
Did you read Fernand's comment ?
You
Le 19/02/2015 15:00, Ian Whitfield a écrit :
A quick, alternative possibility :
Create a new ODB file that connects to your database. Save it under a
new name.
Open the newly named (and currently empty, at least with regard to
forms, queries, etc) ODB file.
Open the old ODB file.
Try
Hi Alex
I really appreciate your help here!!
But still no luck - My replies are below.
A quick, alternative possibility :
Create a new ODB file that connects to your database. Save it under a
new name.
Open the newly named (and currently empty, at least with regard to
forms, queries,
Le 20/02/2015 15:00, Ian Whitfield a écrit :
I tried to run the 'mysqlcheck' command and I don't know what the output
is but this is what I got ...
That is the output of the built-in help, which gets displayed when you
run mysqlcheck without any parameters. Try :
mysqlcheck -A -p
the '-p'
On 02/20/2015 04:47 PM, Alexander Thurgood wrote:
Try mysqlcheck -A -p
Thanks for the explanation Alex. This is what I get .
FedSaints.Members OK
mysql.columns_priv OK
mysql.db OK
Hi All
I've spent today trying to cure this problem.
I have only ONE table in my Database and needed to make the RecordID
field Auto-incrementing. (I forgot when I set it up)
Using the Base Front End it will *NOT* change the setting - as soon as
you save it reverts to 'No'
Using
On 02/18/2015 05:35 PM, Alexander Thurgood wrote:
Le 18/02/2015 15:23, Ian Whitfield a écrit :
Yesterday I found I had not set my Keyfield (RecordID) to Auto Increment
so I set a new field with phpMyAdmin called 'id'. And this is now
working fine and Auto incrementing. I deleted the old
Le 18/02/2015 15:23, Ian Whitfield a écrit :
Hi Ian,
Yesterday I found I had not set my Keyfield (RecordID) to Auto Increment
so I set a new field with phpMyAdmin called 'id'. And this is now
working fine and Auto incrementing. I deleted the old RecordID field.
Why did you do that ?
Why
15 matches
Mail list logo