Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
SQuery
Message
From
08/05/2008 09:20:37
 
General information
Forum:
Visual FoxPro
Category:
Stonefield
Title:
Re: SQuery
Environment versions
Visual FoxPro:
VFP 8 SP1
OS:
Windows XP
Database:
Visual FoxPro
Miscellaneous
Thread ID:
01308261
Message ID:
01315823
Views:
24
This message has been marked as a message which has helped to the initial question of the thread.
Hi Naomi.

>I see, I may try something like this today. The only problem is that I don't have VFP on the computer I'm using to write reports. Would I still be able to do something like this?

You don't need VFP to write scripts in Stonefield Query; after all, the vast majority of developers using Stonefield Query have never heard of VFP. Use the Scripts node in the Configuration Utility. Click the Add button, type the script name, and enter code in the editbox. For full IntelliSense, including our object model, right-click the editbox and choose Zoom.

>I have an address table. If I would design the report myself, I may use this old trick:
>Address1;Address2;City,Zip
>
>(need to verify it, but that's the idea).
>
>Can I put something like this in the Output expression in the field?

No, since that's a report designer trick and not a valid VFP expression. You'll need to use ADDRESS1 + CHR(13) + ADDRESS2 + CHR(13) etc.

Doug
Previous
Reply
Map
View

Click here to load this message in the networking platform