Need help saving query to table

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

garyd - 03 Nov 2004 17:06 GMT

I'm new to this. Have created a .dbf flat table in Foxpro 2.6 Mac and have
created a project in VFP 8 in Windows and opened the Mac-created file in
VFP8. I can create a query but need to save the query itself as a new table
(dbf). Can't figure it out. Need step by step to save the query as a .dbf
file. TIA

Reply to this Message

Stefan Wuebbe - 04 Nov 2004 09:18 GMT

Do you want to save the resulting record set ot rather the
query itself?
If the former, you can
Select * From <mac26.dbf> Into Table <vfpResult>
If the latter, maybe a Local View is what you want?
See also http://groups.google.com/advanced_group_search
For example these queries return some interesting threads for me
http://groups.google.com/groups?as_q=local%20parameterized%20view*&safe=images&a
s_ugroup=*fox*&lr=&hl=en

http://groups.google.com/groups?hl=en&lr=&q=local+parameterized+view*+free+table
s+group%3A*fox*&btnG=Search

hth
-Stefan

> I'm new to this. Have created a .dbf flat table in Foxpro 2.6 Mac and have
> created a project in VFP 8 in Windows and opened the Mac-created file in
> VFP8. I can create a query but need to save the query itself as a new table
> (dbf). Can't figure it out. Need step by step to save the query as a .dbf
> file. TIA

Reply to this Message

garyd - 04 Nov 2004 16:13 GMT

I want to create a query, sorted as I need, and then save that data as a new
stand alone table (dbf) that I can then use for other purposes.

> Do you want to save the resulting record set ot rather the
> query itself?
[quoted text clipped - 15 lines]
> > (dbf). Can't figure it out. Need step by step to save the query as a .dbf
> > file. TIA

Reply to this Message

garyd - 04 Nov 2004 16:19 GMT

ALSO, when the query is displayed to the screen, there appears to be no
command window available. The menu has it greyed out. I'm not a sql user.
Assuming the table is named xxx.dbf, I need step by step, literally, to save
the query as a dbf.

> I want to create a query, sorted as I need, and then save that data as a new
> stand alone table (dbf) that I can then use for other purposes.
[quoted text clipped - 18 lines]
> > > (dbf). Can't figure it out. Need step by step to save the query as a .dbf
> > > file. TIA

Reply to this Message

Mike - 04 Nov 2004 18:11 GMT

Not sure how you are doing this, but sounds like you are issuing a
browse within a program.
Add the NOWAIT parameter to the BROWSE command.

-mike

> ALSO, when the query is displayed to the screen, there appears to be no
> command window available. The menu has it greyed out. I'm not a sql user.
[quoted text clipped - 23 lines]
>>>>(dbf). Can't figure it out. Need step by step to save the query as a .dbf
>>>>file. TIA

Reply to this Message

garyd - 04 Nov 2004 23:04 GMT

With the table open I go to Tools/Wizard/Query/Query Wizard/ok/Select all
fields/next/Filter records/next/Finish/Save query and run it. Now, I need to
save the resulting query displayed to the screen as a table (dbf). There is
no command window available when the query is displayed. What's the next step?

> Not sure how you are doing this, but sounds like you are issuing a
> browse within a program.
[quoted text clipped - 29 lines]
> >>>>(dbf). Can't figure it out. Need step by step to save the query as a .dbf
> >>>>file. TIA

Reply to this Message

Mike - 05 Nov 2004 19:00 GMT

Two things that you can try. There are more, but we will stick with
these for now.

1) After the browse window appears you can press <ESC> to clear the
browse window. Your output cursor is still open. Then enter the COPY TO
command: COPY TO <dbfName>.

2) Use the command that Stefan suggested: Select * From <mac26.dbf>
Into Table <vfpResult>. If you need to order your output include the
ORDER BY command. Use VFP help for proper syntax.
SELECT *
FROM <mac26.dbf>
INTO TABLE <dbfName>
ORDER BY <Field1,Field2...>
If you want to use the above SELECT statement in the command window
either make the statement all one line otherwise you will need to end
each line with a semicolon except for the last line. The semicolon is
the command line continuation character for VFP.

-mike

> With the table open I go to Tools/Wizard/Query/Query Wizard/ok/Select all
> fields/next/Filter records/next/Finish/Save query and run it. Now, I need to
[quoted text clipped - 34 lines]
>>>>>>(dbf). Can't figure it out. Need step by step to save the query as a .dbf
>>>>>>file. TIA

Reply to this Message