OpenEuphoria

Re: Sqlite -mysql add records

• Posted by Jim Smiley <sixs at ida.net> Apr 11, 2007
• 479 views

Chris Burch wrote:
> 
> Jim Smiley wrote:
> > 
> > 
> Hi
> 
> Don't use the mysql wrapper, but if there's any similarity to sqlite
> 
> > Hi,
> > I copied the wrong line . Below is the working code that inserts a record
> > using
> > SQL YOG
> > -----------------
> > INSERT INTO works (workid,subjectid,personid,title) VALUES
> > ('','1','1','1abc')
> 
> query1 = "INSERT INTO works (workid,subjectid,personid,title) VALUES
> ('','1','1','1abc')"
> 
> > ---------------------------------------
> > None  of these commands seem to work.
> >      result=run_query(query1)error says attempt to subscript an atom
> 
> result = run_query(query1, database_to_run_query_on) 
> 
> where database_to_run_query_on is the actual name, or handle, of a previously
> opened / connected database.
> 
> >  result=mysql_db_query(query1)missing db or query
> result = mysql_db_query(query1, database_to_run_query_on)
> 
> >  result=mysql_db_query(query1)error says empty query
> etc
> 
> Chris
> 
> > ---------------------------------------------------
> > JIm
> 
> 
> <a href="http://euallegro.wikispaces.com">http://euallegro.wikispaces.com</a>
> <a
> href="http://members.aol.com/chriscrylex/euphoria.htm">http://members.aol.com/chriscrylex/euphoria.htm</a>
> <a href="http://uboard.proboards32.com/">http://uboard.proboards32.com/</a>
> <a
> href="http://members.aol.com/chriscrylex/EUSQLite/eusql.html">http://members.aol.com/chriscrylex/EUSQLite/eusql.html</a>


Chris,
I want to take a look at sqlite and use it instead of mysql. What is a good way
to start? I have used in apackage that I tried in PHP. It had aprogram that
allowed building the sqlite files as I remember.
Any suggestins