CCBtx

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

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

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

I am getting an error importing my xml with my custom stylesheet. Where am I going wrong? I am importing the following xml: <?xml version="1.0" encoding="UTF-8" standalone="yes"?> <schools> <school> <name>Abraham Lincoln High School</name> <type>public</type> <enrollment>402</enrollment> <city>Denver</city> <state>CO</state> <districtId>55</districtId> <district>School District No. 1 In The County Of Denver And State Of C&

Excellent. Thank you so much, Comment. As usual... works like a charm.

Can someone help me with the following: I want to extract <loc>, <lastmod> and <priority> from this xml: <?xml version="1.0" encoding="UTF-8"?> <urlset xmlns="http://www.sitemaps.org/schemas/sitemap/0.9"> <url><loc>http://www.myurl.com/</loc><lastmod>2014-04-03T15:51:51-05:00</lastmod><priority>1.0</priority></url> <url><loc>http://www.myurl.com/for-sale/TX/100/79109/173-Main-094451242</loc><lastmod>2014-04-07T03:09:00-05:00</lastmod><priority>0.7</priority></ur

Found the Answer: Substitute "&amp;" for "&" inside the quotes.

I am importing XML data. If I want to import the URL of the following XML: <charts> <chart> <name>Median Condo Value</name> <url>http://www.zillow.com/app?chartType=affordability_avgCondoValue&graphType=barChart&regionId=11093&regionType=6&service=chart</url> </chart> Then I use this select statement: <COL><DATA><xsl:value-of select="//charts/chart[name='Median Condo Value']/url"/></DATA></COL> Here is my question. I want to import a Data element that ha

Alexander: Thank you again for your reply. After looking at this, I dont really think it is a loop... because I want all of the data elements in this particular XML in just one data row. So... I went back and read some of Comment's comments (including his direction to w3webschools), and constucted the following which works great. If anyone knows a more straight forward approach... feel free to post. <?xml version="1.0" encoding="utf-8"?> <xsl:stylesheet version="1.0" xmlns:xsl="http://www.w3.org/1999/XSL/Transform" exclude-result-prefixes="xsl"> <

Alexander: I could not get yours to work with the <tr> and <td>. Instead I used the one below and it loops just like you suggested. Is there a way to import the data into one row rather than looping? <?xml version="1.0" encoding="utf-8"?> <xsl:stylesheet version="1.0" xmlns:xsl="http://www.w3.org/1999/XSL/Transform" exclude-result-prefixes="xsl"> <xsl:output method="xml" version="1.0" encoding="UTF-8" indent="yes"/> <xsl:template match="/"> <FMPXMLRESULT xmlns="http://www.filemaker.com/fmpxmlre

I have attached the XML Response. I am trying to get all data elements in one row and in one table. The index for this particular row is ID 6018 which is Colorado, Denver, Montbello. I can get the region and links just fine. What I am having trouble with is the repeating elements for charts an pages Out of Charts, I have table field names for (i) Median Condo Value, (ii) Median Home Value, (iii) Dollars Per Square Feet, (iv) Dollars Per Square Feet and so on. However, you will notice those are returned as the <name> field in each element. For charts, I need the URL of

Thanks so much. That works perfectly.