Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
How can i show date names on grid headers ?
Message
From
17/02/2003 10:00:30
Cetin Basoz
Engineerica Inc.
Izmir, Turkey
 
General information
Forum:
Visual FoxPro
Category:
Coding, syntax & commands
Miscellaneous
Thread ID:
00754053
Message ID:
00754079
Views:
20
>Thanks Çetin,
>i think to create 12 table for each month and fieldnames can be day1...day31 .
>only important things here year must match the real year also day names too .
>how is your comment
>
>TIA

12 tables for 12 months !!!
Why not 1 only with extra fields like year and month.
Probably I'd do something like :
*index on bintoc(nYear)+bintoc(nMonth) tag yrmon
set key to bintoc(tnDesiredYear)+bintoc(tnDesiredMonth)
with thisform.myGrid
 ldFday = date(tnDesiredYear,tnDesiredMonth,1)
 .Columncount = day(gomonth(ldFday,1)-1)
 for each oCol in .Columns
   ldDate = date(tnDesiredYear,tnDesiredMonth,;
     val(substr(justext(.controlsource),2)))
   ...
 endfor
endwith
Cetin
Çetin Basöz

The way to Go
Flutter - For mobile, web and desktop.
World's most advanced open source relational database.
.Net for foxheads - Blog (main)
FoxSharp - Blog (mirror)
Welcome to FoxyClasses

LinqPad - C#,VB,F#,SQL,eSQL ... scratchpad
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform