Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Cros Tab
Message
 
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Title:
Environment versions
Visual FoxPro:
VFP 9
Database:
Visual FoxPro
Miscellaneous
Thread ID:
01011056
Message ID:
01011075
Views:
19
Bernhart,

Would this work for you?
SELECT iEmployee, DAY(ddate) as iDay, cNomp ;
  FROM tpsh ;
  WHERE cNomp <> SPACE(2) ;
  ORDER BY 1,2 ;
  INTO CURSOR crsCrossTab
>
>
>I have cursor with :( see on the picture)
>
>WWW.Amline.be\cross.jpg
>
>I want
>
>
>iemployee    1  - 2  -  3  -  4  -5  - 6  - 7 - > 31
>99          '  ' '  '  'JF'
>99          '  ' '  '  'K1'
>
>
>What sql Command can i do with for this result ?
>
--sb--
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform