For an existing global, I have defined a "master column" that contains a $horolog value, and created date and time columns which are subfields of the master. Using the SQL Explorer plug-in for Eclipse and the PIP JDBC drive, I can successfully query for all these fields such as below:
select name,editdt,editdate,edittime from vmthuser where userien=6004
But if I attempt the update the date or time subfield like this:
update vmthuser set editdate = '2008-01-01' where userien=6004
then the result is this:
select name,editdt,editdate,edittime from vmthuser where userien=6004
Daffy Duck;1,33496;1841-01-01 00:00:00;09:18:16;
Instead of $horolog day count, "1" has been set the subfield. Updating the edittime field produces a similar result. I don't have this problem updating regular fields.
Ed
If you would like to refer to this comment somewhere else in this project, copy and paste the following link:
For an existing global, I have defined a "master column" that contains a $horolog value, and created date and time columns which are subfields of the master. Using the SQL Explorer plug-in for Eclipse and the PIP JDBC drive, I can successfully query for all these fields such as below:
select name,editdt,editdate,edittime from vmthuser where userien=6004
Daffy Duck;61076,33496;2008-03-21 00:00:00;09:18:16;
But if I attempt the update the date or time subfield like this:
update vmthuser set editdate = '2008-01-01' where userien=6004
then the result is this:
select name,editdt,editdate,edittime from vmthuser where userien=6004
Daffy Duck;1,33496;1841-01-01 00:00:00;09:18:16;
Instead of $horolog day count, "1" has been set the subfield. Updating the edittime field produces a similar result. I don't have this problem updating regular fields.
Ed