Hi Erel
I have received a lot of information and are a little confused.
My application is NON UI.
What should I use the sql.InitializeAsync or ConnectionPool ?
If I have to use the connectionpool when I have to initialize the connection?
I have seen examples that I've reported.
Sub LoadProject
...
Dim sq As SQL = Main.Pool.GetConnecton
'execute async query
sq.ExecQueryAsync("LoadProject", s, Null)
End Sub
Sub LoadProject_QueryComplete (Success As Boolean, Crsr As ResultSet)
Dim sq As SQL = Sender
if success then
do while crsr.nextrow
'loop through the results
loop
crsr.close
end if
sq.Close 'return the connection to the pool
End Sub
You need to initialize the ConnectionPool object and then get a SQL object with ConnectionPool.GetConnection. Make sure to always "close" the sql object. This will return it to the pool.