GadgetGuy Super User
Joined: June 01 2008 Location: United States
Online Status: Offline Posts: 942
|
Posted: December 05 2018 at 14:39 | IP Logged
|
|
|
Dave-
For a year I have been getting an error on PH Startup that says the IR Table is bad.
I finally got feed up with this nagging and attempted to remedy it today however ...
If I look at the IR Table using the PH SQL Editor the IR Table is empty. BUT if I examine the IR Table, outside of PH, using Access the table has four entries in it. I can delete those entries but when I try to save the fix the table it is saved as an "pwrhome.odb" which PH will not accept.
If I change the Extension to "db" instead of "odb" the file is still non-useable.
Can you suggest how I can get this all resolved?
Edited by GadgetGuy - December 05 2018 at 14:40
__________________ Ken B - Live every day like it's your last. Eventually, you'll get it right!
|
dhoward Admin Group
Joined: June 29 2001 Location: United States
Online Status: Offline Posts: 4447
|
Posted: December 05 2018 at 20:06 | IP Logged
|
|
|
Ken,
If you've got an error with your IR table on PowerHome startup, it could be an issue with the relationship between your EQUIP and IR tables. The
EQUIP table is the parent and the IR table is the child. If you've got IR entries with no corresponding EQUIP entries, then it would cause an
error.
If you're not currently using IR in PowerHome, the easiest way to clean these tables would be to open the PH Multi-Editor, change to SQL mode and
then run the following SQL statements:
delete from ir
delete from equip
With both tables empty, then the error should go away and you should be safe to start working with the IR screens from the PH Explorer.
Dave.
|