CCBtx

Great. Thanks Re-indexing the field corrected the problem. Thank you.

I suspect #2 or #3. Can I rebuild the index without copying the database to a new one?

LaRetta.... that is not what is happening here..... I have expanded the size of the field box... done Ctrl-A + Delete, re-entered "N" and "X".... made sure my cursor does not go past that 1 character.... still the same result... no matter what I have in that single char field... the record gets returned with a "Y" search. ...if this makes a difference.... the field entry is controlled by a radio button that only has "Y" and "N" as an option. To test the problem with the search function.... I created a Edit Box field right beside the radio button. So... When I click the "Y" or "N" in the radio button, it obviously changes the value in the Edit Box to the corresponding value, "Y" or "N"... so I am very confident that there is no other value in there separated by a CR or LF

I thought that... It doesnt. And... I just checked it.... no matter what I put in the field, it gets returned when I search on "Y" So... I put an "X" in the field... the record gets returned on a "Y" search, but not a "N" search or "=" search. ...it also returns on a "X" search. I guess I will just delete it and re-enter.... but I wish I knew the cause.

I have a field with "Y", "N" or <empty> as values. When I search on the field for "Y", I get all of the Y's back and one of the "N" There are many more records with N in the field.... I just get one... the same one every time. I am performing the search manually. The environment is FMP 15 against a FM Server 15. Any ideas?

I cant get the paper size correct, or for filemaker to properly control the printer... consistently from a script... in the print setup/print dialogs. Should I find it strange that if I set print settings in print setup, those same settings do NOT appear when I select print? I am giving up. My current work-around is enter preview, create a pdf, open the pdf in Acrobat, and then print the pdf from Acrobat.... obviously a bad solution. If anyone can help, I would really appreciate it.

...so, I have narrowed it down to the paper size in the print driver.... I have probably not had the opportunity in a few years or so about how I hate, hate. hate HATE, HATE.... the fm print driver setup... espescially with clients accessing the solution on a server... and those clients having all different print setups. At the moment... when I chose a page size... I cant get it to save that page size... Joys of FM print engine.... I think that is what it is.... if I can get the proper size to "stick"... it appears to work.

I have.... or else the subpart summary would not show in browse/preview mode... or show in the pdf.

I have a sub summary part that appears on top of the body that does not print. The sub summary part appears properly (with the proper data) in browse and preview mode. In preview mode, if I save to pdf, the sub summary part appears correctly in the pdf. When I print it.... nothing. I believe it has something to do with th FM print.... I am doing everything through a script. I stopped the script and changes a bunch of setting... changed printers.. changed back... no clue what... and it actually printed. But.... when I closed that window... back to nothing. Any ideas?

I am trying to design a recursive field that will give me an IRR of an investment. To calculate IRR, I have to understand recursion. As a guide, I downloaded this very good example.... but do not understand it, Let( $i = $i + 1 ; Middle( "abcdefghkjilmnopqrstuvwxyz" ; $i ; 1 ) & If ( $i < EndLoop ; ¶ & Test ; Let( $i = "" ; "" ) ) ) Can someone explain to me was "Test" does? I feel silly... but can find no documentation on it. And what does the "Let( $i = "" ; "" )" do? Thanks, #1 Solved... Test is the field name... hence the recursion

SOLVED!!! My data had gotten so big, a transaction counter had added a digit which made the data in that field 1 digit longer than the field length. ...sure wish there was a log that told me that rather than searching for it for 3 days :-(

Hey Guys... suddenly, after several months, I can't add transactions to my mysql database. Periodically, I will offload transactions from my filemaker table to a mysql table (once the filemaker table has > 500,000 transactions). The import to the mysql table takes place in a script. I started getting a 729 import error on the mysql table import. (729 = Errors occurred during import...) So... I manually tried to import and -0- records imported. The "Import Summary" reads: --------------------------------------------------------------------------- Total records added / updated: 1500 Total records skipped due to errors: 1500 Total fields skipped due to errors: 0 Table created: <none> --------------------------------------------------------------------------- So... I tried to add one record to the mysql table.... that was several hours ago and filemaker "hangs" while working with the entire 3 million record found set. (The mysql table presently has 3,484,495 records in it and the filemaker table has just over 800,000 records.) If I, say, do a search on a specific date, to constrain the found set count in the mysql, I can add a record just fine. So, it is importing with errors. Can anyone suggest where I start looking for the error. 729 does not tell me much. (The fm database is hosted on an fm server). Thanks

SOLVED. I did not understand Commit properly. I thought Commit committed all records in all open windows. What I am doing is creating a new window for phone, creating the record, and then selecting back to the company window leaving the separate phone window open (but uncommitted). I was then executing commit while the company window was selected. I now execute commit while on the phone window before selecting back to the company window. Problem solved.

Hey guys I am having a very wierd problem. I am on FM Server 12 with FM Pro Adv client. I build a record in "Company" and give Company a unique key, say Company.Key I then build a record in "Phone" and give Phone the Company.Key So. Company::Company.Key = Phone::Company.Key The tables WILL NOT relate until after I go in and change something on the database. So, say I am on the company form with a portal to phone. After I build the records, the portal is blank. I go in to the database, change something, save, come back to the company form, and voila, the portal is now populated. No amount of clicking around, committing, or anything else, seems to create the relationship unless I go in and do something to the database. Ideas???

OMG. That's embarrasing!! Thanks a lot, comment!!!