Paranoia99
Programmer
I have built a class (VFP6) that generates an html file from
a table. Testing it in VFP by dropping it on a form, it works great. However, after I compiled it into an out of process COM .exe and instantiated it in an Active Server Page, the object builds the page, but incorrectly. To generate the html page correctly, I rely on the table being ordered by 2 fields for use with SCAN. The problem is, if I drop the class on a form in VFP6, the table sorts as expected. However, the COM object seems to not sort the table at all. In fact, it appears to be in the same exact order as the table I pull it from.
The sort is performed by:
SELECT * FROM mytable into newtable ;
ORDER BY onlevel DESC, posnum ASC
I have tried changing the field names to the appropriate column numbers, and I have tried using SORT TO, but with no success. Each time newtable is still unsorted when the COM server does it from the ASP, and each variation has worked perfectly when making a quick test form in VFP.
Any ideas why this happening?
a table. Testing it in VFP by dropping it on a form, it works great. However, after I compiled it into an out of process COM .exe and instantiated it in an Active Server Page, the object builds the page, but incorrectly. To generate the html page correctly, I rely on the table being ordered by 2 fields for use with SCAN. The problem is, if I drop the class on a form in VFP6, the table sorts as expected. However, the COM object seems to not sort the table at all. In fact, it appears to be in the same exact order as the table I pull it from.
The sort is performed by:
SELECT * FROM mytable into newtable ;
ORDER BY onlevel DESC, posnum ASC
I have tried changing the field names to the appropriate column numbers, and I have tried using SORT TO, but with no success. Each time newtable is still unsorted when the COM server does it from the ASP, and each variation has worked perfectly when making a quick test form in VFP.
Any ideas why this happening?
