Stored Procedures in Omnis Library
Using Postgres and Studio 6.
We have some complex stored procedures that we want to set up in a new PG database.
No problem doing this with PG Admin (and using Razor, too).
We want to put this code in our Omnis library so the user can trigger it when a new database is created.
The SQL is a large block of static text. (50+ lines)
What is the preferred way of storing this in the library?
3 ideas so far:
1. STA: (too cumbersome, SQL is already written)
2. Copy text to an object method as comments, then extract the leading semi-colons
3. Store the SQL in a record in the database by copy/paste (but requires our intervention)
4. Read from a text file (not secure)
Any ideas out there?
Sorry I missed the conference. Sounds great.
San Francisco, CA
Manage your list subscriptions at lists.omnis-dev.com