SQLite and Linux SQL
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],xxx 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 use-revolution@lists.runrev.com Please visit this url to subscribe, unsubscribe and manage your subscription preferences: http://lists.runrev.com/mailman/listinfo/use-revolution
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],xxx 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 use-revolution@lists.runrev.com Please visit this url to subscribe, unsubscribe and manage your subscription preferences: http://lists.runrev.com/mailman/listinfo/use-revolution ___ use-revolution mailing list use-revolution@lists.runrev.com Please visit this url to subscribe, unsubscribe and manage your subscription preferences: http://lists.runrev.com/mailman/listinfo/use-revolution
RE: SQLite and Linux SQL
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],xxx 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 use-revolution@lists.runrev.com Please visit this url to subscribe, unsubscribe and manage your subscription preferences: http://lists.runrev.com/mailman/listinfo/use-revolution ___ use-revolution mailing list use-revolution@lists.runrev.com Please visit this url to subscribe, unsubscribe and manage your subscription preferences: http://lists.runrev.com/mailman/listinfo/use-revolution ___ use-revolution mailing list use-revolution@lists.runrev.com Please visit this url to subscribe, unsubscribe and manage your subscription preferences: http://lists.runrev.com/mailman/listinfo/use-revolution
Sqlite on Linux
I've compiled my application on Windows and I've moved it to Linux. I get the following error when I try to access the Sqlite database with my application on Linux: Failed to load dbsqlite.so error dbsqlite.so: cannot open shared object file: No such file or directoryfound /root/Linux/externals/database_drivers/dbsqlite.so symbols 7134656,7134544,7134624 called idcounterptrx12.db #65533;#65533;#65533;ph'l#65533;F#549;#65533;* I've tried it on Fedora Core 4, RedHat 7.3 and 8.0. All with the same error. I've set the permissions to 777 for the file and I've tripple checked that the file is there and in that directory. It's creating a file called c:/test.db on my hard drive which I'm sure the .so is creating. I emailed Altuit yesterday but I havn't heard back from them. Is anyone else using the Altuit .so on Linux that has seen this problem before. Any help would be appreciated. Jeff ___ use-revolution mailing list use-revolution@lists.runrev.com Please visit this url to subscribe, unsubscribe and manage your subscription preferences: http://lists.runrev.com/mailman/listinfo/use-revolution
Re: Sqlite on Linux
Jeff, Chris Bohnert of Altuit has previously sent 2 support emails to you and it appears you aren't getting them (though we have no record of a bounce). Perhaps you can check your JUNK folder or give us another email address to respond to? We generally try our best at getting back to our valued customers! :-) thanks, Chipp Jeff Honken wrote: I emailed Altuit yesterday but I havn't heard back from them. ___ use-revolution mailing list use-revolution@lists.runrev.com Please visit this url to subscribe, unsubscribe and manage your subscription preferences: http://lists.runrev.com/mailman/listinfo/use-revolution
RE: Sqlite on Linux
Chipp, I haven't received anything from Chris. Do you have a direct email that I can email him. I'd like him to try [EMAIL PROTECTED] and [EMAIL PROTECTED] Jeff -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Chipp Walters Sent: Friday, February 17, 2006 1:51 PM To: How to use Revolution Subject: Re: Sqlite on Linux Jeff, Chris Bohnert of Altuit has previously sent 2 support emails to you and it appears you aren't getting them (though we have no record of a bounce). Perhaps you can check your JUNK folder or give us another email address to respond to? We generally try our best at getting back to our valued customers! :-) thanks, Chipp Jeff Honken wrote: I emailed Altuit yesterday but I havn't heard back from them. ___ use-revolution mailing list use-revolution@lists.runrev.com Please visit this url to subscribe, unsubscribe and manage your subscription preferences: http://lists.runrev.com/mailman/listinfo/use-revolution ___ use-revolution mailing list use-revolution@lists.runrev.com Please visit this url to subscribe, unsubscribe and manage your subscription preferences: http://lists.runrev.com/mailman/listinfo/use-revolution