Problem max querys in Sybase

[Ricardo Alfredo]

My problem is the following one.
It happens that I have a screen of the high complexity, where I have many
querys that is more than 20 than they are used in combobox., table and listbox
When treatment to open querys number 21 - 22 an error isexecuted.
Reviewing in SYBASE I am with
many connections one by each query that I execute myself, it even shows querys that I open to me,
process and later I close them because I do not use them.
As I can avoid this problem since before it used BDE and did not happen

[Mat000]

Hi there,

try to link all ClientDataSets to the separate SQLConnection. Set its AutoClone property to False.

Beware of using SQLConnection with AutoClone set to False with the components that leave the command active.
You'll receive an exception similar to "This routine cannot be called because another command structure has results pending".


I hope this will be helpful.