Re: [sqlite] Parsing sqlitedb file.

[Andrew Barnes]

> 
> Message: 6
> Date: Mon, 9 Jul 2012 22:17:02 -0700 (PDT)
> From: rsharnagate 
> To: sqlite-users@sqlite.org
> Subject: Re: [sqlite] Parsing sqlitedb file.
> Message-ID:
>   

Re: [sqlite] sqlite gui app

[Andrew Barnes]

>>hello, I  wana show my sqlite database in wxwidgets gui library,but I don't 
know how to do this.
could you tell me any resource about this?
thank you!

have a look at http://wxcode.sourceforge.net/components/wxsqlite3/

google is your friend!





  
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] sqlite3_transaction trans(db); can't work in c, I don't know why?

[Andrew Barnes]

>>>sqlite_transaction trans(db); 

>>>sqlite3_prepare(db,"insert into image values('.rar',?);",-1,,0); 

>>>sqlite3_bind_blob(stat,1,ffile,filesize,NULL); 

>>>sqlite3_step(stat); 

>>>free(ffile); 

>>>sqlite3_finalize(stat); 

>>>trans.commit();

and what happens? what do you thing should happen?

and what is sqlite_transaction it doesn't seem to be part of the API
  
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] Is there way to modify table structure after > initial definition ?

[Andrew Barnes]

> Huang Chen Min wrote:
> > Dear all:
> > Forgive for asking such stupid question. I use Xbase way to
> > understand SQLite.
> > It is allowed to modify dat type of column in clipper. In my personal
> > thoughts, Creating a brandnew table and copy those data from older version
> > might be an alternative way. Is there any instrument to meet my need
> > directly.
> > Best Regards
> > --
> > tom
> 
> You need to study the ALTER TABLE statement and its limitations.  See
> http://www.sqlite.org/lang_altertable.html .
> 

SQLLite uses dynamic typing so you can put data of any type into any column. 

http://sqlite.org/faq.html#q2

  
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

[sqlite] Compiling SQLite3 to run on Windows Mobile 6.5

[Andrew Barnes]

>>Would this be able to run on windows mobile or windows ce?

I don't see why not but I've never used windows mobile or ce and I suppose it 
depends on the hardware too.

Maybe I've misunderstood what you are trying to do but it seems to me that 
somewhere in the process that gets your data
into your AS400 you should be able to put a program which reads the database 
and outputs a CSV file. 

It should not be a hard program to write and looks to me like a better option 
than trying to get the shell to do it.

Quite where in the process this best fits depends on how your hardware hangs 
together and how streamlined you want the
user experience to be.

Andy

PS Sorry if these aren't slotting into the threads correctly, I'm new here and 
trying to work out just how to do it.


  
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] Compiling SQLite3 to run on Windows Mobile 6.5

[Andrew Barnes]

Hi,

Not sure if anyone has suggested this already but rather than messing with the 
shell and bat files, cant you write a little program which reads the database, 
outputs a CSV file and puts it wherever it needs putting

Andy
  
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users