Re: Copying views from one db to another
From: Stefan Wuebbe (stefan.wuebbe_at_gmx.de)
Date: 08/31/04
- Next message: Mikhail: "Altering Table - Adding Primary Key With References"
- Messages sorted by: [ date ] [ thread ]
Date: Tue, 31 Aug 2004 05:14:44 +0200
"twnety0ne@yahoo.com" schrieb
> "Stefan Wuebbe" wrote:
>
>> Ken,
>>
>> You can use "gendbc.prg" in the Vfp Home() folder and
>> run it to get a result.prg containing your view definitions.
>>
>>
> Thank you Stefan for your reply, I am a newbie can you please explain in a
> more detailed manner...thank you in advance.
You can run it from the command window
DO HOME() + 'tools\gendbc\gendbc.prg'
Then gendbc wants to know which database.DBC it should
analyze and where to put the results.PRG
Afterwards, you can have a look at the result, say you named
it "results.prg":
Modify Command results.prg
... and search Ctrl+F for your view name(s).
The view definition is one CREATE VIEW line plus a bunch
of DbSetProp() statements setting the view / field's properties,
like "SendUpdates", "KeyField", "Tables" etc.
Running the "results.prg" as it is would give you an entire new
(empty) database if you want.
If you just copy and run those lines related to your particular
view, you can re-create the view only, say in another database
container
Create Database yourNew.dbc
Create View ...
DbSetProp(...
hth
-Stefan
- Next message: Mikhail: "Altering Table - Adding Primary Key With References"
- Messages sorted by: [ date ] [ thread ]
Relevant Pages
|
