posted November 11, 2005 03:08 PM            

Bail:
sqlite_free_table lpTable

if you quote this out,
'FOR i = 0 TO iFields
' zField = @lpTable[i]
' arrResults(iRow, iCol) = @zField
' INCR iCol : IF iCol = nColumns THEN iCol = 0
' IF (i+1) MOD nColumns = 0 THEN INCR iRow
'NEXT I

run the query over and over on a large table, the memory use keeps going up
doesn’t get freed until the database is closed

posted November 14, 2005 08:55 PM            

quote:

---

Originally posted by Stan Durham:
It doesn’t appear that the memory is being freed.
[/B]

---

Hey Stan;

I'll try to take a look at this next weekend.

My week is shot already fixing problems that are
happening with database running on several huge servers...

look forward to troubleshooting one that can run on a floppy...

seeya - Terence.

posted November 22, 2005 10:31 PM            

There was a problem behind my monitor.

There is nothing wrong with lpTable.

posted November 25, 2005 05:13 PM            

quote:

---

Originally posted by Stan Durham:
I found out what was wrong with the code.

There was a problem behind my monitor.

There is nothing wrong with lpTable.

---

Hey Stan;

Glad you seem to have gotten this resolved; when you say you
figured out what was wrong with the code - is there something
in the original example that I posted that needs to be updated?

Also - in your experience, have you been able to get the "callback"
method of function call to work?

Thanks! - Terence.

posted November 25, 2005 05:50 PM            

There was something wrong with my test program.

The beauty of your code is, the table gets released.

I’m afraid to invest the time to try and get the callback working, and then run into table locking problems.
It can be done, I have a driver for another language that does it.
Other drivers leave the table locked.

I might give it a go later on.