[sqlite] C# + SQLite - How do you do Multiple Rows Inserts/Updates?

[R Smith]

That's not an SQLitespeed feature but indeed a backwards-compatible 
SQLite feature. (I had this wrong too at some point)

You probably already know, but to be clear: In SQL standard, 
double-quotes indicate identifiers and single quotes indicate string values.
While the single quotes are used more or less universally, identifiers 
often get quoted differently.
In Postgres and SQLite the standard is adhered to with Double quotes.
MySQL uses a back-tick like this ` (which, by the way, will also work in 
SQLite due the same backward compatibility)
MSSQL likes the square brackets [ and ] around identifiers (which, 
again, also works in SQLite for the same reason)

Further to this, in earlier MySQL and in SQLite you may also use double 
quotes to denote strings, and it will regard a double-quoted value to be 
a string if A - it isn't an identifier, or B - used in a place where you 
can't use an identifier. (You can just imagine the bugs in your SQL that 
can arise from this!)

While all of the above works, you are strongly encouraged to simply do 
it correctly and use double-quotes for identifiers and single quotes for 
strings.

We have been lobbying for a strict-mode in SQLite where none of these 
shenanigans are allowed - but that is far easier said than done.


On 2016/02/09 5:10 PM, Chris Prakoso wrote:
> Actually I've just done it now, in SQLiteSpeed, and it allowed me to use
> double-quote as delimiter successfully.
>
> Regards,
> Chris
>
> On Tue, Feb 9, 2016 at 3:03 PM, Simon Slavin  wrote:
>
>> On 9 Feb 2016, at 12:10pm, Chris Prakoso  wrote:
>>
>>> *insert into test (field1,field2) values (1,"two"),(2,"three")*
>> As well as the comments about your software being out of date, you need to
>> know that the text delimiter in SQLite is the non-directional single quote
>> character normally seen as an apostrophe.  You cannot successfully use the
>> double quote character or any directional quotes.
>>
>> Should be
>>
>>  insert into test (field1,field2) values (1,'two'),(2,'three')
>>
>> Simon.
>> ___
>> sqlite-users mailing list
>> sqlite-users at mailinglists.sqlite.org
>> http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
>>
> ___
> sqlite-users mailing list
> sqlite-users at mailinglists.sqlite.org
> http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users

[sqlite] C# + SQLite - Update/Insert using Transaction is slower than without.

[Chris Prakoso]

Yes. Nothing complicated, fortunately.

On Tue, Feb 9, 2016 at 4:09 PM, Steven M. McNeese <
steven.mcneese at freedomparkdfw.com> wrote:

> So are you saying you are just reading data from your SQLite db using C#
> and
> just need to insert using the SQLite command?
>
> -Original Message-
> From: sqlite-users-bounces at mailinglists.sqlite.org
> [mailto:sqlite-users-bounces at mailinglists.sqlite.org] On Behalf Of Chris
> Prakoso
> Sent: Tuesday, February 9, 2016 7:56 AM
> To: SQLite mailing list
> Subject: Re: [sqlite] C# + SQLite - Update/Insert using Transaction is
> slower than without.
>
> Steven,
>
> I don't use any back-end, the code I pasted here IS my back-end.  I opted
> for direct SQLite connection.  So I don't use EF6 nor Linq.
>
> Chris
>
> On Tue, Feb 9, 2016 at 1:47 PM, Steven M. McNeese <
> steven.mcneese at freedomparkdfw.com> wrote:
>
> > Chris,
> >
> > What are you using in c# for SQLite back end?  Ado.net? Linq.  Let me
> > know and I can help you with bulk inserts.
> >
> > Sent from my iPhone
> >
> > > On Feb 9, 2016, at 6:13 AM, Chris Prakoso  wrote:
> > >
> > > Ok. Got it.
> > > Now, if only I can get that multiple rows update working on my code,
> > > it would be perfect.
> > >
> > > Thanks a lot,
> > > Chris
> > >
> > >> On Tue, Feb 9, 2016 at 12:07 PM, Clemens Ladisch
> > >> 
> > wrote:
> > >>
> > >> Chris Prakoso wrote:
> > >>>public bool UpdateData(string tableName,
> > >> Dictionary<string,object> fields, List whereKeys)
> > >>>{
> > >>>...
> > >>>using (SQLiteTransaction transaction =
> > >> conn.BeginTransaction())
> > >>>{
> > >>>...
> > >>>rowsUpdated = cmd.ExecuteNonQuery();
> > >>>transaction.Commit();
> > >>
> > >> Using one transaction for each statement is slow.
> > >> (Re-opening the database doesn't help either.)
> > >>
> > >> You should use a single transaction around all update statements.
> > >>
> > >>
> > >> Regards,
> > >> Clemens
> > >> ___
> > >> sqlite-users mailing list
> > >> sqlite-users at mailinglists.sqlite.org
> > >> http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-user
> > >> s
> > > ___
> > > sqlite-users mailing list
> > > sqlite-users at mailinglists.sqlite.org
> > > http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
> >
> >
> > ___
> > sqlite-users mailing list
> > sqlite-users at mailinglists.sqlite.org
> > http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
> >
> ___
> sqlite-users mailing list
> sqlite-users at mailinglists.sqlite.org
> http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
>
>
> ---
> This email has been checked for viruses by Avast antivirus software.
> https://www.avast.com/antivirus
>
>
>
> ___
> sqlite-users mailing list
> sqlite-users at mailinglists.sqlite.org
> http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
>

[sqlite] C# + SQLite - How do you do Multiple Rows Inserts/Updates?

[Chris Prakoso]

Thanks for the detailed explanation.

Regards,
Chris

On Tue, Feb 9, 2016 at 4:05 PM, R Smith  wrote:

> That's not an SQLitespeed feature but indeed a backwards-compatible SQLite
> feature. (I had this wrong too at some point)
>
> You probably already know, but to be clear: In SQL standard, double-quotes
> indicate identifiers and single quotes indicate string values.
> While the single quotes are used more or less universally, identifiers
> often get quoted differently.
> In Postgres and SQLite the standard is adhered to with Double quotes.
> MySQL uses a back-tick like this ` (which, by the way, will also work in
> SQLite due the same backward compatibility)
> MSSQL likes the square brackets [ and ] around identifiers (which, again,
> also works in SQLite for the same reason)
>
> Further to this, in earlier MySQL and in SQLite you may also use double
> quotes to denote strings, and it will regard a double-quoted value to be a
> string if A - it isn't an identifier, or B - used in a place where you
> can't use an identifier. (You can just imagine the bugs in your SQL that
> can arise from this!)
>
> While all of the above works, you are strongly encouraged to simply do it
> correctly and use double-quotes for identifiers and single quotes for
> strings.
>
> We have been lobbying for a strict-mode in SQLite where none of these
> shenanigans are allowed - but that is far easier said than done.
>
>
>
> On 2016/02/09 5:10 PM, Chris Prakoso wrote:
>
>> Actually I've just done it now, in SQLiteSpeed, and it allowed me to use
>> double-quote as delimiter successfully.
>>
>> Regards,
>> Chris
>>
>> On Tue, Feb 9, 2016 at 3:03 PM, Simon Slavin 
>> wrote:
>>
>> On 9 Feb 2016, at 12:10pm, Chris Prakoso  wrote:
>>>
>>> *insert into test (field1,field2) values (1,"two"),(2,"three")*

>>> As well as the comments about your software being out of date, you need
>>> to
>>> know that the text delimiter in SQLite is the non-directional single
>>> quote
>>> character normally seen as an apostrophe.  You cannot successfully use
>>> the
>>> double quote character or any directional quotes.
>>>
>>> Should be
>>>
>>>  insert into test (field1,field2) values (1,'two'),(2,'three')
>>>
>>> Simon.
>>> ___
>>> sqlite-users mailing list
>>> sqlite-users at mailinglists.sqlite.org
>>> http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
>>>
>>> ___
>> sqlite-users mailing list
>> sqlite-users at mailinglists.sqlite.org
>> http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
>>
>
> ___
> sqlite-users mailing list
> sqlite-users at mailinglists.sqlite.org
> http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
>

[sqlite] C# + SQLite - How do you do Multiple Rows Inserts/Updates?

[Salih Yücel]

Hi,
I have windowns phone project but one problem . Sqli te select result data type 
text column turkish characters encoding problem
But Android operation system no problem turkish characters


Salih Y?cel
Mobil Grup Lideri /Mobile Group Leader

Univera Bilgisayar Sistemleri San. ve Tic. A.?.


Bu elektronik posta ve onunla iletilen b?t?n dosyalar sadece g?ndericisi 
taraf?ndan almas? ama?lanan yetkili ger?ek ya da t?zel ki?inin kullan?m? 
i?indir.E?er s?z konusu yetkili al?c? de?ilseniz bu elektronik postan?n 
i?eri?ini a??klaman?z, kopyalaman?z, y?nlendirmeniz ve kullanman?z kesinlikle 
yasakt?r ve bu elektronik postay? derhal silmeniz gerekmektedir. UN?VERA A.?. 
bu mesaj?n i?erdi?i bilgilerin do?rulu?u veya eksiksiz oldu?u konusunda 
herhangi bir garanti vermemektedir. Bu nedenle bu bilgilerin ne ?ekilde olursa 
olsun i?eri?inden, iletilmesinden, al?nmasndan ve saklanmas?ndan sorumlu 
de?ildir. Bu mesajdaki g?r??ler yalnzca g?nderen ki?iye aittir ve UN?VERA 
A.?.'nin g?r??lerini yans?tmayabilir. Bu e-posta bilinen b?t?n bilgisayar 
vir?slerine kar?? taranm??t?r.

This e-mail and any files transmitted with it are confidential and intended 
solely for the use of the individual or entity to whom they are addressed. If 
you are not the intended recipient you are hereby notified that any 
dissemination, forwarding, copying or use of any of the information is strictly 
prohibited, and the e-mail should immediately be deleted. UNIVERA A.S. makes no 
warranty as to the accuracy or completeness of any information contained in 
this message and hereby excludes any liability of any kind for the information 
contained therein or for the information transmission, reception, storage or 
use of such in any way whatsoever. The opinions expressed in this message 
belong to sender alone and may not necessarily reflect the opinions of UNIVERA 
A.S. This e-mail has been scanned for all known computer viruses.



-Original Message-
From: sqlite-users-bounces at mailinglists.sqlite.org 
[mailto:sqlite-users-boun...@mailinglists.sqlite.org] On Behalf Of Chris Prakoso
Sent: Tuesday, February 9, 2016 5:09 PM
To: SQLite mailing list 
Subject: Re: [sqlite] C# + SQLite - How do you do Multiple Rows Inserts/Updates?

Yes thank you.  My SQLite is the latest, it's the front-end that is outdated, 
which I have just swiftly corrected.

Regards,
Chris

On Tue, Feb 9, 2016 at 2:52 PM, Richard Hipp  wrote:

> On 2/9/16, Clemens Ladisch  wrote:
> > Chris Prakoso wrote:
> >> insert into test (field1,field2) values (1,"two"),(2,"three")
> >>
> >> SQL Error: near ",": syntax error
> >
> > You might want to update to a tool that is not years out of date.
> >
>
> What Clemens means by this is that prior to SQLite 3.7.11 (2012-03-20)
> the INSERT statement would only take a single row in the VALUES
> clause.  He is suggesting that you are using a version of SQLite that
> is 4 year old or older and therefore lacks this feature.
>
> --
> D. Richard Hipp
> drh at sqlite.org
> ___
> sqlite-users mailing list
> sqlite-users at mailinglists.sqlite.org
> http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
>
___
sqlite-users mailing list
sqlite-users at mailinglists.sqlite.org
http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users

[sqlite] C# + SQLite - How do you do Multiple Rows Inserts/Updates?

[Clemens Ladisch]

Chris Prakoso wrote:
> insert into test (field1,field2) values (1,"two"),(2,"three")
>
> SQL Error: near ",": syntax error

You might want to update to a tool that is not years out of date.


Regards,
Clemens

[sqlite] C# + SQLite - How do you do Multiple Rows Inserts/Updates?

[Chris Prakoso]

Ok. Thanks for the reminder.

Regards,
Chris

On Tue, Feb 9, 2016 at 3:18 PM, Richard Hipp  wrote:

> On 2/9/16, Chris Prakoso  wrote:
> > Actually I've just done it now, in SQLiteSpeed, and it allowed me to use
> > double-quote as delimiter successfully.
> >
>
> That is supported for backwards compatibility.  I originally put in
> support for double-quoted string literals to be compatible with MySQL
> 3.5.  I have long since regretted that decision.  You are encouraged
> to use single-quotes for string literals, as double-quotes have a very
> different meaning that can lead to subtle bugs.
> --
> D. Richard Hipp
> drh at sqlite.org
> ___
> sqlite-users mailing list
> sqlite-users at mailinglists.sqlite.org
> http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
>

[sqlite] C# + SQLite - How do you do Multiple Rows Inserts/Updates?

[Chris Prakoso]

Actually I've just done it now, in SQLiteSpeed, and it allowed me to use
double-quote as delimiter successfully.

Regards,
Chris

On Tue, Feb 9, 2016 at 3:03 PM, Simon Slavin  wrote:

>
> On 9 Feb 2016, at 12:10pm, Chris Prakoso  wrote:
>
> > *insert into test (field1,field2) values (1,"two"),(2,"three")*
>
> As well as the comments about your software being out of date, you need to
> know that the text delimiter in SQLite is the non-directional single quote
> character normally seen as an apostrophe.  You cannot successfully use the
> double quote character or any directional quotes.
>
> Should be
>
> insert into test (field1,field2) values (1,'two'),(2,'three')
>
> Simon.
> ___
> sqlite-users mailing list
> sqlite-users at mailinglists.sqlite.org
> http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
>

[sqlite] C# + SQLite - How do you do Multiple Rows Inserts/Updates?

[Chris Prakoso]

Yes thank you.  My SQLite is the latest, it's the front-end that is
outdated, which I have just swiftly corrected.

Regards,
Chris

On Tue, Feb 9, 2016 at 2:52 PM, Richard Hipp  wrote:

> On 2/9/16, Clemens Ladisch  wrote:
> > Chris Prakoso wrote:
> >> insert into test (field1,field2) values (1,"two"),(2,"three")
> >>
> >> SQL Error: near ",": syntax error
> >
> > You might want to update to a tool that is not years out of date.
> >
>
> What Clemens means by this is that prior to SQLite 3.7.11 (2012-03-20)
> the INSERT statement would only take a single row in the VALUES
> clause.  He is suggesting that you are using a version of SQLite that
> is 4 year old or older and therefore lacks this feature.
>
> --
> D. Richard Hipp
> drh at sqlite.org
> ___
> sqlite-users mailing list
> sqlite-users at mailinglists.sqlite.org
> http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
>

[sqlite] C# + SQLite - How do you do Multiple Rows Inserts/Updates?

[Simon Slavin]

On 9 Feb 2016, at 12:10pm, Chris Prakoso  wrote:

> *insert into test (field1,field2) values (1,"two"),(2,"three")*

As well as the comments about your software being out of date, you need to know 
that the text delimiter in SQLite is the non-directional single quote character 
normally seen as an apostrophe.  You cannot successfully use the double quote 
character or any directional quotes.

Should be

insert into test (field1,field2) values (1,'two'),(2,'three')

Simon.

[sqlite] C# + SQLite - How do you do Multiple Rows Inserts/Updates?

[R Smith]

On 2016/02/09 1:30 PM, Chris Prakoso wrote:
> Hi Clemens,
>
> Thanks for your reply.  I've tried to use raw SQL but it didn't work
> either.  Do you have any SQLite front-end that you use?

If I may suggest, try SQLitespeed (http://sqlc.rifin.co.za/) and add 
your DB file, open it and then use the buttons on the far right (such as 
"Insert", "Update", "Delete", etc.) to produce the SQL that will insert 
to or update the selected table. You can then see the correct syntax and 
expand on it to add your own values etc.

You could also right-click on the results list and select from the menu 
"Row Actions"-->"Show UPDATE SQL for changing this row" or "Show INSERT 
SQL for copying this row" etc.
There are a myriad more auto-SQL things in there, perhaps a good option 
if you are learning SQL still.

You could also right-click in a query and then select "Copy as 
Code"-->"Java"/"C#"/ whatever you like, or add your own codify settings 
for your preferred language to take the pain out of adapting queries to 
code.

The INSERT and UPDATE functions you described should really work in SQL, 
so perhaps it's a small syntax error or such preventing success.


(PS: This list is not a support group for SQLitespeed or any other gui, 
you may use its own bug/query reporter from the menu to get help there)

Cheers,
Ryan

[sqlite] C# + SQLite - Update/Insert using Transaction is slower than without.

[Chris Prakoso]

Steven,

I don't use any back-end, the code I pasted here IS my back-end.  I opted
for direct SQLite connection.  So I don't use EF6 nor Linq.

Chris

On Tue, Feb 9, 2016 at 1:47 PM, Steven M. McNeese <
steven.mcneese at freedomparkdfw.com> wrote:

> Chris,
>
> What are you using in c# for SQLite back end?  Ado.net? Linq.  Let me know
> and I can help you with bulk inserts.
>
> Sent from my iPhone
>
> > On Feb 9, 2016, at 6:13 AM, Chris Prakoso  wrote:
> >
> > Ok. Got it.
> > Now, if only I can get that multiple rows update working on my code, it
> > would be perfect.
> >
> > Thanks a lot,
> > Chris
> >
> >> On Tue, Feb 9, 2016 at 12:07 PM, Clemens Ladisch 
> wrote:
> >>
> >> Chris Prakoso wrote:
> >>>public bool UpdateData(string tableName,
> >> Dictionary fields, List whereKeys)
> >>>{
> >>>...
> >>>using (SQLiteTransaction transaction =
> >> conn.BeginTransaction())
> >>>{
> >>>...
> >>>rowsUpdated = cmd.ExecuteNonQuery();
> >>>transaction.Commit();
> >>
> >> Using one transaction for each statement is slow.
> >> (Re-opening the database doesn't help either.)
> >>
> >> You should use a single transaction around all update statements.
> >>
> >>
> >> Regards,
> >> Clemens
> >> ___
> >> sqlite-users mailing list
> >> sqlite-users at mailinglists.sqlite.org
> >> http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
> > ___
> > sqlite-users mailing list
> > sqlite-users at mailinglists.sqlite.org
> > http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
>
>
> ___
> sqlite-users mailing list
> sqlite-users at mailinglists.sqlite.org
> http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
>

[sqlite] C# + SQLite - How do you do Multiple Rows Inserts/Updates?

[Chris Prakoso]

Thanks Ryan,

I will definitely try it.  I'm ok with raw SQL, just not familiar with the
odd ones like this multiple rows update.

Thanks a lot,
Chris

On Tue, Feb 9, 2016 at 12:42 PM, R Smith  wrote:

>
>
> On 2016/02/09 1:30 PM, Chris Prakoso wrote:
>
>> Hi Clemens,
>>
>> Thanks for your reply.  I've tried to use raw SQL but it didn't work
>> either.  Do you have any SQLite front-end that you use?
>>
>
> If I may suggest, try SQLitespeed (http://sqlc.rifin.co.za/) and add your
> DB file, open it and then use the buttons on the far right (such as
> "Insert", "Update", "Delete", etc.) to produce the SQL that will insert to
> or update the selected table. You can then see the correct syntax and
> expand on it to add your own values etc.
>
> You could also right-click on the results list and select from the menu
> "Row Actions"-->"Show UPDATE SQL for changing this row" or "Show INSERT SQL
> for copying this row" etc.
> There are a myriad more auto-SQL things in there, perhaps a good option if
> you are learning SQL still.
>
> You could also right-click in a query and then select "Copy as
> Code"-->"Java"/"C#"/ whatever you like, or add your own codify settings for
> your preferred language to take the pain out of adapting queries to code.
>
> The INSERT and UPDATE functions you described should really work in SQL,
> so perhaps it's a small syntax error or such preventing success.
>
>
> (PS: This list is not a support group for SQLitespeed or any other gui,
> you may use its own bug/query reporter from the menu to get help there)
>
> Cheers,
> Ryan
>
>
> ___
> sqlite-users mailing list
> sqlite-users at mailinglists.sqlite.org
> http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
>

[sqlite] C# + SQLite - Update/Insert using Transaction is slower than without.

[Clemens Ladisch]

Chris Prakoso wrote:
> public bool UpdateData(string tableName, Dictionary 
> fields, List whereKeys)
> {
> ...
> using (SQLiteTransaction transaction = 
> conn.BeginTransaction())
> {
> ...
> rowsUpdated = cmd.ExecuteNonQuery();
> transaction.Commit();

Using one transaction for each statement is slow.
(Re-opening the database doesn't help either.)

You should use a single transaction around all update statements.


Regards,
Clemens

[sqlite] C# + SQLite - Update/Insert using Transaction is slower than without.

[Chris Prakoso]

Ok. Got it.
Now, if only I can get that multiple rows update working on my code, it
would be perfect.

Thanks a lot,
Chris

On Tue, Feb 9, 2016 at 12:07 PM, Clemens Ladisch  wrote:

> Chris Prakoso wrote:
> > public bool UpdateData(string tableName,
> Dictionary fields, List whereKeys)
> > {
> > ...
> > using (SQLiteTransaction transaction =
> conn.BeginTransaction())
> > {
> > ...
> > rowsUpdated = cmd.ExecuteNonQuery();
> > transaction.Commit();
>
> Using one transaction for each statement is slow.
> (Re-opening the database doesn't help either.)
>
> You should use a single transaction around all update statements.
>
>
> Regards,
> Clemens
> ___
> sqlite-users mailing list
> sqlite-users at mailinglists.sqlite.org
> http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
>

[sqlite] C# + SQLite - Update/Insert using Transaction is slower than without.

[Clemens Ladisch]

Chris Prakoso wrote:
> I've been testing the performance of my Insert/Update using
> Transaction and without, and I found that it is quicker when I don't
> use it.

Show the code.


Regards,
Clemens

[sqlite] C# + SQLite - How do you do Multiple Rows Inserts/Updates?

[Clemens Ladisch]

Chris Prakoso wrote:
> My question is whether anybody had successfully implemented multiple
> rows Insert/Update.

This is possible in SQL:

INSERT INTO MyTable(ID, Value)
VALUES (1, 'hello'),
   (2, 'world');

UPDATE MyTable
SET Value = 'the same value'
WHERE ID IN (1, 2);

-- rather verbose; better use two simple UPDATEs:
UPDATE MyTable
SET Value = CASE ID
WHEN 1 THEN 'new A'
WHEN 2 THEN 'new B'
END
WHERE ID IN (1, 2);


Regards,
Clemens

[sqlite] C# + SQLite - How do you do Multiple Rows Inserts/Updates?

[Chris Prakoso]

I did a test using simple table, and entering the sql directly using SQLite
Administrator:

*insert into test (field1,field2) values (1,"two"),(2,"three")*


The error I got from the SQLite Administrator is:

*2/9/2016 11:29:40 AM: SQL Error: near ",": syntax error  *

Thanks,
Chris


On Tue, Feb 9, 2016 at 11:55 AM, Richard Hipp  wrote:

> On 2/9/16, Chris Prakoso  wrote:
> > Hi Clemens,
> >
> > Thanks for your reply.  I've tried to use raw SQL but it didn't work
> > either.
>
> Please show us the SQL that you did you.
>
> > Do you have any SQLite front-end that you use?
> >
>
> The only supported "front-end" (if I correctly understand your
> meaning) is the command-line tool "sqlite3.exe" available from the
> https://www.sqlite.org/download.html page.  There are many other
> third-party tools, most of which are GUI-based.  You can use them if
> you want, and they usually work quite well, but occasionally have
> bugs.
>
> --
> D. Richard Hipp
> drh at sqlite.org
> ___
> sqlite-users mailing list
> sqlite-users at mailinglists.sqlite.org
> http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
>

[sqlite] C# + SQLite - Update/Insert using Transaction is slower than without.

[Chris Prakoso]

Here they are:

public bool UpdateData(string tableName, Dictionary
fields, List whereKeys)
{
bool result = false;
string sql = "";
List fieldList = new List();
List whereKeyList = new List();
int rowsUpdated = 0;

using (SQLiteConnection conn = new
SQLiteConnection(this.ConnectionString))
{
try
{
conn.Open();

SQLiteCommand cmd = new SQLiteCommand(conn);

using (SQLiteTransaction transaction =
conn.BeginTransaction())
{

// Build a list of fields need to be updated
if (fields.Count > 0)
{
foreach (KeyValuePair kvp in
fields)
{
cmd.Parameters.AddWithValue(kvp.Key,
kvp.Value);
fieldList.Add(kvp.Key);
}
}

sql = "update " + tableName + " set " +
this.BuildUpdateFieldList(fieldList) +
" where " + this.BuildWhereClause(whereKeys);

cmd.CommandText = sql;

rowsUpdated = cmd.ExecuteNonQuery();

transaction.Commit();
}


if (rowsUpdated > 0)
result = true;

}
catch (System.Exception ex)
{
this.UpdateStatusMessage(ex.Message);
}
}

return result;
}

On Tue, Feb 9, 2016 at 11:13 AM, Clemens Ladisch  wrote:

> Chris Prakoso wrote:
> > I've been testing the performance of my Insert/Update using
> > Transaction and without, and I found that it is quicker when I don't
> > use it.
>
> Show the code.
>
>
> Regards,
> Clemens
> ___
> sqlite-users mailing list
> sqlite-users at mailinglists.sqlite.org
> http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
>

[sqlite] C# + SQLite - How do you do Multiple Rows Inserts/Updates?

[Chris Prakoso]

Hi Clemens,

Thanks for your reply.  I've tried to use raw SQL but it didn't work
either.  Do you have any SQLite front-end that you use?


Regards,
Chris

On Tue, Feb 9, 2016 at 11:12 AM, Clemens Ladisch  wrote:
> Chris Prakoso wrote:
>> My question is whether anybody had successfully implemented multiple
>> rows Insert/Update.
>
> This is possible in SQL:
>
> INSERT INTO MyTable(ID, Value)
> VALUES (1, 'hello'),
>(2, 'world');
>
> UPDATE MyTable
> SET Value = 'the same value'
> WHERE ID IN (1, 2);
>
> -- rather verbose; better use two simple UPDATEs:
> UPDATE MyTable
> SET Value = CASE ID
> WHEN 1 THEN 'new A'
> WHEN 2 THEN 'new B'
> END
> WHERE ID IN (1, 2);
>
>
> Regards,
> Clemens
> ___
> sqlite-users mailing list
> sqlite-users at mailinglists.sqlite.org
> http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users

[sqlite] C# + SQLite - Update/Insert using Transaction is slower than without.

[Chris Prakoso]

Hi all,

I've been testing the performance of my Insert/Update using
Transaction and without, and I found that it is quicker when I don't
use it.

Anybody has an insight on this?

Thanks a lot,
Chris

[sqlite] C# + SQLite - How do you do Multiple Rows Inserts/Updates?

[Chris Prakoso]

Hi all,

I just joined the Mailing List yesterday, so apologise for any mistake
I am doing.

I'm a .NET (C#) Developer, and at the moment I'm coding a small app
with SQLite as the backend database.

My question is whether anybody had successfully implemented multiple
rows Insert/Update.

I've tried to use INSERT OR REPLACE and passing multiple VALUES, but
it didn't seem to work.

Any pointers would be appreciated.


Thanks very much,
Chris

[sqlite] C# + SQLite - How do you do Multiple Rows Inserts/Updates?

[Richard Hipp]

On 2/9/16, Chris Prakoso  wrote:
> Actually I've just done it now, in SQLiteSpeed, and it allowed me to use
> double-quote as delimiter successfully.
>

That is supported for backwards compatibility.  I originally put in
support for double-quoted string literals to be compatible with MySQL
3.5.  I have long since regretted that decision.  You are encouraged
to use single-quotes for string literals, as double-quotes have a very
different meaning that can lead to subtle bugs.
-- 
D. Richard Hipp
drh at sqlite.org

[sqlite] C# + SQLite - Update/Insert using Transaction is slower than without.

[Steven M. McNeese]

So are you saying you are just reading data from your SQLite db using C# and
just need to insert using the SQLite command?  

-Original Message-
From: sqlite-users-boun...@mailinglists.sqlite.org
[mailto:sqlite-users-bounces at mailinglists.sqlite.org] On Behalf Of Chris
Prakoso
Sent: Tuesday, February 9, 2016 7:56 AM
To: SQLite mailing list
Subject: Re: [sqlite] C# + SQLite - Update/Insert using Transaction is
slower than without.

Steven,

I don't use any back-end, the code I pasted here IS my back-end.  I opted
for direct SQLite connection.  So I don't use EF6 nor Linq.

Chris

On Tue, Feb 9, 2016 at 1:47 PM, Steven M. McNeese <
steven.mcneese at freedomparkdfw.com> wrote:

> Chris,
>
> What are you using in c# for SQLite back end?  Ado.net? Linq.  Let me 
> know and I can help you with bulk inserts.
>
> Sent from my iPhone
>
> > On Feb 9, 2016, at 6:13 AM, Chris Prakoso  wrote:
> >
> > Ok. Got it.
> > Now, if only I can get that multiple rows update working on my code, 
> > it would be perfect.
> >
> > Thanks a lot,
> > Chris
> >
> >> On Tue, Feb 9, 2016 at 12:07 PM, Clemens Ladisch 
> >> 
> wrote:
> >>
> >> Chris Prakoso wrote:
> >>>public bool UpdateData(string tableName,
> >> Dictionary<string,object> fields, List whereKeys)
> >>>{
> >>>...
> >>>using (SQLiteTransaction transaction =
> >> conn.BeginTransaction())
> >>>{
> >>>...
> >>>rowsUpdated = cmd.ExecuteNonQuery();
> >>>transaction.Commit();
> >>
> >> Using one transaction for each statement is slow.
> >> (Re-opening the database doesn't help either.)
> >>
> >> You should use a single transaction around all update statements.
> >>
> >>
> >> Regards,
> >> Clemens
> >> ___
> >> sqlite-users mailing list
> >> sqlite-users at mailinglists.sqlite.org
> >> http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-user
> >> s
> > ___
> > sqlite-users mailing list
> > sqlite-users at mailinglists.sqlite.org
> > http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
>
>
> ___
> sqlite-users mailing list
> sqlite-users at mailinglists.sqlite.org
> http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
>
___
sqlite-users mailing list
sqlite-users at mailinglists.sqlite.org
http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users


---
This email has been checked for viruses by Avast antivirus software.
https://www.avast.com/antivirus

[sqlite] C# + SQLite - How do you do Multiple Rows Inserts/Updates?

[Richard Hipp]

On 2/9/16, Clemens Ladisch  wrote:
> Chris Prakoso wrote:
>> insert into test (field1,field2) values (1,"two"),(2,"three")
>>
>> SQL Error: near ",": syntax error
>
> You might want to update to a tool that is not years out of date.
>

What Clemens means by this is that prior to SQLite 3.7.11 (2012-03-20)
the INSERT statement would only take a single row in the VALUES
clause.  He is suggesting that you are using a version of SQLite that
is 4 year old or older and therefore lacks this feature.

-- 
D. Richard Hipp
drh at sqlite.org

[sqlite] C# + SQLite - Update/Insert using Transaction is slower than without.

[Steven M. McNeese]

Chris,

What are you using in c# for SQLite back end?  Ado.net? Linq.  Let me know and 
I can help you with bulk inserts. 

Sent from my iPhone

> On Feb 9, 2016, at 6:13 AM, Chris Prakoso  wrote:
> 
> Ok. Got it.
> Now, if only I can get that multiple rows update working on my code, it
> would be perfect.
> 
> Thanks a lot,
> Chris
> 
>> On Tue, Feb 9, 2016 at 12:07 PM, Clemens Ladisch  
>> wrote:
>> 
>> Chris Prakoso wrote:
>>>public bool UpdateData(string tableName,
>> Dictionary fields, List whereKeys)
>>>{
>>>...
>>>using (SQLiteTransaction transaction =
>> conn.BeginTransaction())
>>>{
>>>...
>>>rowsUpdated = cmd.ExecuteNonQuery();
>>>transaction.Commit();
>> 
>> Using one transaction for each statement is slow.
>> (Re-opening the database doesn't help either.)
>> 
>> You should use a single transaction around all update statements.
>> 
>> 
>> Regards,
>> Clemens
>> ___
>> sqlite-users mailing list
>> sqlite-users at mailinglists.sqlite.org
>> http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
> ___
> sqlite-users mailing list
> sqlite-users at mailinglists.sqlite.org
> http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users

[sqlite] C# + SQLite - How do you do Multiple Rows Inserts/Updates?

[Richard Hipp]

On 2/9/16, Chris Prakoso  wrote:
> Hi Clemens,
>
> Thanks for your reply.  I've tried to use raw SQL but it didn't work
> either.

Please show us the SQL that you did you.

> Do you have any SQLite front-end that you use?
>

The only supported "front-end" (if I correctly understand your
meaning) is the command-line tool "sqlite3.exe" available from the
https://www.sqlite.org/download.html page.  There are many other
third-party tools, most of which are GUI-based.  You can use them if
you want, and they usually work quite well, but occasionally have
bugs.

-- 
D. Richard Hipp
drh at sqlite.org

Re: [sqlite] C# - SQLite - and other things

[Joe Mistachkin]

Incongruous wrote:
> 
> After downloading sqlite-netFx451-static-binary-x64-2013-1.0.90.0 and
uncompressing
> it, I got this list of file:
> 

I think using the System.Data.SQLite NuGet package would be better in this
case.  The
package is here (it can also be found by searching in the Visual Studio
IDE):

https://nuget.org/api/v2/package/System.Data.SQLite/1.0.91.0

--
Joe Mistachkin

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

[sqlite] C# - SQLite - and other things

[Incongruous]

After downloading sqlite-netFx451-static-binary-x64-2013-1.0.90.0 and 
uncompressing it, I got this list of file:

Installer.exe
Installer.pdb
northwindEF.db
SQLite.Designer.dll
SQLite.Designer.pdb
SQLite.Designer.xml
SQLite.Interop.dll
SQLite.Interop.pdb
sqlite_file_list.txt
System.Data.SQLite.dll
System.Data.SQLite.Linq.dll
System.Data.SQLite.Linq.pdb
System.Data.SQLite.Linq.xml
System.Data.SQLite.pdb
System.Data.SQLite.xml
test.db
test.exe
test.exe.config
test.pdb
testlinq.exe
testlinq.exe.config
testlinq.pdb
[ I tried the intaller.exe, but I get a msg saying: Cannot continue, the 
"confirm" option is not enabled. ]

I have a project that looks like this:
Project:
|   pro.exe\ |
|---> image  \ |
|---> gui   \ |
|---> mylib   \ |
|---> sound  \ |
|---> sqlite   \ |
mysqlite.cs---|--->%PATH%
|__>SQLite.Designer.dll
SQLite.Designer.xml
   SQLite.Interop.dll
System.Data.SQLite.dll
   System.Data.SQLite.Linq.dll

The files contained in the sqlite-netFx451-static-binary-x64-2013-1.0.90.0 are 
located in a folder that exists in the %path%, but I cannot stop to wonder if 
all the files are necessary or if all I need is the DLLs in order to reference 
the methods in the database, and if I only need certain files, which ones are 
those?

My second question is, how can I add the DLLs from 
sqlite-netFx451-static-binary-x64-2013-1.0.90.0 to the ‘mysqlite.cs’ file in 
order to reference the its methods? I know that this question is unrelated to 
SQLite, but in its answer is my complete understanding of the solution provided.

Any help would be much appreciated.

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

RE: [sqlite] C++ SQLite

[bartsmissaert]

I did try the ODBC driver, but I found it was quite a bit slower.

RBS


> RB Smissaert uttered:
>
>> Yes, that looks to be the way to do it. Basically will have to learn how
>> to
>> translate C defines to VB declares.
>
>
> Why not just use ODBC?
>
> http://www.sqlite.org/cvstrac/wiki?p=SqliteOdbc
> http://www.ch-werner.de/sqliteodbc/
>
> That way, you're not even tied to SQLite.
>
>
>>
>> RBS
>>
>> -Original Message-
>> From: John Stanton [mailto:[EMAIL PROTECTED]
>> Sent: 28 November 2006 21:58
>> To: sqlite-users@sqlite.org
>> Subject: Re: [sqlite] C++ SQLite
>>
>> Maybe all you have to do is to make yourself a list og VB types cross
>> referenced to the fundamental type used in the Win32 and Sqlite APIs.
>> Then you could link any library into your VB programs.
>>
>> RB Smissaert wrote:
>>> You might be right, but with the Win32 API you have loads of nice
>>> documents/programs (I like the API guide from KPD) that help you out.
>>> All I have to do is copy their declares straight to VB and look at the
>> data
>>> types I have to provide. Is the same available for the SQLite API?
>>>
>>> RBS
>>>
>>> -Original Message-
>>> From: John Stanton [mailto:[EMAIL PROTECTED]
>>> Sent: 28 November 2006 18:43
>>> To: sqlite-users@sqlite.org
>>> Subject: Re: [sqlite] C++ SQLite
>>>
>>> If you can use the Win32 API you can use the Sqlite API.  Just because
>>> they can be called from C programs does not make them "all to do with
>>> C".
>>>
>>> RB Smissaert wrote:
>>>
>>>> Will have a look, but I was looking for a text geared towards VB. I
>>>> take
>>>
>>> it
>>>
>>>> the documentation that comes with SQLite is all to do with C.
>>>> In fact I already have a wrapper that seems to work well, the one from
>>>> TerraInformatica, but maybe there was more control if I could write my
>>>
>>> own.
>>>
>>>> RBS
>>>>
>>>> -Original Message-
>>>> From: Clay Dowling [mailto:[EMAIL PROTECTED]
>>>> Sent: 28 November 2006 18:19
>>>> To: sqlite-users@sqlite.org
>>>> Subject: Re: [sqlite] C++ SQLite
>>>>
>>>>
>>>> [EMAIL PROTECTED] said:
>>>>
>>>>
>>>>> Thanks. Would you know any VB source code that wraps all the possible
>>>>> declares in a class? Or do you know where to find the documentation
>>>>> to make all the possible declares in VB/VBA?
>>>>>
>>>>> RBS
>>>>
>>>>
>>>> The SQLite documentation will give you everything you need to write
>>>> the
>>>> wrapper.  The sqlite.h file in the source bundle would also be a great
>>>> help.  You may also be able to find a wrapper already written linked
>>>> on
>>>> the SQLite web site.
>>>>
>>>> Clay Dowling
>>>>
>>>>
>>>>
>>>>>> Yes.  It's a regular windows DLL, so it will behave like all other
>>>>>> Windows
>>>>>> DLLs.
>>>>>>
>>>>>> Clay Dowling
>>>>>>
>>>>>> [EMAIL PROTECTED] said:
>>>>>>
>>>>>>
>>>>>>> Can I call the SQLite API (as in the dll SQLite.dll) directly from
>>>>>>> VB or do I need the wrapper? So, could it work from VB with
>>>>>>> declares
>>>>>>> as I use for the Windows API?
>>>>>>>
>>>>>>> RBS
>>>>>>>
>>>>>>>
>>>>>>>
>>>>>>>> sebcity wrote:
>>>>>>>>
>>>>>>>>
>>>>>>>>> How would one go about using c++ (Visual Studio.NET) to call and
>>>>>>>>> display
>>>>>>>>> SQLite tables. C++ wrappers?
>>>>>>>>
>>>>>>>> You should be able to call the Sqlite3 API directly.
>>>>>>>>
>>>>>>>>
>>>>
>>>>
>>>
>> 
>>>
>>>> -
>>>>
>>>>
>>>>>>>> To unsubscribe, send email to [EMAIL PROTECTED]

RE: [sqlite] C++ SQLite

[Christian Smith]

RB Smissaert uttered:


Yes, that looks to be the way to do it. Basically will have to learn how to
translate C defines to VB declares.



Why not just use ODBC?

http://www.sqlite.org/cvstrac/wiki?p=SqliteOdbc
http://www.ch-werner.de/sqliteodbc/

That way, you're not even tied to SQLite.




RBS

-Original Message-
From: John Stanton [mailto:[EMAIL PROTECTED]
Sent: 28 November 2006 21:58
To: sqlite-users@sqlite.org
Subject: Re: [sqlite] C++ SQLite

Maybe all you have to do is to make yourself a list og VB types cross
referenced to the fundamental type used in the Win32 and Sqlite APIs.
Then you could link any library into your VB programs.

RB Smissaert wrote:

You might be right, but with the Win32 API you have loads of nice
documents/programs (I like the API guide from KPD) that help you out.
All I have to do is copy their declares straight to VB and look at the

data

types I have to provide. Is the same available for the SQLite API?

RBS

-Original Message-
From: John Stanton [mailto:[EMAIL PROTECTED]
Sent: 28 November 2006 18:43
To: sqlite-users@sqlite.org
Subject: Re: [sqlite] C++ SQLite

If you can use the Win32 API you can use the Sqlite API.  Just because
they can be called from C programs does not make them "all to do with C".

RB Smissaert wrote:


Will have a look, but I was looking for a text geared towards VB. I take


it


the documentation that comes with SQLite is all to do with C.
In fact I already have a wrapper that seems to work well, the one from
TerraInformatica, but maybe there was more control if I could write my


own.


RBS

-Original Message-
From: Clay Dowling [mailto:[EMAIL PROTECTED]
Sent: 28 November 2006 18:19
To: sqlite-users@sqlite.org
Subject: Re: [sqlite] C++ SQLite


[EMAIL PROTECTED] said:



Thanks. Would you know any VB source code that wraps all the possible
declares in a class? Or do you know where to find the documentation
to make all the possible declares in VB/VBA?

RBS



The SQLite documentation will give you everything you need to write the
wrapper.  The sqlite.h file in the source bundle would also be a great
help.  You may also be able to find a wrapper already written linked on
the SQLite web site.

Clay Dowling




Yes.  It's a regular windows DLL, so it will behave like all other
Windows
DLLs.

Clay Dowling

[EMAIL PROTECTED] said:



Can I call the SQLite API (as in the dll SQLite.dll) directly from
VB or do I need the wrapper? So, could it work from VB with declares
as I use for the Windows API?

RBS




sebcity wrote:



How would one go about using c++ (Visual Studio.NET) to call and
display
SQLite tables. C++ wrappers?


You should be able to call the Sqlite3 API directly.












-



To unsubscribe, send email to [EMAIL PROTECTED]











-















-



To unsubscribe, send email to [EMAIL PROTECTED]











-



--
Simple Content Management
http://www.ceamus.com













-



To unsubscribe, send email to [EMAIL PROTECTED]











-















-



To unsubscribe, send email to [EMAIL PROTECTED]











-










-
To unsubscribe, send email to [EMAIL PROTECTED]




-







-

To unsubscribe, send email to [EMAIL PROTECTED]



-






-
To unsubscribe, send email to [EMAIL PROTECTED]

-




-
To unsubscribe, send email to [EMAIL PROTECTED]
-



--
/"\
\ /ASCII RIBBON CAMPAIGN - AGAINST HTML MAIL
 X   - AGAINST MS ATTACHMENTS
/ \

-
To unsubscribe, send email to [EMAIL PROTECTED]
-

Re: [sqlite] C++ SQLite

[John Stanton]

There us very little to learn, just equivalent names for types.

RB Smissaert wrote:

Yes, that looks to be the way to do it. Basically will have to learn how to
translate C defines to VB declares.

RBS

-Original Message-
From: John Stanton [mailto:[EMAIL PROTECTED] 
Sent: 28 November 2006 21:58

To: sqlite-users@sqlite.org
Subject: Re: [sqlite] C++ SQLite

Maybe all you have to do is to make yourself a list og VB types cross 
referenced to the fundamental type used in the Win32 and Sqlite APIs. 
Then you could link any library into your VB programs.


RB Smissaert wrote:


You might be right, but with the Win32 API you have loads of nice
documents/programs (I like the API guide from KPD) that help you out.
All I have to do is copy their declares straight to VB and look at the


data


types I have to provide. Is the same available for the SQLite API?

RBS

-Original Message-
From: John Stanton [mailto:[EMAIL PROTECTED] 
Sent: 28 November 2006 18:43

To: sqlite-users@sqlite.org
Subject: Re: [sqlite] C++ SQLite

If you can use the Win32 API you can use the Sqlite API.  Just because 
they can be called from C programs does not make them "all to do with C".


RB Smissaert wrote:



Will have a look, but I was looking for a text geared towards VB. I take


it



the documentation that comes with SQLite is all to do with C.
In fact I already have a wrapper that seems to work well, the one from
TerraInformatica, but maybe there was more control if I could write my


own.



RBS

-Original Message-
From: Clay Dowling [mailto:[EMAIL PROTECTED] 
Sent: 28 November 2006 18:19

To: sqlite-users@sqlite.org
Subject: Re: [sqlite] C++ SQLite


[EMAIL PROTECTED] said:




Thanks. Would you know any VB source code that wraps all the possible
declares in a class? Or do you know where to find the documentation
to make all the possible declares in VB/VBA?

RBS



The SQLite documentation will give you everything you need to write the
wrapper.  The sqlite.h file in the source bundle would also be a great
help.  You may also be able to find a wrapper already written linked on
the SQLite web site.

Clay Dowling





Yes.  It's a regular windows DLL, so it will behave like all other
Windows
DLLs.

Clay Dowling

[EMAIL PROTECTED] said:




Can I call the SQLite API (as in the dll SQLite.dll) directly from
VB or do I need the wrapper? So, could it work from VB with declares
as I use for the Windows API?

RBS





sebcity wrote:




How would one go about using c++ (Visual Studio.NET) to call and
display
SQLite tables. C++ wrappers?


You should be able to call the Sqlite3 API directly.









-




To unsubscribe, send email to [EMAIL PROTECTED]








-










-




To unsubscribe, send email to [EMAIL PROTECTED]








-




--
Simple Content Management
http://www.ceamus.com










-




To unsubscribe, send email to [EMAIL PROTECTED]








-










-




To unsubscribe, send email to [EMAIL PROTECTED]








-











-
To unsubscribe, send email to [EMAIL PROTECTED]






-








-


To unsubscribe, send email to [EMAIL PROTECTED]




-




-
To unsubscribe, send email to [EMAIL PROTECTED]

-




-
To unsubscribe, send email to [EMAIL PROTECTED]
-




-
To unsubscribe, send email to [EMAIL PROTECTED]
-

Re: [sqlite] C++ SQLite

[Roberto]

Check that the version of VB, or VB itself supports calling external
functions using 'cdecl' calling convention (instead of WINAPI
stdcall).

On 28/11/06, RB Smissaert <[EMAIL PROTECTED]> wrote:

Yes, that looks to be the way to do it. Basically will have to learn how to
translate C defines to VB declares.

RBS



-
To unsubscribe, send email to [EMAIL PROTECTED]
-

RE: [sqlite] C++ SQLite

[RB Smissaert]

Yes, that looks to be the way to do it. Basically will have to learn how to
translate C defines to VB declares.

RBS

-Original Message-
From: John Stanton [mailto:[EMAIL PROTECTED] 
Sent: 28 November 2006 21:58
To: sqlite-users@sqlite.org
Subject: Re: [sqlite] C++ SQLite

Maybe all you have to do is to make yourself a list og VB types cross 
referenced to the fundamental type used in the Win32 and Sqlite APIs. 
Then you could link any library into your VB programs.

RB Smissaert wrote:
> You might be right, but with the Win32 API you have loads of nice
> documents/programs (I like the API guide from KPD) that help you out.
> All I have to do is copy their declares straight to VB and look at the
data
> types I have to provide. Is the same available for the SQLite API?
> 
> RBS
> 
> -Original Message-
> From: John Stanton [mailto:[EMAIL PROTECTED] 
> Sent: 28 November 2006 18:43
> To: sqlite-users@sqlite.org
> Subject: Re: [sqlite] C++ SQLite
> 
> If you can use the Win32 API you can use the Sqlite API.  Just because 
> they can be called from C programs does not make them "all to do with C".
> 
> RB Smissaert wrote:
> 
>>Will have a look, but I was looking for a text geared towards VB. I take
> 
> it
> 
>>the documentation that comes with SQLite is all to do with C.
>>In fact I already have a wrapper that seems to work well, the one from
>>TerraInformatica, but maybe there was more control if I could write my
> 
> own.
> 
>>RBS
>>
>>-Original Message-
>>From: Clay Dowling [mailto:[EMAIL PROTECTED] 
>>Sent: 28 November 2006 18:19
>>To: sqlite-users@sqlite.org
>>Subject: Re: [sqlite] C++ SQLite
>>
>>
>>[EMAIL PROTECTED] said:
>>
>>
>>>Thanks. Would you know any VB source code that wraps all the possible
>>>declares in a class? Or do you know where to find the documentation
>>>to make all the possible declares in VB/VBA?
>>>
>>>RBS
>>
>>
>>The SQLite documentation will give you everything you need to write the
>>wrapper.  The sqlite.h file in the source bundle would also be a great
>>help.  You may also be able to find a wrapper already written linked on
>>the SQLite web site.
>>
>>Clay Dowling
>>
>>
>>
>>>>Yes.  It's a regular windows DLL, so it will behave like all other
>>>>Windows
>>>>DLLs.
>>>>
>>>>Clay Dowling
>>>>
>>>>[EMAIL PROTECTED] said:
>>>>
>>>>
>>>>>Can I call the SQLite API (as in the dll SQLite.dll) directly from
>>>>>VB or do I need the wrapper? So, could it work from VB with declares
>>>>>as I use for the Windows API?
>>>>>
>>>>>RBS
>>>>>
>>>>>
>>>>>
>>>>>>sebcity wrote:
>>>>>>
>>>>>>
>>>>>>>How would one go about using c++ (Visual Studio.NET) to call and
>>>>>>>display
>>>>>>>SQLite tables. C++ wrappers?
>>>>>>
>>>>>>You should be able to call the Sqlite3 API directly.
>>>>>>
>>>>>>
>>
>>
>

> 
>>-
>>
>>
>>>>>>To unsubscribe, send email to [EMAIL PROTECTED]
>>>>>>
>>
>>
>

> 
>>-
>>
>>
>>>>>>
>>>>>
>>>>>
>>>>>
>

> 
>>-
>>
>>
>>>>>To unsubscribe, send email to [EMAIL PROTECTED]
>>>>>
>>
>>
>

> 
>>-
>>
>>
>>>>--
>>>>Simple Content Management
>>>>http://www.ceamus.com
>>>>
>>>>
>>>>
>>
>>
>

> 
>>-
>>
>>
>>>>To unsubscribe, send email to [EMAIL PROTECTED]
>>>>
>>
>>
>

> 
>>-
>>
>>
>>>>
>>>
>>>
>>>
>

> 
>>-
>>
>>
>>>To unsubscribe, send email to [EMAIL PROTECTED]
>>>
>>
>>
>

> 
>>-
>>
>>
>>
> 
> 
>

> -
> To unsubscribe, send email to [EMAIL PROTECTED]
>

> -
> 
> 
> 
> 
>

-
> To unsubscribe, send email to [EMAIL PROTECTED]
>

-
> 



-
To unsubscribe, send email to [EMAIL PROTECTED]

-




-
To unsubscribe, send email to [EMAIL PROTECTED]
-

Re: [sqlite] C++ SQLite

[John Stanton]

Maybe all you have to do is to make yourself a list og VB types cross 
referenced to the fundamental type used in the Win32 and Sqlite APIs. 
Then you could link any library into your VB programs.


RB Smissaert wrote:

You might be right, but with the Win32 API you have loads of nice
documents/programs (I like the API guide from KPD) that help you out.
All I have to do is copy their declares straight to VB and look at the data
types I have to provide. Is the same available for the SQLite API?

RBS

-Original Message-
From: John Stanton [mailto:[EMAIL PROTECTED] 
Sent: 28 November 2006 18:43

To: sqlite-users@sqlite.org
Subject: Re: [sqlite] C++ SQLite

If you can use the Win32 API you can use the Sqlite API.  Just because 
they can be called from C programs does not make them "all to do with C".


RB Smissaert wrote:


Will have a look, but I was looking for a text geared towards VB. I take


it


the documentation that comes with SQLite is all to do with C.
In fact I already have a wrapper that seems to work well, the one from
TerraInformatica, but maybe there was more control if I could write my


own.


RBS

-Original Message-
From: Clay Dowling [mailto:[EMAIL PROTECTED] 
Sent: 28 November 2006 18:19

To: sqlite-users@sqlite.org
Subject: Re: [sqlite] C++ SQLite


[EMAIL PROTECTED] said:



Thanks. Would you know any VB source code that wraps all the possible
declares in a class? Or do you know where to find the documentation
to make all the possible declares in VB/VBA?

RBS



The SQLite documentation will give you everything you need to write the
wrapper.  The sqlite.h file in the source bundle would also be a great
help.  You may also be able to find a wrapper already written linked on
the SQLite web site.

Clay Dowling




Yes.  It's a regular windows DLL, so it will behave like all other
Windows
DLLs.

Clay Dowling

[EMAIL PROTECTED] said:



Can I call the SQLite API (as in the dll SQLite.dll) directly from
VB or do I need the wrapper? So, could it work from VB with declares
as I use for the Windows API?

RBS




sebcity wrote:



How would one go about using c++ (Visual Studio.NET) to call and
display
SQLite tables. C++ wrappers?


You should be able to call the Sqlite3 API directly.









-



To unsubscribe, send email to [EMAIL PROTECTED]








-












-



To unsubscribe, send email to [EMAIL PROTECTED]








-



--
Simple Content Management
http://www.ceamus.com










-



To unsubscribe, send email to [EMAIL PROTECTED]








-












-



To unsubscribe, send email to [EMAIL PROTECTED]








-







-
To unsubscribe, send email to [EMAIL PROTECTED]

-




-
To unsubscribe, send email to [EMAIL PROTECTED]
-




-
To unsubscribe, send email to [EMAIL PROTECTED]
-

RE: [sqlite] C++ SQLite

[RB Smissaert]

> In the amount of time that you've spent asking for an import
> library on this list you could have written all of the imports.

If you say so. Thanks in any case.

RBS

-Original Message-
From: Clay Dowling [mailto:[EMAIL PROTECTED] 
Sent: 28 November 2006 21:39
To: sqlite-users@sqlite.org
Subject: RE: [sqlite] C++ SQLite


RB Smissaert said:
> You might be right, but with the Win32 API you have loads of nice
> documents/programs (I like the API guide from KPD) that help you out.
> All I have to do is copy their declares straight to VB and look at the
> data
> types I have to provide. Is the same available for the SQLite API?
>

http://www.sqlite.org/capi3ref.html

That's the page you want.  It declares everything you need.  In the amount
of time that you've spent asking for an import library on this list you
could have written all of the imports.

The sqlite3* and sqlite3_stmt* types are just pointers, so you can declare
them as such.  Everything else is a fundamental type.  Now you're good to
go.  Combine that with my article in a previous message about how to use
the API and you're on the same footing as the C programmers who use the
library.

Clay Dowling



> -Original Message-
> From: John Stanton [mailto:[EMAIL PROTECTED]
> Sent: 28 November 2006 18:43
> To: sqlite-users@sqlite.org
> Subject: Re: [sqlite] C++ SQLite
>
> If you can use the Win32 API you can use the Sqlite API.  Just because
> they can be called from C programs does not make them "all to do with C".
>
> RB Smissaert wrote:
>> Will have a look, but I was looking for a text geared towards VB. I take
> it
>> the documentation that comes with SQLite is all to do with C.
>> In fact I already have a wrapper that seems to work well, the one from
>> TerraInformatica, but maybe there was more control if I could write my
> own.
>>
>> RBS
>>
>> -Original Message-
>> From: Clay Dowling [mailto:[EMAIL PROTECTED]
>> Sent: 28 November 2006 18:19
>> To: sqlite-users@sqlite.org
>> Subject: Re: [sqlite] C++ SQLite
>>
>>
>> [EMAIL PROTECTED] said:
>>
>>>Thanks. Would you know any VB source code that wraps all the possible
>>>declares in a class? Or do you know where to find the documentation
>>>to make all the possible declares in VB/VBA?
>>>
>>>RBS
>>
>>
>> The SQLite documentation will give you everything you need to write the
>> wrapper.  The sqlite.h file in the source bundle would also be a great
>> help.  You may also be able to find a wrapper already written linked on
>> the SQLite web site.
>>
>> Clay Dowling
>>
>>
>>>
>>>>Yes.  It's a regular windows DLL, so it will behave like all other
>>>>Windows
>>>>DLLs.
>>>>
>>>>Clay Dowling
>>>>
>>>>[EMAIL PROTECTED] said:
>>>>
>>>>>Can I call the SQLite API (as in the dll SQLite.dll) directly from
>>>>>VB or do I need the wrapper? So, could it work from VB with declares
>>>>>as I use for the Windows API?
>>>>>
>>>>>RBS
>>>>>
>>>>>
>>>>>>sebcity wrote:
>>>>>>
>>>>>>>How would one go about using c++ (Visual Studio.NET) to call and
>>>>>>>display
>>>>>>>SQLite tables. C++ wrappers?
>>>>>>
>>>>>>You should be able to call the Sqlite3 API directly.
>>>>>>
>>>>>>
>>
>>
>

>> -
>>
>>>>>>To unsubscribe, send email to [EMAIL PROTECTED]
>>>>>>
>>
>>
>

>> -
>>
>>>>>>
>>>>>>
>>>>>
>>>>>
>>>>>
>>>>>
>>
>

>> -
>>
>>>>>To unsubscribe, send email to [EMAIL PROTECTED]
>>>>>
>>
>>
>

>> -
>>
>>>>>
>>>>
>>>>--
>>>>Simple Content Management
>>>>http://www.ceamus.com
>>>>
>>>>
>>>>
>>
>>
>

>> -
>>
>>

RE: [sqlite] C++ SQLite

[Clay Dowling]

RB Smissaert said:
> You might be right, but with the Win32 API you have loads of nice
> documents/programs (I like the API guide from KPD) that help you out.
> All I have to do is copy their declares straight to VB and look at the
> data
> types I have to provide. Is the same available for the SQLite API?
>

http://www.sqlite.org/capi3ref.html

That's the page you want.  It declares everything you need.  In the amount
of time that you've spent asking for an import library on this list you
could have written all of the imports.

The sqlite3* and sqlite3_stmt* types are just pointers, so you can declare
them as such.  Everything else is a fundamental type.  Now you're good to
go.  Combine that with my article in a previous message about how to use
the API and you're on the same footing as the C programmers who use the
library.

Clay Dowling



> -Original Message-
> From: John Stanton [mailto:[EMAIL PROTECTED]
> Sent: 28 November 2006 18:43
> To: sqlite-users@sqlite.org
> Subject: Re: [sqlite] C++ SQLite
>
> If you can use the Win32 API you can use the Sqlite API.  Just because
> they can be called from C programs does not make them "all to do with C".
>
> RB Smissaert wrote:
>> Will have a look, but I was looking for a text geared towards VB. I take
> it
>> the documentation that comes with SQLite is all to do with C.
>> In fact I already have a wrapper that seems to work well, the one from
>> TerraInformatica, but maybe there was more control if I could write my
> own.
>>
>> RBS
>>
>> -Original Message-
>> From: Clay Dowling [mailto:[EMAIL PROTECTED]
>> Sent: 28 November 2006 18:19
>> To: sqlite-users@sqlite.org
>> Subject: Re: [sqlite] C++ SQLite
>>
>>
>> [EMAIL PROTECTED] said:
>>
>>>Thanks. Would you know any VB source code that wraps all the possible
>>>declares in a class? Or do you know where to find the documentation
>>>to make all the possible declares in VB/VBA?
>>>
>>>RBS
>>
>>
>> The SQLite documentation will give you everything you need to write the
>> wrapper.  The sqlite.h file in the source bundle would also be a great
>> help.  You may also be able to find a wrapper already written linked on
>> the SQLite web site.
>>
>> Clay Dowling
>>
>>
>>>
>>>>Yes.  It's a regular windows DLL, so it will behave like all other
>>>>Windows
>>>>DLLs.
>>>>
>>>>Clay Dowling
>>>>
>>>>[EMAIL PROTECTED] said:
>>>>
>>>>>Can I call the SQLite API (as in the dll SQLite.dll) directly from
>>>>>VB or do I need the wrapper? So, could it work from VB with declares
>>>>>as I use for the Windows API?
>>>>>
>>>>>RBS
>>>>>
>>>>>
>>>>>>sebcity wrote:
>>>>>>
>>>>>>>How would one go about using c++ (Visual Studio.NET) to call and
>>>>>>>display
>>>>>>>SQLite tables. C++ wrappers?
>>>>>>
>>>>>>You should be able to call the Sqlite3 API directly.
>>>>>>
>>>>>>
>>
>>
> 
>> -
>>
>>>>>>To unsubscribe, send email to [EMAIL PROTECTED]
>>>>>>
>>
>>
> 
>> -
>>
>>>>>>
>>>>>>
>>>>>
>>>>>
>>>>>
>>>>>
>>
> 
>> -
>>
>>>>>To unsubscribe, send email to [EMAIL PROTECTED]
>>>>>
>>
>>
> 
>> -
>>
>>>>>
>>>>
>>>>--
>>>>Simple Content Management
>>>>http://www.ceamus.com
>>>>
>>>>
>>>>
>>
>>
> 
>> -
>>
>>>>To unsubscribe, send email to [EMAIL PROTECTED]
>>>>
>>
>>
> 
>> -
>>
>>>>
>>>>
>>>
>>>
>>>
>>>
>>
> 
>> -
>>
>>>To unsubscribe, send email to [EMAIL PROTECTED]
>>>
>>
>>
> 
>> -
>>
>>>
>>
>>
>
>
> 
> -
> To unsubscribe, send email to [EMAIL PROTECTED]
> 
> -
>
>
>
>
> -
> To unsubscribe, send email to [EMAIL PROTECTED]
> -
>
>


-- 
Simple Content Management
http://www.ceamus.com


-
To unsubscribe, send email to [EMAIL PROTECTED]
-

RE: [sqlite] C++ SQLite

[RB Smissaert]

You might be right, but with the Win32 API you have loads of nice
documents/programs (I like the API guide from KPD) that help you out.
All I have to do is copy their declares straight to VB and look at the data
types I have to provide. Is the same available for the SQLite API?

RBS

-Original Message-
From: John Stanton [mailto:[EMAIL PROTECTED] 
Sent: 28 November 2006 18:43
To: sqlite-users@sqlite.org
Subject: Re: [sqlite] C++ SQLite

If you can use the Win32 API you can use the Sqlite API.  Just because 
they can be called from C programs does not make them "all to do with C".

RB Smissaert wrote:
> Will have a look, but I was looking for a text geared towards VB. I take
it
> the documentation that comes with SQLite is all to do with C.
> In fact I already have a wrapper that seems to work well, the one from
> TerraInformatica, but maybe there was more control if I could write my
own.
> 
> RBS
> 
> -Original Message-
> From: Clay Dowling [mailto:[EMAIL PROTECTED] 
> Sent: 28 November 2006 18:19
> To: sqlite-users@sqlite.org
> Subject: Re: [sqlite] C++ SQLite
> 
> 
> [EMAIL PROTECTED] said:
> 
>>Thanks. Would you know any VB source code that wraps all the possible
>>declares in a class? Or do you know where to find the documentation
>>to make all the possible declares in VB/VBA?
>>
>>RBS
> 
> 
> The SQLite documentation will give you everything you need to write the
> wrapper.  The sqlite.h file in the source bundle would also be a great
> help.  You may also be able to find a wrapper already written linked on
> the SQLite web site.
> 
> Clay Dowling
> 
> 
>>
>>>Yes.  It's a regular windows DLL, so it will behave like all other
>>>Windows
>>>DLLs.
>>>
>>>Clay Dowling
>>>
>>>[EMAIL PROTECTED] said:
>>>
>>>>Can I call the SQLite API (as in the dll SQLite.dll) directly from
>>>>VB or do I need the wrapper? So, could it work from VB with declares
>>>>as I use for the Windows API?
>>>>
>>>>RBS
>>>>
>>>>
>>>>>sebcity wrote:
>>>>>
>>>>>>How would one go about using c++ (Visual Studio.NET) to call and
>>>>>>display
>>>>>>SQLite tables. C++ wrappers?
>>>>>
>>>>>You should be able to call the Sqlite3 API directly.
>>>>>
>>>>>
> 
>

> -
> 
>>>>>To unsubscribe, send email to [EMAIL PROTECTED]
>>>>>
> 
>

> -
> 
>>>>>
>>>>>
>>>>
>>>>
>>>>
>>>>
>

> -
> 
>>>>To unsubscribe, send email to [EMAIL PROTECTED]
>>>>
> 
>

> -
> 
>>>>
>>>
>>>--
>>>Simple Content Management
>>>http://www.ceamus.com
>>>
>>>
>>>
> 
>

> -
> 
>>>To unsubscribe, send email to [EMAIL PROTECTED]
>>>
> 
>

> -
> 
>>>
>>>
>>
>>
>>
>>
>

> -
> 
>>To unsubscribe, send email to [EMAIL PROTECTED]
>>
> 
>

> -
> 
>>
> 
> 



-
To unsubscribe, send email to [EMAIL PROTECTED]

-




-
To unsubscribe, send email to [EMAIL PROTECTED]
-

Re: [sqlite] C++ SQLite

[John Stanton]

If you can use the Win32 API you can use the Sqlite API.  Just because 
they can be called from C programs does not make them "all to do with C".


RB Smissaert wrote:

Will have a look, but I was looking for a text geared towards VB. I take it
the documentation that comes with SQLite is all to do with C.
In fact I already have a wrapper that seems to work well, the one from
TerraInformatica, but maybe there was more control if I could write my own.

RBS

-Original Message-
From: Clay Dowling [mailto:[EMAIL PROTECTED] 
Sent: 28 November 2006 18:19

To: sqlite-users@sqlite.org
Subject: Re: [sqlite] C++ SQLite


[EMAIL PROTECTED] said:


Thanks. Would you know any VB source code that wraps all the possible
declares in a class? Or do you know where to find the documentation
to make all the possible declares in VB/VBA?

RBS



The SQLite documentation will give you everything you need to write the
wrapper.  The sqlite.h file in the source bundle would also be a great
help.  You may also be able to find a wrapper already written linked on
the SQLite web site.

Clay Dowling





Yes.  It's a regular windows DLL, so it will behave like all other
Windows
DLLs.

Clay Dowling

[EMAIL PROTECTED] said:


Can I call the SQLite API (as in the dll SQLite.dll) directly from
VB or do I need the wrapper? So, could it work from VB with declares
as I use for the Windows API?

RBS



sebcity wrote:


How would one go about using c++ (Visual Studio.NET) to call and
display
SQLite tables. C++ wrappers?


You should be able to call the Sqlite3 API directly.





-


To unsubscribe, send email to [EMAIL PROTECTED]




-











-


To unsubscribe, send email to [EMAIL PROTECTED]




-





--
Simple Content Management
http://www.ceamus.com






-


To unsubscribe, send email to [EMAIL PROTECTED]




-











-


To unsubscribe, send email to [EMAIL PROTECTED]




-









-
To unsubscribe, send email to [EMAIL PROTECTED]
-

RE: [sqlite] C++ SQLite

[RB Smissaert]

Will have a look, but I was looking for a text geared towards VB. I take it
the documentation that comes with SQLite is all to do with C.
In fact I already have a wrapper that seems to work well, the one from
TerraInformatica, but maybe there was more control if I could write my own.

RBS

-Original Message-
From: Clay Dowling [mailto:[EMAIL PROTECTED] 
Sent: 28 November 2006 18:19
To: sqlite-users@sqlite.org
Subject: Re: [sqlite] C++ SQLite


[EMAIL PROTECTED] said:
> Thanks. Would you know any VB source code that wraps all the possible
> declares in a class? Or do you know where to find the documentation
> to make all the possible declares in VB/VBA?
>
> RBS

The SQLite documentation will give you everything you need to write the
wrapper.  The sqlite.h file in the source bundle would also be a great
help.  You may also be able to find a wrapper already written linked on
the SQLite web site.

Clay Dowling

>
>
>> Yes.  It's a regular windows DLL, so it will behave like all other
>> Windows
>> DLLs.
>>
>> Clay Dowling
>>
>> [EMAIL PROTECTED] said:
>>> Can I call the SQLite API (as in the dll SQLite.dll) directly from
>>> VB or do I need the wrapper? So, could it work from VB with declares
>>> as I use for the Windows API?
>>>
>>> RBS
>>>
>>>> sebcity wrote:
>>>>> How would one go about using c++ (Visual Studio.NET) to call and
>>>>> display
>>>>> SQLite tables. C++ wrappers?
>>>> You should be able to call the Sqlite3 API directly.
>>>>
>>>>

-
>>>> To unsubscribe, send email to [EMAIL PROTECTED]
>>>>

-
>>>>
>>>>
>>>>
>>>
>>>
>>>
>>>
>>>

-
>>> To unsubscribe, send email to [EMAIL PROTECTED]
>>>

-
>>>
>>>
>>
>>
>> --
>> Simple Content Management
>> http://www.ceamus.com
>>
>>
>>

-
>> To unsubscribe, send email to [EMAIL PROTECTED]
>>

-
>>
>>
>>
>
>
>
>
>

-
> To unsubscribe, send email to [EMAIL PROTECTED]
>

-
>
>


-- 
Simple Content Management
http://www.ceamus.com



-
To unsubscribe, send email to [EMAIL PROTECTED]

-




-
To unsubscribe, send email to [EMAIL PROTECTED]
-

Re: [sqlite] C++ SQLite

[Clay Dowling]

Yes.  It's a regular windows DLL, so it will behave like all other Windows
DLLs.

Clay Dowling

[EMAIL PROTECTED] said:
> Can I call the SQLite API (as in the dll SQLite.dll) directly from
> VB or do I need the wrapper? So, could it work from VB with declares
> as I use for the Windows API?
>
> RBS
>
>> sebcity wrote:
>>> How would one go about using c++ (Visual Studio.NET) to call and
>>> display
>>> SQLite tables. C++ wrappers?
>> You should be able to call the Sqlite3 API directly.
>>
>> -
>> To unsubscribe, send email to [EMAIL PROTECTED]
>> -
>>
>>
>>
>
>
>
>
> -
> To unsubscribe, send email to [EMAIL PROTECTED]
> -
>
>


-- 
Simple Content Management
http://www.ceamus.com


-
To unsubscribe, send email to [EMAIL PROTECTED]
-

Re: [sqlite] C++ SQLite

[bartsmissaert]

Can I call the SQLite API (as in the dll SQLite.dll) directly from
VB or do I need the wrapper? So, could it work from VB with declares
as I use for the Windows API?

RBS

> sebcity wrote:
>> How would one go about using c++ (Visual Studio.NET) to call and display
>> SQLite tables. C++ wrappers?
> You should be able to call the Sqlite3 API directly.
>
> -
> To unsubscribe, send email to [EMAIL PROTECTED]
> -
>
>
>




-
To unsubscribe, send email to [EMAIL PROTECTED]
-

Re: [sqlite] C++ SQLite

[John Stanton]

Remember the first rule of IT.  "If you don't have time do do it right, 
you don't have time to do it twice".


sebcity wrote:

Time constraints

Craig Morrison-2 wrote:


sebcity wrote:

Thanks, Could you supply an example? 


I'm not going to be as nice as everyone else, go here:

http://www.sqlite.org/cvstrac/wiki

Do some research and then come back instead of asking for handouts.

We've all been where you are now, the difference is that we tried on our 
own and _then_ came here asking questions when we got stuck. Trying to 
do a little work on your own will do you a world of good.




Clay Dowling wrote:


sebcity wrote:


How would one go about using c++ (Visual Studio.NET) to call and
display
SQLite tables. C++ wrappers?


You could just use the API directly.  Myself, I've put a wrapper around
it, but there's nothing saying that you have to.

Clay
--
CeaMuS
http://www.ceamus.com
Simple Content Management

-
To unsubscribe, send email to [EMAIL PROTECTED]
-








--
Craig Morrison
=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=
http://pse.2cah.com
  Controlling pseudoephedrine purchases.

http://www.mtsprofessional.com/
  A Win32 email server that works for You.

-
To unsubscribe, send email to [EMAIL PROTECTED]
-









-
To unsubscribe, send email to [EMAIL PROTECTED]
-

Re: [sqlite] C++ SQLite

[John Stanton]

sebcity wrote:

How would one go about using c++ (Visual Studio.NET) to call and display
SQLite tables. C++ wrappers?

You should be able to call the Sqlite3 API directly.

-
To unsubscribe, send email to [EMAIL PROTECTED]
-

Re: [sqlite] C++ SQLite

[Clay Dowling]

sebcity said:
>
> Thanks, Could you supply an example?
>

http://www.linuxjournal.com/article/7803

Clay
-- 
Simple Content Management
http://www.ceamus.com


-
To unsubscribe, send email to [EMAIL PROTECTED]
-

Re: [sqlite] C++ SQLite

[Markus Hoenicka]

sebcity <[EMAIL PROTECTED]> was heard to say:

>
> Time constraints
>

Good point. I've got time constraints too. Could everyone else please start to
solve all my problems right now too please?

Markus


-- 
Markus Hoenicka
[EMAIL PROTECTED]
(Spam-protected email: replace the quadrupeds with "mhoenicka")
http://www.mhoenicka.de


-
To unsubscribe, send email to [EMAIL PROTECTED]
-

Re: [sqlite] C++ SQLite

[sebcity]

Time constraints

Craig Morrison-2 wrote:
> 
> sebcity wrote:
>> Thanks, Could you supply an example? 
> 
> I'm not going to be as nice as everyone else, go here:
> 
> http://www.sqlite.org/cvstrac/wiki
> 
> Do some research and then come back instead of asking for handouts.
> 
> We've all been where you are now, the difference is that we tried on our 
> own and _then_ came here asking questions when we got stuck. Trying to 
> do a little work on your own will do you a world of good.
> 
>> 
>> Clay Dowling wrote:
>>> sebcity wrote:
 How would one go about using c++ (Visual Studio.NET) to call and
 display
 SQLite tables. C++ wrappers?
>>> You could just use the API directly.  Myself, I've put a wrapper around
>>> it, but there's nothing saying that you have to.
>>>
>>> Clay
>>> -- 
>>> CeaMuS
>>> http://www.ceamus.com
>>> Simple Content Management
>>>
>>> -
>>> To unsubscribe, send email to [EMAIL PROTECTED]
>>> -
>>>
>>>
>>>
>> 
> 
> 
> 
> -- 
> Craig Morrison
> =-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=
> http://pse.2cah.com
>Controlling pseudoephedrine purchases.
> 
> http://www.mtsprofessional.com/
>A Win32 email server that works for You.
> 
> -
> To unsubscribe, send email to [EMAIL PROTECTED]
> -
> 
> 
> 

-- 
View this message in context: 
http://www.nabble.com/C%2B%2B-SQLite-tf2717819.html#a7578545
Sent from the SQLite mailing list archive at Nabble.com.


-
To unsubscribe, send email to [EMAIL PROTECTED]
-

[sqlite] Re:[sqlite] C++ SQLite

[Linker M Lin]

u have to search sqlite++.
:)
 
--
Linker M Lin
[EMAIL PROTECTED]
※
※※我思故我在※※
※



- 原始邮件 
发件人： sebcity <[EMAIL PROTECTED]>
收件人： sqlite-users@sqlite.org
已发送： 2006/11/28(周二), 下午7:52:07
主题： Re: [sqlite] C++ SQLite


Thanks, Could you supply an example? 

Clay Dowling wrote:
> 
> sebcity wrote:
>> How would one go about using c++ (Visual Studio.NET) to call and display
>> SQLite tables. C++ wrappers?
> 
> You could just use the API directly.  Myself, I've put a wrapper around
> it, but there's nothing saying that you have to.
> 
> Clay
> -- 
> CeaMuS
> http://www.ceamus.com
> Simple Content Management
> 
> -
> To unsubscribe, send email to [EMAIL PROTECTED]
> -
> 
> 
> 

-- 
View this message in context: 
http://www.nabble.com/C%2B%2B-SQLite-tf2717819.html#a7577870
Sent from the SQLite mailing list archive at Nabble.com.


-
To unsubscribe, send email to [EMAIL PROTECTED]
-



___ 
抢注雅虎免费邮箱-3.5G容量，20M附件！ 
http://cn.mail.yahoo.com

Re: [sqlite] C++ SQLite

[Craig Morrison]

sebcity wrote:
Thanks, Could you supply an example? 


I'm not going to be as nice as everyone else, go here:

http://www.sqlite.org/cvstrac/wiki

Do some research and then come back instead of asking for handouts.

We've all been where you are now, the difference is that we tried on our 
own and _then_ came here asking questions when we got stuck. Trying to 
do a little work on your own will do you a world of good.




Clay Dowling wrote:

sebcity wrote:

How would one go about using c++ (Visual Studio.NET) to call and display
SQLite tables. C++ wrappers?

You could just use the API directly.  Myself, I've put a wrapper around
it, but there's nothing saying that you have to.

Clay
--
CeaMuS
http://www.ceamus.com
Simple Content Management

-
To unsubscribe, send email to [EMAIL PROTECTED]
-









--
Craig Morrison
=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=
http://pse.2cah.com
  Controlling pseudoephedrine purchases.

http://www.mtsprofessional.com/
  A Win32 email server that works for You.

-
To unsubscribe, send email to [EMAIL PROTECTED]
-

Re: [sqlite] C++ SQLite

[Clay Dowling]

sebcity wrote:
> How would one go about using c++ (Visual Studio.NET) to call and display
> SQLite tables. C++ wrappers?

You could just use the API directly.  Myself, I've put a wrapper around
it, but there's nothing saying that you have to.

Clay
-- 
CeaMuS
http://www.ceamus.com
Simple Content Management

-
To unsubscribe, send email to [EMAIL PROTECTED]
-

[sqlite] C++ SQLite

[sebcity]

How would one go about using c++ (Visual Studio.NET) to call and display
SQLite tables. C++ wrappers?
-- 
View this message in context: 
http://www.nabble.com/C%2B%2B-SQLite-tf2717819.html#a7577607
Sent from the SQLite mailing list archive at Nabble.com.


-
To unsubscribe, send email to [EMAIL PROTECTED]
-