Database Access from Client Issue

Hello folks!

I looked around a bit to see if this was already being discussed, but did not find anything. Here’s the issue: I have a valid connection to a Postgres relational database. In designer, I can access the table within and place the values into a table in a window. But when I launch a client of that design, the client cannot (will not) display the values.

What might I be missing?

Where and how are you accessing the table? If you’re doing anything with scripting, you need to look at the scope which is being used. The Designer will always have a “gateway” scope, whereas Clients (Vision) have client scopes. Perspective Sessions have “gateway” scope because their scripts are all run on the Gateway, instead of the local client.

Oh! I did not realize the two were separate. Is there a quick fix so the client sees the data?

As I said, it depends on how you’re accessing the data. Could you provide a screenshot or some more details regarding an instance where you’re not seeing the data in the client?

Here is an example in the documentation of a scripting function which has two different scopes available to it. If you are using scripting, please verify the function you are using is being used in the correct scope.

if you’re using a binding, scopes should not be an issue (we handle them for you), so I would need some more insight into what you’re doing to help you further.

Thanks. Interesting, but I believe this is a binding. It’s a very simple query:

Am I correct?

If you’re using a pure SQL Query binding (as opposed to a Named Query binding), you need to enable permissions at the project level.

  1. In the Designer’s menu, select Project > Project Properties.
  2. Now locate Vision > Permissions in the table to the left.
  3. Enable “Legacy Database Access”.
  4. You can also specify roles if required while you are here.
  5. Click OK to apply your changes.
  6. Save the project.
1 Like

cmallonee: That did it! Many thanks for the help!

1 Like