Search Again: Re: SQL commands *into* Optigold From: Shawn Hogan Date: Monday, November 4, 2002 Time: 10:59:31 am 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 ---------------------------------------------------

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