Search Again: Re: SQL commands *into* Optigold From: Steve Lok Date: Monday, November 4, 2002 Time: 12:14:14 pm Thanks for the info. Has anyone attempted this to your knowledge? Would you recommend that the Optigold data files not be tampered with directly? I mean, if the process is very complicated (updating across multiple tables, dependent table schema, etc.) I would just throw out this idea in favor of preserving the data files' integrity. -----Original Message----- From: isp-list@optigold.com [mailto:isp-list@optigold.com] On Behalf Of Shawn Hogan Sent: Monday, November 04, 2002 1:59 PM To: Optigold ISP List Subject: Re: [Optigold ISP] SQL commands *into* Optigold Steve Lok wrote: > My question is this - we've been using Optigold happily for the last 2 > years, and one of the main draws was the ability to use SQL to > interface between Optigold and other systems. Now that we're ready to > move on the project, it's become clear that we need the ability to > control Optigold (mostly inserting new customers, adding billing cycle > items automatically, etc.) from an external office intranet (via SQL). > I didn't see any mention of this ability (only SQL *out*) in the > manual, and the search through the lists is unclear. Can you give me a > definitive answer on this? If SQL is not available, am I stuck with > resorting to the importing/exporting of text files? It's possible if you set it up as an ODBC data source... Although doing so is completely, 100% not supported on our end, as if you are inserting and updating into the tables, it would be very easy to break things if not done properly. So you would be on your own when modifying the tables directly. - Shawn ------------------------------- Shawn D. Hogan President, Digital Point Solutions http://www.digitalpoint.com (858) 452-3696 --------------------------------------------------- To subscribe, unsubscribe or to search list archive please visit http://www.optigold.com/lists/isp.html --------------------------------------------------- --------------------------------------------------- To subscribe, unsubscribe or to search list archive please visit http://www.optigold.com/lists/isp.html ---------------------------------------------------

Messages In This Thread: SQL commands *into* Optigold by Steve Lok on Nov 4, 2002 at 10:54:53 am Re: SQL commands *into* Optigold by Shawn Hogan on Nov 4, 2002 at 10:59:31 am Re: SQL commands *into* Optigold by Steve Lok on Nov 4, 2002 at 12:14:14 pm Re: SQL commands *into* Optigold by Shawn Hogan on Nov 4, 2002 at 12:18:42 pm Re: SQL commands *into* Optigold by Michael J. Colvin on Nov 4, 2002 at 12:19:47 pm Re: SQL commands *into* Optigold by Michael J. Colvin on Nov 4, 2002 at 12:24:21 pm Re: SQL commands *into* Optigold by Shawn Hogan on Nov 4, 2002 at 12:40:33 pm Re: SQL commands *into* Optigold by Shawn Hogan on Nov 4, 2002 at 12:46:15 pm Re: SQL commands *into* Optigold by Michael J. Colvin on Nov 4, 2002 at 12:51:01 pm Re: SQL commands *into* Optigold by Steve Lok on Nov 5, 2002 at 10:21:03 am