01-08-2019 06:11 AM
How is it possible to define the default value of an object's attribute with type "date" to be the respective date?
I did try to use NOW and TODAY, but did not manage to configure it correctly.
Thanks for your help,
Solved! Go to Solution.
11-26-2020 10:26 PM
do you if it's possible to define this in an Access-Warehouse?
I need to save the date when one a) creates a new object and b) edits an existing one.
Thanks in advance
11-26-2020 11:51 PM
Yes, for new data records use the expression =Date() as default value (in table draft view of Access).
For existing data records you can't do this in GeoMedia and an Access Warehouse.
You would need triggers for that. But Access doesn't support triggers with the old mdb database format.
In Access you can solve this problem with events in a form. However you can't use these events in combination with GeoMedia.
In Access 2010 and newer there are macros for tables. This is something like a trigger.
I have never used it in combination with a third party application. And I guess it is more something like an "event on the Access table editor". Maybe these events/macros will not be fired if a third party application use the table. - Anyway, GeoMedia can't use A2010 and newer.
I don't see any possiblities to do this for insert date with the standard attribute property dialog in GeoMedia and an Access Warehouse. It would be only possible with code.