What do you do when the handheld's db needs to have a schema update for
added functionality? Pushing the cab is the easiest part.
These are very difficult and complex problems you are trying to solve.
There are companies out there like Dexterra that offer complete mobile
platforms which do such things already.
Lars Black - 21 Apr 2006 18:22 GMT
> What do you do when the handheld's db needs to have a schema update for
> added functionality? Pushing the cab is the easiest part.
I have a setup table that has a "DB Version". When the database is opened, I
check this version against a constant version in the application. If they
differ, the program know what DDL / DML statements it has to run to upgrade
the DB.
> These are very difficult and complex problems you are trying to solve.
It is not THAT complex, I have a couple of apps running that does it
Cheers,
Lars
David Owen - 21 Apr 2006 18:58 GMT
To add on to what Lars mentioned, it's not that hard to do. I have a
process where I can update the EXE or any supporting files on a remote PPC
any time the user has a network connection; this allows me to change
web-service locations, etc.
David Owen
> What do you do when the handheld's db needs to have a schema update for
> added functionality? Pushing the cab is the easiest part.
>
> These are very difficult and complex problems you are trying to solve.
> There are companies out there like Dexterra that offer complete mobile
> platforms which do such things already.