<html>
<head>
<meta http-equiv="content-type" content="text/html; charset=ISO-8859-1">
</head>
<body bgcolor="#FFFFFF" text="#000000">
Hello,<br>
<br>
I have Day or two old SVN (Trunk) Lazarus with FPC 2.4.4<br>
<br>
I have simple select with simple where clause. Nothing fancy.<br>
<br>
If I run exact same SQL with SQLite Expert Personal I get the rows
as expected.<br>
<br>
I looked my code, and did some debugging into the SQLite code, and
this happened.<br>
<br>
1. I call the .RefetchData;<br>
<br>
Then I Step into the Sqlite3DS unit TSqlite3Dataset.BuildLinkedList
method.<br>
<br>
It successfully calls the sqlite3_prepare() etc...<br>
This code seems odd to me, but some parts of my App works perfectly
so maybe this is just something that it does not seem to be :<br>
<br>
...<br>
FRecordCount := 0;<br>
ColumnCount := sqlite3_column_count(vm);<br>
FRowCount := ColumnCount;<br>
...<br>
<br>
Then comes the :<br>
FReturnCode := sqlite3_step(vm);<br>
while FReturnCode = SQLITE_ROW do<br>
begin<br>
<br>
loop, Which I think would fetch the Actual data.<br>
<br>
And first call (Outside the Loop returns ReturnCode 101 (SQLITE_DONE<span
class="Apple-style-span" style="color: rgb(0, 0, 0); font-family:
Verdana, sans-serif; font-style: normal; font-variant: normal;
font-weight: normal; letter-spacing: normal; line-height: normal;
orphans: 2; text-align: -webkit-auto; text-indent: 0px;
text-transform: none; white-space: normal; widows: 2;
word-spacing: 0px; -webkit-text-decorations-in-effect: none;
-webkit-text-size-adjust: auto; -webkit-text-stroke-width: 0px;
font-size: medium; "></span> <a
href="http://www.sqlite.org/c3ref/c_abort.html">http://www.sqlite.org/c3ref/c_abort.html</a>
)...<br>
<br>
What in earth is going on... Any ideas What might be wrong in here?
In mY Code or the SqLite Code. <br>
<br>
I have similar selects in other parts of the Code and even in same
File and Same Table and they seem to work... Is there anything I
should try??? Any ideas are welcome... <br>
<br>
-TP-<br>
<br>
<br>
<br>
<br>
<br>
<br>
</body>
</html>