Re: Breaking Long Query into multiple statements ?


"Andrew Howell" <ajh@work> wrote in message
news:uqjNedDYFHA.2484@xxxxxxxxxxxxxxxxxxxxxxx
> "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
>

Unfortunately you can't do this. It will compile but will throw an error at
runtime. The total length of the sql string is limited, and AFAIK can't be
exceeded in any single query.


.

Relevant Pages

  • Breaking Long Query into multiple statements ?
    ... line with semi colon, 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? ...
    (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)
Loading