-
Mark Phillips replied to the topic Connection to PostgreSQL with DAM natively in the forum Omnis General Coding 1 year, 3 months ago
We don’t have any problems. Our Omnis desktop connects to local postgres.
We use Postgres 9.5, moving to postgres 12.
Omnis Studio v6 and v10.1use Host: localhost (or 127.0.0.1)
database name, user name and user password, and you should be good to go. Test logon using pgAdmin or similar. -
Mark Phillips replied to the topic Popup Menu toolbar button to Window Communication in the forum Omnis General Coding 1 year, 5 months ago
I removed the statement “extension”: false; from the library.json file and Omnis Studio v10.1 built a new library. With that I was able to replicate the behavior you describe. Interesting, in the wrong way. 🙂
I cannot think of a workaround at the moment, but I will consider this further in the days ahead.
-
Mark Phillips replied to the topic Popup Menu toolbar button to Window Communication in the forum Omnis General Coding 1 year, 5 months ago
I ran the json import but it failed on an error at line 0 of library.json.
Double clicking on the error list open the Find and Replace dialog to search for “T_report_parameters”. That is, I think, simply what is in the search buffer from another project. So I don’t know why the build fails.
-
Mark Phillips replied to the topic Popup Menu toolbar button to Window Communication in the forum Omnis General Coding 1 year, 5 months ago
I could not replicate your results, as I understand them. However, I did spend some time on the theory that you are seeing the results of a namespace collision. That is two or more instances with the same name. In my quick & dirty testing, I could not rename the window toolbar, nor the button object it contains. I was able to change the name of…[Read more]
-
Mark Phillips replied to the topic AutoUpdater question in the forum Omnis General Coding 1 year, 11 months ago
To follow up, the xcomp directory in the application tree, not in the app data directory created by firstrun. So, you will need a method to assert proper permission to add to the xcomp directory. FWIW, it can be done; we do it although keeping up with new rules from Apple is a challenge. If you support windows only, you may enjoy an easier time with it.
-
Mark Phillips replied to the topic AutoUpdater question in the forum Omnis General Coding 1 year, 11 months ago
I don’t use AutoUpdater. I wrote a similar tool, Molu Update Server, circa 2007 that handles all update tasks except replacing the Omnis engine itself. Omnis Studio 10 has an option of running a script at launch, which promises to ease the update process.
The challenge of writing to the xcomps directory is the access permissions enforced by the o…[Read more]
-
Mark Phillips replied to the topic Home User path in the forum Omnis General Coding 1 year, 12 months ago
we use this in Omnis Studio v6.0. “homedirectorypath” is a character variable.
For Mac,
; user home path
Do $runapplescript(‘path to home folder from user domain as string’,homedirectorypath) Returns errcode`
Calculate homedirectorypath as replaceall(homedirectorypath,kDq,”)For Windows:
If isunicode()
Register DLL…[Read more] -
Mark Phillips replied to the topic Migrating DML to SQL in the forum Omnis General Coding 1 year, 12 months ago
Thanks to everyone who replied here and privately. I have identified a project for testing the new DML/SQL bridge in Omnis Studio 10. As we progress I will try to share what we learn here.
-
Mark Phillips started the topic Migrating DML to SQL in the forum Omnis General Coding 2 years, 4 months ago
I know this is an overworked topic. I have a small project I would like to move forward that requires the DML to be moved to SQL. I know several people are working on this, but I don’t seem to have current contact info. If you know someone with a conversion tool in working order please ask them to contact me.
-
Mark Phillips replied to the topic Omnis host in the forum Omnis forum 4 years, 3 months ago
I recently began offering managed servers. Each server is a VM running in secure facility (two physical locations, bridged) in the eastern US. Presently, we have a template for a specific product that enables us to spin up a new server in a matter of moments. This approach would work for Omnis apps as well. If you do not find someone already…[Read more]
-
Mark Phillips replied to the topic Object classes versus Table classes in the forum Omnis forum 4 years, 4 months ago
Many years ago I took the approach of using Table classes for db table manipulations. This allowed me to use the built-in methods to generate most SQL statements and to use Omnis list and row variables to bind data to the UX classes. To handle complex relationships between tables, and to provide a place for hand crafted SQL statements, I use…[Read more]
-
Mark Phillips became a registered member 4 years, 4 months ago
- Load More