Login ProductsSalesSupportDownloadsAbout |
Home » Technical Support » ElevateDB Technical Support » Support Forums » ElevateDB General » View Thread |
Messages 11 to 11 of 11 total |
External module procedure |
Mon, Feb 16 2009 3:17 PM | Permanent Link |
Tim Young [Elevate Software] Elevate Software, Inc. timyoung@elevatesoft.com | Dan,
<< A simple import in csv format is a good idea. >> Duh, I also forgot one simple thing. You could use stores to accomplish the creation/querying of such data: 1) Create the CSV file in the external module and write it to a local store on the server. 2) Using the remote session on the client, import the CSV file into a temporary table that you create for just this purpose (CREATE TEMPORARY TABLE). 3) Use the IMPORT TABLE statement to import the CSV file into the temporary table. 4) Now you can query this table, etc. just like any other table. 5) Drop the temporary table when you are done with it. The entire sequence of events above all takes place on the ElevateDB Server. You can find out more about stores here: http://www.elevatesoft.com/manual?action=mantopic&id=edb2sql&category=0&topic=20 -- Tim Young Elevate Software www.elevatesoft.com |
« Previous Page | Page 2 of 2 | |
Jump to Page: 1 2 |
This web page was last updated on Friday, May 3, 2024 at 08:07 PM | Privacy PolicySite Map © 2024 Elevate Software, Inc. All Rights Reserved Questions or comments ? E-mail us at info@elevatesoft.com |