Which one is considered as better prog?

[Xenocide]

Hi

it's not really a technical question.

Between doing query on the fly directly in the VB code or doing them normally and linking them to form on control after, which one is the best?

Btw I'm talking 'bout query that would be used only in 1 form and not query that will be use on almost every form of a project

 

[PHV]

A saved query is 'compiled' on its first execution and the execution plan is saved.
So, in theory, a saved query should be faster than one build on the fly.

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ222-2244

 

[Xenocide]

ok thanks PHV =^_^+