On Thu, 2006-03-09 at 08:47 +0000, colincoleman2002 wrote:

> Thanks David,
>
> I am very interested in any other way to get around this problem,
> the system is getting large width wise (number of tables), where one
> delphi form using IBO 4.x has 218 Tdataset controls on it, a load of
> them are DBlookupcombos, due to the fact the system is creating a
> recipe for mixing multi layered polythene film, the users love the
> delphi system because the old system worked on 1 layer ata time, and
> to create a recipe they were going in and out of forms that took
> about 20 seconds to create, so the new system works well, but id
> like to know if your method, copies all the lookup tables values
> into a local firebird Db on each client desk, then runs the form
> against the virtual Db, then when it comes to posting asks the main
> DB for the next generator keys for each table and then loads each

Our backing database is not firebird, so we do not use a generator per-
se, but the principle is the same. We invoke our key generator for (n)
keys on a given table and it reserves that many keys and responds with
the lowest value. We then populate the in-memory row representations
with a loop (TClientDataset rows).

> table across the void by hand?