Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Query Help Please
Message
Information générale
Forum:
Visual FoxPro
Catégorie:
Codage, syntaxe et commandes
Divers
Thread ID:
00780728
Message ID:
00780761
Vues:
5
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.
Précédent
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform