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.
@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 method you're
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 should
I can see now that doing
SELECT
name
FROM SQLITE_MASTER
WHERE TYPE = 'table'
ORDER BY 1 ASC
limit -1
offset 2
works, but it doesn't do what I was trying and that is to keep
the field name out.
RBS
-Original Message-
From: RB Smissaert [mailto:[EMAIL PROTECTED]
Sent: 06 March 2007
- 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
FROM SQLITE_MASTER
WHERE TYPE
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 be a
: [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
that. Is there a pragma
to figure out how to re-code this.
RBS
-Original Message-
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
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
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
should learn C first.
RBS
-Original Message-
From: RB Smissaert [mailto:[EMAIL 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
11 matches
Mail list logo
