Stored Procedures in Omnis Library
There is a nice (this can be discussed) way to store data in a library.
An Omnis Library has the same structure as a DF1.
You can add files in it add records in those files, fetch and update them.
I wouldn’t do that for everything but quite convenient for some uses…
More if you need…
>> On Nov 3, 2017, at 9:33 AM, Alan Grinberg <email@example.com> wrote:
>> Hello all,
>> 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.
>> Alan Grinberg
>> AG Systems/ZOO-INK
>> San Francisco, CA
>> www.zoo-ink.com <applewebdata://E01F3E44-AB72-4A7B-A459-57C700E4EAEF>
>> Manage your list subscriptions at lists.omnis-dev.com
> Manage your list subscriptions at lists.omnis-dev.com
Manage your list subscriptions at lists.omnis-dev.com