Cloning an Alpha or Number Field as a Time

The following script causes the define command to map a DMSII ALPHA or NUMBER time item as a relational database time item.

File name: script.user_layout.payment

update DMS_ITEMS set di_options=256, dms_subtype=3
where dms_item_name='TIME11' and dataset_name = 'HORSE-FEATHERS'