Support for PostgreSQL?

Hey,

Right now the Run BASIC v2.0 code supports SQLite 3, SQL Server and MySQL. Just wondering how important PostgreSQL is?

Thoughts?

-Carl

Happens to be one of my favoriate. I love their triggers.
But I can live without it. Not a big deal.

Rather see time on memory leaks, and stuff like lof() fail on large files etc..
Just my personal pref. I'll be happy with anything...

The memory leaks are related to using the RUN statement?

Do you have a simple example of LOF() not working properly? I did a quick search here and didn't see a previous mention.

Here is a section of a program with some debug.
print "265---";DB$
open DB$ for input as #a ' see if the file is sqlite format
print "267 DB:";DB$
print "--------";lof(#a)
a$ = "x"
if lof(#a) > 12 then
a$ = input$(#a,13)
a$ = lower$(a$)
end if
close #a

Debug results..

265---c:\rbp101\projects\ancestry_project\data\ancestry.db
267 DB:c:\rbp101\projects\ancestry_project\data\ancestry.db

Runtime Error in program 'ionSql': print "--------";lof(#a)
AllocationFailure

It fails with an allocation error. It does this for all files?

No.. Here is the debug output of another file that is ok.

265---c:\rbp101\projects\foodbank_project\data\foodBank.db
267 DB:c:\rbp101\projects\foodbank_project\data\foodBank.db
--------3473297

Directory shows:
ancestry.db size = 172,789 KB
fooBank.db size = 3,392 KB

Would it be okay if you could email me one of the files that doesn't work?

It's on it's way..

Great. How did you send it? I've been looking for something from you. :)

May be start with what is supported now and add other databases as time permits.