SmartOpen

[zippo]

What is the mean of the doSmartOpen option in the TZQuery component? I played a little, but see no difference in the behaviour of the application.

Is there any mini FAQ for Zeos?

[btrewern]

Don't see the option! What version of Zeos are you using?

Ben

[gto]

Don't see the option! What version of Zeos are you using?

Ben

CVS 13/10 have that option
anyway, I don't know what it does too

if the mod's can play with a mini-faq, I wish to know what ZSequence does!

[zippo]

True, the CVS from 13/10. Zeos team, help!

[gto]

Hey zippo, I've been looking the sources for that option..

The main diference between SmartOpen and not SmartOpen is the procedure used to fetch the data on the background.

The code actually is in ZDbcInterbase6Statement.pas

Using SmartOpen will fire the ExecutePrepared function.. otherwise, the ExecuteQueryPrepared is used...

I cannot figure out the main difference through the functions, but, for me, SmartOpen enabled is slightly faster.. maybe SmartOpen is some kind of andvanced FetchOnDemand option.

Well, technical comments would be great
[]'s

Update!!

Googling out and I find that:

Added doSmartOpen option to Dataset to allow executing DML statements by Open without throwing exception.

link to google cache

[zippo]

ahaaaa...

Thank you! I'll play a little to see what's the speed difference.