>>>>>>>>>Hi everybody,
>>>>>>>>>
>>>>>>>>>I have three simple tables called Software, Hardware, Other which only cDesciption and iActive_Flag fields not to count ID field. I have one form with 3 grids close to each other for these tables maintenance.
>>>>>>>>>
>>>>>>>>>Now I'd like to be able to print a 3 columns report for them. Is Excel my only option here? How would I show 1/0 field in Excel as a checkmark?
>>>>>>>>>
>>>>>>>>>Thanks a lot in advance.
>>>>>>>>
>>>>>>>>Why can't you combine three tables in one cursor and print regular report?
>>>>>>>
>>>>>>>Do you mean combining them based on record number (using 3 extra steps)? I thought about it, not sure if this is better.
>>>>>>>
>>>>>>>Thanks.
>>>>>>
>>>>>>I think - at least in vfp 6 - it's a more than 3 steps
>>>>>>
>>>>>>select Id, desc ;
>>>>>> from table1 ;
>>>>>> into cursor1 ;
>>>>>> order by ...
>>>>>>
>>>>>>select recno() as xxx, * from cursor1 into cursor cursor1 order by 1
>>>>>>
>>>>>>
>>>>>>
>>>>>>
>>>>>>
>>>>>>
>>>>>
>>>>>Yes, reading my mind, are you? <g>
>>>>
>>>>Not really. Just thinking aloud
>>>>
>>>>This is the fastest solution. Do not fiddle around with replace. It's slooooowwwwwwww
>>>
>>>If Rushmore is not there (obviously) then Select-SQL will perform the same scan, i.e. no gains in speed.
>>
>>
>>Try it, and you will see
>>
>>(1) there are no vfp statements (ie the whole scan loop that is done 3 times) to process, hence faster
>>(2) there's no &processing, hence faster
>
>1) Select-sql will make the same number of scans (joins) as in my code
>2) in regard to '&', well it is too old. Please, be assured that if I would spend more than 5 minutes writing it, then I could easily eliminate '&' just to please you.
I said to try it. First test (if you cannot understand why), then argue
Gregory