Google is your friend:

http://visualbasic.ittoolbox.com/groups/technical-functional/visualbasic
-l/converting-gregorain-date-to-arabic-503349


____________________________________________________

OLAN KNIGHT
LEAD PROGRAMMER/ANALYST OF TECHNICAL SERVICES
OFFICE: 404-705-3291 | MOBILE: 972-979-8753
EMAIL:  Olan.Knight@...| www.intecbilling.com

-----Original Message-----

How I convert date from grogorian to arabic date and vice versa using
API or any Formula

Thanks

This e-mail and any attachments are confidential and may also be legally
privileged and/or copyright material of Intec Telecom Systems PLC (or its
affiliated companies). If you are not an intended or authorised recipient
of this e-mail or have received it in error, please delete it immediately
and notify the sender by e-mail. In such a case, reading, reproducing,
printing or further dissemination of this e-mail or its contents is strictly
prohibited and may be unlawful.
Intec Telecom Systems PLC does not represent or warrant that an attachment
hereto is free from computer viruses or other defects. The opinions
expressed in this e-mail and any attachments may be those of the author and
are not necessarily those of Intec Telecom Systems PLC.

Dear friends,

>>>Sorry I'm newbie in ORACLE 10G  and Power Builder 10, I use to be using MS
SQL 2000 and Power Builder 7 using ODBC. Please be patient with me :D
[OLK]  No worries, mate - We're here to help!


1. Mr. Olan said "Basically you first create a DSN file for the database you are
using, then you can use the appropriate information to connect using ODBC". My
action are, I already did create DSN and connect it to DB Painte using ODBC,
just like I said, it works but my table is not shown in this connection. My
colleague said that I must create own SCHEMA, because now I'm creating table in
SYSTEM SCHEMA.

[OLK]  Ah yes, you cannot create tables in the System schema and access them
without specific rights. The CORRECT way to do this is to use your own schema
and have the appropriate rights assigned to that schema - as you have done.


2.  I have success connect through ORACLE 10 with Power Builder 10 after I
notice one think from your email, that the "Connection String" is refer to TNS
Service not my personal server. Thank you :D
[OLK]  You're welcome


3. Can you help me, to guide me for the native script connection using ORACLE
10?

[OLK]  Simply create a transaction object (or use SQLCA) and populate the
appropriate parameters, then use the ONNECT command.

            Example: CONNECT USING  SQLCA;


Other Problems
4. I install the SQL* Plus and Oracle Instant pack, but I have still problem
with it when I taste it. It come out with "SP2-0750: You may need Oracle to set
ORACLE_HOME to your oracle home directory"

[OLK]  If you have more than one Oracle Client installed, you will have another 
application called "Oracle Home".

            1. From the START button, find Programs, then Oracle Installation
Products, then Oracle Home Selector.

            2. Select the version of Oracle you want to use

            3. If you want to use any other version of Oracle, you will need to
repeat steps 1 and 2 and change the selected version of Oracle


5. If I still have the problem like point 4, is ist OK for me to continues my
development?
[OLK]  Sure, as long as you can connect to a usable database you are good to go

Best Regards,
Mr. Darmadi, Tri

[OLK]  Good Luck!







--- On Wed, 11/11/09, Olan Knight <Olan.Knight@...> wrote:


From: Olan Knight <Olan.Knight@...>
Subject: [PowerObject] RE: Connect Oracle 10G 10.1 Release Power Buider 10
To: PowerObject@yahoogroups.com
Date: Wednesday, 11 November, 2009, 13:00



Any ODBC connection to any database has to have some minimum information; here's
an example of one that works using a DSN with the transaction object being
populated in the script with the correct parameters:

// Profile IFGS Registry
SQLCA.DBMS = "ODBC"
SQLCA.AutoCommit = False
SQLCA.DBParm = "ConnectString= 'DSN=IFGS_ Registry; UID=dba;PWD=
sql',DelimitIden tifier='No' "

Basically you first create a DSN file for the database you are using, then you
can use the appropriate information to connect using ODBC.

But WHY would you want to connect to an Oracle database using ODBC. Use the
native Oracle connection - it's MUCH faster! Your ORA-12154 error means that
whatever name you specified for the database, whether it is in a configuration
file or in script when populating the transaction object, does not match the
name listed in the TNSNAMES.ORA file.

When the Oracle client is installed on a PC (and you DO have the Oracle Client
installed, right?) a file called TNSNAMES.ORA is created.

Example: My Oracle Client is for v9.2, so Oracle installed the following
top=level folder on my "C" drive: C:\oracle\ora92\ , along with a bunch of
sub-folders. One of the subfolders contains the TNSNAMES file:
C:\oracle\ora92\ network\ADMIN

Every database that the client can connect to MUST be listed in this TNSNAMES
file; here's a sample entry:

DEV10G =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST =MSDATLDEV01) (PORT = 1521))
)
(CONNECT_DATA =
(SERVICE_NAME = DEV10)
)
)

The name you use in your connection attempt must match the name used in the
TNSNAMES.ORA file; in this case the name is "DEV10G".

Check the name you used in the native Oracle connection attempt and try again.

____________ _________ _________ _________ _________ ____

OLAN KNIGHT
LEAD PROGRAMMER/ANALYST OF TECHNICAL SERVICES
OFFICE: 404-705-3291 | MOBILE: 972-979-8753
EMAIL: Olan.Knight@ intecbilling. com| www.intecbilling. com

-----Original Message-----

Dear Friend,

Thanks for your kind attention. I did success connect my ORACLE 10G to SQL Plus,
but the setting for SQL Plus it just contain User ID, Password, and Host String
and when I connect with my username and password without entering the host name,
the SQL run smoothly, but when I try the setup to Power Builder 10, it still
came out with error ORA-12154.

Thanks bro... Is it another way to solve my problems?

Best Regards,

--- On Tue, 10/11/09, barry.johnson@ jeffersonhospita l.org <barry.johnson@
jeffersonhospita l.org> wrote:

Can you connect to your database using the Oracle tools like SQL Developer
or SQL*Plus?

If you can, try using the same host parameter in PB for Server.

-----PowerObject@ yahoogroups. com wrote: -----

Dear friends,

I have problems with my connection, my computer software installed
specification are:

- Oracle 10G Release 10.1 tipe Personal Edition
- Power Builder 10

What I have done:
1. Oracle Profile Database Painter in Power Builder (O90 Oracle 9i)
- I create profile name ORADB_APPS, with setup:
Server : http://localhost: 5501/ (is it true i must fill this?)
Login ID : SYSTEM
Password : ******

Connect as : SYSDBA

I get error ORA-12154, can you guys help me solve this problem?

2. ODBC Profile Database Painter in Power Builder (OD ODBC)

- I create profile name MSDB_APPS, with setup:
Data Source : ORADB_APPS
USER ID : SYSTEM
Password : ******

My connection is success, but when I try to make application,
my table is missing, I just have table with scheme SYSMAN, etc.
Please help me, to solve this.

Other question:

1. Can you guys give me the script for native connection, with ODBC and

Oracle. thanks?

Best Regards,

Mr. Darmadi, Tri








This e-mail and any attachments are confidential and may also be legally
privileged and/or copyright material of Intec Telecom Systems PLC (or its
affiliated companies). If you are not an intended or authorised recipient
of this e-mail or have received it in error, please delete it immediately
and notify the sender by e-mail. In such a case, reading, reproducing,
printing or further dissemination of this e-mail or its contents is strictly
prohibited and may be unlawful.
Intec Telecom Systems PLC does not represent or warrant that an attachment
hereto is free from computer viruses or other defects. The opinions
expressed in this e-mail and any attachments may be those of the author and
are not necessarily those of Intec Telecom Systems PLC.


[Non-text portions of this message have been removed]

Well, you can do this if you must, but the preferred way is to put
common code into a function and have both the button and the ItemChanged
event call the function when required.

You can call any PB event via script using the EVENT or the POST EVENT
calls, but you will need to create all of the required parameters for
the event and pass them just like you would for any function or event
call.

row   = a numeric value; perhaps dw.GetRow ()
ldwo = the column object. Say the column was named "emr_juris_ind", then
you would use
             dot notation to create a column object; Example:  ldwo =
this.Object.emr_juris_ind
data = the new data, in string format, that you wish to place into the
column listed above

// Call the ItemChanged event
parent.EVENT ItemChanged (row, ldwo, data)

____________________________________________________

OLAN KNIGHT
LEAD PROGRAMMER/ANALYST OF TECHNICAL SERVICES
OFFICE: 404-705-3291 | MOBILE: 972-979-8753
EMAIL:  Olan.Knight@...| www.intecbilling.com


-----Original Message-----

Hi All,

I need a help on how to call datawindow events.

I need to call Itemchanged event from a button click. Arguments passed
will be (row, dataobject, data).

can triggerevent be used for it.

Regards
Jerin

This e-mail and any attachments are confidential and may also be legally
privileged and/or copyright material of Intec Telecom Systems PLC (or its
affiliated companies). If you are not an intended or authorised recipient
of this e-mail or have received it in error, please delete it immediately
and notify the sender by e-mail. In such a case, reading, reproducing,
printing or further dissemination of this e-mail or its contents is strictly
prohibited and may be unlawful.
Intec Telecom Systems PLC does not represent or warrant that an attachment
hereto is free from computer viruses or other defects. The opinions
expressed in this e-mail and any attachments may be those of the author and
are not necessarily those of Intec Telecom Systems PLC.

Regarding the real datatype, we found yesterday that if we subtract
.00001 from the real before the calculation is done, it appears to yield
the same results in both PowerBuilder and Appeon. We need to do some
more thorough testing of this, but so far it looks promising.

As for .Net and the web, I believe that beginning with version 11,
PowerBuilder is capable of producing ASP.Net web forms targets. However,
we have found that Appeon meets our needs better for taking our
application to the web.

- Trevor

Sally Li wrote:
> Trevor,
>
>
>
> Your rounding problem is caused by the difference between JavaScript and
PowerScript. The two different languages have different
> ways to handle the calculation of the Real data. This difference won't affect
all users since their requirements about the
> calculation accuracy won't be as high as an insurance company. Also it is not
possible to replace Real with Double in your
> application since it may introduce other problems.  So we recommend you move
the PB code from client-side to server-side NVO when it
> is running on the Web.  By encapsulating the logic in an NVO it would NOT be
converted to JavaScript and the integrity of your
> calculations would be preserved.  PB can deploy NVOs to EAServer (J2EE) and
IIS (.NET). Please note that when PB deploys NVOs to
> .NET they can only be called via Web service.
>
>
>
>
>
> Gibson,
>
>
>
> I looked your email and my suggestion for you is using Appeon .NET version
basing on the following facts and our general experience.
> After decade working in PB to Web migration industry, we found that the
workload and time for any PB-to-Web project will be
> allocated to
>
> 1.       Modify unsupported features.
>
> 2.       Tune the Web application's performance tuning.
>
>
>
> Comparing to any other migration solutions or tools, including PB Web Forms,
Appeon supports the most PB features and delivers the
> best performance and also we are time-tested and proved by worldwide PB users
that Appeon is capable and stable to handle really
> complex and large system, such as ERP system.
>
> 1.         We support up to 95% PB features.
>
> 2.         We spent years on automatically boosting the Web application
performance. For example, we offers 10-X data compression,
> utilized AJAX technology, cache pooling mechanism, etc to automatically boost 
Web applications' performance.
>
> Besides, Appeon supports PB 8.5, windows 2003, MS SQL Server and also Oracle,
which means your current environment, is enough to run
> Appeon.
>
>
>
> I believe that Sybase will figure out a solution for PB users to go .Net and
Web but positively it won't happen soon. The PB 12 is
> still under development and the WPF application is not Web solution.  If you
want both Web and .Net, you need to wait till the
> silverlight version which according to Sybase roadmap will be included in the
version after PB 12.  It will take more than 2 years,
> I believe.
>
>
>
> Regards,
>
> Sally Li
>
>
>
>   _____
>
> From: PowerObject@yahoogroups.com [mailto:PowerObject@yahoogroups.com] On
Behalf Of Trevor Holyoak
> Sent: Tuesday, November 10, 2009 4:35 AM
> To: PowerObject@yahoogroups.com
> Subject: Re: [PowerObject] ASP.NET, Appeon Server, Oracle, MS SQL Server and
Powerbuilder pro's and con's and architectures
>
>
>
>
>
> The .Net version of Appeon works on IE 7 and above and does not use
> Silverlight. I believe you would need to at least move to version 11 of
> PowerBuilder. We had to do a few changes for Appeon (we simply put in an
> "if" statement that did something different if it was Appeon in a few
> places, so we can continue to use the same code base for both Appeon and
> client/server targets), but nothing major. Actually, the biggest problem
> we've had is something we're still trying to work out - Appeon treats
> reals (the numeric datatype) differently than PowerBuilder and we get
> different results when rounding.
>
> - Trevor
>
> Gibson, Shane wrote:
>
>> Also forgot if I go to Appeon .NET How much code re-write will I have to do
to get my application working since It is based on
>>
> client server model and is using PB 8.5?
>
>> Larry S. Gibson (Shane)
>> Web Developer
>> ________________________________
>> From: PowerObject@ <mailto:PowerObject%40yahoogroups.com> yahoogroups.com
[mailto:PowerObject@
>>
> <mailto:PowerObject%40yahoogroups.com> yahoogroups.com] On Behalf Of Gibson,
Shane
>
>> Sent: Monday, November 09, 2009 1:11 PM
>> To: PowerObject@ <mailto:PowerObject%40yahoogroups.com> yahoogroups.com
>> Subject: RE: [PowerObject] ASP.NET, Appeon Server, Oracle, MS SQL Server and
Powerbuilder pro's and con's and architectures
>>
>>
>>
>> Thank you Trevor,
>>
>> For the solution you suggest will the client need to i.e. 8 or higher (or
have silver light installed) also accessibility is an
>>
> big concern for my organization, and last item I would like to hear your
thoughts on, the tools needed, I will not need Visual
> Studios 2010 or Microsoft Expressions Studio / Blend? There features will be
incorporated in PB 12? Please elaborate definitely
> interested in this solution! As well as other suggestions! Also one last
question the windows .net framework classes, will they be
> available with intelli-sense in PB (I have only worked in PB 8.5 and prior)
and have the referencing like Visual Studios?
>
>> Larry S. Gibson (Shane)
>> Web Developer
>> ________________________________
>> From: PowerObject@ <mailto:PowerObject%40yahoogroups.com>
yahoogroups.com<mailto:PowerObject%40yahoogroups.com>
>>
> [mailto:PowerObject@ <mailto:PowerObject%40yahoogroups.com>
yahoogroups.com<mailto:PowerObject%40yahoogroups.com>] On Behalf Of
> Trevor Holyoak
>
>> Sent: Monday, November 09, 2009 12:26 PM
>> To: PowerObject@ <mailto:PowerObject%40yahoogroups.com>
yahoogroups.com<mailto:PowerObject%40yahoogroups.com>
>> Subject: Re: [PowerObject] ASP.NET, Appeon Server, Oracle, MS SQL Server and
Powerbuilder pro's and con's and architectures
>>
>> There are two versions of Appeon - one of them uses .Net and runs on
>> IIS. We have been using it alongside the client/server version with very
>> few problems.
>>
>> If you upgrade to the current version of PowerBuilder, you will find you
>> can deploy it as a .Net application. And when version 12 comes out, you
>> can use it to make 100% pure .Net applications using WPF. There will be
>> no reason to use other tools.
>>
>> I hope that helps,
>> Trevor
>>
>> Gibson, Shane wrote:
>>
>>
>>> Hello All,
>>> I am faced with an architectural dilemma and would like some advice and
facts! Situation is this we have a client / server model
>>>
> running in the PB 8.5 environment, our current website and other web-based
applications are all running on windows machines and have
> been designed with ASP.NET! We have been researching Appeon server from Sybase
to get our application on the web, but from what I
> have read it seems as if it runs or emulates Java. I would very much like to
avoid having java as a platform and .net as another my
> goal is to get the PB applications migrated to .net even if I have to settle
for the DataWindow .net feature, so what would it take
> to get our PB client server application migrated in a .net. Need specifics!
>
>>> Here is our current environment:
>>>
>>> 1.) We have Windows 2003 Web Front end server running IIS prod server (same
for dev)
>>> 2.) We have Visual Studios for our web team development
>>> 3.) We have MS SQL Server EE for our web applications
>>> 4.) We are using Sybase PB 8.5 for Client / Server Dev and pushing this
application to clients in a release for prod
>>> 5.) We have Oracle for the Database for the Client / Server Application
>>>
>>> Here is what I am thinking and hope the environment would look like [Help me
fill in the Gaps]
>>>
>>> 6.) We have Windows 2003 Web Front end server running IIS already so this
would be deploy server (same for dev)
>>> 7.) We have Visual Studios for our web team development [could we keep this
and add a Sybase DataWindow plug-in to get the
>>>
> painters in Visual Studios?]
>
>>> 8.) We have MS SQL Server EE for our web apps and use Oracle for existing
data retrieval
>>>
>>> So is the Appeon server running java or is it need for .net architecture?
>>>
>>> What would a typical Architecture look like using ASP.NET [windows web
server 2008/2003], Sybase DataWindow .net, Oracle/SQL
>>>
> Server?
>
>>> Are there any tools out there that would be needed? Would be helpful? Would
we need to upgrade our development environment? If
>>>
> yes on upgrading dev environment would we need visual studios and add the
DataWindow .net plug-in in this or does Sybase still have
> to be its own RAD / IDE?
>
>>> Is it just easier to re-write the application using ASP.NET with out the
DataWindow and migrate our database?
>>>
>>> Please let me know of any flaws you see (i.e. you have to have Appeon for
.net development with Sybase web), any questions for me
>>>
> that may help you help me [< - - LOL], Any past experiences or architectures
you have used or are using that are similar to this
> scenario would be a great help!!
>
>>> Thank you in advance,
>>> Larry S. Gibson (Shane)
>>> Web Developer
>>>
>>>
>>> [Non-text portions of this message have been removed]
>>>
>>>
>>>
>>> ------------------------------------
>>>
>>> Yahoo! Groups Links
>>>
>>>
>>>
>>>
>>>
>>>
>> [Non-text portions of this message have been removed]
>>
>>
>>
>> [Non-text portions of this message have been removed]
>>
>>
>>
>> ------------------------------------
>>
>> Yahoo! Groups Links
>>
>>
>>
>>
>>
>
>
>
>
>
> [Non-text portions of this message have been removed]
>
>
>
> ------------------------------------
>
> Yahoo! Groups Links
>
>
>
>

Dear Olan Knight

Thanks a lot for the help.

The code worked and my issues are solving.


Best of Luck

Thanks and Regards
Jerin





--- On Thu, 11/12/09, Olan Knight <Olan.Knight@...> wrote:

From: Olan Knight <Olan.Knight@...>
Subject: RE: [PowerObject] How to call Itemchanged event
To: "powerobject@yahoogroups.com" <PowerObject@yahoogroups.com>
Date: Thursday, November 12, 2009, 9:29 PM







 









       Well, you can do this if you must, but the preferred way is to put

common code into a function and have both the button and the ItemChanged

event call the function when required.



You can call any PB event via script using the EVENT or the POST EVENT

calls, but you will need to create all of the required parameters for

the event and pass them just like you would for any function or event

call.



row   = a numeric value; perhaps dw.GetRow ()

ldwo = the column object. Say the column was named "emr_juris_ind" , then

you would use

             dot notation to create a column object; Example:  ldwo =

this.Object. emr_juris_ ind

data = the new data, in string format, that you wish to place into the

column listed above



// Call the ItemChanged event

parent.EVENT ItemChanged (row, ldwo, data)



____________ _________ _________ _________ _________ ____



OLAN KNIGHT

LEAD PROGRAMMER/ANALYST OF TECHNICAL SERVICES

OFFICE: 404-705-3291 | MOBILE: 972-979-8753

EMAIL:  Olan.Knight@ intecbilling. com| www.intecbilling. com



-----Original Message-----



Hi All,



I need a help on how to call datawindow events.



I need to call Itemchanged event from a button click. Arguments passed

will be (row, dataobject, data).



can triggerevent be used for it.



Regards

Jerin



This e-mail and any attachments are confidential and may also be legally

privileged and/or copyright material of Intec Telecom Systems PLC (or its

affiliated companies). If you are not an intended or authorised recipient

of this e-mail or have received it in error, please delete it immediately

and notify the sender by e-mail. In such a case, reading, reproducing,

printing or further dissemination of this e-mail or its contents is strictly

prohibited and may be unlawful.

Intec Telecom Systems PLC does not represent or warrant that an attachment

hereto is free from computer viruses or other defects. The opinions

expressed in this e-mail and any attachments may be those of the author and

are not necessarily those of Intec Telecom Systems PLC.























[Non-text portions of this message have been removed]

Hello,
             Have a question, new to the coding on the dw object! In a asp.net
web app I would typically call this statement Variable_1 =
textbox.value.ToString(); to get the current value of a textbox but in the dw
what looks like a textbox is not really a textbox so how do I get the value of
this object like I would asp.net to set it to a variable?(I want this to happen
on the item change event or focus change event) Using PB 8

Larry S. Gibson (Shane)
Web Developer
________________________________
From: PowerObject@yahoogroups.com [mailto:PowerObject@yahoogroups.com] On Behalf
Of Jerin Josey
Sent: Sunday, November 15, 2009 12:53 AM
To: PowerObject@yahoogroups.com
Cc: Olan.Knight@...
Subject: RE: [PowerObject] How to call Itemchanged event



Dear Olan Knight

Thanks a lot for the help.

The code worked and my issues are solving.

Best of Luck

Thanks and Regards
Jerin

--- On Thu, 11/12/09, Olan Knight
<Olan.Knight@...<mailto:Olan.Knight%40intecbilling.com>> wrote:

From: Olan Knight
<Olan.Knight@...<mailto:Olan.Knight%40intecbilling.com>>
Subject: RE: [PowerObject] How to call Itemchanged event
To: "powerobject@yahoogroups.com<mailto:powerobject%40yahoogroups.com>"
<PowerObject@yahoogroups.com<mailto:PowerObject%40yahoogroups.com>>
Date: Thursday, November 12, 2009, 9:29 PM



Well, you can do this if you must, but the preferred way is to put

common code into a function and have both the button and the ItemChanged

event call the function when required.

You can call any PB event via script using the EVENT or the POST EVENT

calls, but you will need to create all of the required parameters for

the event and pass them just like you would for any function or event

call.

row = a numeric value; perhaps dw.GetRow ()

ldwo = the column object. Say the column was named "emr_juris_ind" , then

you would use

dot notation to create a column object; Example: ldwo =

this.Object. emr_juris_ ind

data = the new data, in string format, that you wish to place into the

column listed above

// Call the ItemChanged event

parent.EVENT ItemChanged (row, ldwo, data)

____________ _________ _________ _________ _________ ____

OLAN KNIGHT

LEAD PROGRAMMER/ANALYST OF TECHNICAL SERVICES

OFFICE: 404-705-3291 | MOBILE: 972-979-8753

EMAIL: Olan.Knight@ intecbilling. com| www.intecbilling. com

-----Original Message-----

Hi All,

I need a help on how to call datawindow events.

I need to call Itemchanged event from a button click. Arguments passed

will be (row, dataobject, data).

can triggerevent be used for it.

Regards

Jerin

This e-mail and any attachments are confidential and may also be legally

privileged and/or copyright material of Intec Telecom Systems PLC (or its

affiliated companies). If you are not an intended or authorised recipient

of this e-mail or have received it in error, please delete it immediately

and notify the sender by e-mail. In such a case, reading, reproducing,

printing or further dissemination of this e-mail or its contents is strictly

prohibited and may be unlawful.

Intec Telecom Systems PLC does not represent or warrant that an attachment

hereto is free from computer viruses or other defects. The opinions

expressed in this e-mail and any attachments may be those of the author and

are not necessarily those of Intec Telecom Systems PLC.

[Non-text portions of this message have been removed]



[Non-text portions of this message have been removed]

Shane -



    The third parameter in the ItemChanged event for any dw is "data",
and it refers to the data entered by the user onto the datawindow; i.e.
anything the user can type or select from a dropdown is passed as a
string in this parameter. If that value is interger data, you will need
to convert it from a string back into an integer if you wish to
manipulate it.



    Or am I not understanding the question?





Olan



-----Original Message-----



Hello,

             Have a question, new to the coding on the dw object! In a
asp.net web app I would typically call this statement Variable_1 =
textbox.value.ToString(); to get the current value of a textbox but in
the dw what looks like a textbox is not really a textbox so how do I get
the value of this object like I would asp.net to set it to a variable?(I
want this to happen on the item change event or focus change event)
Using PB 8



Larry S. Gibson (Shane)

Web Developer

________________________________



Dear Olan Knight



Thanks a lot for the help.



The code worked and my issues are solving.



Best of Luck



Thanks and Regards

Jerin



--- On Thu, 11/12/09, Olan Knight
<Olan.Knight@...<mailto:Olan.Knight%40intecbilling.com>>
wrote:





Well, you can do this if you must, but the preferred way is to put

common code into a function and have both the button and the ItemChanged

event call the function when required.



You can call any PB event via script using the EVENT or the POST EVENT

calls, but you will need to create all of the required parameters for

the event and pass them just like you would for any function or event

call.



row = a numeric value; perhaps dw.GetRow ()

ldwo = the column object. Say the column was named "emr_juris_ind" ,
then



you would use

dot notation to create a column object; Example: ldwo =



this.Object. emr_juris_ ind

data = the new data, in string format, that you wish to place into the

column listed above



// Call the ItemChanged event

parent.EVENT ItemChanged (row, ldwo, data)





-----Original Message-----



Hi All,



I need a help on how to call datawindow events.

I need to call Itemchanged event from a button click. Arguments passed

will be (row, dataobject, data).



can triggerevent be used for it.



Regards



Jerin

This e-mail and any attachments are confidential and may also be legally
privileged and/or copyright material of Intec Telecom Systems PLC (or its
affiliated companies). If you are not an intended or authorised recipient
of this e-mail or have received it in error, please delete it immediately
and notify the sender by e-mail. In such a case, reading, reproducing,
printing or further dissemination of this e-mail or its contents is strictly
prohibited and may be unlawful.
Intec Telecom Systems PLC does not represent or warrant that an attachment
hereto is free from computer viruses or other defects. The opinions
expressed in this e-mail and any attachments may be those of the author and
are not necessarily those of Intec Telecom Systems PLC.


[Non-text portions of this message have been removed]

Hello everyone,
 
I would really appreciate if anyone can help me out on the below issue.
 
1) I need to display the signature sent by the point of sales(POS)system. The
signature data is between <signature> xml tags and it is in base 64 encoded BC
Nibble format.So i need to convert the nibble format to bitmap and display the
signature image using powerbuilder. So do anyone know the procedure to convert
the nibble to bitmap?.
 
Thanks in Advance,
 
Regards,
Venu




[Non-text portions of this message have been removed]

That is good to know, but I want to pull the value out of that textbox field
that is currently part of the DataWindow, I explain more I have a window object
with a DataWindow placed on it inside the DataWindow is a text object (it's not
a sle_textbox), when the window object is opened the text object inside the
DataWindow pulls a date value into it from somewhere (not sure where yet), but
also it has a drop down calendar that you can select a new date from, I want to
update a label text object somewhere else in the window object based on the new
date selected from the calendar object that automatically updates the textbox
object in the DataWindow, my logic tells me that I need to grab the current
value of the textbox object in the item change event? But being new to the
DataWindow I am clueless of how to Get the Text / String value from that field
(also remember this transaction has not called an update on the db yet which is
done by button click in the window object)? Hope this helps you help me LOL!
Thanks Olan! Also if there is any quick and simple tutorials out there on the
DataWindow itself I could use some more practice with this object!

Larry S. Gibson (Shane)
Web Developer
________________________________
From: PowerObject@yahoogroups.com [mailto:PowerObject@yahoogroups.com] On Behalf
Of Olan Knight
Sent: Monday, November 16, 2009 9:48 AM
To: PowerObject@yahoogroups.com
Subject: [PowerObject] RE: How to call Itemchanged event #2



Shane -

The third parameter in the ItemChanged event for any dw is "data",
and it refers to the data entered by the user onto the datawindow; i.e.
anything the user can type or select from a dropdown is passed as a
string in this parameter. If that value is interger data, you will need
to convert it from a string back into an integer if you wish to
manipulate it.

Or am I not understanding the question?

Olan

-----Original Message-----

Hello,

Have a question, new to the coding on the dw object! In a
asp.net web app I would typically call this statement Variable_1 =
textbox.value.ToString(); to get the current value of a textbox but in
the dw what looks like a textbox is not really a textbox so how do I get
the value of this object like I would asp.net to set it to a variable?(I
want this to happen on the item change event or focus change event)
Using PB 8

Larry S. Gibson (Shane)

Web Developer

________________________________

Dear Olan Knight

Thanks a lot for the help.

The code worked and my issues are solving.

Best of Luck

Thanks and Regards

Jerin

--- On Thu, 11/12/09, Olan Knight
<Olan.Knight@...<mailto:Olan.Knight%40intecbilling.com><mailto:Olan\
.Knight%40intecbilling.com>>
wrote:

Well, you can do this if you must, but the preferred way is to put

common code into a function and have both the button and the ItemChanged

event call the function when required.

You can call any PB event via script using the EVENT or the POST EVENT

calls, but you will need to create all of the required parameters for

the event and pass them just like you would for any function or event

call.

row = a numeric value; perhaps dw.GetRow ()

ldwo = the column object. Say the column was named "emr_juris_ind" ,
then

you would use

dot notation to create a column object; Example: ldwo =

this.Object. emr_juris_ ind

data = the new data, in string format, that you wish to place into the

column listed above

// Call the ItemChanged event

parent.EVENT ItemChanged (row, ldwo, data)

-----Original Message-----

Hi All,

I need a help on how to call datawindow events.

I need to call Itemchanged event from a button click. Arguments passed

will be (row, dataobject, data).

can triggerevent be used for it.

Regards

Jerin

This e-mail and any attachments are confidential and may also be legally
privileged and/or copyright material of Intec Telecom Systems PLC (or its
affiliated companies). If you are not an intended or authorised recipient
of this e-mail or have received it in error, please delete it immediately
and notify the sender by e-mail. In such a case, reading, reproducing,
printing or further dissemination of this e-mail or its contents is strictly
prohibited and may be unlawful.
Intec Telecom Systems PLC does not represent or warrant that an attachment
hereto is free from computer viruses or other defects. The opinions
expressed in this e-mail and any attachments may be those of the author and
are not necessarily those of Intec Telecom Systems PLC.

[Non-text portions of this message have been removed]



[Non-text portions of this message have been removed]

Test displayed on a dw can be "static text", a database column, an SLE
field, or an MLE field.

Static text is accessed as follows:  <field name>.text.
	 ls_old_text   = st_label.Text
	 st_label.Text = "New Label"

Database columns are accessed with the Get and Set statements:
	 ll_rc = dw.GetItemString (ll_row, "column_name")
	 ll_rc = dw.SetItem (ll_row, "label_field", "New Label")

SLE and MLEs are access like static tecxt field using the TEXT attribute
of the object.


Olan

-----Original Message-----

That is good to know, but I want to pull the value out of that textbox
field that is currently part of the DataWindow, I explain more I have a
window object with a DataWindow placed on it inside the DataWindow is a
text object (it's not a sle_textbox), when the window object is opened
the text object inside the DataWindow pulls a date value into it from
somewhere (not sure where yet), but also it has a drop down calendar
that you can select a new date from, I want to update a label text
object somewhere else in the window object based on the new date
selected from the calendar object that automatically updates the textbox
object in the DataWindow, my logic tells me that I need to grab the
current value of the textbox object in the item change event? But being
new to the DataWindow I am clueless of how to Get the Text / String
value from that field (also remember this transaction has not called an
update on the db yet which is done by button click in the window
object)? Hope t
  his helps you help me LOL! Thanks Olan! Also if there is any quick and
simple tutorials out there on the DataWindow itself I could use some
more practice with this object!

Larry S. Gibson (Shane)
Web Developer
________________________________


Shane -

The third parameter in the ItemChanged event for any dw is "data",
and it refers to the data entered by the user onto the datawindow; i.e.
anything the user can type or select from a dropdown is passed as a
string in this parameter. If that value is interger data, you will need
to convert it from a string back into an integer if you wish to
manipulate it.

Or am I not understanding the question?

Olan

-----Original Message-----

Hello,

Have a question, new to the coding on the dw object! In a
asp.net web app I would typically call this statement Variable_1 =
textbox.value.ToString(); to get the current value of a textbox but in
the dw what looks like a textbox is not really a textbox so how do I get
the value of this object like I would asp.net to set it to a variable?(I
want this to happen on the item change event or focus change event)
Using PB 8

Larry S. Gibson (Shane)

Web Developer

________________________________

Dear Olan Knight

Thanks a lot for the help.

The code worked and my issues are solving.

Best of Luck

Thanks and Regards

Jerin

--- On Thu, 11/12/09, Olan Knight
<Olan.Knight@...<mailto:Olan.Knight%40intecbilling.com><mai
lto:Olan.Knight%40intecbilling.com>>
wrote:

Well, you can do this if you must, but the preferred way is to put

common code into a function and have both the button and the ItemChanged

event call the function when required.

You can call any PB event via script using the EVENT or the POST EVENT

calls, but you will need to create all of the required parameters for

the event and pass them just like you would for any function or event

call.

row = a numeric value; perhaps dw.GetRow ()

ldwo = the column object. Say the column was named "emr_juris_ind" ,
then

you would use

dot notation to create a column object; Example: ldwo =

this.Object. emr_juris_ ind

data = the new data, in string format, that you wish to place into the

column listed above

// Call the ItemChanged event

parent.EVENT ItemChanged (row, ldwo, data)

-----Original Message-----

Hi All,

I need a help on how to call datawindow events.

I need to call Itemchanged event from a button click. Arguments passed

will be (row, dataobject, data).

can triggerevent be used for it.

Regards

Jerin

This e-mail and any attachments are confidential and may also be legally
privileged and/or copyright material of Intec Telecom Systems PLC (or
its
affiliated companies). If you are not an intended or authorised
recipient
of this e-mail or have received it in error, please delete it
immediately
and notify the sender by e-mail. In such a case, reading, reproducing,
printing or further dissemination of this e-mail or its contents is
strictly
prohibited and may be unlawful.
Intec Telecom Systems PLC does not represent or warrant that an
attachment
hereto is free from computer viruses or other defects. The opinions
expressed in this e-mail and any attachments may be those of the author
and
are not necessarily those of Intec Telecom Systems PLC.

[Non-text portions of this message have been removed]



[Non-text portions of this message have been removed]



------------------------------------

Yahoo! Groups Links

One more thing: LEARN to use the online HELP that comes with
PowerBuilder. I've been using PowerBuilder since version 4 and I still
get into the HELP file every day!

As for tutorials, use the tutorial that comes with PowerBuilder to
start. DO NOT merely cookie-cutter the steps when you work the tutorial:
be SURE you understand the step. Once you finish the PB tutorial you
will be MUCH more comfortable in PB.

Olan


-----Original Message-----

That is good to know, but I want to pull the value out of that textbox
field that is currently part of the DataWindow, I explain more I have a
window object with a DataWindow placed on it inside the DataWindow is a
text object (it's not a sle_textbox), when the window object is opened
the text object inside the DataWindow pulls a date value into it from
somewhere (not sure where yet), but also it has a drop down calendar
that you can select a new date from, I want to update a label text
object somewhere else in the window object based on the new date
selected from the calendar object that automatically updates the textbox
object in the DataWindow, my logic tells me that I need to grab the
current value of the textbox object in the item change event? But being
new to the DataWindow I am clueless of how to Get the Text / String
value from that field (also remember this transaction has not called an
update on the db yet which is done by button click in the window
object)? Hope t
  his helps you help me LOL! Thanks Olan! Also if there is any quick and
simple tutorials out there on the DataWindow itself I could use some
more practice with this object!

Larry S. Gibson (Shane)
Web Developer
________________________________
From: PowerObject@yahoogroups.com [mailto:PowerObject@yahoogroups.com]
On Behalf Of Olan Knight
Sent: Monday, November 16, 2009 9:48 AM
To: PowerObject@yahoogroups.com
Subject: [PowerObject] RE: How to call Itemchanged event #2



Shane -

The third parameter in the ItemChanged event for any dw is "data",
and it refers to the data entered by the user onto the datawindow; i.e.
anything the user can type or select from a dropdown is passed as a
string in this parameter. If that value is interger data, you will need
to convert it from a string back into an integer if you wish to
manipulate it.

Or am I not understanding the question?

Olan

-----Original Message-----

Hello,

Have a question, new to the coding on the dw object! In a
asp.net web app I would typically call this statement Variable_1 =
textbox.value.ToString(); to get the current value of a textbox but in
the dw what looks like a textbox is not really a textbox so how do I get
the value of this object like I would asp.net to set it to a variable?(I
want this to happen on the item change event or focus change event)
Using PB 8

Larry S. Gibson (Shane)

Web Developer

________________________________

Dear Olan Knight

Thanks a lot for the help.

The code worked and my issues are solving.

Best of Luck

Thanks and Regards

Jerin

--- On Thu, 11/12/09, Olan Knight
<Olan.Knight@...<mailto:Olan.Knight%40intecbilling.com><mai
lto:Olan.Knight%40intecbilling.com>>
wrote:

Well, you can do this if you must, but the preferred way is to put

common code into a function and have both the button and the ItemChanged

event call the function when required.

You can call any PB event via script using the EVENT or the POST EVENT

calls, but you will need to create all of the required parameters for

the event and pass them just like you would for any function or event

call.

row = a numeric value; perhaps dw.GetRow ()

ldwo = the column object. Say the column was named "emr_juris_ind" ,
then

you would use

dot notation to create a column object; Example: ldwo =

this.Object. emr_juris_ ind

data = the new data, in string format, that you wish to place into the

column listed above

// Call the ItemChanged event

parent.EVENT ItemChanged (row, ldwo, data)

-----Original Message-----

Hi All,

I need a help on how to call datawindow events.

I need to call Itemchanged event from a button click. Arguments passed

will be (row, dataobject, data).

can triggerevent be used for it.

Regards

Jerin

This e-mail and any attachments are confidential and may also be legally
privileged and/or copyright material of Intec Telecom Systems PLC (or
its
affiliated companies). If you are not an intended or authorised
recipient
of this e-mail or have received it in error, please delete it
immediately
and notify the sender by e-mail. In such a case, reading, reproducing,
printing or further dissemination of this e-mail or its contents is
strictly
prohibited and may be unlawful.
Intec Telecom Systems PLC does not represent or warrant that an
attachment
hereto is free from computer viruses or other defects. The opinions
expressed in this e-mail and any attachments may be those of the author
and
are not necessarily those of Intec Telecom Systems PLC.

[Non-text portions of this message have been removed]



[Non-text portions of this message have been removed]



------------------------------------

Yahoo! Groups Links

Thank you OLAN,
             Yes I will admit I skipped most of the boring parts of the tutorials
for the static items such as sle's and static text labels seemed very similar to
other langauges, I have being using the online help as well it is a blessing
(When working on asp.net I live in the MSDN), But the datawindow is a monster I
have yet to conquer, I am almost positive it is a database column, but when I
tried the dw.GetItemString I got an error but I may have had something like
dw_1.object.textbox1.GetText(); instead I will try with your code! Thank you for
being so willing to help me OLAN!

Thanks Again,
Larry S. Gibson (Shane)
Web Developer
________________________________
From: PowerObject@yahoogroups.com [mailto:PowerObject@yahoogroups.com] On Behalf
Of Olan Knight
Sent: Monday, November 16, 2009 12:59 PM
To: PowerObject@yahoogroups.com
Subject: [PowerObject] RE: How to call Itemchanged event #2



Test displayed on a dw can be "static text", a database column, an SLE
field, or an MLE field.

Static text is accessed as follows: <field name>.text.
ls_old_text = st_label.Text
st_label.Text = "New Label"

Database columns are accessed with the Get and Set statements:
ll_rc = dw.GetItemString (ll_row, "column_name")
ll_rc = dw.SetItem (ll_row, "label_field", "New Label")

SLE and MLEs are access like static tecxt field using the TEXT attribute
of the object.

Olan

-----Original Message-----

That is good to know, but I want to pull the value out of that textbox
field that is currently part of the DataWindow, I explain more I have a
window object with a DataWindow placed on it inside the DataWindow is a
text object (it's not a sle_textbox), when the window object is opened
the text object inside the DataWindow pulls a date value into it from
somewhere (not sure where yet), but also it has a drop down calendar
that you can select a new date from, I want to update a label text
object somewhere else in the window object based on the new date
selected from the calendar object that automatically updates the textbox
object in the DataWindow, my logic tells me that I need to grab the
current value of the textbox object in the item change event? But being
new to the DataWindow I am clueless of how to Get the Text / String
value from that field (also remember this transaction has not called an
update on the db yet which is done by button click in the window
object)? Hope t
his helps you help me LOL! Thanks Olan! Also if there is any quick and
simple tutorials out there on the DataWindow itself I could use some
more practice with this object!

Larry S. Gibson (Shane)
Web Developer
________________________________

Shane -

The third parameter in the ItemChanged event for any dw is "data",
and it refers to the data entered by the user onto the datawindow; i.e.
anything the user can type or select from a dropdown is passed as a
string in this parameter. If that value is interger data, you will need
to convert it from a string back into an integer if you wish to
manipulate it.

Or am I not understanding the question?

Olan

-----Original Message-----

Hello,

Have a question, new to the coding on the dw object! In a
asp.net web app I would typically call this statement Variable_1 =
textbox.value.ToString(); to get the current value of a textbox but in
the dw what looks like a textbox is not really a textbox so how do I get
the value of this object like I would asp.net to set it to a variable?(I
want this to happen on the item change event or focus change event)
Using PB 8

Larry S. Gibson (Shane)

Web Developer

________________________________

Dear Olan Knight

Thanks a lot for the help.

The code worked and my issues are solving.

Best of Luck

Thanks and Regards

Jerin

--- On Thu, 11/12/09, Olan Knight
<Olan.Knight@...<mailto:Olan.Knight%40intecbilling.com><mailto:Olan\
.Knight%40intecbilling.com><mai
lto:Olan.Knight%40intecbilling.com>>
wrote:

Well, you can do this if you must, but the preferred way is to put

common code into a function and have both the button and the ItemChanged

event call the function when required.

You can call any PB event via script using the EVENT or the POST EVENT

calls, but you will need to create all of the required parameters for

the event and pass them just like you would for any function or event

call.

row = a numeric value; perhaps dw.GetRow ()

ldwo = the column object. Say the column was named "emr_juris_ind" ,
then

you would use

dot notation to create a column object; Example: ldwo =

this.Object. emr_juris_ ind

data = the new data, in string format, that you wish to place into the

column listed above

// Call the ItemChanged event

parent.EVENT ItemChanged (row, ldwo, data)

-----Original Message-----

Hi All,

I need a help on how to call datawindow events.

I need to call Itemchanged event from a button click. Arguments passed

will be (row, dataobject, data).

can triggerevent be used for it.

Regards

Jerin

This e-mail and any attachments are confidential and may also be legally
privileged and/or copyright material of Intec Telecom Systems PLC (or
its
affiliated companies). If you are not an intended or authorised
recipient
of this e-mail or have received it in error, please delete it
immediately
and notify the sender by e-mail. In such a case, reading, reproducing,
printing or further dissemination of this e-mail or its contents is
strictly
prohibited and may be unlawful.
Intec Telecom Systems PLC does not represent or warrant that an
attachment
hereto is free from computer viruses or other defects. The opinions
expressed in this e-mail and any attachments may be those of the author
and
are not necessarily those of Intec Telecom Systems PLC.

[Non-text portions of this message have been removed]

[Non-text portions of this message have been removed]

------------------------------------

Yahoo! Groups Links



[Non-text portions of this message have been removed]

>> But the datawindow is a monster
Oh, yeah! The dw IS the power in PowerBuilder

Remember that dot notation does not mix with "standard" notation.

Dot Notation:
	 ls_text = String (dw.Object.<column name>.Text)
	 dw.Object.<column name>.Text = "Here I am"

Standard notation:
	 ls_text = dw.GetItemString (<row>, <column or object name>)
	 ll_rc     = dw.SetItem (<row>, <column>, <string value>)


Later -

Olan

-----Original Message-----

Thank you OLAN,
             Yes I will admit I skipped most of the boring parts of the
tutorials for the static items such as sle's and static text labels
seemed very similar to other langauges, I have being using the online
help as well it is a blessing (When working on asp.net I live in the
MSDN), But the datawindow is a monster I have yet to conquer, I am
almost positive it is a database column, but when I tried the
dw.GetItemString I got an error but I may have had something like
dw_1.object.textbox1.GetText(); instead I will try with your code! Thank
you for being so willing to help me OLAN!

Thanks Again,
Larry S. Gibson (Shane)
Web Developer
________________________________

Test displayed on a dw can be "static text", a database column, an SLE
field, or an MLE field.

Static text is accessed as follows: <field name>.text.
ls_old_text = st_label.Text
st_label.Text = "New Label"

Database columns are accessed with the Get and Set statements:
ll_rc = dw.GetItemString (ll_row, "column_name")
ll_rc = dw.SetItem (ll_row, "label_field", "New Label")

SLE and MLEs are access like static tecxt field using the TEXT attribute
of the object.

Olan

-----Original Message-----

That is good to know, but I want to pull the value out of that textbox
field that is currently part of the DataWindow, I explain more I have a
window object with a DataWindow placed on it inside the DataWindow is a
text object (it's not a sle_textbox), when the window object is opened
the text object inside the DataWindow pulls a date value into it from
somewhere (not sure where yet), but also it has a drop down calendar
that you can select a new date from, I want to update a label text
object somewhere else in the window object based on the new date
selected from the calendar object that automatically updates the textbox
object in the DataWindow, my logic tells me that I need to grab the
current value of the textbox object in the item change event? But being
new to the DataWindow I am clueless of how to Get the Text / String
value from that field (also remember this transaction has not called an
update on the db yet which is done by button click in the window
object)? Hope t
his helps you help me LOL! Thanks Olan! Also if there is any quick and
simple tutorials out there on the DataWindow itself I could use some
more practice with this object!

Larry S. Gibson (Shane)
Web Developer
________________________________

Shane -

The third parameter in the ItemChanged event for any dw is "data",
and it refers to the data entered by the user onto the datawindow; i.e.
anything the user can type or select from a dropdown is passed as a
string in this parameter. If that value is interger data, you will need
to convert it from a string back into an integer if you wish to
manipulate it.

Or am I not understanding the question?

Olan

-----Original Message-----

Hello,

Have a question, new to the coding on the dw object! In a
asp.net web app I would typically call this statement Variable_1 =
textbox.value.ToString(); to get the current value of a textbox but in
the dw what looks like a textbox is not really a textbox so how do I get
the value of this object like I would asp.net to set it to a variable?(I
want this to happen on the item change event or focus change event)
Using PB 8

Larry S. Gibson (Shane)

Web Developer

________________________________

Dear Olan Knight

Thanks a lot for the help.

The code worked and my issues are solving.

Best of Luck

Thanks and Regards

Jerin

--- On Thu, 11/12/09, Olan Knight
<Olan.Knight@...<mailto:Olan.Knight%40intecbilling.com><mai
lto:Olan.Knight%40intecbilling.com><mai
lto:Olan.Knight%40intecbilling.com>>
wrote:

Well, you can do this if you must, but the preferred way is to put

common code into a function and have both the button and the ItemChanged

event call the function when required.

You can call any PB event via script using the EVENT or the POST EVENT

calls, but you will need to create all of the required parameters for

the event and pass them just like you would for any function or event

call.

row = a numeric value; perhaps dw.GetRow ()

ldwo = the column object. Say the column was named "emr_juris_ind" ,
then

you would use

dot notation to create a column object; Example: ldwo =

this.Object. emr_juris_ ind

data = the new data, in string format, that you wish to place into the

column listed above

// Call the ItemChanged event

parent.EVENT ItemChanged (row, ldwo, data)

-----Original Message-----

Hi All,

I need a help on how to call datawindow events.

I need to call Itemchanged event from a button click. Arguments passed

will be (row, dataobject, data).

can triggerevent be used for it.

Regards

Jerin

This e-mail and any attachments are confidential and may also be legally
privileged and/or copyright material of Intec Telecom Systems PLC (or its
affiliated companies). If you are not an intended or authorised recipient
of this e-mail or have received it in error, please delete it immediately
and notify the sender by e-mail. In such a case, reading, reproducing,
printing or further dissemination of this e-mail or its contents is strictly
prohibited and may be unlawful.
Intec Telecom Systems PLC does not represent or warrant that an attachment
hereto is free from computer viruses or other defects. The opinions
expressed in this e-mail and any attachments may be those of the author and
are not necessarily those of Intec Telecom Systems PLC.

Thanks Again OLAN. I appreciate those who help for free! I try to help out
sometimes with .net questions in the ASP.NET groups, but funny I am working
backwards to learn PB 8 LOL!

Thanks Again,
Larry S. Gibson (Shane)
Web Developer
________________________________
From: PowerObject@yahoogroups.com [mailto:PowerObject@yahoogroups.com] On Behalf
Of Olan Knight
Sent: Monday, November 16, 2009 5:00 PM
To: PowerObject@yahoogroups.com
Subject: [PowerObject] RE: How to call Itemchanged event #2



>> But the datawindow is a monster
Oh, yeah! The dw IS the power in PowerBuilder

Remember that dot notation does not mix with "standard" notation.

Dot Notation:
ls_text = String (dw.Object.<column name>.Text)
dw.Object.<column name>.Text = "Here I am"

Standard notation:
ls_text = dw.GetItemString (<row>, <column or object name>)
ll_rc = dw.SetItem (<row>, <column>, <string value>)

Later -

Olan

-----Original Message-----

Thank you OLAN,
Yes I will admit I skipped most of the boring parts of the
tutorials for the static items such as sle's and static text labels
seemed very similar to other langauges, I have being using the online
help as well it is a blessing (When working on asp.net I live in the
MSDN), But the datawindow is a monster I have yet to conquer, I am
almost positive it is a database column, but when I tried the
dw.GetItemString I got an error but I may have had something like
dw_1.object.textbox1.GetText(); instead I will try with your code! Thank
you for being so willing to help me OLAN!

Thanks Again,
Larry S. Gibson (Shane)
Web Developer
________________________________

Test displayed on a dw can be "static text", a database column, an SLE
field, or an MLE field.

Static text is accessed as follows: <field name>.text.
ls_old_text = st_label.Text
st_label.Text = "New Label"

Database columns are accessed with the Get and Set statements:
ll_rc = dw.GetItemString (ll_row, "column_name")
ll_rc = dw.SetItem (ll_row, "label_field", "New Label")

SLE and MLEs are access like static tecxt field using the TEXT attribute
of the object.

Olan

-----Original Message-----

That is good to know, but I want to pull the value out of that textbox
field that is currently part of the DataWindow, I explain more I have a
window object with a DataWindow placed on it inside the DataWindow is a
text object (it's not a sle_textbox), when the window object is opened
the text object inside the DataWindow pulls a date value into it from
somewhere (not sure where yet), but also it has a drop down calendar
that you can select a new date from, I want to update a label text
object somewhere else in the window object based on the new date
selected from the calendar object that automatically updates the textbox
object in the DataWindow, my logic tells me that I need to grab the
current value of the textbox object in the item change event? But being
new to the DataWindow I am clueless of how to Get the Text / String
value from that field (also remember this transaction has not called an
update on the db yet which is done by button click in the window
object)? Hope t
his helps you help me LOL! Thanks Olan! Also if there is any quick and
simple tutorials out there on the DataWindow itself I could use some
more practice with this object!

Larry S. Gibson (Shane)
Web Developer
________________________________

Shane -

The third parameter in the ItemChanged event for any dw is "data",
and it refers to the data entered by the user onto the datawindow; i.e.
anything the user can type or select from a dropdown is passed as a
string in this parameter. If that value is interger data, you will need
to convert it from a string back into an integer if you wish to
manipulate it.

Or am I not understanding the question?

Olan

-----Original Message-----

Hello,

Have a question, new to the coding on the dw object! In a
asp.net web app I would typically call this statement Variable_1 =
textbox.value.ToString(); to get the current value of a textbox but in
the dw what looks like a textbox is not really a textbox so how do I get
the value of this object like I would asp.net to set it to a variable?(I
want this to happen on the item change event or focus change event)
Using PB 8

Larry S. Gibson (Shane)

Web Developer

________________________________

Dear Olan Knight

Thanks a lot for the help.

The code worked and my issues are solving.

Best of Luck

Thanks and Regards

Jerin

--- On Thu, 11/12/09, Olan Knight
<Olan.Knight@...<mailto:Olan.Knight%40intecbilling.com><mailto:Olan\
.Knight%40intecbilling.com><mai
lto:Olan.Knight%40intecbilling.com><mai
lto:Olan.Knight%40intecbilling.com>>
wrote:

Well, you can do this if you must, but the preferred way is to put

common code into a function and have both the button and the ItemChanged

event call the function when required.

You can call any PB event via script using the EVENT or the POST EVENT

calls, but you will need to create all of the required parameters for

the event and pass them just like you would for any function or event

call.

row = a numeric value; perhaps dw.GetRow ()

ldwo = the column object. Say the column was named "emr_juris_ind" ,
then

you would use

dot notation to create a column object; Example: ldwo =

this.Object. emr_juris_ ind

data = the new data, in string format, that you wish to place into the

column listed above

// Call the ItemChanged event

parent.EVENT ItemChanged (row, ldwo, data)

-----Original Message-----

Hi All,

I need a help on how to call datawindow events.

I need to call Itemchanged event from a button click. Arguments passed

will be (row, dataobject, data).

can triggerevent be used for it.

Regards

Jerin

This e-mail and any attachments are confidential and may also be legally
privileged and/or copyright material of Intec Telecom Systems PLC (or its
affiliated companies). If you are not an intended or authorised recipient
of this e-mail or have received it in error, please delete it immediately
and notify the sender by e-mail. In such a case, reading, reproducing,
printing or further dissemination of this e-mail or its contents is strictly
prohibited and may be unlawful.
Intec Telecom Systems PLC does not represent or warrant that an attachment
hereto is free from computer viruses or other defects. The opinions
expressed in this e-mail and any attachments may be those of the author and
are not necessarily those of Intec Telecom Systems PLC.



[Non-text portions of this message have been removed]

Hi, I am storing some information from image files on a DB, like the reference
path to the file, tittle, file size.. I am not storing the image file itself
like a blob eventough I migth do that in a future.

I also need to get the image width and heigth to be able to store them on the DB
also and do some later work with that info..

but I don't know how to get that information (width and heigth), can someone
help me and give me a clue how to obtain width and height of the image, without
actually displaying the image..

Using PB 11.5 and MySql DB..

Thanks

If the object that contains the image file is in PowerBuilder you can
use dot notation OR the Describe syntax to get the required information:

<DW Control Name>.Describe("<BitMapname>.Width")
or
<DW Control Name>.Object.<BitMapname>.Width

for InkPicture controls:
<DW Control Name>.Describe("<InkPicturename>.Ink.Width")
or
<DW Control Name>.Object.<InkPicturename>.Ink.Width

For non-PowerBuilder controls, put a wrapper around the "
JPGSizeExtractor" Java class:
http://www.anttikupila.com/flash/getting-jpg-dimensions-with-as3-without
-loading-the-entire-file/


____________________________________________________

OLAN KNIGHT
LEAD PROGRAMMER/ANALYST OF TECHNICAL SERVICES
OFFICE: 404-705-3291 | MOBILE: 972-979-8753
EMAIL:  Olan.Knight@...| www.intecbilling.com


-----Original Message-----

Hi, I am storing some information from image files on a DB, like the
reference path to the file, tittle, file size.. I am not storing the
image file itself like a blob eventough I migth do that in a future.

I also need to get the image width and heigth to be able to store them
on the DB also and do some later work with that info..

but I don't know how to get that information (width and heigth), can
someone help me and give me a clue how to obtain width and height of the
image, without actually displaying the image..

Using PB 11.5 and MySql DB..

Thanks

This e-mail and any attachments are confidential and may also be legally
privileged and/or copyright material of Intec Telecom Systems PLC (or its
affiliated companies). If you are not an intended or authorised recipient
of this e-mail or have received it in error, please delete it immediately
and notify the sender by e-mail. In such a case, reading, reproducing,
printing or further dissemination of this e-mail or its contents is strictly
prohibited and may be unlawful.
Intec Telecom Systems PLC does not represent or warrant that an attachment
hereto is free from computer viruses or other defects. The opinions
expressed in this e-mail and any attachments may be those of the author and
are not necessarily those of Intec Telecom Systems PLC.

Okay got lost again!!
What's the purpose of this code block? I know everything in "qt" are columns and
dw_1 is the DataWindow but what is the of_Register() function doing? It is
happening on the window object open() function? Is it pull the values out of the
database and preloading the calendar.ddlb_witharrow with this value and
registering the object with the DataWindow?

// Setup calendar controls
dw_1.of_SetDropDownCalendar(TRUE)
dw_1.iuo_calendar.of_Register("received_date", dw_1.iuo_calendar.ddlb_witharrow)
dw_1.iuo_calendar.of_Register("received_inventory_date",
dw_1.iuo_calendar.ddlb_witharrow)
dw_1.iuo_calendar.of_Register("late_report_date",
dw_1.iuo_calendar.ddlb_witharrow)
dw_1.iuo_calendar.of_Register("late_inventory_date",
dw_1.iuo_calendar.ddlb_witharrow)
dw_1.iuo_calendar.of_Register("report_period", dw_1.iuo_calendar.ddlb_witharrow)
dw_1.iuo_calendar.of_Register("report_period_end_date",
dw_1.iuo_calendar.ddlb_witharrow)


Thanks,
Larry S. Gibson (Shane)
Web Developer
________________________________
From: PowerObject@yahoogroups.com [mailto:PowerObject@yahoogroups.com] On Behalf
Of Gibson, Shane
Sent: Tuesday, November 17, 2009 6:40 AM
To: PowerObject@yahoogroups.com
Subject: [PowerObject] RE: How to call Itemchanged event #2



Thanks Again OLAN. I appreciate those who help for free! I try to help out
sometimes with .net questions in the ASP.NET groups, but funny I am working
backwards to learn PB 8 LOL!

Thanks Again,
Larry S. Gibson (Shane)
Web Developer
________________________________
From: PowerObject@yahoogroups.com<mailto:PowerObject%40yahoogroups.com>
[mailto:PowerObject@yahoogroups.com<mailto:PowerObject%40yahoogroups.com>] On
Behalf Of Olan Knight
Sent: Monday, November 16, 2009 5:00 PM
To: PowerObject@yahoogroups.com<mailto:PowerObject%40yahoogroups.com>
Subject: [PowerObject] RE: How to call Itemchanged event #2

>> But the datawindow is a monster
Oh, yeah! The dw IS the power in PowerBuilder

Remember that dot notation does not mix with "standard" notation.

Dot Notation:
ls_text = String (dw.Object.<column name>.Text)
dw.Object.<column name>.Text = "Here I am"

Standard notation:
ls_text = dw.GetItemString (<row>, <column or object name>)
ll_rc = dw.SetItem (<row>, <column>, <string value>)

Later -

Olan

-----Original Message-----

Thank you OLAN,
Yes I will admit I skipped most of the boring parts of the
tutorials for the static items such as sle's and static text labels
seemed very similar to other langauges, I have being using the online
help as well it is a blessing (When working on asp.net I live in the
MSDN), But the datawindow is a monster I have yet to conquer, I am
almost positive it is a database column, but when I tried the
dw.GetItemString I got an error but I may have had something like
dw_1.object.textbox1.GetText(); instead I will try with your code! Thank
you for being so willing to help me OLAN!

Thanks Again,
Larry S. Gibson (Shane)
Web Developer
________________________________

Test displayed on a dw can be "static text", a database column, an SLE
field, or an MLE field.

Static text is accessed as follows: <field name>.text.
ls_old_text = st_label.Text
st_label.Text = "New Label"

Database columns are accessed with the Get and Set statements:
ll_rc = dw.GetItemString (ll_row, "column_name")
ll_rc = dw.SetItem (ll_row, "label_field", "New Label")

SLE and MLEs are access like static tecxt field using the TEXT attribute
of the object.

Olan

-----Original Message-----

That is good to know, but I want to pull the value out of that textbox
field that is currently part of the DataWindow, I explain more I have a
window object with a DataWindow placed on it inside the DataWindow is a
text object (it's not a sle_textbox), when the window object is opened
the text object inside the DataWindow pulls a date value into it from
somewhere (not sure where yet), but also it has a drop down calendar
that you can select a new date from, I want to update a label text
object somewhere else in the window object based on the new date
selected from the calendar object that automatically updates the textbox
object in the DataWindow, my logic tells me that I need to grab the
current value of the textbox object in the item change event? But being
new to the DataWindow I am clueless of how to Get the Text / String
value from that field (also remember this transaction has not called an
update on the db yet which is done by button click in the window
object)? Hope t
his helps you help me LOL! Thanks Olan! Also if there is any quick and
simple tutorials out there on the DataWindow itself I could use some
more practice with this object!

Larry S. Gibson (Shane)
Web Developer
________________________________

Shane -

The third parameter in the ItemChanged event for any dw is "data",
and it refers to the data entered by the user onto the datawindow; i.e.
anything the user can type or select from a dropdown is passed as a
string in this parameter. If that value is interger data, you will need
to convert it from a string back into an integer if you wish to
manipulate it.

Or am I not understanding the question?

Olan

-----Original Message-----

Hello,

Have a question, new to the coding on the dw object! In a
asp.net web app I would typically call this statement Variable_1 =
textbox.value.ToString(); to get the current value of a textbox but in
the dw what looks like a textbox is not really a textbox so how do I get
the value of this object like I would asp.net to set it to a variable?(I
want this to happen on the item change event or focus change event)
Using PB 8

Larry S. Gibson (Shane)

Web Developer

________________________________

Dear Olan Knight

Thanks a lot for the help.

The code worked and my issues are solving.

Best of Luck

Thanks and Regards

Jerin

--- On Thu, 11/12/09, Olan Knight
<Olan.Knight@...<mailto:Olan.Knight%40intecbilling.com><mailto:Olan\
.Knight%40intecbilling.com><mailto:Olan.Knight%40intecbilling.com><mai
lto:Olan.Knight%40intecbilling.com><mai
lto:Olan.Knight%40intecbilling.com>>
wrote:

Well, you can do this if you must, but the preferred way is to put

common code into a function and have both the button and the ItemChanged

event call the function when required.

You can call any PB event via script using the EVENT or the POST EVENT

calls, but you will need to create all of the required parameters for

the event and pass them just like you would for any function or event

call.

row = a numeric value; perhaps dw.GetRow ()

ldwo = the column object. Say the column was named "emr_juris_ind" ,
then

you would use

dot notation to create a column object; Example: ldwo =

this.Object. emr_juris_ ind

data = the new data, in string format, that you wish to place into the

column listed above

// Call the ItemChanged event

parent.EVENT ItemChanged (row, ldwo, data)

-----Original Message-----

Hi All,

I need a help on how to call datawindow events.

I need to call Itemchanged event from a button click. Arguments passed

will be (row, dataobject, data).

can triggerevent be used for it.

Regards

Jerin

This e-mail and any attachments are confidential and may also be legally
privileged and/or copyright material of Intec Telecom Systems PLC (or its
affiliated companies). If you are not an intended or authorised recipient
of this e-mail or have received it in error, please delete it immediately
and notify the sender by e-mail. In such a case, reading, reproducing,
printing or further dissemination of this e-mail or its contents is strictly
prohibited and may be unlawful.
Intec Telecom Systems PLC does not represent or warrant that an attachment
hereto is free from computer viruses or other defects. The opinions
expressed in this e-mail and any attachments may be those of the author and
are not necessarily those of Intec Telecom Systems PLC.

[Non-text portions of this message have been removed]



[Non-text portions of this message have been removed]

This code uses a pre-defined object in the PFC.

Look in the instance variables on the window for "iuo_calendar" and not
the object TYPE, which will almost certainly be "u_calendar".

Add the PFC HELP to your PowerBuilder PowerBar (the one across the top)
 	 Get to the Library Painter
	 Right click in the blank space in the row of toolbar (menu)
icons across the top of the screen
	 Select "Customize"
	 Ensure the PowerBar radio button is selected
	 Select an unused icon and drag it from the top into the bottom
"Current Toolbar" section
	 Add the following:
Comand Line:    winhlp32.exe C:\Program Files\Sybase\PowerBuilder
9\Help\pbpfc90.hlp
Item Text:   PFC Help
Item MicroHelp PFC Help

NOTE:  Your PBPFC HLP file will be named differently and in a slightly
different location. Find it before you start this and use the correct
path and file for the command line entry.

Now you can open up the PFC Help! When it opens for the first time,
click the radio button maximize the indexing.
Once that's done you can click on the FIND tabpage, enter "u_calendar"
into "1", select the bottom entry in "2", seelct the top "u_calendar"
entry in "3", then click DISPLAY.


Have Fun!

Olan


-----Original Message-----

Okay got lost again!!
What's the purpose of this code block? I know everything in "qt" are
columns and dw_1 is the DataWindow but what is the of_Register()
function doing? It is happening on the window object open() function? Is
it pull the values out of the database and preloading the
calendar.ddlb_witharrow with this value and registering the object with
the DataWindow?

// Setup calendar controls
dw_1.of_SetDropDownCalendar(TRUE)
dw_1.iuo_calendar.of_Register("received_date",
dw_1.iuo_calendar.ddlb_witharrow)
dw_1.iuo_calendar.of_Register("received_inventory_date",
dw_1.iuo_calendar.ddlb_witharrow)
dw_1.iuo_calendar.of_Register("late_report_date",
dw_1.iuo_calendar.ddlb_witharrow)
dw_1.iuo_calendar.of_Register("late_inventory_date",
dw_1.iuo_calendar.ddlb_witharrow)
dw_1.iuo_calendar.of_Register("report_period",
dw_1.iuo_calendar.ddlb_witharrow)
dw_1.iuo_calendar.of_Register("report_period_end_date",
dw_1.iuo_calendar.ddlb_witharrow)


Thanks,
Larry S. Gibson (Shane)
Web Developer

This e-mail and any attachments are confidential and may also be legally
privileged and/or copyright material of Intec Telecom Systems PLC (or its
affiliated companies). If you are not an intended or authorised recipient
of this e-mail or have received it in error, please delete it immediately
and notify the sender by e-mail. In such a case, reading, reproducing,
printing or further dissemination of this e-mail or its contents is strictly
prohibited and may be unlawful.
Intec Telecom Systems PLC does not represent or warrant that an attachment
hereto is free from computer viruses or other defects. The opinions
expressed in this e-mail and any attachments may be those of the author and
are not necessarily those of Intec Telecom Systems PLC.

Thank you OLAN once again a big help! I did find my problem to why I was having
so much trouble pulling the values, I was using getitemdate and needed to use
getitemdatetime! What thru me off was when I looked at the db I saw date as
datatype and did not stop to actually look at the data! Thanks for the tip on
the pfc help I bought a book specifically for this but I think I will get more
from what said in the long run thanks again!

Larry S. Gibson (Shane)
Web Developer
________________________________
From: PowerObject@yahoogroups.com [mailto:PowerObject@yahoogroups.com] On Behalf
Of Olan Knight
Sent: Tuesday, November 17, 2009 1:18 PM
To: PowerObject@yahoogroups.com
Subject: [PowerObject] RE: How to call Itemchanged event #3



This code uses a pre-defined object in the PFC.

Look in the instance variables on the window for "iuo_calendar" and not
the object TYPE, which will almost certainly be "u_calendar".

Add the PFC HELP to your PowerBuilder PowerBar (the one across the top)
Get to the Library Painter
Right click in the blank space in the row of toolbar (menu)
icons across the top of the screen
Select "Customize"
Ensure the PowerBar radio button is selected
Select an unused icon and drag it from the top into the bottom
"Current Toolbar" section
Add the following:
Comand Line: winhlp32.exe C:\Program Files\Sybase\PowerBuilder
9\Help\pbpfc90.hlp
Item Text: PFC Help
Item MicroHelp PFC Help

NOTE: Your PBPFC HLP file will be named differently and in a slightly
different location. Find it before you start this and use the correct
path and file for the command line entry.

Now you can open up the PFC Help! When it opens for the first time,
click the radio button maximize the indexing.
Once that's done you can click on the FIND tabpage, enter "u_calendar"
into "1", select the bottom entry in "2", seelct the top "u_calendar"
entry in "3", then click DISPLAY.

Have Fun!

Olan

-----Original Message-----

Okay got lost again!!
What's the purpose of this code block? I know everything in "qt" are
columns and dw_1 is the DataWindow but what is the of_Register()
function doing? It is happening on the window object open() function? Is
it pull the values out of the database and preloading the
calendar.ddlb_witharrow with this value and registering the object with
the DataWindow?

// Setup calendar controls
dw_1.of_SetDropDownCalendar(TRUE)
dw_1.iuo_calendar.of_Register("received_date",
dw_1.iuo_calendar.ddlb_witharrow)
dw_1.iuo_calendar.of_Register("received_inventory_date",
dw_1.iuo_calendar.ddlb_witharrow)
dw_1.iuo_calendar.of_Register("late_report_date",
dw_1.iuo_calendar.ddlb_witharrow)
dw_1.iuo_calendar.of_Register("late_inventory_date",
dw_1.iuo_calendar.ddlb_witharrow)
dw_1.iuo_calendar.of_Register("report_period",
dw_1.iuo_calendar.ddlb_witharrow)
dw_1.iuo_calendar.of_Register("report_period_end_date",
dw_1.iuo_calendar.ddlb_witharrow)

Thanks,
Larry S. Gibson (Shane)
Web Developer

This e-mail and any attachments are confidential and may also be legally
privileged and/or copyright material of Intec Telecom Systems PLC (or its
affiliated companies). If you are not an intended or authorised recipient
of this e-mail or have received it in error, please delete it immediately
and notify the sender by e-mail. In such a case, reading, reproducing,
printing or further dissemination of this e-mail or its contents is strictly
prohibited and may be unlawful.
Intec Telecom Systems PLC does not represent or warrant that an attachment
hereto is free from computer viruses or other defects. The opinions
expressed in this e-mail and any attachments may be those of the author and
are not necessarily those of Intec Telecom Systems PLC.



[Non-text portions of this message have been removed]

PB 11.2 Build 8669, Uses PFC, Oracle 10g

In a datawindow SLE with a lowered border and left-aligned text, the first
character is directly adjacent to the border with no intervening space.
This is unattractive and harder to read, particularly when the left side
of a sans-serif character is a vertical line that blends with the border
(B, D, E, F, etc). These fields are not display-only so I can't just
insert a space unless I'm willing to write code to handle it (which I'm
not). The data length is variable so center-aligning the fields is not an
attractive option. DDLB's and DDDW's are slightly indented and do not have
this problem. Can an SLE be formatted to provide an indent to left-aligned
text?

Thanks,
    Michael W. Bailey
    CSC Raytheon Missile Systems Account
    TIES Application Manager
    (520) 545-6496 - Office
    (520) 977-3914 - Cell
    mbailey5@...

[Non-text portions of this message have been removed]

A clarification to my earlier email.... The problem is with datawindow
edit columns (not SLE's).

Thanks,
    Michael W. Bailey
    CSC Raytheon Missile Systems Account
    TIES Application Manager
    mbailey5@...





[PowerObject] DW SLE text alignment

Michael W Bailey
to:
PowerObject
11/17/2009 03:44 PM


Sent by:
PowerObject@yahoogroups.com
Please respond to PowerObject






PB 11.2 Build 8669, Uses PFC, Oracle 10g

In a datawindow SLE with a lowered border and left-aligned text, the first

character is directly adjacent to the border with no intervening space.
This is unattractive and harder to read, particularly when the left side
of a sans-serif character is a vertical line that blends with the border
(B, D, E, F, etc). These fields are not display-only so I can't just
insert a space unless I'm willing to write code to handle it (which I'm
not). The data length is variable so center-aligning the fields is not an
attractive option. DDLB's and DDDW's are slightly indented and do not have

this problem. Can an SLE be formatted to provide an indent to left-aligned

text?

Thanks,
    Michael W. Bailey
    CSC Raytheon Missile Systems Account
    TIES Application Manager
    (520) 545-6496 - Office
    (520) 977-3914 - Cell
    mbailey5@...

[Non-text portions of this message have been removed]



------------------------------------

Yahoo! Groups Links






[Non-text portions of this message have been removed]

Fake it.

1. Create an SLE with no borders at all. Left-justify the SLE.
2. Create a BOX and format it to look like you wish: 3D Lowered sounds
right.
     Make the box slightly larger than the SLE.
     Set the BGColor to match the BGColor of the SLE.
3. Place the real SLE inside the BOX object
4. Set your taborders, and Voila!

Olan

-----Original Message-----

PB 11.2 Build 8669, Uses PFC, Oracle 10g

In a datawindow SLE with a lowered border and left-aligned text, the
first
character is directly adjacent to the border with no intervening space.
This is unattractive and harder to read, particularly when the left side

of a sans-serif character is a vertical line that blends with the border

(B, D, E, F, etc). These fields are not display-only so I can't just
insert a space unless I'm willing to write code to handle it (which I'm
not). The data length is variable so center-aligning the fields is not
an
attractive option. DDLB's and DDDW's are slightly indented and do not
have
this problem. Can an SLE be formatted to provide an indent to
left-aligned
text?

Thanks,
    Michael W. Bailey

This e-mail and any attachments are confidential and may also be legally
privileged and/or copyright material of Intec Telecom Systems PLC (or its
affiliated companies). If you are not an intended or authorised recipient
of this e-mail or have received it in error, please delete it immediately
and notify the sender by e-mail. In such a case, reading, reproducing,
printing or further dissemination of this e-mail or its contents is strictly
prohibited and may be unlawful.
Intec Telecom Systems PLC does not represent or warrant that an attachment
hereto is free from computer viruses or other defects. The opinions
expressed in this e-mail and any attachments may be those of the author and
are not necessarily those of Intec Telecom Systems PLC.

Thanks for the help Olan.

Thanks,
    Michael W. Bailey
    CSC Raytheon Missile Systems Account
    TIES Application Manager
    mbailey5@...





[PowerObject] RE: DW SLE text alignment

Olan Knight
to:
PowerObject
11/17/2009 04:52 PM


Sent by:
PowerObject@yahoogroups.com
Please respond to PowerObject






Fake it.

1. Create an SLE with no borders at all. Left-justify the SLE.
2. Create a BOX and format it to look like you wish: 3D Lowered sounds
right.
     Make the box slightly larger than the SLE.
     Set the BGColor to match the BGColor of the SLE.
3. Place the real SLE inside the BOX object
4. Set your taborders, and Voila!

Olan

-----Original Message-----

PB 11.2 Build 8669, Uses PFC, Oracle 10g

In a datawindow SLE with a lowered border and left-aligned text, the
first
character is directly adjacent to the border with no intervening space.
This is unattractive and harder to read, particularly when the left side

of a sans-serif character is a vertical line that blends with the border

(B, D, E, F, etc). These fields are not display-only so I can't just
insert a space unless I'm willing to write code to handle it (which I'm
not). The data length is variable so center-aligning the fields is not
an
attractive option. DDLB's and DDDW's are slightly indented and do not
have
this problem. Can an SLE be formatted to provide an indent to
left-aligned
text?

Thanks,
    Michael W. Bailey

This e-mail and any attachments are confidential and may also be legally
privileged and/or copyright material of Intec Telecom Systems PLC (or its
affiliated companies). If you are not an intended or authorised recipient
of this e-mail or have received it in error, please delete it immediately
and notify the sender by e-mail. In such a case, reading, reproducing,
printing or further dissemination of this e-mail or its contents is
strictly
prohibited and may be unlawful.
Intec Telecom Systems PLC does not represent or warrant that an attachment
hereto is free from computer viruses or other defects. The opinions
expressed in this e-mail and any attachments may be those of the author
and
are not necessarily those of Intec Telecom Systems PLC.


------------------------------------

Yahoo! Groups Links






[Non-text portions of this message have been removed]

Dear All,
I'am using power builder 11.5. In webform setting focus
to a column in datawindow is not working.
My script is
dw_1.SetColumn('box_id')
dw_1.SetFocus()


Also datawindow print is not working
My script is
dw_1.print()


Regards
Pratheep John
Emirates Post,Dubai

Hi...

Print should work at least for creating pdf files. Setfocus is listed in
the unsupported functions for datawindow in webform applications!

So use of setfocus has no sense in web forms applications. As for print
you can use it to create .pdf files. All information previously
mentioned is documented in help files!

Andreas.

PRATHEEP JOHN wrote:
>
> Dear All,
> I'am using power builder 11.5. In webform setting focus
> to a column in datawindow is not working.
> My script is
> dw_1.SetColumn('box_id')
> dw_1.SetFocus()
>
> Also datawindow print is not working
> My script is
> dw_1.print()
>
> Regards
> Pratheep John
> Emirates Post,Dubai
>
>



[Non-text portions of this message have been removed]

Dear Andreas,
Thanks for the reply,
what is the alternative way to set focus to a column in a datawindow(webform)

Regards
Pratheep John

--- In PowerObject@yahoogroups.com, Andre Mykonio <amykonio@...> wrote:
>
>
> Hi...
>
> Print should work at least for creating pdf files. Setfocus is listed in
> the unsupported functions for datawindow in webform applications!
>
> So use of setfocus has no sense in web forms applications. As for print
> you can use it to create .pdf files. All information previously
> mentioned is documented in help files!
>
> Andreas.
>
> PRATHEEP JOHN wrote:
> >
> > Dear All,
> > I'am using power builder 11.5. In webform setting focus
> > to a column in datawindow is not working.
> > My script is
> > dw_1.SetColumn('box_id')
> > dw_1.SetFocus()
> >
> > Also datawindow print is not working
> > My script is
> > dw_1.print()
> >
> > Regards
> > Pratheep John
> > Emirates Post,Dubai
> >
> >
>
>
>
> [Non-text portions of this message have been removed]
>

I think there is no alternative... I will do some research, but until
now I can't provide you more information...

I think that you should know that webform application from pb have a lot
of problems. First of all they run only in Internet Explorer...
Officially there is no announcement for changes concerning webform
development. But I think that plans made by Sybase do not include any
further development of webform targets... In powerbuilder 12.0 this part
of powerbuilder will be the same as in powerbuilder 11.5. Only WPF
support will be added within Powerbuilder.NET, the new IDE. The existing
IDE which will be renamed to Powerbuilder Classic will remain the same
with small improvements (concerning database support).

I mention all that because development equals investment, and I'm not
sure what kind of investment we are doing when choosing to develop
webform applications. I don't criticise you. I also have some small
app's developed in webforms in which I'm making improvements.

If i find anything concerning setfocus (some workaround), i'll post it.

Andreas Mykonios.

O/H PRATHEEP JOHN ??????:
>
>
> Dear Andreas,
> Thanks for the reply,
> what is the alternative way to set focus to a column in a
> datawindow(webform)
>
> Regards
> Pratheep John
>
> --- In PowerObject@yahoogroups.com
> <mailto:PowerObject%40yahoogroups.com>, Andre Mykonio <amykonio@...>
> wrote:
> >
> >
> > Hi...
> >
> > Print should work at least for creating pdf files. Setfocus is
> listed in
> > the unsupported functions for datawindow in webform applications!
> >
> > So use of setfocus has no sense in web forms applications. As for print
> > you can use it to create .pdf files. All information previously
> > mentioned is documented in help files!
> >
> > Andreas.
> >
> > PRATHEEP JOHN wrote:
> > >
> > > Dear All,
> > > I'am using power builder 11.5. In webform setting focus
> > > to a column in datawindow is not working.
> > > My script is
> > > dw_1.SetColumn('box_id')
> > > dw_1.SetFocus()
> > >
> > > Also datawindow print is not working
> > > My script is
> > > dw_1.print()
> > >
> > > Regards
> > > Pratheep John
> > > Emirates Post,Dubai
> > >
> > >
> >
> >
> >
> > [Non-text portions of this message have been removed]
> >
>
>



[Non-text portions of this message have been removed]

Hello,

I want an entire application (developed using PB 6.5) to be ported to web
faster.  What will be best option?

Happiness Always
BKR Shivaprakkash

The fastest option is to use Citrix that allows web users to run Client/Server
application directly from your web site.

From: PowerObject@yahoogroups.com [mailto:PowerObject@yahoogroups.com] On Behalf
Of sivakrith
Sent: Monday, November 23, 2009 9:54 AM
To: PowerObject@yahoogroups.com
Subject: [PowerObject] Re: Best way to port PB 6.5 application to Web



Hello,

I want an entire application (developed using PB 6.5) to be ported to web
faster. What will be best option?

Happiness Always
BKR Shivaprakkash



[Non-text portions of this message have been removed]

Hi All,



I think the better solution than WebForm is Appeon for .NET, which supports more
PB features (up to 95%) and offers superior Web
performance. FYI, Sybase is also the worldwide partner of Appeon. They sell and
market Appeon globally. If this is not really a good
product and can do what Sybase cannot do, Sybase won't be partner of us and sell
our product.



Appeon for .NET supports all the features you mentioned here such as SetFocus,
datawindow.print. Also we make plans for enhancing
the product, for example, we are going to support FireFox next year and extend
the Java application support to JBoss, which is an
open source server. Also we will support more PB features and provide more web
features.  Since development equals investment, why
not develop your web application with a real efficient tool and in a mature
platform.



Feel free to contact me at sally.li@... if you want to try Appeon for
.NET.



Regards,

Sally Li

http://www.appeon.com/images/sig_line.gif

Appeon Corporation
Sally Li
Account Manager
Direct Line: 1-877-3APPEON x626
Email: sally.li@...

   _____

From: PowerObject@yahoogroups.com [mailto:PowerObject@yahoogroups.com] On Behalf
Of Andre Mykonio
Sent: Monday, November 23, 2009 10:34 PM
To: PowerObject@yahoogroups.com
Subject: Re: [PowerObject] Re: Set Focus and datawindow print is not working in
WebForm





I think there is no alternative... I will do some research, but until
now I can't provide you more information...

I think that you should know that webform application from pb have a lot
of problems. First of all they run only in Internet Explorer...
Officially there is no announcement for changes concerning webform
development. But I think that plans made by Sybase do not include any
further development of webform targets... In powerbuilder 12.0 this part
of powerbuilder will be the same as in powerbuilder 11.5. Only WPF
support will be added within Powerbuilder.NET, the new IDE. The existing
IDE which will be renamed to Powerbuilder Classic will remain the same
with small improvements (concerning database support).

I mention all that because development equals investment, and I'm not
sure what kind of investment we are doing when choosing to develop
webform applications. I don't criticise you. I also have some small
app's developed in webforms in which I'm making improvements.

If i find anything concerning setfocus (some workaround), i'll post it.

Andreas Mykonios.

O/H PRATHEEP JOHN ??????:
>
>
> Dear Andreas,
> Thanks for the reply,
> what is the alternative way to set focus to a column in a
> datawindow(webform)
>
> Regards
> Pratheep John
>
> --- In PowerObject@ <mailto:PowerObject%40yahoogroups.com> yahoogroups.com
> <mailto:PowerObject%40yahoogroups.com>, Andre Mykonio <amykonio@...>
> wrote:
> >
> >
> > Hi...
> >
> > Print should work at least for creating pdf files. Setfocus is
> listed in
> > the unsupported functions for datawindow in webform applications!
> >
> > So use of setfocus has no sense in web forms applications. As for print
> > you can use it to create .pdf files. All information previously
> > mentioned is documented in help files!
> >
> > Andreas.
> >
> > PRATHEEP JOHN wrote:
> > >
> > > Dear All,
> > > I'am using power builder 11.5. In webform setting focus
> > > to a column in datawindow is not working.
> > > My script is
> > > dw_1.SetColumn('box_id')
> > > dw_1.SetFocus()
> > >
> > > Also datawindow print is not working
> > > My script is
> > > dw_1.print()
> > >
> > > Regards
> > > Pratheep John
> > > Emirates Post,Dubai
> > >
> > >
> >
> >
> >
> > [Non-text portions of this message have been removed]
> >
>
>

[Non-text portions of this message have been removed]





[Non-text portions of this message have been removed]