Convert Sql Handle To Number

[Sunil]

Hi All,

I am trying to use dynalibs and generated the following apt,apl.

test1.apt - main file include test3.apl , include dynalibs test3.apd
test2.apt - include test3.apl , dlg1 dialog (Marked as __Exported ) , generated test2.apd
test3.apl - one class clsComboBox1 , Sql Handle : hSql

when run test1.apt and click on pb1 which is calling dlg1 to open.

here is Error , SQL Error.

How to use SQL handles in Dynalibs.

why this error is comming, any clue.

Regards.
Sunil

[lairton]

Hello Sunil,

Can you save test3.apl as Text, please.
Because I do not have TD6.2 here in this pc, so I'll try to help you using TD5.2.


Lairton.

[Sunil]

Hi lairton,
find enclosed test3.apl save as txt.

Regards.
Sunil

[lairton]

Hi Sunil, thanks for the file in text format.

here is the sample.
I'm sure the forum folks can show others solutions as suggestions.
here is my little contribution. maybe if I have a little more time I can create a better solution.

come on talk about it

note: I changed the database settings because I have only oracle database available in my pc.

[Sunil]

Hi lairton,

Thanks for suggestion, that works for me, but i have to do lot of changes in application.

I would like to find more on this, why Sql Handles connected in main application , has to be reconnected again in all modules called from apd,
that means apd when load on demand create own sessions.

any comments,,,

Regards.
Sunil

[lairton]

Sunil,

Please see attached sample.
In this sample the Sql Handle is connected in main app and the connection is passed by APDs and used to populate the combo.

however, in my opinion its more efficient use as my previous sample.

[Sunil]

Hi lairton,
Yes, i have gone through samples. In my case , my application is very large if use apd then I have to change in overall applications consists of 203 modules.

Please suggest if i can use the same handle used in Main App, eg. hSql,hSql1,hSql2....

Regards.
Sunil