Re: [sqlite] sqlite with borland c builder

2004-04-01 Thread Nuno Lucas
Make sure you compile the dll (if you are compiling a dll, offcourse) with the C calling convention. I'm not sure now, but if I remember correctly that is not the default for the Borland compiler. Other cause could be not linking with the import library, but that is basic. Just my two cents. I

Re: [sqlite] sqlite with borland c builder

2004-04-01 Thread Nuno Lucas
Make sure you compile the dll (if you are compiling a dll, offcourse) with the C calling convention. I'm not sure now, but if I remember correctly that is not the default for the Borland compiler. Other cause could be not linking with the import library, but that is basic. Just my two cents. I

[sqlite] sqlite with borland c builder

2004-04-01 Thread Roy Black
Hello, I would like to develop some applications with sqlite. I am using Borland C builder 6 for these purposes. I was trying to compile/install sqlite for Borland C builder 6 (Windows) without success. I followed the instructions at http://www.sqlite.org/cvstrac/wiki?p=HowToCompile but got the

Re: [sqlite] Concurrency Proposal

2004-04-01 Thread ben . carlyle
G'day, "D. Richard Hipp" <[EMAIL PROTECTED]> 31/03/2004 01:21 PM To: [EMAIL PROTECTED] cc: Subject:Re: [sqlite] Concurrency Proposal > I think the gist of Ben's proposal is as follows > (please correct me if I am wrong): > Writes do not modify the

Re: [sqlite] Group by only returning one row when source table is sub-query or view

2004-04-01 Thread Greg Obleshchuk
Hi Richard, It is a bit more than that for me anyway. I have several complex views which are using grouping within the view themselves. At the moment I have no other way of summarising the results of these views apart from inserting the results into a temp table and then processing the temp

Re: [sqlite] Group by only returning one row when source table is sub-query or view

2004-04-01 Thread D. Richard Hipp
Greg Obleshchuk wrote: > > I posted a bug ticket a few days ago (ticket 678) regarding group by only > returning one row if the source was a subquery or view. I was wonder if > anyone could confirm the bug and how long would a fix take? (I'm not in a > position to create a fix) > >

[sqlite] Sorry for the repeated reply

2004-04-01 Thread aducom
Something terrible went wrong here. Again sorry. Albert - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]

RE: [sqlite] Using sqlite with C++Builder6

2004-04-01 Thread aducom
If you know how to apply Delphi components into C++Builder then you might give the components of sqlite.aducom.com a try. Albert > I have it working under Windows 2000 using BCB 6. > > -Original Message- > From: Eli Wheaton [mailto:[EMAIL PROTECTED] > Sent: Thursday, April 01, 2004 4:47

RE: [sqlite] Using sqlite with C++Builder6

2004-04-01 Thread aducom
If you know how to apply Delphi components into C++Builder then you might give the components of sqlite.aducom.com a try. Albert > I have it working under Windows 2000 using BCB 6. > > -Original Message- > From: Eli Wheaton [mailto:[EMAIL PROTECTED] > Sent: Thursday, April 01, 2004 4:47

Re: [sqlite] Solicitation for linking table design suggestions

2004-04-01 Thread D. Richard Hipp
Stephen Blake wrote: This is fine, but I'd like to use something smaller, i.e. the rowid. I understand that if I .dump the tables, the rowid's will change. Is it possible to force them to be the same, for example, by doing something like this (forgive errors, I hope you get the idea): SELECT

[sqlite] Solicitation for linking table design suggestions

2004-04-01 Thread Stephen Blake
Hi all, I'm fairly new to SQLite and loving it, thanks to Mr. Hipp and everyone else who makes it happen. My previous database experience is all in Oracle, but I hope you won't hold that against me. ;-) I need to create a table to link two tables that look somewhat like this: CREATE TABLE t1 (

Re: [sqlite] erroneous assert or bug

2004-04-01 Thread D. Richard Hipp
Michael Hunley wrote: I am getting an assertion in the following code because pTos->flags is set to 0x26, which translates into MEM_Static | MEM_Str | MEM_Int. The value on the top of the stack is 1024. pTos->i is correctly 1024. It is being used in an expression "UPDATE DBPrefs set

[sqlite] Using sqlite with C++Builder6

2004-04-01 Thread Eli Wheaton
Hi All, I'm having a problem trying to get SQLite to work with a C++Builder6 project. Does anyone have any advice on how to do this? OS: Windows XP - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail:

Re: [sqlite] va_list

2004-04-01 Thread eno
right after hitting send I found a line missing and some typo. // // The stack, as we are used to it, grows downwards. // If it wouldn't we had to use begin()/end() here. Values::const_reverse_iterator it = v.rbegin(); Values::const_reverse_iterator end = v.rend(); while(it

Re: [sqlite] va_list

2004-04-01 Thread eno
Greg Obleshchuk wrote: Hi Chris, Thanks for your reply. I do have a different way of handling it in C# but I am passing the call on to the sqlite_vmprintf function (in printf.c and that accepts a va_list) The way around it that I use is having a switch statement and if the use passes one

[sqlite] Réf. : Re: [sqlite] single quote protection

2004-04-01 Thread Gregory Letellier
 thx for your help     ---Message original---   De : Tito Ciuro Date : 04/01/04 14:24:31 A : Gregory Letellier Cc : [EMAIL PROTECTED] Sujet : Re: [sqlite] single quote protection   Hello Gregory,   http://www.mail-archive.com/[EMAIL PROTECTED]/msg01031.html   Advice: use the

[sqlite] single quote protection

2004-04-01 Thread Gregory Letellier
hello,   i've many strings value to insert in a varchar column, but this strings contains character : '   how to protect it ?   thx for your help !       IncrediMail - La messagerie électronique a enfin évolué - Cliquer

Re: [sqlite] va_list

2004-04-01 Thread Christian Smith
On Thu, 1 Apr 2004, Greg Obleshchuk wrote: >Hi , Can anyone tell me if you can manually create a va_list object. I >have in my wrapper now the sqlite_vmprintf function but as .NET doesn't >support the ... as a parameter I had to use a [ParamArray] . Currently I >am testing the number of

[sqlite] va_list

2004-04-01 Thread Greg Obleshchuk
Hi , Can anyone tell me if you can manually create a va_list object. I have in my wrapper now the sqlite_vmprintf function but as .NET doesn't support the ... as a parameter I had to use a [ParamArray] . Currently I am testing the number of parameters passed and calling sqlite_vmprintf