RE: [sqlite] What is wrong with this simple query (offset)?

2007-03-07 Thread RB Smissaert
You were absolutely right, I didn't call the new dll. All solved now. RBS -Original Message- From: Trey Mack [mailto:[EMAIL PROTECTED] Sent: 07 March 2007 13:12 To: sqlite-users@sqlite.org Subject: Re: [sqlite] What is wrong with this simple query (offset)? > It looks all as it sho

RE: [sqlite] What is wrong with this simple query (offset)?

2007-03-07 Thread RB Smissaert
@sqlite.org Subject: Re: [sqlite] What is wrong with this simple query (offset)? > It looks all as it should work and it compiles with the same number of > warnings, but I get a bad dll calling convention in VB with the extra > integer argument iFields. You've changed the signature of the meth

Re: [sqlite] What is wrong with this simple query (offset)?

2007-03-07 Thread Trey Mack
It looks all as it should work and it compiles with the same number of warnings, but I get a bad dll calling convention in VB with the extra integer argument iFields. You've changed the signature of the method you're calling, and it looks like you changed it correctly in the VB declaration.

RE: [sqlite] What is wrong with this simple query (offset)?

2007-03-06 Thread RB Smissaert
AIL PROTECTED] Sent: 06 March 2007 23:14 To: sqlite-users@sqlite.org Subject: RE: [sqlite] What is wrong with this simple query (offset)? OK, forget about this, I think I am nearly there. RBS -Original Message- From: RB Smissaert [mailto:[EMAIL PROTECTED] Sent: 06 March 2007 22:42 To

RE: [sqlite] What is wrong with this simple query (offset)?

2007-03-06 Thread RB Smissaert
OK, forget about this, I think I am nearly there. RBS -Original Message- From: RB Smissaert [mailto:[EMAIL PROTECTED] Sent: 06 March 2007 22:42 To: sqlite-users@sqlite.org Subject: RE: [sqlite] What is wrong with this simple query (offset)? Could I ask if somebody could tell me how I

RE: [sqlite] What is wrong with this simple query (offset)?

2007-03-06 Thread RB Smissaert
Smissaert [mailto:[EMAIL PROTECTED] Sent: 06 March 2007 21:45 To: sqlite-users@sqlite.org Subject: RE: [sqlite] What is wrong with this simple query (offset)? Yes, I can see now where this happens: TempWideDataHolder = CoTaskMemAlloc(1); // Set up array bounds SA_Bounds[0

RE: [sqlite] What is wrong with this simple query (offset)?

2007-03-06 Thread RB Smissaert
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Sent: 06 March 2007 21:22 To: sqlite-users@sqlite.org Subject: Re: [sqlite] What is wrong with this simple query (offset)? "RB Smissaert" <[EMAIL PROTECTED]> wrote: > Ah, thanks. > I am not using the sqlite3 command line ut

RE: [sqlite] What is wrong with this simple query (offset)?

2007-03-06 Thread RB Smissaert
: [sqlite] What is wrong with this simple query (offset)? "RB Smissaert" <[EMAIL PROTECTED]> wrote: > Ah, thanks. > I am not using the sqlite3 command line utility, but a VB adapted version of > the regular sqlite3.dll. I take it should be no problem to do the same with

Re: [sqlite] What is wrong with this simple query (offset)?

2007-03-06 Thread drh
"RB Smissaert" <[EMAIL PROTECTED]> wrote: > Ah, thanks. > I am not using the sqlite3 command line utility, but a VB adapted version of > the regular sqlite3.dll. I take it should be no problem to do the same with > that. Is there a pragma for this? > No. The returning of field names is going to

Re: [sqlite] What is wrong with this simple query (offset)?

2007-03-06 Thread Jeff Godfrey
- Original Message - From: "RB Smissaert" <[EMAIL PROTECTED]> To: <sqlite-users@sqlite.org> Sent: Tuesday, March 06, 2007 1:39 PM Subject: [sqlite] What is wrong with this simple query (offset)? Why does this query give a syntax error near offset? SELECT Name FR

RE: [sqlite] What is wrong with this simple query (offset)?

2007-03-06 Thread RB Smissaert
:40 To: sqlite-users@sqlite.org Subject: [sqlite] What is wrong with this simple query (offset)? Why does this query give a syntax error near offset? SELECT Name FROM SQLITE_MASTER WHERE TYPE = 'table' ORDER BY 1 ASC offset 2 limit works fine. RBS

[sqlite] What is wrong with this simple query (offset)?

2007-03-06 Thread RB Smissaert
Why does this query give a syntax error near offset? SELECT Name FROM SQLITE_MASTER WHERE TYPE = 'table' ORDER BY 1 ASC offset 2 limit works fine. RBS - To unsubscribe, send email to [EMAIL PROTECTED]