I don't know if this is doable, I need to find fields in a table that contain negative numbers with out having to search every numeric field. Can I query the whole table and get a list of Fields that have at least one negative number?
you could loop through the table and for each row loop through each column by referring to the column's ordinal or index number 9columns start at index 0), you do not need to know a column's. Then for each column test its type if it is a number then test if <0.
I don't know if this is doable, I need to find fields in a table that contain negative numbers with out having to search every numeric field. Can I query the whole table and get a list of Fields that have at least one negative number?