>My code is:
>select * from mytable where ascan(myarray,myfld) # 0 into cursor mycursor...
>What does # 0 mean or do ????
For every record in your table, this performs an ASCAN to see if the value is in the array. If it is (ascan returns a positive number) then it is part of the result set.
Larry Miller
MCSD
LWMiller3@verizon.netAccumulate learning by study, understand what you learn by questioning. -- Mingjiao