Atlanta Macintosh Users Group - Filemaker http://forums.amugonline.org/index.php <![CDATA[Free FileMaker Templates Online]]> http://forums.amugonline.org/index.php?topic=1061.msg3688#msg3688
1. FileMaker Solutions Archive from FileMaker - these include the solutions that are bundled with the FileMaker Pro application along with 3rd-party files.

2. FMPro.org Web Directory

Lee.]]> http://forums.amugonline.org/index.php?action=post;topic=1061.0 Wed, 22 Aug 2007 11:11:46 GMT http://forums.amugonline.org/index.php?topic=1061.msg3688#msg3688 <![CDATA[Re: Scripting FMP find]]> http://forums.amugonline.org/index.php?topic=1056.msg3681#msg3681 Quote from: Larry Cronkite on August 16, 2007, 10:16:31 AM
I am trying to set up a script that will show the corresponding inventory item when the find icon is clicked in the order window (repeating record).

I have been able to open the inventory window but I have not been able to find the correct setup in the Specify Find Requests panel to cause the inventory window to display the correct corresponding item.

When I set it up to find the inventory_productID = sales_productID I get an AND function - that doesn't work.

Can anyone help?


Larry,

If I understand you correctly, you're trying to hardwire the scripted find request by setting the find criteria via the Specify Find Requests dialog in ScriptMaker - that's not going to give you the flexibility you're looking for.  Your script should:

1. Capture the search criteria from the Sales screen (either via global fields, script parameters, or variables)

2. Go to the Inventory layout

3. Enter Find Mode

4. Populate the appropriate fields with the previously-captured search criteria

5. Perform Find

Hopefully, that was clear enough.

Lee.]]> http://forums.amugonline.org/index.php?action=post;topic=1056.0 Sat, 18 Aug 2007 16:41:30 GMT http://forums.amugonline.org/index.php?topic=1056.msg3681#msg3681 <![CDATA[Scripting FMP find]]> http://forums.amugonline.org/index.php?topic=1056.msg3662#msg3662
I have been able to open the inventory window but I have not been able to find the correct setup in the Specify Find Requests panel to cause the inventory window to display the correct corresponding item.

When I set it up to find the inventory_productID = sales_productID I get an AND function - that doesn't work.

Can anyone help?
]]> http://forums.amugonline.org/index.php?action=post;topic=1056.0 Thu, 16 Aug 2007 14:16:31 GMT http://forums.amugonline.org/index.php?topic=1056.msg3662#msg3662 <![CDATA[Re: FileMaker to MySQL Connection]]> http://forums.amugonline.org/index.php?topic=979.msg3530#msg3530
Okay, I take back the part about "Mac Discrimination." Vista actually does have some occasional advantages over Tiger, such as the ability to instantly see your wireless connection speed at the bottom of the screen. Sometimes you get free things with Vista and other times you get free things with OS X. Like my old roommate once said after stealing my last beer: "It all comes out in the wash."

Quote from: Lee Hoong on July 14, 2007, 11:09:34 AM


This makes sense from a security perspective, especially if the SQL source holds proprietary or restricted data.  There are very few publicly-accessible SQL databases online - most of these are from academic institutions, as you might expect.  The more common scenario would be FMP access to an internal SQL data source (e.g. a corporate SQL Db), in which case, your best bet would be to contact the Db admin to request an appropriate account for access (read-only or read-write).

Lee.
[/quote]]>] http://forums.amugonline.org/index.php?action=post;topic=979.0 Fri, 27 Jul 2007 18:01:58 GMT http://forums.amugonline.org/index.php?topic=979.msg3530#msg3530 <![CDATA[Re: FileMaker to MySQL Connection]]> http://forums.amugonline.org/index.php?topic=979.msg3466#msg3466 Quote from: Todd Daniel on July 14, 2007, 10:03:09 AM
RE: SQL access with FileMaker Pro 9

For those who are following this thread, here's where I'm at so far:

1) Once again Mac discrimination has come into play. If you are a Mac owner, you have to purchase the ODBC drivers from a third party: Actual Technologies - http://www.a...ologies.com/ Cost is $30.


I don't agree with the "Mac discrimination" characterization here.  The fact is that Apple does not provide free ODBC drivers to OS X users as Microsoft does for WinXP (Vista?) users.  The OS X ODBC drivers from Actual Technologies have been "blessed" by FileMaker, i.e. provide the most reliable (tested) connectivity between FMP and a supported SQL source.  Use of ODBC drivers from other vendors should work also.

Quote

2) In my search so far, it appears that typical host providers don't like it when someone tries to make a connection to a SQL database on their server. I will keep researching this. What this could mean is that a person would have to have their OWN server before they can access it.


This makes sense from a security perspective, especially if the SQL source holds proprietary or restricted data.  There are very few publicly-accessible SQL databases online - most of these are from academic institutions, as you might expect.  The more common scenario would be FMP access to an internal SQL data source (e.g. a corporate SQL Db), in which case, your best bet would be to contact the Db admin to request an appropriate account for access (read-only or read-write).

Lee.]]> http://forums.amugonline.org/index.php?action=post;topic=979.0 Sat, 14 Jul 2007 15:09:34 GMT http://forums.amugonline.org/index.php?topic=979.msg3466#msg3466