[sqlite] UPDATE no such column

This sucession of queries give me "SQLite error no such column: tmp_ProporcionesGrupos.GRUPO" Can anyone help me? CREATE TABLE tmp_ProporcionesGrupos ( GRUPO integer, PROPORCION real ); INSERT INTO tmp_ProporcionesGrupos ( grupo, proporcion ) SELECT t.grupo_post,

[sqlite] run a script in Visual Basic.NET

How can I run an SQL script written in a txt file in Visual Basic .NET I am using *System.Data.SQLite.dll* 1.0.66.0 library I want to avoid write the SQL code in the visual basic routine. Any Ideas? Regards Esteban ___ sqlite-users mailing list

Re: [sqlite] using sqlite calculated field

this solution works, but it is very messy: SELECT datsiniestros.grupo, datsiniestros.siniestro, datsiniestros.ibm, datsiniestros.edad, datsiniestros.porinc, datsiniestros.sexofem, /* (CASE sexofem WHEN 'False' THEN parrentas.masc_ippd ELSE parrentas.fem_ippd END) AS IPPD,

[sqlite] using sqlite calculated field

this query fail: Because I am trying to use the IPPD calculated field. How can i do this? Thanks SELECT datsiniestros.grupo, datsiniestros.siniestro, datsiniestros.ibm, datsiniestros.edad, datsiniestros.porinc, datsiniestros.sexofem, (CASE sexofem WHEN 'False' THEN

Re: [sqlite] import CSV in ADO.NET

This is not applicable for me, because I will need go out of the application. Is somethere a form of execute the SQLite Shell from Visual Basic in a hidden manner? Regards Esteban 2011/12/5 Joe Mistachkin <sql...@mistachkin.com> > > Esteban Cervetto wrote: > > > >

[sqlite] import CSV in ADO.NET

I am needing import txt files (Tab delimited) to a .db3 base. These two lines I cant execute it SQLcommand.CommandText = ".import siniestros.txt " & ctbl_TmpSiniestros SQLcommand.ExecuteNonQuery() I dont know how to run sqlite "dot" commands with this dll library. I am googling it so much. :(