Groups | Search | Server Info | Keyboard shortcuts | Login | Register [http] [https] [nntp] [nntps]

Groups > comp.databases.filemaker > #1531 > unrolled thread

Found record, but field does not have the value displayed in

Back to article view | Back to comp.databases.filemaker

Contents

  Found record, but field does not have the value displayed in Bizouman <bizouman@gmail.com> - 2013-11-20 15:59 -0800
    Re: Found record, but field does not have the value displayed in Bizouman <bizouman@gmail.com> - 2013-11-20 16:13 -0800
      Re: Found record, but field does not have the value displayed in Helpful Harry <HelpfulHarry@BusyWorking.com> - 2013-11-21 19:34 +1300

#1531 — Found record, but field does not have the value displayed in

Hello

I'm stuck with a problem, I have a date field and I search for date range OR a specific date.

I have multiple record that are returned in the range, than I focus on a specific date.

The problem is I have one record that keep popping in but the field is empty.

When I sort based on the date, this record show 1st even if the other record have earlier dates.

I have try to make it a repeating field[10] and make sure in the past it was not left with data. The field is not a repeating field anymore. and it doesn't have a carriage return and it set as a date value.

Made a script to set a variable $test=field, display dialog with $test... empty

I create a script to setfield[1 thru 20] to a value of ""

I rebuild the file, save as compacted,
turn off/on indexing,
use the recover console and rebuild index now....  

The record keep popping up in the result. and it's the only record with that specific date (August 31st 2011).

When into the field, Ctrl-I to see the index, and the date is listed, so since it's the only record in the found set, that record fill the index with that value.

What do I miss, How do I get rid of that ?

When I export the sorted found set in the date range into a HTM file or XLSX file I get this:

Date_Fin 	no_client 	E_No_Contrat 	nom_livraison 	adresse1

	GAL700 	PA1395 	M. Joe Smitch 	111 Place Youpi
31 août 2011 	
31 mars 2010 	COM320 	PA1389 	Mme Comeau 	103 Leduc

The 1st row doesn't show any date, than you have the data, the 2rn row get only the date of August 31 2011 and on the 3rd row the sorting of the record goes perfect.

Please help, this rogue record keep showing in my report every month...

My last option is to kill that related data and create a new one from scratch and link it to the original data... but this will fix that issue, but won't do any good if in the future I have more...

Thank you

[toc] | [next] | [standalone]

#1532

By the way FM12Av4 Win7, with FMS12

Guess what.

I created a new layout from scratch using FM template, adding all the fields.

Found the one I was looking for... and BINGO, for no reason in that field, there it is.. 31/08/2011 .... delete the field, and Voila!! it's not returning in the found set.

Now it's working, but WHY ???

[toc] | [prev] | [next] | [standalone]

#1533

In article <84f9627b-59d0-4717-8dd9-3e2f7189c5a7@googlegroups.com>,
Bizouman <bizouman@gmail.com> wrote:
> 
> By the way FM12Av4 Win7, with FMS12
> 
> Guess what.
> 
> I created a new layout from scratch using FM template, adding all the fields.
> 
> Found the one I was looking for... and BINGO, for no reason in that field,
> there it is.. 31/08/2011 .... delete the field, and Voila!! it's not
> returning in the found set.
> 
> Now it's working, but WHY ???

First guess ... especially if the Find is preformed using a Script,
then the original field you were looking at probably wasn't what you
thought it was, e.g. it was the date field or layout was via a
relationship where the record with the date "31/08/2011" didn't meet
the relationship's requirements.

Helpful Harry  :o)

[toc] | [prev] | [standalone]

Back to top | Article view | comp.databases.filemaker

csiph-web