You can do: Select * From Table Where 1 Into UpdateTable (it's a little bit short)
----- Original Message ----- From: "Robert Crossley" <[EMAIL PROTECTED]> To: "MapInfo List" <[EMAIL PROTECTED]> Sent: Wednesday, June 30, 2004 2:51 AM Subject: MI-L Finding Valid records > > 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 > >
