Deleting Records

[cubsvikes77]

Every time I try to delete a record it deletes ALL records. It doesn't care that I checked only one record. Can someone explain why this is happening and also how to fix it? Also, if I click into a record to update it, all records are updated with the same info. I have to go into the SQL to update something. The form is working well other than this.

Also, I tried to back up the data I put in to an XML file and had dozens of errors. I checked all options when doing it.

[andrelewis]

As for deleting records, is it possible you didn't set auto increment for your primary key in the Table view? This would mean that all records had the same ID, and selecting one would use that id to delete. Since they all have the same ID they would all get deleted..?

Also you should make sure to include the version you are using, the PHP version and the MySql version as well.

Andre

[cubsvikes77]

That was it. I am pretty new to messing with databases hands on. I altered one thing then another gets messed up. Finally got it worked out after 5 hours of messing with this darn thing. Thanks for the help!

Version 1.0.4

SQL 5.0.24a

PHP 4.4.7