Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Report Designer keeps rejecting 2 of my fields
Message
General information
Forum:
Visual FoxPro
Category:
Reports & Report designer
Environment versions
Visual FoxPro:
VFP 7 SP1
OS:
Windows XP SP2
Database:
Visual FoxPro
Miscellaneous
Thread ID:
01135024
Message ID:
01135230
Views:
10
Hi Boris.

Thanks for replying (as usual) and, again, congrats on the award.

Yes I'm sure I'm in the correct alias:

1) I select it on the Data Sessions window
2) all other fields from that cursor are allowed without problem (when I DO NOT select the offending 2 fields into the cursor)

Strange thing though. I switched off and went home last night after sending the request. This morning I switched on, ran the sql and report and, the darnest thing, it worked fine.

At the moment, unless it happens again later, I'm willing to put this down as a glitch.

But don't you just hat mysteries like that!? :-)

Cheers

Terry

>>
>>Terry
>
>Are you sure you are in correct alias?
>Maybe your current alias is some other Table/Cursor that have almost identical structure. try this just to be sure:
>
>SELECT ET.Operator, ET.Route, ET.Class, ET.Date, op.Desc as OpDesc, ;
>      SUM(IIF(BETWEEN( ET.date, ldStart1, ldEnd1), Number, 0000000)) AS Num1Pass, ;
>      SUM(IIF(BETWEEN( ET.date, ldStart2, ldEnd2), Number, 0000000)) AS Num2Pass ;
>...
>INTO CURSOS crsWhatever
>SELECT crsWhatever
>REPORT FORM ....
>BROWSE NORMAL TITLE ALIAS()
>
- Whoever said that women are the weaker sex never tried to wrest the bedclothes off one in the middle of the night
- Worry is the interest you pay, in advance, for a loan that you may never need to take out.
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform