UltraLite DB v10 on Palm: how to copy?

#1

Hello all,

How to copy clean (only structure with no data, something like template db)
Ultralite DB v10 on Palm (using C++ program written in CW 9)
over existing DB with data programmatically? In the case of embedded SQL
DB it is created automatically on start, with separate DB I have to create
new DB with all the options that were in the old DB and this is not good
for me.

Regards, Anatoly Ivanov

#2

this is what i use:

create empty database on desktop

set DATABASE="DSN=..."
"%SQLANY10%\win32\ulinit" -a %DATABASE% -c "dbf=hamsfadb.pdb" -n HamiltonPub -p
HmL9 -s HamiltonPub

then this database i embed into main prc (zipeed, split to 64kb blocks and put
to resources)

when i launch application and no database is found i join resources into memory,
decompress it (using syszlibarm) and copy to storage with DmCreateDatabaseFromImage

if it sounds too difficult for you then you may omit compression/decompression,
but in my case empty database is almost 2mb big (compressed 66kb) so your
application will grow a lot

i hope it will help

Anatoly Ivanov wrote:

Quote:

Hello all,

How to copy clean (only structure with no data, something like template
db) Ultralite DB v10 on Palm (using C++ program written in CW 9) over
existing DB with data programmatically? In the case of embedded SQL DB
it is created automatically on start, with separate DB I have to create
new DB with all the options that were in the old DB and this is not good
for me.

Regards, Anatoly Ivanov

#3

this is what i use:

create empty database on desktop

set DATABASE="DSN=..."
"%SQLANY10%\win32\ulinit" -a %DATABASE% -c "dbf=hamsfadb.pdb" -n HamiltonPub -p
HmL9 -s HamiltonPub

then this database i embed into main prc (zipeed, split to 64kb blocks and put
to resources)

when i launch application and no database is found i join resources into memory,
decompress it (using syszlibarm) and copy to storage with DmCreateDatabaseFromImage

if it sounds too difficult for you then you may omit compression/decompression,
but in my case empty database is almost 2mb big (compressed 66kb) so your
application will grow a lot

i hope it will help

Anatoly Ivanov wrote:

Quote:

Hello all,

How to copy clean (only structure with no data, something like template
db) Ultralite DB v10 on Palm (using C++ program written in CW 9) over
existing DB with data programmatically? In the case of embedded SQL DB
it is created automatically on start, with separate DB I have to create
new DB with all the options that were in the old DB and this is not good
for me.

Regards, Anatoly Ivanov

#4

this is what i use:

create empty database on desktop

set DATABASE="DSN=..."
"%SQLANY10%\win32\ulinit" -a %DATABASE% -c "dbf=hamsfadb.pdb" -n HamiltonPub -p
HmL9 -s HamiltonPub

then this database i embed into main prc (zipeed, split to 64kb blocks and put
to resources)

when i launch application and no database is found i join resources into memory,
decompress it (using syszlibarm) and copy to storage with DmCreateDatabaseFromImage

if it sounds too difficult for you then you may omit compression/decompression,
but in my case empty database is almost 2mb big (compressed 66kb) so your
application will grow a lot

i hope it will help

Anatoly Ivanov wrote:

Quote:

Hello all,

How to copy clean (only structure with no data, something like template
db) Ultralite DB v10 on Palm (using C++ program written in CW 9) over
existing DB with data programmatically? In the case of embedded SQL DB
it is created automatically on start, with separate DB I have to create
new DB with all the options that were in the old DB and this is not good
for me.

Regards, Anatoly Ivanov

#5

this is what i use:

create empty database on desktop

set DATABASE="DSN=..."
"%SQLANY10%\win32\ulinit" -a %DATABASE% -c "dbf=hamsfadb.pdb" -n HamiltonPub -p
HmL9 -s HamiltonPub

then this database i embed into main prc (zipeed, split to 64kb blocks and put
to resources)

when i launch application and no database is found i join resources into memory,
decompress it (using syszlibarm) and copy to storage with DmCreateDatabaseFromImage

if it sounds too difficult for you then you may omit compression/decompression,
but in my case empty database is almost 2mb big (compressed 66kb) so your
application will grow a lot

i hope it will help

Anatoly Ivanov wrote:

Quote:

Hello all,

How to copy clean (only structure with no data, something like template
db) Ultralite DB v10 on Palm (using C++ program written in CW 9) over
existing DB with data programmatically? In the case of embedded SQL DB
it is created automatically on start, with separate DB I have to create
new DB with all the options that were in the old DB and this is not good
for me.

Regards, Anatoly Ivanov

#6

this is what i use:

create empty database on desktop

set DATABASE="DSN=..."
"%SQLANY10%\win32\ulinit" -a %DATABASE% -c "dbf=hamsfadb.pdb" -n HamiltonPub -p
HmL9 -s HamiltonPub

then this database i embed into main prc (zipeed, split to 64kb blocks and put
to resources)

when i launch application and no database is found i join resources into memory,
decompress it (using syszlibarm) and copy to storage with DmCreateDatabaseFromImage

if it sounds too difficult for you then you may omit compression/decompression,
but in my case empty database is almost 2mb big (compressed 66kb) so your
application will grow a lot

i hope it will help

Anatoly Ivanov wrote:

Quote:

Hello all,

How to copy clean (only structure with no data, something like template
db) Ultralite DB v10 on Palm (using C++ program written in CW 9) over
existing DB with data programmatically? In the case of embedded SQL DB
it is created automatically on start, with separate DB I have to create
new DB with all the options that were in the old DB and this is not good
for me.

Regards, Anatoly Ivanov

#7

this is what i use:

create empty database on desktop

set DATABASE="DSN=..."
"%SQLANY10%\win32\ulinit" -a %DATABASE% -c "dbf=hamsfadb.pdb" -n HamiltonPub -p
HmL9 -s HamiltonPub

then this database i embed into main prc (zipeed, split to 64kb blocks and put
to resources)

when i launch application and no database is found i join resources into memory,
decompress it (using syszlibarm) and copy to storage with DmCreateDatabaseFromImage

if it sounds too difficult for you then you may omit compression/decompression,
but in my case empty database is almost 2mb big (compressed 66kb) so your
application will grow a lot

i hope it will help

Anatoly Ivanov wrote:

Quote:

Hello all,

How to copy clean (only structure with no data, something like template
db) Ultralite DB v10 on Palm (using C++ program written in CW 9) over
existing DB with data programmatically? In the case of embedded SQL DB
it is created automatically on start, with separate DB I have to create
new DB with all the options that were in the old DB and this is not good
for me.

Regards, Anatoly Ivanov

#8

this is what i use:

create empty database on desktop

set DATABASE="DSN=..."
"%SQLANY10%\win32\ulinit" -a %DATABASE% -c "dbf=hamsfadb.pdb" -n HamiltonPub -p
HmL9 -s HamiltonPub

then this database i embed into main prc (zipeed, split to 64kb blocks and put
to resources)

when i launch application and no database is found i join resources into memory,
decompress it (using syszlibarm) and copy to storage with DmCreateDatabaseFromImage

if it sounds too difficult for you then you may omit compression/decompression,
but in my case empty database is almost 2mb big (compressed 66kb) so your
application will grow a lot

i hope it will help

Anatoly Ivanov wrote:

Quote:

Hello all,

How to copy clean (only structure with no data, something like template
db) Ultralite DB v10 on Palm (using C++ program written in CW 9) over
existing DB with data programmatically? In the case of embedded SQL DB
it is created automatically on start, with separate DB I have to create
new DB with all the options that were in the old DB and this is not good
for me.

Regards, Anatoly Ivanov

#9

this is what i use:

create empty database on desktop

set DATABASE="DSN=..."
"%SQLANY10%\win32\ulinit" -a %DATABASE% -c "dbf=hamsfadb.pdb" -n HamiltonPub -p
HmL9 -s HamiltonPub

then this database i embed into main prc (zipeed, split to 64kb blocks and put
to resources)

when i launch application and no database is found i join resources into memory,
decompress it (using syszlibarm) and copy to storage with DmCreateDatabaseFromImage

if it sounds too difficult for you then you may omit compression/decompression,
but in my case empty database is almost 2mb big (compressed 66kb) so your
application will grow a lot

i hope it will help

Anatoly Ivanov wrote:

Quote:

Hello all,

How to copy clean (only structure with no data, something like template
db) Ultralite DB v10 on Palm (using C++ program written in CW 9) over
existing DB with data programmatically? In the case of embedded SQL DB
it is created automatically on start, with separate DB I have to create
new DB with all the options that were in the old DB and this is not good
for me.

Regards, Anatoly Ivanov

#10

this is what i use:

create empty database on desktop

set DATABASE="DSN=..."
"%SQLANY10%\win32\ulinit" -a %DATABASE% -c "dbf=hamsfadb.pdb" -n HamiltonPub -p
HmL9 -s HamiltonPub

then this database i embed into main prc (zipeed, split to 64kb blocks and put
to resources)

when i launch application and no database is found i join resources into memory,
decompress it (using syszlibarm) and copy to storage with DmCreateDatabaseFromImage

if it sounds too difficult for you then you may omit compression/decompression,
but in my case empty database is almost 2mb big (compressed 66kb) so your
application will grow a lot

i hope it will help

Anatoly Ivanov wrote:

Quote:

Hello all,

How to copy clean (only structure with no data, something like template
db) Ultralite DB v10 on Palm (using C++ program written in CW 9) over
existing DB with data programmatically? In the case of embedded SQL DB
it is created automatically on start, with separate DB I have to create
new DB with all the options that were in the old DB and this is not good
for me.

Regards, Anatoly Ivanov