External data source privilege set

[daroloson]

I have a database the brings in the data using an external data source (MySQL)

and I'm trying to create a privilege set less that Full Access that can access the

data. Everything I've tried so far just gives you don't have enough privileges to do that

(vague about what). I'm guessing with an external data source the account has to be

able to create new records to populate from the source but what are the minimum requirements?

Dani Roloson

University of Waterloo

[dansmith65]

Are you connecting to the MySQL database with an account that has write access?

[daroloson]

Are you connecting to the MySQL database with an account that has write access?

Read-only

[daroloson]

Turns out that I had to add under Extended Privileges for the Privilege Set

Access via FileMaker Network (fmapp)

since the database was on a FileMaker Server.

The error

Your access privileges do not allow you to perform this action.

wasn't very helpful.

Next problem is that for the account I want to do a find when opening the database of

Get(AccountName) on a field but it doesn't seem to execute that.

In Find Requests, how can you use functions?

(Feel free to point me to another forum.)

[daroloson]

Nevermind

I was trying to do just a Perform Find when I should be doing:

Enter Find Mode [] <—— do not restore do not pause

Set Field [AnyTable::SomeField; Get(AccountName)]

Perform Find [] <—— do not restore here either

(I will web search before I post. x 100)

[dansmith65]

I didn't read your first post properly - I thought you were trying to edit MySQL data from FileMaker.

FYI: I prefer to use the method of performing a find that you stated above, but there is another way: you can set a variable, then use that variable in the Perform Find step (with "Specify find request" checked). If the variable is empty, the variable name is used in the find request, rather than an empty value.