Jump to content


  • Content Count

  • Joined

  • Last visited

Community Reputation

0 Neutral

About DataLackey

  • Rank

Profile Information

  • Industry
    Environmental Consulting
  1. Hi Wim, thanks for replying. This is using FMP on Windows. I haven't tested every resolution/zoom level, but I've tried a few of each and it's happening at each one.
  2. Hi FileMaker people, I used to use FileMaker on a Mac, but have recently switched to a Windows 10 computer. I was developing a database on the Mac, but since moving to PC I'm getting a lot of horizontal lines, blurred text and broken borders, images and buttons as I scroll. I've attached three screenshots as examples - these are happening on most layouts, most of the time. The solution is hosted remotely on a Windows 2012 server. I didn't have these problems when I used a Mac, and I've looked at it on a coworker's Mac over the same internet connection and the problem didn't occur. I
  3. I'm trying to load data into the Amazon RDS db. Sequel Pro and FM are both connected to the same host db using the same ODBC driver. I figure the ODBC driver supports the syntax, since the query works on Sequel Pro. The fact that I'm getting a "forbidden" error rather than a syntax error when it doesn't work suggests that Filemaker supports the command, but I don't know for sure.
  4. Hey Wim, Thanks for looking into this. I didn't realise this was a problem. I'll make sure that the script doesn't reference a file from a container field. That said, it still doesn't solve the issue I first raised. I've tried running the SQL query to load data from a text file that's not stored in Filemaker at all, it still doesn't work. I've run the query with text file sitting in the desktop. Sequel Pro works, Filemaker doesn't. They're both using the same ODBC driver and the same user account on the same external database. Is this a problem with Filemaker's local_infile conf
  5. The container field is set to "Store container data externally', so the text file isn't in the FM database. Sequel Pro can access the file without an xDBC driver. The folder that holds the externally stored container field contents does not have file sharing enabled. As far as I know, file sharing isn't necessary for the LOAD DATA LOCAL INFILE SQL statement. I've had no problems with running these statements in Sequel Pro with the input file in a range of different locations without file sharing enabled. I don't think the file being in a container field is the issue here. If I run a
  6. Yep. The text file is in a container field, stored externally. Trying to load that into the Amazon database. I've got a query that works in Sequel Pro, but doesn't work in Filemaker Execute SQL script step.
  7. Hi, I'm trying to use Filemaker to manage a mysql database on Amazon RDS. I'm trying to set up an import layout that will allow users to load data into into the RDS database. Mostly, Filemaker and mysql are playing well together. But I'm getting a problem when I try import data using LOAD DATA LOCAL INFILE . I've run the query successfully with a different client on the same database (Sequel Pro) but when I run it using the Execute SQL script step in Filemaker I get an error, with the message "Load data local infile forbidden". I've looked around online, and it seems like I need
  • Create New...

Important Information

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