Hi,

I've got a situation where we have a database application in vehicles.
(Stand alone / one PC per vehicle).

In the main office we have the main office database, which on a regular
basis needs to obtain information from the vehicles database.

I was wondering if anyone had any suggestions as to which is the best
way to go about doing this.

My first thought was to use the internet, and have a DBISAM server in
the office, and have the vehicles connect to it and do a :


Insert into ServerDB\MyTable (Field1, Field2, Field3)
select afield, 2ndfield, 3rdfield
from LocalDB\mytable
where ...


....however, I don't think it's possible to select from one (local)
database and insert into another (remote) database within the same Query?

Other options I've thought of, but are not sure on the best way to go are:

b) Have two seperate tables, one connected locally, and the other
removely and individually insert records from one into the other...

c) Save the records I want inserted into a table - transfer that table
to the server using FTP (or whatever) and then doing the query all at
the one location.

I was just wondering if anyone could recommend which would be best (or
if there is a better way), or see any pitfalls with any of these options?

Cheers

Adam.

Adam,

<< ...however, I don't think it's possible to select from one (local)
database and insert into another (remote) database within the same Query? >>

No, it isn't possible.

<< c) Save the records I want inserted into a table - transfer that table to
the server using FTP (or whatever) and then doing the query all at the one
location. >>

This is the option I would use, although you don't really need to use FTP to
do so.  You can just save the records from a given table to a stream using
the TDBISAMTable/Query SaveToStream method, send the stream to the DBISAM
Database Server using a server-side procedure call, and then just load the
stream on the other end into the destination table.

--
Tim Young
Elevate Software
www.elevatesoft.com

Hi Tim,

I hope you had a great weekend. Got to do some cave diving this weekend,
so I'm all happy!

Thanks for the updates regarding the stream too! Sounds like the way to
go, and will certainly make it more efficient!

Cheers mate

Adam.

Adam,

<< I hope you had a great weekend. Got to do some cave diving this weekend,
so I'm all happy! >>

Yeah, it was okay, which is fine with me.  Be careful with that cave
diving....

--
Tim Young
Elevate Software
www.elevatesoft.com