Breaking Long Query into multiple statements ?

From: "Luqman" <pearlsoft@xxxxxxxxxxxx>
Date: Tue, 24 May 2005 00:15:32 +0500

In foxpro for Dos, I have written a Select query, and surely divided each
line with semi colon, but still foxpro compiler raise error

"compiled line too long."

How can I break my query into multiple statements ?

Best Regards,

Luqman

.

Follow-Ups:
- Re: Breaking Long Query into multiple statements ?
  - From: Andrew Howell
- Re: Breaking Long Query into multiple statements ?
  - From: Anders Altberg
- Re: Breaking Long Query into multiple statements ?
  - From: Gene Wirchenko
- Re: Breaking Long Query into multiple statements ?
  - From: Ook

Prev by Date: Re: Installshield Issues with Foxpro Merge Module
Next by Date: sending e-mail from foxpro for dos ?
Previous by thread: OT: Blat -ps switch
Next by thread: Re: Breaking Long Query into multiple statements ?
Index(es):
- Date
- Thread

Relevant Pages

Re: Breaking Long Query into multiple statements ?
... but still foxpro compiler raise error ... >> How can I break my query into multiple statements? ... > SELECT blah blah blah blah....... ...
(microsoft.public.fox.programmer.exchange)
Re: Breaking Long Query into multiple statements ?
... The length of each line separate with a semi colon is ... If your query is longer then the compiler limit, ... but still foxpro compiler raise error ...
(microsoft.public.fox.programmer.exchange)
Re: Breaking Long Query into multiple statements ?
... but still foxpro compiler raise error ... > How can I break my query into multiple statements? ...
(microsoft.public.fox.programmer.exchange)
Re: Breaking Long Query into multiple statements ?
... but still foxpro compiler raise error ... >How can I break my query into multiple statements? ... If you use aliases, define a shorter one and use that as in: ... an order by to get the group-by order. ...
(microsoft.public.fox.programmer.exchange)
Re: concatenate query results to a string
... Greg wrote: ... semi colon. ... I can open a new mail item and I have a query which returns the contacts ... MVP ...
(microsoft.public.access.formscoding)