Sal Mercker
|
Posted: 01/10/2005, 5:04 PM |
|
trying to figure out how to set up codcharge to use ms access for php pages. thought i had it workign but it is still trying to pull up sql databses for applications like stores. telling me it is a bad string or something.can someone help me figure out what i am doing wrong?
|
|
|
Sal Mercker
|
Posted: 01/10/2005, 5:07 PM |
|
one wanted to fix my email address i put on the last post cause it is wrong this is the right one. plus this is one of the errors i am getting.
Warning: odbc_exec() [function.odbc-exec]: SQL error: [Microsoft][ODBC Microsoft Access Driver] The record cannot be deleted or changed because table 'store_products' includes related records., SQL state S1000 in SQLExecDirect in C:\Program Files\Apache Group\Apache2\htdocs\KDASTORE\db_odbc.php on line 86
Database error: Invalid SQL: DELETE FROM store_categories WHERE category_id = 1
ODBC Error: 1 (General Error (The ODBC interface cannot return detailed error messages).)
Session halted.
|
|
|
Sal Mercker
|
Posted: 01/10/2005, 5:10 PM |
|
basically it wont let me delete the old info that came when i built the store template.
|
|
|
peterr
Posts: 5971
|
Posted: 01/10/2005, 10:51 PM |
|
Looks like this is due to database restrictions. You can remove those restrictions by editing the relations in MS Access, or you can delete the records in right order: first delete the child records then the parent. Generally it is very good that an application doesn't allow you to delete categories if any records for those categories weren't deleted yet.
_________________
Peter R.
YesSoftware Forums Moderator
For product support please visit http://support.yessoftware.com |
|
|