This topic is 1848 days old. Please don't post here. Open a new topic instead.
I'm trying to export my filemaker records to my external sql database via the execute sql script step but am getting a number of errors.
I can see my external ODBC source and can generally write to it (I can go to the respective layout and click 'new record'). My query basically as follows:
"INSERT INTO dbo.Log ( dbo.Log.log_id, dbo.Log.log_case_idf, dbo.Log.Labour_TOTALS_Labour_Cost, dbo.Log.Labour_TOTALS_Item_Sale) SELECT Log_Log.log_id, Log_Log.log_case_idf, Log_Log.Labour_TOTALS_Labour_Cost, Log_Log.Labour_TOTALS_Item_Sale, FROM Log WHERE Log_Log.Log_Type = '2'" My first question is: is it even possible to export to an odbc source with a 'insert INTO SELECT' query?
Users are more frequently than ever requesting that custom reports be made. Up till now this has involved me creating layouts and scripts that can produce the data/reports in the form they want.
I'm wondering if now it might be possible to let them take control of reporting in a way that is separate from the current database (which is heavy on GUI and disabling of features for ordinary users).
I'm thinking of creating a totally new database which users would be able to completely edit from a design perspective, which would point to the main database as an external data source. However I would like it so that they would NOT be able to edit/create/delete those external records.
I've had a play with it and can't seem to get it to work (we're using external authentication via windows server active directory).
Is such a thing possible?
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 the server and client to both enable 'local_infile'. I know it's enabled on the server (because I can check manually, and the query works on a different client). Does anyone know how to check or change this within Filemaker?
Otherwise, does anyone have any ideas as to how I might work around this? Unfortunately I can't call a stored procedure on the server because the query relies on variables. My understanding is that you can't use variables in a LOAD DATA INFILE statement on the server, and you can't use LOAD DATA INFILE in a prepared statement.
Does anyone know how to change the local_infile variable within the Filemaker mysql client, or failing that, does anyone have a good workaround for the restriction on variables with the LOAD DATA INFILE statement if I run it on the server?
In case it's not already blatantly obvious, I don't really know what I'm doing, so any help (especially help that is dumbed down) would be hugely appreciated.
I am creating a run-time from two linked solution files but cannot get a working solution which references the linked file correctly. When I create the run-time if I attempt to add the linked file to the Solution Files list I get an error message that the file is either open or already linked to the primary solution file.
Of course if I leave it out and create the runtime anyway, when I open the generated run-time I get an error that the linked file cannot be found.
How do I get around this circular issue and why on earth won't FM let me include linked files in the Solutions list when generating the runtime?
Turning to the forum for assistance on this as neither the built-in documentation and external sources seem to provide a working solution to this problem.
Can anyone point me to a clear process for re-linking an external file source (data file) where the solution has previously been saved with the external data source reference removed?
I am making a cut-down copy of a production database from copies of a two-file linked solution. Despite repeated attempts to specify the files as linked to each other under Manage> External Data Sources the external data source is not found.
Advice I Googled suggested going into Manage>Database>Tables and looking for italicised tables with "Data Source Missing" messages and that they could be re-linked from there. This is not the case, the interface file does not list external tables in the tables tab (and doesn't on the original working solution either). The Relationship Graph does show tables from the linked solution and has marked them as "Data Source Missing".
Surely there is a straightforward way to re-link a file with foreign TO references with the external file that defines them? I've tried re-linking to the file multiple times under Manage > External Data Sources but it has no effect.
Thanks in advance for any help.