Stored Procedures in Omnis Library

Hi Alan,

I use $userinfo to store blocks of long applescripts in a xml structure (in order to know what’s inside $userinfo).

Same for long SQL procedures, Html/JavaScript or any 3rd party scripts.

Best regards,
Alain
—
Learn something new every day!

> On 3 Nov 2017, at 16:33, Alan Grinberg <omnis@alangrinberg.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?
>
> Thanks,
> Alan
>
> 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>
> www.perfectfit.net
> alan@perfectfit.net
> —————————————————-
>
> _____________________________________________________________
> Manage your list subscriptions at lists.omnis-dev.com

_____________________________________________________________
Manage your list subscriptions at lists.omnis-dev.com