Am trying to use a cursor as the rowsource for a combobox in a grid. This combobox is bound to a date field in a table. The cursor is a one field cursor (a date field) that consists of 7 records, 7 possible dates for the week.
Instead of having the users type in a date value, i want to let them pick a date from a combobox. Because the validation requires that date to fall within a weekend long period, they would be chosing a date from 7 diff choices. I figure its quicker to chose a date than to type one.....
In the form's init, i create the cursor, drop 7 rows into it, and try to set the combo props:
IF USED("tmpdatedetails")
USE IN tmpdatedetails
ENDIF
CREATE CURSOR tmpdatedetails ;
(cTmpDate D)
thisform.grd1.column1.CboDetdate.rowsource = "tmpdatedetails.ctmpdate"
thisform.grd1.column1.CboDetdate.rowsourcetype = 6
when the code hits the commands to set the combobox props, it hurls with "Data Type Mismatch". what am i doing wrong?