General information
Category:
Coding, syntax & commands
Hello Yuri,
I am using (ctoday - ttod(resp_due_dt)) as days with the following and i am getting the error message
function, type, count or argument is not valid on the select statement.
Could you please tell me Yuri. what do i need to change.
******************************Start*****************************
ctoday = date()
CREATE CURSOR cuList2 (project_no C(3), workpkg_no C(5),sub_title C(150), days n(3))
for n = 1 to thisform.list1.listcount
col1 = thisform.list1.listitem(n, 1)
col2 = thisform.list1.listitem(n,2)
select project_no,workpkg_no,sub_title,(ctoday - ttod(resp_due_dt)) as days ;
from sub where project_no = col1 and workpkg_no = col2 and empty(to_cont) ;
and resp_due_dt <= ctoday into cursor temp
select cuList2
append from dbf("temp")
use in select("temp")
endfor
******************************End********************************
Thank you.
Previous
Next
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only