Chris, I've tried using the revdb_execute in the past on this code but it always seems to choke. The queries are very long and I've only had luck with the merge and revdb_querylist. I'm assuming since Rev purchased this code they would have to make the changes for the Linux version to eliminate the restrictions. I'll keep experimenting with getting revdb_execute to work with the queries since I'm still holding my breath for the Linux version of 2.7.X. Thanks, Jeff
-----Original Message----- From: chris bohnert [mailto:[EMAIL PROTECTED] Sent: Wednesday, January 03, 2007 3:29 PM To: How to use Revolution Subject: Re: SQLite and Linux SQL Jeff, A couple of points on this: 1.) For commands that don't return a recordset you're better off calling revdb_execute or its command variant revExecuteSQL. 2.) Orginally altSqlite checked for "select" in queries that we're asking for rowsets to be returned because there were some pragmas that could be executed that would crash rev. That restriction was later removed on the mac and windows versions. 3.) Inserts should use the revdb_execute or revExecuteSQL syntax and can do so without incurring the pragma check -- cb On 1/3/07, Jeff Honken <[EMAIL PROTECTED]> wrote: > > I'm trying to figure out why the below code works great on windows for > creating a SQLITE database but not on Linux. On Linux I get a message > that says "revdberr,Database Error: MUST be select SQL!" I've read on a > past post that I should be using "revExecuteSQL tConnectionID, > tSQLQuery". This is only a very small part of the full code I'm > executing to create the database. Before I spend a lot of time can > someone confirm that I'm using the wrong syntax on the Create > statements. Also why does it work on Windows and not Linux? I'm > executing a lot of insert statements "2500 Inserts" in the code so what > syntax should I use for Inserts?. Any help would be greatly > appreciated. > > > > put > revdb_connect("sqlite3",x12Provider.db,,,,,"[EMAIL PROTECTED]","xxxxxxxxxxx > x") into gConID > > > --> Start of Creates for Database > put merge("CREATE TABLE AccountEntry (PracticeID TEXT, AccAutoNo INTEGER > PRIMARY KEY, ChartNum TEXT, ClaimNum TEXT, DAllowed TEXT, TOS TEXT, POS > TEXT, Provider TEXT)") into tSQL > put revdb_querylist(,,gConID,tSQL) into tList > > > _______________________________________________ > use-revolution mailing list > [email protected] > Please visit this url to subscribe, unsubscribe and manage your > subscription preferences: > http://lists.runrev.com/mailman/listinfo/use-revolution > > _______________________________________________ use-revolution mailing list [email protected] Please visit this url to subscribe, unsubscribe and manage your subscription preferences: http://lists.runrev.com/mailman/listinfo/use-revolution _______________________________________________ use-revolution mailing list [email protected] Please visit this url to subscribe, unsubscribe and manage your subscription preferences: http://lists.runrev.com/mailman/listinfo/use-revolution
