Groups | Search | Server Info | Keyboard shortcuts | Login | Register [http] [https] [nntp] [nntps]
Groups > comp.databases.filemaker > #1531
| Newsgroups | comp.databases.filemaker |
|---|---|
| Date | 2013-11-20 15:59 -0800 |
| Message-ID | <04e807bf-a4f0-4ab9-88e7-e436fddb6061@googlegroups.com> (permalink) |
| Subject | Found record, but field does not have the value displayed in |
| From | Bizouman <bizouman@gmail.com> |
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
Back to comp.databases.filemaker | Previous | Next — Next in thread | Find similar | Unroll thread
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
csiph-web