Convert Sql Handle To Number

Discussion forum about all things Gupta, OpenText and the community.
Sunil

Re: Convert Sql Handle To Number

Post by Sunil » 15 Feb 2014, 21:55

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
You do not have the required permissions to view the files attached to this post.

lairton
Brazil
Posts: 170
Joined: 15 Mar 2017, 19:32
Location: Brazil

Re: Convert Sql Handle To Number

Post by lairton » 17 Feb 2014, 13:37

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

Re: Convert Sql Handle To Number

Post by Sunil » 17 Feb 2014, 18:56

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

Regards.
Sunil
You do not have the required permissions to view the files attached to this post.

lairton
Brazil
Posts: 170
Joined: 15 Mar 2017, 19:32
Location: Brazil

Re: Convert Sql Handle To Number

Post by lairton » 17 Feb 2014, 21:19

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.
You do not have the required permissions to view the files attached to this post.

Sunil

Re: Convert Sql Handle To Number

Post by Sunil » 20 Feb 2014, 04:30

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
Brazil
Posts: 170
Joined: 15 Mar 2017, 19:32
Location: Brazil

Re: Convert Sql Handle To Number

Post by lairton » 20 Feb 2014, 15:50

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.
You do not have the required permissions to view the files attached to this post.

Sunil

Re: Convert Sql Handle To Number

Post by Sunil » 20 Feb 2014, 19:42

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

Return to “General Discussion”

Who is online

Users browsing this forum: [Ccbot] and 1 guest