When I generate the report I get the initial filter screen, and when I click ok to view the report, I get the following error message:
"The report could not be loaded due to the following error: (-2147217900) Cannot truncate table 'Cashier' because it is being refrenced by a FOREIGN KEY constraint.
The table keys only seem to reference themselves, so check your table for integrity. If you don't know how to do that, try deleting the cashiers and reentering them.
-Jerry
hi..... Thank you for help for me...
Actually, We have 2 cashier(Admin, me) and We delete cashier 'me', but following Error MSG again
Run-time Error '-2147217873(80040ef) Delete statement conflicted with COLUMN REFERENCE constraint 'FK_NWT_Mobile_cash_392E6792' The conflict occurred in database 'bsw_vic1' table 'NWT_Mobile cashier',column 'cashierID'.
How to do.......Please..
"JerryData" wrote:
Hi. You most likely have a bad table entry field (it happens). The only thing I can think of doing for this is to go into the database to see the table. You most likely need to correct the table entry... One way to do this is to go to the RMS Administrator and you can do a query to see what's in there. type: (first part you can cut & paste the hit the green arrow:) SELECT * FROM Cashier (then click the green arrow) This will show you the table entries. Note the ID # of the bad entry and the bad field. Look closely! Then type an UPDATE statement that makes the correction. Example: UPDATE Cashier SET [Name]='me' WHERE [ID]=7; Then hit the green button.
If this doesn't work, go to the sql2005 Express manager (download it from Microsoft if you don't have it). Once you attach the database you can go right to the table and correct it. If you still can't get it, I'd be happy to look at it via remote. (I doubt I would charge you for this, it is probably a 2 second thing)
hi..... Thank you for help for me...
Actually, We have 2 cashier(Admin, me) and We delete cashier 'me', but following Error MSG again
Run-time Error '-2147217873(80040ef) Delete statement conflicted with COLUMN REFERENCE constraint 'FK_NWT_Mobile_cash_392E6792' The conflict occurred in database 'bsw_vic1' table 'NWT_Mobile cashier',column 'cashierID'.
How to do.......Please..
"JerryData" wrote:
hi.... Thank you for help me........ Then We still problem.... so, Could you look via Remote... I leave phone number......416-508-1355 (Daniel) Or leave your Phone number.....Plz
"JerryData" wrote:
Have something to add? Share your thoughts — no account required.
Ask the community — no account required