Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Accessing grid with no alias
Message
From
21/10/2009 06:07:50
Lutz Scheffler
Lutz Scheffler Software Ingenieurbüro
Dresden, Germany
 
General information
Forum:
Visual FoxPro
Category:
Forms & Form designer
Environment versions
Visual FoxPro:
VFP 9 SP2
OS:
Vista
Network:
Windows XP
Database:
Visual FoxPro
Application:
Desktop
Miscellaneous
Thread ID:
01430324
Message ID:
01430326
Views:
49
Hi Robin,

#1 The grid should have a ALIAS this is .RECORDSOURCE
#2 what's wrong with
LOCATE FOR "CLAPWORTHY ROBIN"$CUSTOMERS.SURNAME+" "+CUSTOMERS.FIRSTNAME
?

Agnes
>Hi
>
>I've been using an inherited form class that allows me to quickly & easily pass it a few parameters and it constructs an easy to use grid, and of course I've been happily using it for years.
>
>Been asked to add a Text Search option at the bottom of the grid, no problem I thought.
>
>When I dug around inside this class, to my amazement I found the grid it creates has no alias, the control source of some of the columns can be several fields eg Customers.csurname+" "+customers.cfirstname
>
>So i've no table to search through, the grid has no alias, and the grid is not using an array.
>
>How the hell do I go through the grid, looking for my search string text, in particular I want to be able to search for say
>
>CLAPWORTHY ROBIN
>
>in the grid example, this a combination of the two fields above IE CUSTOMERS.SURNAME+" "+CUSTOMERS.FIRSTNAME
>
>Can anyone help?
>
>TIA
>
>Rob
Words are given to man to enable him to conceal his true feelings.
Charles Maurice de Talleyrand-Périgord

Weeks of programming can save you hours of planning.

Off

There is no place like [::1]
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform