Sybase NNTP forums - End Of Life (EOL)

The NNTP forums from Sybase - forums.sybase.com - are now closed.

All new questions should be directed to the appropriate forum at the SAP Community Network (SCN).

Individual products have links to the respective forums on SCN, or you can go to SCN and search for your product in the search box (upper right corner) to find your specific developer center.

SQLCA - user defined transaction object

9 posts in Appeon (partner product) Last posting was on 2011-11-01 11:32:32.0Z
Mike S Posted on 2011-10-27 15:19:22.0Z
From: "Mike S" <M@M.com>
Subject: SQLCA - user defined transaction object
Newsgroups: sybase.public.appeon
User-Agent: XanaNews/1.18.1.6
MIME-Version: 1.0
Content-Type: text/plain; charset=iso-8859-1
NNTP-Posting-Host: vip152.sybase.com
X-Original-NNTP-Posting-Host: vip152.sybase.com
Message-ID: <4ea9767a$1@forums-1-dub>
Date: 27 Oct 2011 08:19:22 -0700
X-Trace: forums-1-dub 1319728762 10.22.241.152 (27 Oct 2011 08:19:22 -0700)
X-Original-Trace: 27 Oct 2011 08:19:22 -0700, vip152.sybase.com
Lines: 18
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub sybase.public.appeon:2811
Article PK: 21888

In PB you can use a user defined transaction object for SQLCA by
setting the variable type of SQLCA to your transaction object in the
additional properties in the application object.

I need to do the same in appeon.


I see that you can define a transaction object other than sqlca in
appeon's config. I assume that if i use this, then i can not reference
SQLCA in my application, but i have to replace all usage sqlca to this?

Is there any way to get sqlca in appeon to be my userdefined
transaction object?



--


Chris Pollach Posted on 2011-10-27 16:04:54.0Z
From: "Chris Pollach" <cpollach@travel-net.com>
Newsgroups: sybase.public.appeon
References: <4ea9767a$1@forums-1-dub>
Subject: Re: SQLCA - user defined transaction object
Lines: 1169
X-Priority: 3
X-MSMail-Priority: Normal
X-Newsreader: Microsoft Outlook Express 6.00.2900.5931
X-RFC2646: Format=Flowed; Original
X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2900.6109
NNTP-Posting-Host: vip152.sybase.com
X-Original-NNTP-Posting-Host: vip152.sybase.com
Message-ID: <4ea98126@forums-1-dub>
Date: 27 Oct 2011 09:04:54 -0700
X-Trace: forums-1-dub 1319731494 10.22.241.152 (27 Oct 2011 09:04:54 -0700)
X-Original-Trace: 27 Oct 2011 09:04:54 -0700, vip152.sybase.com
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub sybase.public.appeon:2812
Article PK: 21890

Hi Mike;

SQLCA is actually a "pointer" to the default global based Transaction
object. You can substitute your NVUO based TO for the default by remapping
SQLCA to say for example "ns_mike_trans" in your Application Object's
"Additional Properties" dialog (accessible from the Application Painter).
Have a look at the screen capture attached. So in this example, both your PB
application and Appeon just need to know about the global variable SQLCA.
What actual object it is using at run time is dynamically resolved. :-)

Now, where your application has multiple simultaneous connections to the
same DBMS instance or varied DBMS instances (you can have to 255 of these in
any PB application BTW) - then, you need to tell Appeon about each
transaction Object "Pointer". So ... say that you use SQLCA to point to a
DEMO database. Then, you have a User Object TO (ns_mike_trans) that you
"point" to using an Instance variable "io_mike". Then, you need to tell
Appeon about IO_MIKE. It makes no difference if your CREATE statement for
"io_mike" uses Transaction or "ns_mike_trans". You just need to inform
Appeon that a new TO pointer is "in play" (io_mike) and what data cache
Appeon should use for it. (see my 2nd example attached for an application we
have that uses more that one TO).

HTH

--
Regards ... Chris
Blog: http://chrispollach.blogspot.com
PBDJ: http://chrispollach.sys-con.com
SourceForge: http://sourceforge.net/projects/stdfndclass

"Mike S" <M@M.com> wrote in message news:4ea9767a$1@forums-1-dub...
> In PB you can use a user defined transaction object for SQLCA by
> setting the variable type of SQLCA to your transaction object in the
> additional properties in the application object.
>
> I need to do the same in appeon.
>
>
> I see that you can define a transaction object other than sqlca in
> appeon's config. I assume that if i use this, then i can not reference
> SQLCA in my application, but i have to replace all usage sqlca to this?
>
> Is there any way to get sqlca in appeon to be my userdefined
> transaction object?
>
>
>
> --
>

PB_TO_Mapping.PNG
Appeon_TO_Mapping.PNG

Mike S Posted on 2011-10-27 17:19:49.0Z
From: "Mike S" <M@M.com>
Subject: Re: SQLCA - user defined transaction object
Newsgroups: sybase.public.appeon
References: <4ea9767a$1@forums-1-dub> <4ea98126@forums-1-dub>
User-Agent: XanaNews/1.18.1.6
NNTP-Posting-Host: vip152.sybase.com
X-Original-NNTP-Posting-Host: vip152.sybase.com
Message-ID: <4ea992b5$1@forums-1-dub>
Date: 27 Oct 2011 10:19:49 -0700
X-Trace: forums-1-dub 1319735989 10.22.241.152 (27 Oct 2011 10:19:49 -0700)
X-Original-Trace: 27 Oct 2011 10:19:49 -0700, vip152.sybase.com
Lines: 44
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub sybase.public.appeon:2813
Article PK: 13608

appeon does not use the transaction object defined in the Additional
Properties for sqlca.

I have my NVUO transaction object (in which i have a new function
defined) in there for sqlca, and it works fine in PB, but appeon lists
my function call on sqlca as an error.

Chris Pollach wrote:

> Hi Mike;
>
> SQLCA is actually a "pointer" to the default global based Transaction
> object. You can substitute your NVUO based TO for the default by
> remapping SQLCA to say for example "ns_mike_trans" in your
> Application Object's "Additional Properties" dialog (accessible from
> the Application Painter). Have a look at the screen capture attached.
> So in this example, both your PB application and Appeon just need to
> know about the global variable SQLCA. What actual object it is using
> at run time is dynamically resolved. :-)
>
> Now, where your application has multiple simultaneous connections to
> the same DBMS instance or varied DBMS instances (you can have to 255
> of these in any PB application BTW) - then, you need to tell Appeon
> about each transaction Object "Pointer". So ... say that you use
> SQLCA to point to a DEMO database. Then, you have a User Object TO
> (ns_mike_trans) that you "point" to using an Instance variable
> "io_mike". Then, you need to tell Appeon about IO_MIKE. It makes no
> difference if your CREATE statement for "io_mike" uses Transaction or
> "ns_mike_trans". You just need to inform Appeon that a new TO pointer
> is "in play" (io_mike) and what data cache Appeon should use for it.
> (see my 2nd example attached for an application we have that uses
> more that one TO).
>
> HTH

--


Chris Pollach Posted on 2011-10-27 18:41:05.0Z
From: "Chris Pollach" <cpollach@travel-net.com>
Newsgroups: sybase.public.appeon
References: <4ea9767a$1@forums-1-dub> <4ea98126@forums-1-dub> <4ea992b5$1@forums-1-dub>
Subject: Re: SQLCA - user defined transaction object
Lines: 3141
X-Priority: 3
X-MSMail-Priority: Normal
X-Newsreader: Microsoft Outlook Express 6.00.2900.5931
X-RFC2646: Format=Flowed; Original
X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2900.6109
NNTP-Posting-Host: vip152.sybase.com
X-Original-NNTP-Posting-Host: vip152.sybase.com
Message-ID: <4ea9a5c1@forums-1-dub>
Date: 27 Oct 2011 11:41:05 -0700
X-Trace: forums-1-dub 1319740865 10.22.241.152 (27 Oct 2011 11:41:05 -0700)
X-Original-Trace: 27 Oct 2011 11:41:05 -0700, vip152.sybase.com
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub sybase.public.appeon:2815
Article PK: 13611

Hmmm ... what kind of error are you getting?

Also, did you ...

1) Select the "Connection Cache" in AEM and test to see if these are OK?
2) Launch AEM and see if the TO mappings are defined OK (see attached)?
- make sure to run the "TEST" on these too in AEM.

"Mike S" <M@M.com> wrote in message news:4ea992b5$1@forums-1-dub...
> appeon does not use the transaction object defined in the Additional
> Properties for sqlca.
>
> I have my NVUO transaction object (in which i have a new function
> defined) in there for sqlca, and it works fine in PB, but appeon lists
> my function call on sqlca as an error.
>
>
>
>
>
>
> Chris Pollach wrote:
>
>> Hi Mike;
>>
>> SQLCA is actually a "pointer" to the default global based Transaction
>> object. You can substitute your NVUO based TO for the default by
>> remapping SQLCA to say for example "ns_mike_trans" in your
>> Application Object's "Additional Properties" dialog (accessible from
>> the Application Painter). Have a look at the screen capture attached.
>> So in this example, both your PB application and Appeon just need to
>> know about the global variable SQLCA. What actual object it is using
>> at run time is dynamically resolved. :-)
>>
>> Now, where your application has multiple simultaneous connections to
>> the same DBMS instance or varied DBMS instances (you can have to 255
>> of these in any PB application BTW) - then, you need to tell Appeon
>> about each transaction Object "Pointer". So ... say that you use
>> SQLCA to point to a DEMO database. Then, you have a User Object TO
>> (ns_mike_trans) that you "point" to using an Instance variable
>> "io_mike". Then, you need to tell Appeon about IO_MIKE. It makes no
>> difference if your CREATE statement for "io_mike" uses Transaction or
>> "ns_mike_trans". You just need to inform Appeon that a new TO pointer
>> is "in play" (io_mike) and what data cache Appeon should use for it.
>> (see my 2nd example attached for an application we have that uses
>> more that one TO).
>>
>> HTH
>
>
>
> --
>

AEM_TO_Mappings.PNG

Mike S Posted on 2011-10-27 20:09:51.0Z
From: "Mike S" <M@M.com>
Subject: Re: SQLCA - user defined transaction object
Newsgroups: sybase.public.appeon
References: <4ea9767a$1@forums-1-dub> <4ea98126@forums-1-dub> <4ea992b5$1@forums-1-dub> <4ea9a5c1@forums-1-dub>
User-Agent: XanaNews/1.18.1.6
NNTP-Posting-Host: vip152.sybase.com
X-Original-NNTP-Posting-Host: vip152.sybase.com
Message-ID: <4ea9ba8f$1@forums-1-dub>
Date: 27 Oct 2011 13:09:51 -0700
X-Trace: forums-1-dub 1319746191 10.22.241.152 (27 Oct 2011 13:09:51 -0700)
X-Original-Trace: 27 Oct 2011 13:09:51 -0700, vip152.sybase.com
Lines: 97
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub sybase.public.appeon:2817
Article PK: 13610

the connection is fine - appeon lists my function as unsupported.


from the appeon report:

Code Diagnosis:
Unsupported Code:
Ls_err_msg = sqlca.uf_geterrortext()

Line Number:
27

Location:
Uf_linked_update() event/function of u_tab_folder in class.pbl


Unsupported Item:
Uf_geterrortext

Type:


Reason:
Can not found the function 'uf_geterrortext'

Priority:
Have to modify

Chris Pollach wrote:

>
> Hmmm ... what kind of error are you getting?
>
> Also, did you ...
>
> 1) Select the "Connection Cache" in AEM and test to see if these are
> OK? 2) Launch AEM and see if the TO mappings are defined OK (see
> attached)? - make sure to run the "TEST" on these too in AEM.
>
>
>
>
>
> "Mike S" <M@M.com> wrote in message news:4ea992b5$1@forums-1-dub...
> > appeon does not use the transaction object defined in the Additional
> > Properties for sqlca.
> >
> > I have my NVUO transaction object (in which i have a new function
> > defined) in there for sqlca, and it works fine in PB, but appeon
> > lists my function call on sqlca as an error.
> >
> >
> >
> >
> >
> >
> > Chris Pollach wrote:
> >
> > > Hi Mike;
> > >
> > > SQLCA is actually a "pointer" to the default global based
> > > Transaction object. You can substitute your NVUO based TO for the
> > > default by remapping SQLCA to say for example "ns_mike_trans" in
> > > your Application Object's "Additional Properties" dialog
> > > (accessible from the Application Painter). Have a look at the
> > > screen capture attached. So in this example, both your PB
> > > application and Appeon just need to know about the global
> > > variable SQLCA. What actual object it is using at run time is
> > > dynamically resolved. :-)
> > >
> > > Now, where your application has multiple simultaneous connections
> > > to the same DBMS instance or varied DBMS instances (you can have
> > > to 255 of these in any PB application BTW) - then, you need to
> > > tell Appeon about each transaction Object "Pointer". So ... say
> > > that you use SQLCA to point to a DEMO database. Then, you have a
> > > User Object TO (ns_mike_trans) that you "point" to using an
> > > Instance variable "io_mike". Then, you need to tell Appeon about
> > > IO_MIKE. It makes no difference if your CREATE statement for
> > > "io_mike" uses Transaction or "ns_mike_trans". You just need to
> > > inform Appeon that a new TO pointer is "in play" (io_mike) and
> > > what data cache Appeon should use for it. (see my 2nd example
> > > attached for an application we have that uses more that one TO).
> > >
> > > HTH
> >
> >
> >
> > --

--


Chris Pollach Posted on 2011-10-30 23:29:40.0Z
From: "Chris Pollach" <cpollach@travel-net.com>
Newsgroups: sybase.public.appeon
References: <4ea9767a$1@forums-1-dub> <4ea98126@forums-1-dub> <4ea992b5$1@forums-1-dub> <4ea9a5c1@forums-1-dub> <4ea9ba8f$1@forums-1-dub>
In-Reply-To: <4ea9ba8f$1@forums-1-dub>
Subject: Re: SQLCA - user defined transaction object
Lines: 8
MIME-Version: 1.0
Content-Type: text/plain; format=flowed; charset="Windows-1252"; reply-type=original
Content-Transfer-Encoding: 7bit
X-Priority: 3
X-MSMail-Priority: Normal
Importance: Normal
X-Newsreader: Microsoft Windows Live Mail 15.4.3538.513
X-MimeOLE: Produced By Microsoft MimeOLE V15.4.3538.513
NNTP-Posting-Host: vip152.sybase.com
X-Original-NNTP-Posting-Host: vip152.sybase.com
Message-ID: <4eadebf4$1@forums-1-dub>
Date: 30 Oct 2011 16:29:40 -0700
X-Trace: forums-1-dub 1320020980 10.22.241.152 (30 Oct 2011 16:29:40 -0700)
X-Original-Trace: 30 Oct 2011 16:29:40 -0700, vip152.sybase.com
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub sybase.public.appeon:2818
Article PK: 21893

Hi Mike;

This makes no sense at I have extended events and functions on my
Transaction Object descendants within my STD Foundation Classes. These
compile and run OK under Appeon. My guess is that that you have a basic
object declaration or improper pointer issue. My TO is actually
"ns_transaction_sa_master" and mapped to SQLCA at the Application Object
level. I reference my TO methods as follows ...

For example:
SQLCA.of_connect ( ) // Try 2 Connect!


Regards ... Chris
President: OSUG / STD Inc.
Blog: http://chrispollach.blogspot.com
PBDJ: http://chrispollach.sys-con.com
SourceForge: http://sourceforge.net/projects/stdfndclass

"Mike S" wrote in message news:4ea9ba8f$1@forums-1-dub...

the connection is fine - appeon lists my function as unsupported.


from the appeon report:

Code Diagnosis:
Unsupported Code:
Ls_err_msg = sqlca.uf_geterrortext()

Line Number:
27

Location:
Uf_linked_update() event/function of u_tab_folder in class.pbl


Unsupported Item:
Uf_geterrortext

Type:


Reason:
Can not found the function 'uf_geterrortext'

Priority:
Have to modify

Chris Pollach wrote:

>
> Hmmm ... what kind of error are you getting?
>
> Also, did you ...
>
> 1) Select the "Connection Cache" in AEM and test to see if these are
> OK? 2) Launch AEM and see if the TO mappings are defined OK (see
> attached)? - make sure to run the "TEST" on these too in AEM.
>
>
>
>
>
> "Mike S" <M@M.com> wrote in message news:4ea992b5$1@forums-1-dub...
> > appeon does not use the transaction object defined in the Additional
> > Properties for sqlca.
> >
> > I have my NVUO transaction object (in which i have a new function
> > defined) in there for sqlca, and it works fine in PB, but appeon
> > lists my function call on sqlca as an error.
> >
> >
> >
> >
> >
> >
> > Chris Pollach wrote:
> >
> > > Hi Mike;
> > >
> > > SQLCA is actually a "pointer" to the default global based
> > > Transaction object. You can substitute your NVUO based TO for the
> > > default by remapping SQLCA to say for example "ns_mike_trans" in
> > > your Application Object's "Additional Properties" dialog
> > > (accessible from the Application Painter). Have a look at the
> > > screen capture attached. So in this example, both your PB
> > > application and Appeon just need to know about the global
> > > variable SQLCA. What actual object it is using at run time is
> > > dynamically resolved. :-)
> > >
> > > Now, where your application has multiple simultaneous connections
> > > to the same DBMS instance or varied DBMS instances (you can have
> > > to 255 of these in any PB application BTW) - then, you need to
> > > tell Appeon about each transaction Object "Pointer". So ... say
> > > that you use SQLCA to point to a DEMO database. Then, you have a
> > > User Object TO (ns_mike_trans) that you "point" to using an
> > > Instance variable "io_mike". Then, you need to tell Appeon about
> > > IO_MIKE. It makes no difference if your CREATE statement for
> > > "io_mike" uses Transaction or "ns_mike_trans". You just need to
> > > inform Appeon that a new TO pointer is "in play" (io_mike) and
> > > what data cache Appeon should use for it. (see my 2nd example
> > > attached for an application we have that uses more that one TO).
> > >
> > > HTH
> >
> >
> >
> > --

--


Mike S Posted on 2011-10-31 20:40:06.0Z
From: "Mike S" <M@M.com>
Subject: Re: SQLCA - user defined transaction object
Newsgroups: sybase.public.appeon
References: <4ea9767a$1@forums-1-dub> <4ea98126@forums-1-dub> <4ea992b5$1@forums-1-dub> <4ea9a5c1@forums-1-dub> <4ea9ba8f$1@forums-1-dub> <4eadebf4$1@forums-1-dub>
User-Agent: XanaNews/1.18.1.6
MIME-Version: 1.0
Content-Type: text/plain; charset=iso-8859-1
NNTP-Posting-Host: vip152.sybase.com
X-Original-NNTP-Posting-Host: vip152.sybase.com
Message-ID: <4eaf07a6$1@forums-1-dub>
Date: 31 Oct 2011 12:40:06 -0800
X-Trace: forums-1-dub 1320093606 10.22.241.152 (31 Oct 2011 12:40:06 -0800)
X-Original-Trace: 31 Oct 2011 12:40:06 -0800, vip152.sybase.com
Lines: 128
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub sybase.public.appeon:2820
Article PK: 13612

ha - found my problem. I made an appeon specific version of my
transaction object, forgot about it, and thus didn't update that one
with a new function that i added to the main one. That's why appeon
kept saying that it didn't find the function in the trans object.

thanks for the help!

Chris Pollach wrote:

> Hi Mike;
>
> This makes no sense at I have extended events and functions on my
> Transaction Object descendants within my STD Foundation Classes.
> These compile and run OK under Appeon. My guess is that that you have
> a basic object declaration or improper pointer issue. My TO is
> actually "ns_transaction_sa_master" and mapped to SQLCA at the
> Application Object level. I reference my TO methods as follows ...
>
> For example:
> SQLCA.of_connect ( ) // Try 2 Connect!
>
>
> Regards ... Chris
> President: OSUG / STD Inc.
> Blog: http://chrispollach.blogspot.com
> PBDJ: http://chrispollach.sys-con.com
> SourceForge: http://sourceforge.net/projects/stdfndclass
>
> "Mike S" wrote in message news:4ea9ba8f$1@forums-1-dub...
>
> the connection is fine - appeon lists my function as unsupported.
>
>
> from the appeon report:
>
> Code Diagnosis:
> Unsupported Code:
> Ls_err_msg = sqlca.uf_geterrortext()
>
> Line Number:
> 27
>
> Location:
> Uf_linked_update() event/function of u_tab_folder in class.pbl
>
>
> Unsupported Item:
> Uf_geterrortext
>
> Type:
>
>
> Reason:
> Can not found the function 'uf_geterrortext'
>
> Priority:
> Have to modify
>
>
>
>
>
> Chris Pollach wrote:
>
> >
> > Hmmm ... what kind of error are you getting?
> >
> > Also, did you ...
> >
> > 1) Select the "Connection Cache" in AEM and test to see if these are
> > OK? 2) Launch AEM and see if the TO mappings are defined OK (see
> > attached)? - make sure to run the "TEST" on these too in AEM.
> >
> >
> >
> >
> >
> >"Mike S" <M@M.com> wrote in message news:4ea992b5$1@forums-1-dub...
> >> appeon does not use the transaction object defined in the
> Additional >> Properties for sqlca.
> > >
> >> I have my NVUO transaction object (in which i have a new function
> >> defined) in there for sqlca, and it works fine in PB, but appeon
> >> lists my function call on sqlca as an error.
> > >
> > >
> > >
> > >
> > >
> > >
> >> Chris Pollach wrote:
> > >
> >> > Hi Mike;
> >> >
> >> > SQLCA is actually a "pointer" to the default global based
> >> > Transaction object. You can substitute your NVUO based TO for the
> >> > default by remapping SQLCA to say for example "ns_mike_trans" in
> >> > your Application Object's "Additional Properties" dialog
> >> > (accessible from the Application Painter). Have a look at the
> >> > screen capture attached. So in this example, both your PB
> >> > application and Appeon just need to know about the global
> >> > variable SQLCA. What actual object it is using at run time is
> >> > dynamically resolved. :-)
> >> >
> >> > Now, where your application has multiple simultaneous connections
> >> > to the same DBMS instance or varied DBMS instances (you can have
> >> > to 255 of these in any PB application BTW) - then, you need to
> >> > tell Appeon about each transaction Object "Pointer". So ... say
> >> > that you use SQLCA to point to a DEMO database. Then, you have a
> >> > User Object TO (ns_mike_trans) that you "point" to using an
> >> > Instance variable "io_mike". Then, you need to tell Appeon about
> >> > IO_MIKE. It makes no difference if your CREATE statement for
> >> > "io_mike" uses Transaction or "ns_mike_trans". You just need to
> >> > inform Appeon that a new TO pointer is "in play" (io_mike) and
> >> > what data cache Appeon should use for it. (see my 2nd example
> >> > attached for an application we have that uses more that one TO).
> >> >
> >> > HTH
> > >
> > >
> > >
> >> --

--


Chris Pollach Posted on 2011-11-01 11:32:32.0Z
From: "Chris Pollach" <cpollach@travel-net.com>
Newsgroups: sybase.public.appeon
References: <4ea9767a$1@forums-1-dub> <4ea98126@forums-1-dub> <4ea992b5$1@forums-1-dub> <4ea9a5c1@forums-1-dub> <4ea9ba8f$1@forums-1-dub> <4eadebf4$1@forums-1-dub> <4eaf07a6$1@forums-1-dub>
Subject: Re: SQLCA - user defined transaction object
Lines: 135
X-Priority: 3
X-MSMail-Priority: Normal
X-Newsreader: Microsoft Outlook Express 6.00.2900.5931
X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2900.6109
X-RFC2646: Format=Flowed; Original
NNTP-Posting-Host: vip152.sybase.com
X-Original-NNTP-Posting-Host: vip152.sybase.com
Message-ID: <4eafd8d0@forums-1-dub>
Date: 1 Nov 2011 03:32:32 -0800
X-Trace: forums-1-dub 1320147152 10.22.241.152 (1 Nov 2011 03:32:32 -0800)
X-Original-Trace: 1 Nov 2011 03:32:32 -0800, vip152.sybase.com
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub sybase.public.appeon:2822
Article PK: 21896

Glad you found the problem! :-)

"Mike S" <M@M.com> wrote in message news:4eaf07a6$1@forums-1-dub...
> ha - found my problem. I made an appeon specific version of my
> transaction object, forgot about it, and thus didn't update that one
> with a new function that i added to the main one. That's why appeon
> kept saying that it didn't find the function in the trans object.
>
> thanks for the help!
>
>
> Chris Pollach wrote:
>
>> Hi Mike;
>>
>> This makes no sense at I have extended events and functions on my
>> Transaction Object descendants within my STD Foundation Classes.
>> These compile and run OK under Appeon. My guess is that that you have
>> a basic object declaration or improper pointer issue. My TO is
>> actually "ns_transaction_sa_master" and mapped to SQLCA at the
>> Application Object level. I reference my TO methods as follows ...
>>
>> For example:
>> SQLCA.of_connect ( ) // Try 2 Connect!
>>
>>
>> Regards ... Chris
>> President: OSUG / STD Inc.
>> Blog: http://chrispollach.blogspot.com
>> PBDJ: http://chrispollach.sys-con.com
>> SourceForge: http://sourceforge.net/projects/stdfndclass
>>
>> "Mike S" wrote in message news:4ea9ba8f$1@forums-1-dub...
>>
>> the connection is fine - appeon lists my function as unsupported.
>>
>>
>> from the appeon report:
>>
>> Code Diagnosis:
>> Unsupported Code:
>> Ls_err_msg = sqlca.uf_geterrortext()
>>
>> Line Number:
>> 27
>>
>> Location:
>> Uf_linked_update() event/function of u_tab_folder in class.pbl
>>
>>
>> Unsupported Item:
>> Uf_geterrortext
>>
>> Type:
>>
>>
>> Reason:
>> Can not found the function 'uf_geterrortext'
>>
>> Priority:
>> Have to modify
>>
>>
>>
>>
>>
>> Chris Pollach wrote:
>>
>> >
>> > Hmmm ... what kind of error are you getting?
>> >
>> > Also, did you ...
>> >
>> > 1) Select the "Connection Cache" in AEM and test to see if these are
>> > OK? 2) Launch AEM and see if the TO mappings are defined OK (see
>> > attached)? - make sure to run the "TEST" on these too in AEM.
>> >
>> >
>> >
>> >
>> >
>> >"Mike S" <M@M.com> wrote in message news:4ea992b5$1@forums-1-dub...
>> >> appeon does not use the transaction object defined in the
>> Additional >> Properties for sqlca.
>> > >
>> >> I have my NVUO transaction object (in which i have a new function
>> >> defined) in there for sqlca, and it works fine in PB, but appeon
>> >> lists my function call on sqlca as an error.
>> > >
>> > >
>> > >
>> > >
>> > >
>> > >
>> >> Chris Pollach wrote:
>> > >
>> >> > Hi Mike;
>> >> >
>> >> > SQLCA is actually a "pointer" to the default global based
>> >> > Transaction object. You can substitute your NVUO based TO for the
>> >> > default by remapping SQLCA to say for example "ns_mike_trans" in
>> >> > your Application Object's "Additional Properties" dialog
>> >> > (accessible from the Application Painter). Have a look at the
>> >> > screen capture attached. So in this example, both your PB
>> >> > application and Appeon just need to know about the global
>> >> > variable SQLCA. What actual object it is using at run time is
>> >> > dynamically resolved. :-)
>> >> >
>> >> > Now, where your application has multiple simultaneous connections
>> >> > to the same DBMS instance or varied DBMS instances (you can have
>> >> > to 255 of these in any PB application BTW) - then, you need to
>> >> > tell Appeon about each transaction Object "Pointer". So ... say
>> >> > that you use SQLCA to point to a DEMO database. Then, you have a
>> >> > User Object TO (ns_mike_trans) that you "point" to using an
>> >> > Instance variable "io_mike". Then, you need to tell Appeon about
>> >> > IO_MIKE. It makes no difference if your CREATE statement for
>> >> > "io_mike" uses Transaction or "ns_mike_trans". You just need to
>> >> > inform Appeon that a new TO pointer is "in play" (io_mike) and
>> >> > what data cache Appeon should use for it. (see my 2nd example
>> >> > attached for an application we have that uses more that one TO).
>> >> >
>> >> > HTH
>> > >
>> > >
>> > >
>> >> --
>
>
>
> --
>


pangalz Posted on 2011-10-31 20:08:16.0Z
Sender: 50d3.4eaeffd1.1804289383@sybase.com
From: pangalz@gmail.com
Newsgroups: sybase.public.appeon
Subject: Re: SQLCA - user defined transaction object
X-Mailer: WebNews to Mail Gateway v1.1t
Message-ID: <4eaf0030.5103.1681692777@sybase.com>
References: <4ea992b5$1@forums-1-dub>
NNTP-Posting-Host: 10.22.241.41
X-Original-NNTP-Posting-Host: 10.22.241.41
Date: 31 Oct 2011 12:08:16 -0800
X-Trace: forums-1-dub 1320091696 10.22.241.41 (31 Oct 2011 12:08:16 -0800)
X-Original-Trace: 31 Oct 2011 12:08:16 -0800, 10.22.241.41
Lines: 54
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub sybase.public.appeon:2819
Article PK: 21894

Appeon uses object defined for sqlca correctly. I'm using a
custom NVO_TRANSACTION for overwrite some native functions.

Regards,
Leonardo.

> appeon does not use the transaction object defined in the
> Additional Properties for sqlca.
>
> I have my NVUO transaction object (in which i have a new
> function defined) in there for sqlca, and it works fine in
> PB, but appeon lists my function call on sqlca as an
> error.
>
>
>
>
>
>
> Chris Pollach wrote:
>
> > Hi Mike;
> >
> > SQLCA is actually a "pointer" to the default global
> > based Transaction object. You can substitute your NVUO
> > based TO for the default by remapping SQLCA to say for
> > example "ns_mike_trans" in your Application Object's
> > "Additional Properties" dialog (accessible from the
> Application Painter). Have a look at the screen capture
> > attached. So in this example, both your PB application
> > and Appeon just need to know about the global variable
> > SQLCA. What actual object it is using at run time is
> > dynamically resolved. :-)
> > Now, where your application has multiple simultaneous
> > connections to the same DBMS instance or varied DBMS
> > instances (you can have to 255 of these in any PB
> > application BTW) - then, you need to tell Appeon about
> > each transaction Object "Pointer". So ... say that you
> use SQLCA to point to a DEMO database. Then, you have a
> > User Object TO (ns_mike_trans) that you "point" to using
> > an Instance variable "io_mike". Then, you need to tell
> > Appeon about IO_MIKE. It makes no difference if your
> > CREATE statement for "io_mike" uses Transaction or
> "ns_mike_trans". You just need to inform Appeon that a new
> > TO pointer is "in play" (io_mike) and what data cache
> > Appeon should use for it. (see my 2nd example attached
> > for an application we have that uses more that one TO).
> >
> > HTH
>
>
>
> --
>