datatype Decimal in temporary table.

[Bob]

Hi,
I create a temporary table on the fly using DAO. A couple of fields needs to be of type dbDecimal. The <Field> object does not provide the Precision and Scale properties, but <Field3> does. I struggle to use <Field3> and gain access to these to properties, perhaps my references are not correct. Copilot was not much help, so now I ask some real people.

Thanks in advance

 

[Bob]

Thanks. It is exactly the bloat issue I want to avoid.
What do you mean by "overlay the previous copy"

 

[The_Doc_Man]

If you have a "side-end" table - a file that looks like a back-end but in which the tables are defined but 1empty - and you make a copy of it in the area where you need it, then link to the "side end" tables, you are set. Now the next time you launch this, if you use a batch launcher you can just re-copy the unpopulated version of the file to where you were using ing - THEN launch the app. You see, Access links by NAME, not by some internal file identifier - even though such a thing exists. So you delete the OLD copy of the side-end table, replace with a new "virgin" copy, and presto - all bloat has vanished.

Note that even if you want to start with some things in the side-end tables - but those things are always the same, make a copy of the file as you want it to start and copy THAT to where you will use it.

The ONLY issue that could ever be a problem is if you need relational integrity between a side-end table and a non-side-end table. You cannot have RI between tables in two different files.

 

[Bob]

Thank you for your ideas, Doc and Pat! Definitely a lot quicker to implement and maintain than my current approach.
Fun times ahead implementing this.