Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Query Help Please
Message
General information
Forum:
Visual FoxPro
Category:
Coding, syntax & commands
Miscellaneous
Thread ID:
00780728
Message ID:
00780761
Views:
6
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
Map
View

Click here to load this message in the networking platform