umm any idea : how can i know if using odbc a DDL like CREATE or DROP TABLE
was executed correctly without error , BUT using the result object and not
a try/catch block!

Lenz McKAY Gerardo (PICCORO)
http://qgqlochekone.blogspot.com

2017-05-24 10:07 GMT-04:00 PICCORO McKAY Lenz <mckaygerh...@gmail.com>:

> please pardom me, i explain me better:
>
> i mean: how can i know if a DDL like CREATE or DROP TABLE was executed
> correctly without error , using the result object and not a try/catch block!
>
> Lenz McKAY Gerardo (PICCORO)
> http://qgqlochekone.blogspot.com
>
> 2017-05-24 9:58 GMT-04:00 Benoît Minisini <gam...@users.sourceforge.net>:
>
>> Le 24/05/2017 à 15:47, PICCORO McKAY Lenz a écrit :
>>
>>> due the odbc does not provide a record count like mysql does (cos
>>> provider
>>> may o nor offer) on every sql query..
>>>
>>> how we can know if a DDL sql (i mean a select, a dropt table, or a create
>>> table) was excecuted using the result object and without a try catch
>>> method?
>>>
>>>
>>> Lenz McKAY Gerardo (PICCORO)
>>> http://qgqlochekone.blogspot.com
>>>
>>
>> The record count is only for Result objects. So you should not get it for
>> a CREATE or a DROP TABLE statement.
>>
>> A record count of -1 means that you have to use the MoveNext() method
>> until the Available property is False to get each record. Once done, then
>> you know how many records you get.
>>
>> I think the reason is that the underlying ODBC driver sends the result
>> line by line, whereas the others (MySQL, PostgreSQL and SQLite drivers)
>> send all the lines by default.
>>
>> Maybe the ODBC driver should store the entire query result in memory to
>> simulate a standard Result object when it is internally "move forward" only?
>>
>> --
>> Benoît Minisini
>>
>
>
------------------------------------------------------------------------------
Check out the vibrant tech community on one of the world's most
engaging tech sites, Slashdot.org! http://sdm.link/slashdot
_______________________________________________
Gambas-user mailing list
Gambas-user@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/gambas-user

Reply via email to