Re: VFP9 SP2: How do I copy a view in the data environment

Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance



Hi John,

Which sort of view do you mean?
A local SQL View a Remote View or such a set of tables that you use in the DE?
The definitions of Local SQL Views and Remote Views are stored in the DataBaseContainer.dbc. If you want to reuse such this sort of view:



Modify form myForm.scx

click on menu [View]->Dataenviroment then with click with the right mouse on the DE window and use ADD...
In the dialog click on [views] and now you will see all views you've already defined in DBC. Select the one you want to use again, klick [Add] and then on [OK].
In the DE you select the view you just added and activate in the Properties window the tab [Data]. In the property sheet you can alter the alias of the view.

If you mean a set of tables which was in former VFP version called VIEW, you should start the form, select the appropiate datasession and use the command:
CREATE VIEW FileName
Look in the VFP help file for further information.


Or do you want to save the whole dataenviroment as a class?
If it is so open your form's dataenviroment activate it which the mouse and in menu [File] [Save as class] you can select [dataenviroment} to save your DE as a class.
--


-------------------------------------------------------------------------------------------------------------------------
Mit freundlichen Grüßen aus der Zigarrenstadt Bünde

Wolfgang Schmale

"John Dandy" <jdandy@xxxxxxxxxxx> schrieb im Newsbeitrag news:aac6751qvvmffo96a5dnt8ph7bh01hs1n5@xxxxxxxxxx
I don't want to rebuild a view I already have in the data environment.
I want to copy it, rename and use it again. How do I do this?

John

.



Relevant Pages

  • Re: File name comparisons?
    ... > Jas wrote: ... >> to using Perl. ... > in sort order (as your dates do not sort properly, ... > Ok now we are putting a set of local files to a remote location. ...
    (perl.beginners)
  • Re: Problems with LCD TV and STB
    ... after it's been on for about 10 mins I find that when I use the remote ... off any Q-Link type functions. ... Could it be some sort of IR interference from the screen? ... and see if the problem persists. ...
    (uk.tech.tv.sky)
  • Re: File name comparisons?
    ... Jas wrote: ... in sort order (as your dates do not sort properly, ... filename on the remote server which must be a directory, ... List files on remote machine ...
    (perl.beginners)
  • Re: Just a bit worried
    ... Or something of the sort. ... Currently you have to push one button on the tv remote three times (to get ... or change some other critical setting in between. ... I do understand about his feet. ...
    (rec.pets.cats.anecdotes)