Hi!
Strange. Try add nofilter at the end. Try add space before ';'. Try to use join clauses instead of joining using WHERE.
What are conditions of running that application on Citrix Server? Can you give more specifics?
>The following SELECT statement causes an "Invalid Subscript Reference" error when run over a Citrix server:
>
>
>SELECT projectid,name,typeid,biddue,tonnage,status,division,projects.salesreid,;
>lastactivity FROM projects,curDivId,curSalesId WHERE projects.division =;
>curDivId.DivisionId AND projects.salesrepid = curSalesId.salesrepid INTO;
>CURSOR curProj
>
>When I run this on my local machine or even over the local network it runs fine.
>What am I doing wrong? Is there a better way to write this SELECT statement?
>
>Thanks in advance for your help,
>Russell Clendenon
Vlad Grynchyshyn, Project Manager, MCP
vgryn@yahoo.comICQ #10709245
The professional level of programmer could be determined by level of stupidity of his/her bugs
It is not appropriate to say that question is "foolish". There could be only foolish answers. Everybody passed period of time when knows nothing about something.