Re: Select from open view using DBF()

Tech-Archive recommends: Fix windows errors by optimizing your registry

From: Josh Assing (xjoshx_at_jassing.com)
Date: 01/29/05 

Date: Fri, 28 Jan 2005 21:46:42 -0800

Can you provide code that replicates it?

I just created an alias -- and did a select from dbf("MyAlias")

the file it refers to does not exist (no big suprise here) -- and the select
worked fine...

What VFP? an d code to replicate it would be handy... (Create cursor)
becuase my steps worked w/o error.

On Fri, 28 Jan 2005 13:24:00 -0800, "Ron Weldy" <ronweldy@msn.com> wrote:

>I simplified it while testing with the view open and executed it in the
>command window using:
>
>SELECT * from DBF("v_myview")
>
>A straight DBF("v_myview") will return a file name of c:\temp\J2GO003U.TMP,
>but this file does not exist when looking at the temp folder. I also did a
>search using windows explorer but could not find the file.
>
>
>"Josh Assing" <xjoshx@jassing.com> wrote in message
>news:cv9lv0t2ocvvplcpa6p4lvh6o95ri2pta0@4ax.com...
>>
>> what is your statement?
>>
>> On Fri, 28 Jan 2005 11:52:26 -0800, "Ron Weldy" <ronweldy@msn.com> wrote:
>>
>>>I am trying to SELECT from an open view using the DBF() function and it
>>>errors saying 'table does not exist'. Interestingly enough, when I look
>>>for
>>>the tmp file name that DBF() returns, I can't find it either. Anyone know
>>>what's going on or how to do this?
>>>
>>
>>
>> ---
>> Remove x's to send.
> 

---
Remove x's to send.