[Fwd: Question]
John Esak
john at valar.com
Mon Aug 2 22:05:56 PDT 2004
I'm not sure, but I found a bug with pkeep that meant you had to start the
initial key lookup for the browse with a "1" instead of a "" on a numeric
code.... the pkeep would always return to tht top if "" was used... However,
you sound like you are re-excuting the browse with a different value stuffed
into a new key and that won't help here.... not sure...
John
> -----Original Message-----
> From: filepro-list-bounces at lists.celestial.com
> [mailto:filepro-list-bounces at lists.celestial.com]On Behalf Of Walter
> Vaughan
> Sent: Monday, August 02, 2004 8:08 PM
> To: filepro-list at celestial.com
> Subject: [Fwd: Question]
>
>
> Reformatted for the HTML mail impaired...
>
> -------- Original Message --------
> Subject: Question
> Date: Mon, 2 Aug 2004 19:54:19 -0400
> From: George Simon <flowersoft at compuserve.com>
> Reply-To: George Simon <flowersoft at compuserve.com>
> To: Filepro 2 List <filepro-list at nospam.celestial.com>
>
>
>
> Today I came across something I did not know.
> I have a zip code file of US and Canadian zips in a filePro database.
> Index A is build on the zip code field and the city field.
> I'm doing a lookup into it using the zip code only. If I find a match,
> I do a getnext and if it is the same zip code but to a different city, I
> display a browse window with all the cities matching the zip code, for
> the user to choose from. This works fine.
>
> However, if there is already something in the city and zip code fields,
> I wanted to display the same browse window but with the highlight on the
> record matching the city. To acomplish this I was stuffing a dummy
> field with the contents of the zip & city fields like: ky=77&75
> and doing the lookup. In order not to display zip codes that did not
> match, I put a match length of 7 (the length of the zip code field) in
> the browse lookup. To my surprise, the highlight always falls on the
> first record of the browse window, even though doing an errorbox of the
> ky dummy just prior to the lookup, shows that it contains the zip code
> and city. Changing the position of the first record to middle or bottom
> has no effect, the highlight bar is always on the first record matching
> the zip code. Is this because I put a match length of 7 on the lookup
> or should it work the way I thought it would?
>
>
> _______________________________________________
> Filepro-list mailing list
> Filepro-list at lists.celestial.com
> http://mailman.celestial.com/mailman/listinfo/filepro-list
More information about the Filepro-list
mailing list