General information
Category:
Databases,Tables, Views, Indexing and SQL syntax
>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.
>
Just want to point out that if the query runs, you don't need the SELECT. The newly created cursor is automatically selected. What happens if you add a BROWSE after running the query?
Tamar
Previous
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only