cancel
Showing results for 
Show  only  | Search instead for 
Did you mean: 
  • Learn how to build custom Python data connectors and further customize JMP’s Data Connector Framework with the Python Data Connector Demo, available now in the JMP Marketplace!
  • See how to create experiments to support product design and ID useful product features. Register for June 12 webinar, 2pm US Eastern Time.

Discussions

Solve problems, and share tips and tricks with other JMP users.
Choose Language Hide Translation Bar

PostgreSQL query update issue

While creating query in postgreSQL we need to use double quotes around every column name. In JMP scripts it is not allowing us the query with double quotes and throwing error.
 
Note: We are able to connect postgreSQL server successfully. While running query we are getting error saying "," or ")" missing.
1 REPLY 1
ih
Super User (Alumni) ih
Super User (Alumni)

Re: PostgreSQL query update issue

You should be able to user double quotes in your query string using syntax similar to \!" as shown below.  Can you post part of your query that is throwing the error?

str = "This is a \!"quoted phrase\!" inside a string.";

//When passed to other programs the quotes will look 'normal':
write(str);

 

Recommended Articles