Jump to content

John.M

Members
  • Content Count

    41
  • Joined

  • Last visited

Community Reputation

0 Neutral

About John.M

  • Rank
    member
  1. Hello, I have a couple of questions around trying to get a stored procedure to work using the Execute SQL script step. 1. With that script step you need to specify a DSN and it looks like it's limited to a local user DSN. Is there a way to use the System DSN set up on the server so it doesn't have to be set up on every user computer? 2. Is anybody able to execute a stored procedure just passing parameters with the script step? We haven't had any luck with that or writing data to a SQL table with a stored procedure kicking off once the record is committed. I get an ODBC error wit
  2. I'm in the middle of upgrading from FM11 to FM13/14 and found sets of data will not import to mySQL correctly. Instead of the found set importing, the whole table gets imported. I get the same result on FMPA 13 and FMPA 14 32 bit. FMPA 14 64 bit won't even import at all. This process has been working for years in v11 and older versions. Server: mac 13.0.10.1004 Client: Windows 7 mySQL: 5.6, ODBC driver: 5.2 and both the 32 bit and 64 bit drivers connect to mySQL successfully. Anybody else have this issue? Thanks, John
  3. I found the issue. The base URL needs to be set in the startup script.
  4. I have several solutions that use Super Container and I'm having an issue where the portal container will intermittently show the thumbnail,while at other times it will show "Error" in the same container field. If I bring up the record in the base table, the image shows correctly. Please see the attached file. Thanks in advance for insight on this issue. John  Â
  5. Hi Webko, In this instance, the calls are for an internal AS/400. We use XML to pass data between FM and the AS/400, so that part of the URL is correct. Regards, John
  6. Hello, I'm trying to troubleshoot getting results from the web publishing engine. I've created a script that will return results as expected (24 records for my test), but when I try to run the script from a webpage, I get the fieldnames returned but no results. There are other calls using the WPE that work fine and I believe the URL is correct. It's below so others can see if it's correct. http://corkwood/fmi/xml/fmresultset.xml?-db=ocp_fmp_webinterface&-lay=ocp_fmp_webinterface&-script=Digital_Edition_Update&-script.param=30103333&-find I've rebooted the serv
  7. Hello, I know there's a limitation of viewing 255 layouts in the layout dropdown on windows, but I was under the impression there wasn't a limitation on the mac. I currently have 56 layout folders with subfolders in each, but when I click on the Layout dropdown in the GUI, it only shows the first 17. I added a layout and that shows below the 17th folder, but none of the other folders show up. Any ideas what is going on? Thanks, John
  8. Hi Glenn, In the scenario I'm working on, I would know the record ID (not the internal) because it's being stored in another system and I want that system to update a status field in Filemaker. The part I wasn't sure of is when the WPE is processing the URL, if the record ID (user defined) was passed it would find that record and update it all within the one call. That's how I was interpreting what was in the manual, but wasn't sure how to pass a user defined ID. Looks like I'm back to two calls. Thanks, John
  9. I'm new to the web end of FM and am trying to edit a record using a similar URL below: "http://192.168.123.101/fmi/xml/fmresultset.xml?–db=employees&–lay=departments&–recid=13&Country=USA&–edit" The documentation seems a bit sparce on the details and my questions are 1. Is the "-recid" the internal FM record ID or is that one that is user defined? 2. If it's the internal ID, does there need to be a find performed first to capture the internal ID, then do the edit step or is there a way to accomplish this in one URL? What does the URL look like if you can
  10. I have SuperContainer running in a couple of solutions without issue. I'm in the process of adding another document storage library to one of those solutions, so I created a new table and copied the appropriate SC fields into the new table, then updated the calcs to point to the new fields and duped and updated the appropriate scripts. Everything was working fine until I logged out, then logged back in and the portals would show "Error" in the container field. I've verified all of the calcs in data viewer, then pasted the dataviewer calcs back into the field defs and the portals would show t
  11. Thanks for the response. I couldn't figure out how you came up with the values.
  12. Hello, In a previous post I had requested a way to convert tagged text to color and or be stylized. I had a reply with the following calc: Let ( [ formula = Substitute ( "" & Quote ( text ) & "" ; [ "<RD>" ; Quote ( " & TextColor ( " ) ] ; [ "</RD>" ; Quote ( " ; 16646400 ) & " ) ] ; [ "<B>" ; Quote ( " & TextStyleAdd ( " ) ] ; [ "</B>" ; Quote ( " ; bold ) & " ) ] ; [ "<I>" ; Quote ( " & TextStyleAdd ( " ) ] ; [ "</I>" ; Quote ( " ; italic ) & " ) ] ) ] ; Evaluate ( formula ) ) I
  13. This works fantastic, thank you! I was thinking of something far more complex than this! I definitely need to spend time with the "Let" and "Evaluate" functions! Thanks again. John
  14. Hello, Text parsing is not one of my strong points! I need to be able to take tagged text and convert it to formatted text and there can be 0 to many tags in one line to multiple paragraphs. The tags are <RD>, </RD> for red text, <B>, </B> for bold, and <I>, </I> for Italic. An example may look like: <RD>This text will be red.</RD> The text in this line will be black. <B>The text here is bold</B> and this text is black again, then <I>this text is italicized.</I> Formatted it would look like:
  15. Does anyone know of a plugin that will allow you to save text from Filemaker as an RTF File? Thanks, John
×
×
  • Create New...

Important Information

By using this site, you agree to our Terms of Use.