Change to not cGroup ==""
>That was the problem. I changed it to !EMPTY(cgroup). Thanks Sergey.
>
>>If SET ANSI is OFF, cgroup <> '' will be always False.
>>
>>>In the IDE when I run the .exe and generate the below select statement, it returns multiple records as it should. However, running the SAME .exe outside the IDE returns no records and the only record that exists is the manually added record of "ALL" (see below). I have manually set the enginebehavior to 80 and 90 for testing purposes and receive the same results. Any ideas?
>>>
>>>
>>>*--In IDE returns multiple records, in runtime only 1 record "ALL" added below
>>>SELECT DISTINCT csubgroup as exp_1, cgroup as cgroup;
>>> FROM sysinfo WHERE cgroup <> '' .and. !EMPTY(csubgroup);
>>> ORDER BY csubgroup INTO table (hdir+'tsubgroups')
>>>
>>>ALTER TABLE tsubgroups ADD COLUMN norder n(4,0)
>>>SELECT tsubgroups
>>>i = 0
>>>SCAN
>>> i = i + 1
>>> REPLACE norder WITH i
>>>ENDSCAN
>>>APPEND BLANK
>>>REPLACE exp_1 WITH "ALL"
>>>REPLACE cgroup WITH "ALL"
>>>REPLACE norder WITH 0
>>>
If it's not broken, fix it until it is.
My Blog