Unique Table is nonexistant or not completely specified

[SQLScholar]

Hey all,

On my app (vb6 connected via ADODC\MS datagrid to SQL) i am getting an error on the datagrid control of "Unique table is nonexistant or not completely specified".

The error only occurs on one record (so far) others seem fine - so i am not sure if its the code. It seems to do it when you do a move first/last on the grid. The record count is 1.

Now - i am abit confused what this error message means. Can someone point me into the direction of what this is saying?

TIA

Dan

----------------------------------------
Be who you are and say what you feel, because those who mind don't matter and those who matter don't mind - Dr. Seuss

Computer Science is no more about computers than astronomy is about telescopes - EW Dijkstra
----------------------------------------

 

[BobRodes]

Sounds like the sort of thing you'd get if a null value is encountered. Is there one in the record that causes the problem?

 

[SQLScholar]

Yeah there is....

No nulls i checked.

However i think i might have found a work round. Needs a refresh to the grid before the insert. Cant work out why just this one record though.

Dan

----------------------------------------
Be who you are and say what you feel, because those who mind don't matter and those who matter don't mind - Dr. Seuss

Computer Science is no more about computers than astronomy is about telescopes - EW Dijkstra
----------------------------------------