I have a form in which I need to update 3 columns using the PROPERTY
command. One column is TEXT, the second column is INTEGER and the third
column is DATE. I am able to update the first two columns but I cannot seem
to be able to update the DATE column.
vinsp_date is a valid DATE variable.
vseg_pvmt_type is a valid TEXT variable.
I have tried the following:
SET VAR vTempYear TEXT = ('''' + CTXT(IYR(.vinsp_date)) + '''')
SET VAR vTempDate1 TEXT = ('''' + CTXT(.vinsp_date) + '''')
SET VAR vTempDate2 TEXT = (CTXT(.vinsp_date))
-- The following line updates the INTEGER columns correctly
PROPERTY vci_insp_year TEXTVALUE &vTempYear
-- The following line updates the TEXT columns correctly
PROPERTY vci_test_pvmt TEXTVALUE &vseg_pvmt_type
PROPERTY vci_insp_date TEXTVALUE .vinsp_date
PROPERTY vci_insp_date TEXTVALUE &vinsp_date
PROPERTY vci_insp_date TEXTVALUE .TempDate1
PROPERTY vci_insp_date TEXTVALUE &TempDate1
PROPERTY vci_insp_date TEXTVALUE .TempDate2
PROPERTY vci_insp_date TEXTVALUE &TempDate2
With no luck. Are DATE columns not updatable via the PROPERTY command?
Javier,
Javier Valencia
913-315-3137
