Re: Distributing Application: Netsetup wouldn't work, Disk144 does by Subhash
Subhash
Wed Feb 16 13:35:08 CST 2005
Thanks Jan for your reply. I can't find documentation on GENDBC. Can you tell
where I can find it. Also, as I am new to VFP, I am not familiar with DML
code. What is it and where I can learn about it.
Could you also elaborate a little on why I need to adopt this approach and
why the Setup wouldn't work in Netsetup option although it works fine when I
use 1.44 MB option.
Thanks.
"Jan" wrote:
> Subhash,
>
> I use gendbc to generate the code to recreate the database and run this code
> in a post install executable. As per my previous answer, this may be the
> solution to your problem. Remember that the setup wizard is discontinued
> after VFP6 and when you upgrade you will need to use another install maker.
> Installshield express is included from VFP7 onwards, but only supports the
> post install executable from vfp8 on.
>
> Using a post install executable gives you better control of database
> installation. Typically you would copy the contents of the database folder
> to a backup folder, destroy the contents of the database folder, recreate
> the database programmatically then append the contents of the database in
> the backup folder to reinstate the user/customer data. Obviously as you are
> in control you can also initiate or derive the contents of new columns in
> your tables.
>
> HTH
> Jan
>
> "Subhash" <Subhash@discussions.microsoft.com> wrote in message
> news:37D1BE8C-478A-4B5C-B2D1-4F8B287563FC@microsoft.com...
> > Jan,
> >
> > I do have databases in the same subfolder in distribution folder as they
> > are
> > in the development folder. I simply copy the subfolder from development
> > folder to the distribution folder. As I said, when I use Netsetup on the
> > same
> > distribution folder, it doesn't work but when I use 1.44 MB option, then
> > it
> > works fine.
> >
> > Thanks.
> >
> > "Jan" wrote:
> >
> >> Subhash,
> >>
> >> When you copy the files to your distribution folder, the databases should
> >> be
> >> stored in the appropriate subfolders and that should work. Alternatively,
> >> you can create DML code to create your data (using gendbc for each
> >> database)
> >> and then in a post executable you can run the generated code to create
> >> the
> >> databases.
> >>
> >> If the databases need to be populated you can use the post executable to
> >> do
> >> this also, either by:-
> >> - including the data in a CSV file where the first field indicates the
> >> database name, the second field indicates the table name and the
> >> remaining
> >> fields
> >> contain the data
> >> - or by providing the data in specific files that you include in your
> >> install
> >>
> >> HTH
> >> Jan
> >>
> >> "Subhash" <Subhash@discussions.microsoft.com> wrote in message
> >> news:9E6870BF-32AB-424A-B9E9-D013087613F1@microsoft.com...
> >> >I have spent over 6 hours today trying to make my distributed program
> >> >work
> >> > using Netsetup in step 3 of the Setup Wizard in VFP 6.0.
> >> >
> >> > With the Netsetup, the application installs fine and some options even
> >> > work.
> >> > However, I have two databases that are distibuted with the application
> >> > named
> >> > wwdata and wwtables. Database wwdata has its dbf files stored in
> >> > \\Appdir\data\ and that of wwtables are in \\Appdir\tables. When the
> >> > application tried to open a table in wwtables, I keep getting the
> >> > message
> >> > "Error instantiating cursor object. File City not found in
> >> > \\....\wwtables.dbc" or something like that. I tried numerous times by
> >> > cleaning up the project and making sure that dbc file is not corrupted
> >> > or
> >> > something, but couldn't get rid of the error.
> >> >
> >> > Finally, I reluctantly selected the 1.44 MB option (I want to
> >> > distribute
> >> > the
> >> > application on a CD in stead of floppies), and BOOM, it work the first
> >> > time
> >> > installation. However, it created six subdirectories DISK1 to DISK6 in
> >> > the
> >> > main directory named DISK144.
> >> >
> >> > Does anyone know the cause of this behaviour and is there any other way
> >> > I
> >> > can create Distribution files under one directory.
> >> >
> >> > Thanks in advance for heliping out......
> >>
> >>
> >>
>
>
>