Vince Teachout wrote: > Just being lazy. I need to test a table for fields with numeric > overflow. > > I'm sure I can write a little quick something with TRY/CATCH to read a > table, field by field, row by row, but does anyone know of an easy way? > Something like Select myfield from mytable where (value is keflooey)? > > Not important, just mildly curious. Thanks.
I'd use the TRY/CATCH to catch it (pardon the pun), but also SCATTER/GATHER inside of it for greatest ease, imo. _______________________________________________ Post Messages to: [email protected] Subscription Maintenance: http://leafe.com/mailman/listinfo/profox OT-free version of this list: http://leafe.com/mailman/listinfo/profoxtech Searchable Archive: http://leafe.com/archives/search/profox This message: http://leafe.com/archives/byMID/profox/[EMAIL PROTECTED] ** All postings, unless explicitly stated otherwise, are the opinions of the author, and do not constitute legal or medical advice. This statement is added to the messages for those lawyers who are too stupid to see the obvious.
