Question
database View can see tables but not columns! HALP!!!
ok the setting:
FreeBSD Server PHP MySQL technology using MX Kollection 3 .... Connection is working I can see all of the tables I can also see the columns in all of the tables EXCEPT one table that one i see the table but it shows NO data. I have deleted the table and rebuilt it several times ... attempted to optimize the table ..... Nothing works. However!! IF i look at the table data (right clicking the table and selecting view data) in that mystery table It shows all of the columns!! BUT not in the normal database view ...... Nor does it recognize colums when setting up ANY recordsets ..... I have gone bald .... a toupe will fix that ... but how do i fix this table!!???
FreeBSD Server PHP MySQL technology using MX Kollection 3 .... Connection is working I can see all of the tables I can also see the columns in all of the tables EXCEPT one table that one i see the table but it shows NO data. I have deleted the table and rebuilt it several times ... attempted to optimize the table ..... Nothing works. However!! IF i look at the table data (right clicking the table and selecting view data) in that mystery table It shows all of the columns!! BUT not in the normal database view ...... Nor does it recognize colums when setting up ANY recordsets ..... I have gone bald .... a toupe will fix that ... but how do i fix this table!!???
AdChoices