Yes sure Joe, I just needed some more time.
Here it is the output of explain SELECT a FROM One WHERE b1 = 99 AND
b2 = 100 and b3 = 101;
0|Goto|0|20||1|
Integer|0|0||2|
OpenRead|1|4|keyinfo(3,BINARY,BINARY)|3|
SetNumColumns|1|4||4|
Integer|99|0||5|
IsNull|-1|18||6|
Integer|100|0||7|
IsNull|-2|18||8|
Integer|101|0||9|
IsNull|-3|18||10|
MakeRecord|3|0|ddd|11|
MemStore|0|0||12|
MoveGe|1|18||13|
MemLoad|0|0||14|
IdxGE|1|18|+|15|
Column|1|0||16|
Callback|1|0||17|
Next|1|13||18|
Close|1|0||19|
Halt|0|0||20|
Transaction|0|0||21|
VerifyCookie|0|2||22|
Goto|0|1||23|
Noop|0|0||
result for CW is still 99...
---
Marco Bambini
http://www.sqlabs.net
http://www.sqlabs.net/blog/
http://www.sqlabs.net/realsqlserver/
On Oct 31, 2007, at 10:38 PM, Joe Wilson wrote:
You're not the least bit interested in finding out what the issue
in CodeWarrior was? It might be a symptom of another problem.
--- Marco Bambini <[EMAIL PROTECTED]> wrote:
The problem was somewhere inside CodeWarrior because the same exact
code worked fine with Visual C.
I used CodeWarrior for Win for all my win32 sqlite compilation but it
seems time to update my Win Dev environment...
__________________________________________________
Do You Yahoo!?
Tired of spam? Yahoo! Mail has the best spam protection around
http://mail.yahoo.com
----------------------------------------------------------------------
-------
To unsubscribe, send email to [EMAIL PROTECTED]
----------------------------------------------------------------------
-------
-----------------------------------------------------------------------------
To unsubscribe, send email to [EMAIL PROTECTED]
-----------------------------------------------------------------------------