Gerald

You can use a statement like

Select * from table where object into mytable

then compare the number of records in both tables

eg

if tableinfo(table,tab_info_nrows) <> tableinfo(mytable,tab_info_nrows)
then
        note "there are some non object records"
end if

Cheers

Martin




> -----Original Message-----
> From: Gerald Kornelsen [SMTP:[EMAIL PROTECTED]]
> Sent: Friday, 28 May 1999 07:41
> To:   [EMAIL PROTECTED]
> Subject:      MI Ensure all table rows are objects
> 
> Is there a way, thru SQL or any other method, to ensure all rows in a MI
> table are graphic objects?
> 
> We have tables which are typically about 190 000 rows, and we just found a
> couple instances where the
> tabular data was correct, but somehow during the processing, the graphic
> object was lost.  The row
> count and all the tabular data (totals, counts) are intact.
> 
> A real blow to confidence about table integrity!
> 
> Thanks
> 
> Gerald
> ----------------------------------------------------------------------
> To unsubscribe from this list, send e-mail to [EMAIL PROTECTED] and put
> "unsubscribe MAPINFO-L" in the message body, or contact [EMAIL PROTECTED]
----------------------------------------------------------------------
To unsubscribe from this list, send e-mail to [EMAIL PROTECTED] and put
"unsubscribe MAPINFO-L" in the message body, or contact [EMAIL PROTECTED]

Reply via email to