I have an update that is failing because, I believe, there are deleted records in the table. I think that I used to avoid this by selecting * from table, and it would only return valid records. Now the SQL returns deleted records into the query (improvement?).
I can avoid this on spatial tables by first doing a selection on the table:
Select * from Table Where Obj Into UpdateTable
Update Table UpdateTable Set .....
However, is there an equivalent test for non spatial tables? I have found one (just then - finding an ansewr is often a matter of posing the question):
Select * From Table Where RowID > 0 Into UpdateTable
Is there a better test?
Thanks R --
Robert Crossley
Agtrix P/L 9 Short St PO Box 63 New Brighton 2483 Far Southern Queensland AUSTRALIA
153.549004 E 28.517344 S
P: 02 6680 1309 F: New Connection M: 0419 718 642 E: [EMAIL PROTECTED] W: www.agtrix.com W: www.wotzhere.com
--------------------------------------------------------------------- List hosting provided by Directions Magazine | www.directionsmag.com | To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] Message number: 12406
