>I can't get an SQL statement to run properly. The function actually examines the contents of the table to determine the class the 'customer' belongs ,creates an instance of that class, and then runs the appropriate class code. When I try to run this in an SQL statement it appears to run for ALL customers even though I specify that it is to run only for customers with balances. This is a lot of overhead in addition to the fact that the class code calls dialog boxes if there is no balance. I don't want to change the class code..
>
>I have found a way to do this. I add a numeric field to the SQL statement, have it go into a table rather than a cursor. Once the SQL is finished, I scan the table and run my function on each row. Seems to work fine. Thanks for your help.
Well, main thing is that you solved the problem. :-)
William A. Caton III
Software Engineer
MAXIMUS
Atlanta, Ga.