Have a look at the CrossTab generator that ships with VFP. It's referenced by the system variable _GenXTab.
Cheers,
Andrew
>I have a patient table and a visits table.
>Patient
> Patient_ID
> Name
>
>Visit
> Patient ID
> Date
> Treatment Type
> Amt
>
>I wish to write a SQL statement that will generate a cursor as follows
>
> Patient_ID, Name, Amt_1, Amt_2, Amt_3
>
>where amt_1,amt_2,amt_3 are expenses incurred for treatment type 1, 2 & 3 respectively. The output is actually sort of crosstab. All help appreciated. Thanks.
>Best Regards
If we were to introduce Visual FoxBase+, would we be able to work from the dotNet Prompt?
From Top 22 Developer Responses to defects in Software
2. "It’s not a bug, it’s a feature."
1. "I thought I fixed that."
All my FoxTalk and other articles are available on my
web site.
Unless specifically identified otherwise, anthing posted here is purely my opinion and may or may not reflect the policies or practices of Microsoft.