LocatorGrid in Foxy Classes

Hi Hans,
In FoxyClasses\Docs folder there is FoxyClasses.chm. Under grids classes check MultiSelectGrid and LocatorGrid documentation. Also open sample forms in foxyclasses\samples in design mode and check what properties are set for different purposes. Here is a quick recap:

You can use it w/o setting a single property - form.init:

with thisform.LocatorGrid1

  .cSQL = '* from (" + _samples + 'data\Customer")'

  .Init()

endwith

This creates a grid like VFP native grid but with added capabilities of search/sort/filter (try right click on a column, header click, typing in a column)

And here is another sample with the properties you should use most (suppose we want to create a customer form from customer data and use LocatorGrid as the navigator instead of other ways):

-Create a new form and size it a bit (would put a lot of fields and a grid on it)
-Put a locatorgrid
-Put customer table in its dataenvironment
-Select as many fields as you want from customer table in DE and drag&drop on to form, beneath grid,  using RIGHT mouse button
-Select create multiple controls from the popup that pops when you drop (remember to use RIGHT button, otherwise it automatically creates a grid)
-Set locatorgrid's properties
cSQL: * from customer
followTable: customer
followTag: cust_id
followField: cust_id

-Run the form

I have started to experiment. Working well, except that I got error message at

If !('\MYHEADER.PRG'$Set("PROCEDURE"))

Well, this is probably becasue in my Main program, I have

SET DEFAULT TO SYS(5) + SYS(2003)

*

SET PATH TO ;

BITMAPS, DATA, FORMS, INCLUDE, LIBS, PROGS, REPORTS, D:\DATABASES\CLASS LIBRARIES\HANS FOXY CLASSES, ;

D:\DATABASES\CLASS LIBRARIES\HANS VFP COMMON CLASSES, D:\DATABASES\CLASS LIBRARIES\HANS VFP COMMON SUBCLASSES

"BITMAP ... REPORTS" refers to what is in my particular project.  So, I have no path to the same folders in Foxy Classes:
Bitmaps, classes, Data, DataUpdater, Docs, Forms, Include, Progs, samples (+ files checktree.FXP ... WS_FTP.LOG).

I don't even know if I need a path to them all, but it certainly looks as if I need a path to "Progs", which contains "myheader.PRG".

Kindly advise.

Hans L

Okay, will do.

Thanks,

Hans L

I have looked a little more. Am I right in assuming that everything would work without changes if I refer to

D:\Databases\Class libraries\Foxy Classes\checktree.FXP through D:\Databases\Class libraries\Foxy Classes\WS_FTP.LOG?

It seems that all classes and a lot of prg files and forms and otehr files are directly under folder Foxy Classes.

Regards,

Hans L

Hans,
I am a little confused. On my computer it is:

d:\foxyclasses

and all foxyclasses folders/files are in that folder. I use it in multiple VFP projects which are located outside d:\foxyclasses. Simply in my projects I have these as included files:

d:\foxyclasses\classes\datetimectrls.vcx
d:\foxyclasses\classes\fontfx.vcx
d:\foxyclasses\classes\global.vcx
d:\foxyclasses\classes\grids.vcx
d:\foxyclasses\classes\importer.vcx
d:\foxyclasses\classes\mvrlst.vcx
d:\foxyclasses\classes\utils.vcx

d:\foxyclasses\classes\myheader.prg

d:\foxyclasses\bitmaps\arrowdn.bmp
d:\foxyclasses\bitmaps\arrowdnall.bmp
d:\foxyclasses\bitmaps\arrowup.bmp
d:\foxyclasses\bitmaps\arrowupall.bmp
d:\foxyclasses\bitmaps\bottom.bmp
d:\foxyclasses\bitmaps\bottom.msk
d:\foxyclasses\bitmaps\down.bmp
d:\foxyclasses\bitmaps\next.bmp
d:\foxyclasses\bitmaps\next.msk
d:\foxyclasses\bitmaps\previous.bmp
d:\foxyclasses\bitmaps\previous.msk
d:\foxyclasses\bitmaps\top.bmp
d:\foxyclasses\bitmaps\top.msk
d:\foxyclasses\bitmaps\up.bmp

When you say "Simply in my projects I have these as included files: ", why do you need those files in your projects if you "... use it in multiple VFP projects which are located outside d:\foxyclasses." (by reference in your "Main.prg" file, I assume)?

Hans L

Oh, so you mean that you put the above in the Project Manager's Class Libraries )vxc), Programs (prg) and Other files (bmp and msk)?

Hans L

Okay! Great, I think I have it now.

Thanks,

Hans L

Instead of select * you would explicitly list the fields in desired order. ie:

select Country, City, Region, Company, Contact, Cust_id from customer into cursor crsCustomer nofilter

(same thing for Locatorgrid):

Country, City, Region, Company, Contact, Cust_id from customer

What I do for editing is to use the same form for the grid and editing fields, grid occupies just a portion of the form. It is a little hard to describe this in plain words. How about I show you on a short online session? If you think it is OK then we might do that on weekend I think (or at night - I don't know your timezone, ours is +2 - currently we are 6 hours ahead of EST, say Florida, didn't switch to daylight savings yet).

PS: In case you think an online session would do then we would use teamviewer for it. Download non commercial version from teamviewer.com.

It is teamviewer. My Skype ID is cetin.basoz. My MSN ID is cbasoz atsign passport dot com (sorry afraid of spam, written like this). I keep MSN open more than Skype. But since I know that you will be calling I will open Skype too tonight.

I can't give exact timing though. I usually head to home around 8:30 PM my time and have dinner. Probably after 10 PM (it is home you know,  anytime in between 10 PM - 3 AM but I will try to make it as close as possible to 10 PM my time).

By the way, what is your skype ID? and/or MSN ID?