>>Hi:
>>I have the following problem. I have an SQL statement something like this:
>>
>>cSelectStat = "select "+lcfields +;
>> " FROM a "+;
>> " left Join b On b.fieldpk = a.fieldfk "+;
>> " left Join c On c.fieldpk = b.fieldpk "+;
>> " left Join d On d.fieldpk = c.fieldpk "+;
>> " left Join e On e.fieldpk = d.fieldpk "+;
>> " left Join f On f.fieldid = e.fieldpk "+;
>>
>>&cSelectStat into cursor curtemp readwrite
>>
>>select curtemp
>>
>>And it returns me an error like this after executing the last statement: File ‘curtemp.dbf’ does not exist.
>>Is this a setting in FoxPro that I’m missing or something? Are there any instances it will fail to create a cursor? From what I understand that even the records set return no records that cursor still exist.
>>
>>Please advise.
>>
>>Thanks,
>>Jan
>
>Did you end your command with + ; ?
>
>If yes, then the next line is going to be a comment too.
>
>Anyway, it's much better for debugging purposes to write your query like
>
>text to lcSQL textmerge noshow
> select <<lcFields>>
> from ....
> LEFT JOIN ...
>endtext
>
>lcSQL = chrtran(m.lcSQL, chr(13)+chr(10) + ';',' ')
BTW PRETEXT 15 will do that ;-)
Against Stupidity the Gods themselves Contend in Vain - Johann Christoph Friedrich von Schiller
The only thing normal about database guys is their tables.