Hi All,
i have a table named PLAN include cdate,gdate,sdate,D1,D2,D3....D200
D means date numbers
&& i found these
LdYear=Year(date()) && 2002
LcStart="01/01/"+transform(LdYear) && 01/01/2002
LcDaynumber=date() - ctod(LcStart) && 277 day of year
&&
anyway by this command
select * from plan into curs CrsPlan Readwrite
and then
alter table CrsPlan drop column cdate
alter table CrsPlan drop column gdate
alter table CrsPlan drop column sdate
i can drop the colums. Until here its OK i have form and two textbox txtfirsdaynumber and txtlastdaynumber now i wantto drop columns
txtlastdaynumber
eg. txtfirstdaynumber = 10 txtlastdaynumber=20
cursor must show only D10,D11,D12,D13,D14,D15,D16,D17,D18,D19,D20
but how ?
TIA
