![]() | ![]() Products ![]() ![]() ![]() ![]() |
Home » Technical Support » ElevateDB Technical Support » Support Forums » ElevateDB Extensions » View Thread |
Messages 1 to 4 of 4 total |
![]() |
Tue, Jun 15 2010 2:15 PM | Permanent Link |
Roy Lambert NLH Associates ![]() | A small script to allow functions that are defined for an on-disk database to be cloned into the in-memory one. To restrict it to certain functions only specify a list in the form 'f1','f2' etc as Only
SCRIPT (IN SrcDB VARCHAR, IN Only VARCHAR) BEGIN DECLARE Source CURSOR FOR Selector; DECLARE Creator VARCHAR; DECLARE SelSQL VARCHAR; SET SelSQL = 'SELECT Definition FROM ' + SrcDB + '.Information.Functions WHERE NAME NOT IN (SELECT Name FROM Information.Functions)'; IF (Only IS NOT NULL) AND (Only <> '') THEN SET SelSQL = SelSQL + ' AND Name IN (' + Only + ')'; END IF; PREPARE Selector FROM SelSQL; OPEN Source; FETCH FIRST FROM Source(Definition) INTO Creator; WHILE NOT EOF(Source) DO IF (Creator IS NOT NULL) AND (Creator <> '') THEN EXECUTE IMMEDIATE 'CREATE '+ Creator; END IF; FETCH NEXT FROM Source(Definition) INTO Creator; END WHILE; END Roy Lambert |
Fri, Jun 18 2010 2:22 PM | Permanent Link |
Tim Young [Elevate Software] Elevate Software, Inc. ![]() | Roy,
MM A small script to allow functions that are defined for an on-disk database to be cloned into the in-memory one. To restrict it to certain functions only specify a list in the form 'f1','f2' etc as Only >> Nice. ![]() -- Tim Young Elevate Software www.elevatesoft.com |
Sat, Jun 19 2010 3:45 AM | Permanent Link |
Roy Lambert NLH Associates ![]() | Tim
I only write these things because I'm lazy. Roy Lambert |
Mon, Jun 21 2010 4:01 PM | Permanent Link |
Tim Young [Elevate Software] Elevate Software, Inc. ![]() | Roy,
<< I only write these things because I'm lazy. >> That's why I automate everything short of answering emails here. ![]() -- Tim Young Elevate Software www.elevatesoft.com |
This web page was last updated on Monday, July 7, 2025 at 06:35 PM | Privacy Policy![]() © 2025 Elevate Software, Inc. All Rights Reserved Questions or comments ? ![]() |