SQLite and Linux SQL

[Jeff Honken]

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:chris at altuit.com] 
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 <jhonken at webdsp.com> 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,,,,,"jhonken at xx.com","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
> use-revolution at 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 at lists.runrev.com
Please visit this url to subscribe, unsubscribe and manage your
subscription preferences:
http://lists.runrev.com/mailman/listinfo/use-revolution