Re: Breaking Long Query into multiple statements ?

"Luqman" <pearlsoft@xxxxxxxxxxxx> wrote in message
news:uxRHGx8XFHA.2128@xxxxxxxxxxxxxxxxxxxxxxx
> 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 ?

I may be wrong but hopefully you can extend this first limit with macro
substitution, eg:

m.cmd="WHERE blah blah blah blah......."
SELECT blah blah blah blah....... &cmd

--
HTH
Andrew Howell


.

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: handling a duplicate key error from field to field
    ... Private Sub txtItem_AfterUpdate ... Why are you saving the record to update the field with a query? ... blah blah blah ... typed in the first field is a duplicate key they get the long-winded default ...
    (microsoft.public.access.formscoding)
  • Re: Problem emailing query results
    ... Cleans MI from FN field and concatenates FN.LN.@xxxxxxxxxxxxx as Email field ... that the attached query shows FN LN and the TWO ... "See attached blah blah", True ... assign it to the SQL property of the QueryDef before calling SendObject, ...
    (microsoft.public.access.modulesdaovba)
  • Re: Problem emailing query results
    ... This query generates only one ... Allen Browne - Microsoft MVP. ... "See attached blah blah", True ... assign it to the SQL property of the QueryDef before calling SendObject, ...
    (microsoft.public.access.modulesdaovba)
  • Re: Export Data to Multiple XML Files
    ... selecting on some value of the primary key. ... Let's call the query qryExportOne. ... Dim dbD As DAO.Database ... OutFile = blah blah blah ...
    (microsoft.public.access.externaldata)
Loading