Creating queries directly in SQL.

[kd5oyd]

I just started using VFP 6 this week and I'm already having issues with the query designer. Can I create and save queries and views without the designers?

 

[chpicker]

Yes, you can. Look into the "CREATE SQL VIEW" command.

Ian

 

[Mike Gagnon]

Yes you can, if you are familiar with the SQL language. Otherwise, I normamly start with the Query design and once I've gone as far as I can with that, I choose Query-ViewSQL and copy the code in my program and continue modifying the code until I get the results needed. Same thing for views.
Or write the whole thing from scratch.

 

[rgbean]

For a better View editor (at least before "Toledo" is released), go to

http://www.geeksandgurus.com,

click on the Developer Tools link and then choose the ViewEditor link. There are versions for both VFP 6.0 and 7.0. Steve and Rick (not me) have provided a number of useful tools at this site.

Rick

 

[Mike Gagnon]

Why Rick, is Toledo comming out with a better View editor? Or are you just hoping?

 

[rgbean]

It's been hinted at that the VFP team has been working on an all new Query / View designer that's more like the one in SQL Server and/or Access. Of course, as always, what will actually be in the "Toledo" release is complete speculation and at least partially dependent on the beta testing. I don't believe that they've even firmed up when that will begin - and those that really know are under NDAs, I'm not, so I can make guesses and try to "read-between-lines" on comments made by MS employees on other forums.

Rick

 

[culleoka]

Still in VFP 5.0, but if you look up 'SQL Select' in help, it may solve your problem. This command gives a totally radical performance speed advantage as opposed to a 'Copy to...for..' or 'Seek...Copy While..' command.

Culleoka

 

[Mike Gagnon]

rgbean

Who knows, more "secrets" might be revealed at the Fort Lauderdale Devcon in september ;-)

 

[kd5oyd]

Thank you all very much- your suggestions helped. I have another question, but its unrelated so I'll start a new thread.