Hi Advansys support,
You are always full of good ideas, I took your suggestion and store out the item indices in my form and it does make my data retrieval much more efficient, I am still having to open multiple data connections and wonder if there is a more efficient method.
My next question is I am storing out the month and the year for a date and when I retrieve this record to edit it I would like to set my TRZDateTimeEdit to this date but I keep getting this error:
Could not convert variant of type (OleStr) into type (Double) at line 312, column 7
t_mth = iRST_Edit(“month”)
t_year = IRST_Edit (“year”)
t_date = t_mth & “/01/” & t_year
date_in = CDATE(t_date)
t_date_sel = formatdatetime(date_in,1)
CDIP_FRM.MonthEdit.date = t_date_sel
Can you please tell me why?
Next question is that I have my itemindex for my listview stored in the database as well but have not successfully been able to mark it as selected when retrieving my record into my form:
t_guideline = iRST_Edit(“guideline_idx”)
for I = 0 to .Count – 1
if .Item(I) = t_guideline then
.Item(I).selected = TRUE
No syntax error.. no nothing!
- You must be logged in to reply to this topic.