Is the Date column a db edit field?? If not, then create a stealth(visible false) db edit field linked to the same column name, set the component id , and it should work.
Dan Goldberg -----Original Message----- From: [email protected] [mailto:[EMAIL PROTECTED] On Behalf Of Javier Valencia Sent: Friday, April 25, 2008 11:57 AM To: RBASE-L Mailing List Subject: [RBASE-L] - Updating a Date Column using PROPERTY 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
