Overlapping calls to ODBC

Previous Topic Next Topic
 
classic Classic list List threaded Threaded
2 messages Options
Reply | Threaded
Open this post in threaded view
|

Overlapping calls to ODBC

Federico Balaguer-2
Hello,

I am trying to use overlapping calls while querying or updating a
database. I found postings saying that is possible but I don't know how
to do it.

Thanks!

Federico


Reply | Threaded
Open this post in threaded view
|

Re: Overlapping calls to ODBC

David Gorisek-5
fb wrote:

> Hello,
>
> I am trying to use overlapping calls while querying or updating a
> database. I found postings saying that is possible but I don't know how
> to do it.
>
> Thanks!
>
> Federico
>


You have to change all methods in the class ODBCLibrary by inserting
"overlap" in the primitive call. Example:

BEFORE:
---
ODBCLibrary>>sqlExecute: anExternalHandle
        "Execute a preprepared SQL statement on the specified handle
       
                SQLRETURN SQLExecute(HSTMT hstmt);"

        <stdcall: sword SQLExecute handle>
        ^self invalidCall


AFTER:
---
ODBCLibrary>>sqlExecute: anExternalHandle
        "Execute a preprepared SQL statement on the specified handle
       
                SQLRETURN SQLExecute(HSTMT hstmt);"

        <overlap stdcall: sword SQLExecute handle>
        ^self invalidCall

----

Do this with the following methods:

sqlEndTran: anExternalHandleEnv handle: anExternalHandleDBC
completionType: anInteger

sqlExecDirect: anExternalHandle statementText: aString textLength:
anInteger

sqlExecute: anExternalHandle

sqlFetchScroll: anExternalHandle fetchOrientation: orientationInteger
fetchOffset: offsetInteger

sqlPrepare: anExternalHandle statementText: aString textLength: anInteger


Best regards,

David Gorisek
http://wiki.gorisek.com