Datawindow's Date argument with PowerBuilder 8.0.1 and Oracle 9i 9.2.0.1
Hi, there: Does anybody know how to pass datetime type data from client side to server side in the datawindow? Can anybody recommend a good book about how PowerBuilder deals with Oracle, datawindow, embedded SQL? Thanks in advance.
|
0 |
|
sybase
6/4/2003 2:01:13 PM
sybase.powerbuilder.database
9855 articles. 
2 followers.
2 Replies
1532 Views
PB DateTime data type corresponds to the Oracle Date type. You can set a DateTime variable using constants, or use the Date function to make a Date from mm, dd, yy and DateTime function to convert it. What are you not finding in the PB help and online books? "sybase.working" <sybase.working@yahoomail.com> wrote in message news:eYBQOJqKDHA.345@forums-1-dub... > Hi, there: > > > Does anybody know how to pass datetime type data from client side to server > side in the datawindow? Can anybody recommend a good book about how > PowerBuilder deals with Oracle, datawindow, embedded SQL? Thanks in advance. > >
|
|
0 |
|
Jerry
6/4/2003 2:41:42 PM
Check out the upcoming pb9 book at http://www.pb9books.com. It has a complete chapter devoted to Oracle, although nothing specific about dealing with datetimes. -- Terry Dykstra (TeamSybase) Please state PB / OS / DB versions in your post. SDN: http://www.sybase.com/developer/ http://www.pb9books.com "Jerry Siegel" <jerry@data-sci.com.nospam> wrote in message news:uTGKxfqKDHA.280@forums-1-dub... > PB DateTime data type corresponds to the Oracle Date type. You can set a > DateTime variable using constants, or use the Date function to make a Date > from mm, dd, yy and DateTime function to convert it. > What are you not finding in the PB help and online books? > "sybase.working" <sybase.working@yahoomail.com> wrote in message > news:eYBQOJqKDHA.345@forums-1-dub... > > Hi, there: > > > > > > Does anybody know how to pass datetime type data from client side to > server > > side in the datawindow? Can anybody recommend a good book about how > > PowerBuilder deals with Oracle, datawindow, embedded SQL? Thanks in > advance. > > > > > >
|
|
0 |
|
Terry
6/5/2003 3:07:26 AM
Similar Artilces:
Move from Oracle 8.1.7 to 9.2.0.1 on PowerBuilder 8
Hello, We are currently using PowerBuilder 8.0.1 build 9056 on Oracle 8.1.7 A customer of ours wants to move to Oracle 9.2.0.1. The document on the link below describes the compatibility between PowerBuilder and Oracle. http://www.sybase.com/detail?id=1011566 PowerBuilder 8 : Oracle 9.2 -> pbo9080.dll -> Oracle 9.2 new features are not supported with this driver. Requires build 10501 or later. Requires Oracle patch set 9.2.0.4 or patch set 9.2.0.3 with patch 2. PowerBuilder 9 : Oracle 9.2 -> pbo9090.dll -> Oracle 9.2 new features are not supported with this d...
Move from Oracle 8.1.7 to 9.2.0.1 on PowerBuilder 8
Please see my question below ------------------------------- From: "Bruce Armstrong [TeamSybase]" <NOCANSPAM_bruce.armstrong@teamsybase.com> Subject: Re: Move from Oracle 8.1.7 to 9.2.0.1 on PowerBuilder 8 Date: woensdag 3 november 2004 15:05 This is a good question for the database section. On 3 Nov 2004 04:09:22 -0800, "Frederic Hoornaert" <Frederic.Hoornaert@transics.nospam.com> wrote: >Hello, > >We are currently using PowerBuilder 8.0.1 build 9056 on Oracle 8.1.7 >A customer of ours wants to move to Oracle 9.2.0.1. > >Th...
Make error: DBD-Oracle-1.14 , DBI-1.39, Oracle rdbms 9.2.0.0.0 , solaris 9
------=_NextPart_000_0025_01C3BE5A.4F6A0C70 Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: 7bit Hi, When I make DBD-Oracle 1.14 , Makefile.PL generates a Makefile with "-o build" in the compiler string before blib/arch/auto/DBD/Oracle/Oracle.so and prevents Oracle.so from being built correctly. demo_rdbms.mk appears to be to supplying this: Attempting to discover Oracle OCI build rules^M gcc -B/usr/ccs/bin/ -c DBD_ORA_OBJ.c^M by executing: (make -f /export/home/oracle/ora9idbms/rdbms/demo/demo_rdbms.mk bu ild ECHODO=echo EC...
Updates after 1.5.0.7 (1.5.0.9, 2.0.0.1)can't access the web.
Name: Jay Product: Firefox Summary: Updates after 1.5.0.7 (1.5.0.9, 2.0.0.1)can't access the web. Comments: see summary Browser Details: Mozilla/5.0 (Windows; U; Windows NT 5.1; en-US; rv:1.8.0.7) Gecko/20060909 Firefox/1.5.0.7 ...
EAServer 5.3.0, Oracle 8.1.7 Database with Oracle 10.1.0.2 client VARCHAR2(4000) problem
Hello! I'm having some problems in this configuration on Windows XP. I am developing websites on an Oracle database (8.1.7), with EAServer 5.3.0 (build 53016), Java objects using JSP as a front end. Here is my problem, I have a table with 2 VARCHAR2(4000), and when I access the webpage, the they are displayed as '?????????????'. If I debug the PB component, when I affect the DW field to a variable, it displays it as it doesn't "understand" a thing (each character is replaced by a square). The codeset of EAServer is UTF8, and on my client, it is AM...
superreview requested: [Bug 362139] bump SeaMonkey versions to 1.0.7/1.1 on 1.8.0/1.8 branches, localeVersion to 1.8.1 on 1.8 branch : [Attachment 246921] 1.8.0 patch: SeaMonkey version -> 1.0.7
Robert Kaiser <kairo@kairo.at> has asked neil@parkwaycc.co.uk <neil@httl.net> for superreview: Bug 362139: bump SeaMonkey versions to 1.0.7/1.1 on 1.8.0/1.8 branches, localeVersion to 1.8.1 on 1.8 branch https://bugzilla.mozilla.org/show_bug.cgi?id=362139 Attachment 246921: 1.8.0 patch: SeaMonkey version -> 1.0.7 https://bugzilla.mozilla.org/attachment.cgi?id=246921&action=edit ------- Additional Comments from Robert Kaiser <kairo@kairo.at> This is the 1.8.0 branch patch for bumping SeaMonkey version to 1.0.7 ...
superreview granted: [Bug 362139] bump SeaMonkey versions to 1.0.7/1.1 on 1.8.0/1.8 branches, localeVersion to 1.8.1 on 1.8 branch : [Attachment 246921] 1.8.0 patch: SeaMonkey version -> 1.0.7
neil@parkwaycc.co.uk <neil@httl.net> has granted Robert Kaiser <kairo@kairo.at>'s request for superreview: Bug 362139: bump SeaMonkey versions to 1.0.7/1.1 on 1.8.0/1.8 branches, localeVersion to 1.8.1 on 1.8 branch https://bugzilla.mozilla.org/show_bug.cgi?id=362139 Attachment 246921: 1.8.0 patch: SeaMonkey version -> 1.0.7 https://bugzilla.mozilla.org/attachment.cgi?id=246921&action=edit ...
Firefox 1.5.0.9, Firefox 2.0.0.1 and Thunderbird 1.5.0.9 Security & Stability Updates
As part of Mozilla Corporation�s ongoing stability and security update process, Firefox 1.5.0.9, Firefox 2.0.0.1 and Thunderbird 1.5.0.9 are now available for Windows, Mac, and Linux for free download from getfirefox.com (http://www.getfirefox.com) & getthunderbird.com (http://www.getthunderbird.com). We strongly recommend that all Firefox users upgrade to this latest release. This update is available immediately in 41 languages including Spanish, Japanese, Arabic, Hungarian and more. Note: Firefox 1.5.0.x will be maintained with security and stability updates until Apr...
Firefox 1.5.0.9, Firefox 2.0.0.1 and Thunderbird 1.5.0.9 Security & Stability Updates
As part of Mozilla Corporation�s ongoing stability and security update process, Firefox 1.5.0.9, Firefox 2.0.0.1 and Thunderbird 1.5.0.9 are now available for Windows, Mac, and Linux for free download from getfirefox.com (http://www.getfirefox.com) & getthunderbird.com (http://www.getthunderbird.com). We strongly recommend that all Firefox users upgrade to this latest release. This update is available immediately in 41 languages including Spanish, Japanese, Arabic, Hungarian and more. Note: Firefox 1.5.0.x will be maintained with security and stability updates until Apr...
D.O.S. with Groupwise Messenger 1.0.1, 1.0.2 and 1.0.3
I reported this in the Groupwise Mesenger forum to no avail. I'll try my luck here :-) If you run a 'snmpwalk' on a Netware server running Groupwise Messenger V1.0.1 to V1.0.3) with _MESSENGER_ SNMP enabled, it will abend the server. With version 1.0.2 and 1.0.3, if you disable the Messenger SNMP, server won't abend but will only report SNMP info for Netware (and Groupwise if loaded and SNMP enabled). Can be easily tested by running the win32 snmpwalk from http://www.bradford-sw.com/board/board.cgi?id=BSI_Tools&action=download&gul=13 like this : snmpwal...
Compile problems: Solaris 8, DBD-Oracle1.14, Oracle 9.2.0.1.0, Perl 5.8.0
Hi all, I'm having problems getting the make process go through. The platform is Solaris 8 on 64-bit Sparc, Oracle is 64-bit 9.2.0.1.0 and Perl is the latest package from sunfreeware, DBI is 1.35. First hurdle is to get make to link with the 32 bit libraries, but I managed to fix this. The next one is rather unclear to me, though... The tail of the output from make: Running Mkbootstrap for DBD::Oracle () chmod 644 Oracle.bs rm -f blib/arch/auto/DBD/Oracle/Oracle.so LD_RUN_PATH="/disk/oracle/product/920/lib32:/disk/oracle/product/920/rdbms/lib32" gcc -B/usr/c...
Does ODAC 9.2.0.7.0 work with Oracle database version 9i 9.2.0.6.0 using VS2005?
I am using VS2005 and need to connect to an Oracle database. The Oracle database version is Oracle 9i 9.2.0.6.0 I have taken a look at the Oracle site (http://www.oracle.com/technology/software/tech/windows/odpnet/index.html). I can download the Oracle Data Access Component - Oracle9i Release 2 ODAC 9.2.0.7.0, but will this work with our current Oracle database version 9i 9.2.0.6.0 ? Any help appreciated. Regards, Paul. Apsolutely.Install it, it will work w/o problems. Regards,Dejan VesićMCAD for .Net technologies | http://www.vesic.org/english/ | Blog: http://www.vesic.org...
Powerbuilder 8 / Oracle 8.1.7.0.0 error
When I run my PB 8 build 9506 application using Oracle 8.1.7.0.0 client, I get the following error. If I use Oracle 8.0.5 client, it works. Please advise as I need to be on Oracle 8i. Number 3120 Select error: ORA-03120: two-task conversion routine: integer overflow What version of Oracle is the server? Perhaps it's an Oracle bug. On 10 Sep 2003 06:42:55 -0700, Marsha Jacobs wrote: >When I run my PB 8 build 9506 application using Oracle >8.1.7.0.0 client, I get the following error. If I use Oracle >8.0.5 client, it works. Please advise as I need to be on >Oracl...
Compile problems: Solaris 8, DBD-Oracle1.14, Oracle 9.2.0.1.0, Pe rl 5.8.0
> I ran into this same problem while trying to do a "make" while installing > DBD::Oracle 1.14 on Solaris 8 (64-bit) with Oracle 9.2.0.3.0 and Perl 5.8. > After seeing "ld: warning: option -o appears more than once, first setting > taken", I decided to try and delete all instances of "-o build" from the > Makefile so that I'd be left with just a "-o > blib/arch/auto/DBD/Oracle/Oracle.so" since Oracle.so was the file that it > seemed to be looking for. This allowed me to finish the make and go on > to successfully make...
Hello, We are currently using PowerBuilder 8.0.1 build 9056 on Oracle 8.1.7 A customer of ours wants to move to Oracle 9.2.0.1. The document on the link below describes the compatibility between PowerBuilder and Oracle. http://www.sybase.com/detail?id=1011566 PowerBuilder 8 : Oracle 9.2 -> pbo9080.dll -> Oracle 9.2 new features are not supported with this driver. Requires build 10501 or later. Requires Oracle patch set 9.2.0.4 or patch set 9.2.0.3 with patch 2. PowerBuilder 9 : Oracle 9.2 -> pbo9090.dll -> Oracle 9.2 new features are not supported with this d...
Move from Oracle 8.1.7 to 9.2.0.1 on PowerBuilder 8
Please see my question below ------------------------------- From: "Bruce Armstrong [TeamSybase]" <NOCANSPAM_bruce.armstrong@teamsybase.com> Subject: Re: Move from Oracle 8.1.7 to 9.2.0.1 on PowerBuilder 8 Date: woensdag 3 november 2004 15:05 This is a good question for the database section. On 3 Nov 2004 04:09:22 -0800, "Frederic Hoornaert" <Frederic.Hoornaert@transics.nospam.com> wrote: >Hello, > >We are currently using PowerBuilder 8.0.1 build 9056 on Oracle 8.1.7 >A customer of ours wants to move to Oracle 9.2.0.1. > >Th...
Make error: DBD-Oracle-1.14 , DBI-1.39, Oracle rdbms 9.2.0.0.0 , solaris 9
------=_NextPart_000_0025_01C3BE5A.4F6A0C70 Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: 7bit Hi, When I make DBD-Oracle 1.14 , Makefile.PL generates a Makefile with "-o build" in the compiler string before blib/arch/auto/DBD/Oracle/Oracle.so and prevents Oracle.so from being built correctly. demo_rdbms.mk appears to be to supplying this: Attempting to discover Oracle OCI build rules^M gcc -B/usr/ccs/bin/ -c DBD_ORA_OBJ.c^M by executing: (make -f /export/home/oracle/ora9idbms/rdbms/demo/demo_rdbms.mk bu ild ECHODO=echo EC...
Updates after 1.5.0.7 (1.5.0.9, 2.0.0.1)can't access the web.
Name: Jay Product: Firefox Summary: Updates after 1.5.0.7 (1.5.0.9, 2.0.0.1)can't access the web. Comments: see summary Browser Details: Mozilla/5.0 (Windows; U; Windows NT 5.1; en-US; rv:1.8.0.7) Gecko/20060909 Firefox/1.5.0.7 ...
EAServer 5.3.0, Oracle 8.1.7 Database with Oracle 10.1.0.2 client VARCHAR2(4000) problem
Hello! I'm having some problems in this configuration on Windows XP. I am developing websites on an Oracle database (8.1.7), with EAServer 5.3.0 (build 53016), Java objects using JSP as a front end. Here is my problem, I have a table with 2 VARCHAR2(4000), and when I access the webpage, the they are displayed as '?????????????'. If I debug the PB component, when I affect the DW field to a variable, it displays it as it doesn't "understand" a thing (each character is replaced by a square). The codeset of EAServer is UTF8, and on my client, it is AM...
superreview requested: [Bug 362139] bump SeaMonkey versions to 1.0.7/1.1 on 1.8.0/1.8 branches, localeVersion to 1.8.1 on 1.8 branch : [Attachment 246921] 1.8.0 patch: SeaMonkey version -> 1.0.7
Robert Kaiser <kairo@kairo.at> has asked neil@parkwaycc.co.uk <neil@httl.net> for superreview: Bug 362139: bump SeaMonkey versions to 1.0.7/1.1 on 1.8.0/1.8 branches, localeVersion to 1.8.1 on 1.8 branch https://bugzilla.mozilla.org/show_bug.cgi?id=362139 Attachment 246921: 1.8.0 patch: SeaMonkey version -> 1.0.7 https://bugzilla.mozilla.org/attachment.cgi?id=246921&action=edit ------- Additional Comments from Robert Kaiser <kairo@kairo.at> This is the 1.8.0 branch patch for bumping SeaMonkey version to 1.0.7 ...
superreview granted: [Bug 362139] bump SeaMonkey versions to 1.0.7/1.1 on 1.8.0/1.8 branches, localeVersion to 1.8.1 on 1.8 branch : [Attachment 246921] 1.8.0 patch: SeaMonkey version -> 1.0.7
neil@parkwaycc.co.uk <neil@httl.net> has granted Robert Kaiser <kairo@kairo.at>'s request for superreview: Bug 362139: bump SeaMonkey versions to 1.0.7/1.1 on 1.8.0/1.8 branches, localeVersion to 1.8.1 on 1.8 branch https://bugzilla.mozilla.org/show_bug.cgi?id=362139 Attachment 246921: 1.8.0 patch: SeaMonkey version -> 1.0.7 https://bugzilla.mozilla.org/attachment.cgi?id=246921&action=edit ...
Firefox 1.5.0.9, Firefox 2.0.0.1 and Thunderbird 1.5.0.9 Security & Stability Updates
As part of Mozilla Corporation�s ongoing stability and security update process, Firefox 1.5.0.9, Firefox 2.0.0.1 and Thunderbird 1.5.0.9 are now available for Windows, Mac, and Linux for free download from getfirefox.com (http://www.getfirefox.com) & getthunderbird.com (http://www.getthunderbird.com). We strongly recommend that all Firefox users upgrade to this latest release. This update is available immediately in 41 languages including Spanish, Japanese, Arabic, Hungarian and more. Note: Firefox 1.5.0.x will be maintained with security and stability updates until Apr...
Firefox 1.5.0.9, Firefox 2.0.0.1 and Thunderbird 1.5.0.9 Security & Stability Updates
As part of Mozilla Corporation�s ongoing stability and security update process, Firefox 1.5.0.9, Firefox 2.0.0.1 and Thunderbird 1.5.0.9 are now available for Windows, Mac, and Linux for free download from getfirefox.com (http://www.getfirefox.com) & getthunderbird.com (http://www.getthunderbird.com). We strongly recommend that all Firefox users upgrade to this latest release. This update is available immediately in 41 languages including Spanish, Japanese, Arabic, Hungarian and more. Note: Firefox 1.5.0.x will be maintained with security and stability updates until Apr...
D.O.S. with Groupwise Messenger 1.0.1, 1.0.2 and 1.0.3
I reported this in the Groupwise Mesenger forum to no avail. I'll try my luck here :-) If you run a 'snmpwalk' on a Netware server running Groupwise Messenger V1.0.1 to V1.0.3) with _MESSENGER_ SNMP enabled, it will abend the server. With version 1.0.2 and 1.0.3, if you disable the Messenger SNMP, server won't abend but will only report SNMP info for Netware (and Groupwise if loaded and SNMP enabled). Can be easily tested by running the win32 snmpwalk from http://www.bradford-sw.com/board/board.cgi?id=BSI_Tools&action=download&gul=13 like this : snmpwal...
Compile problems: Solaris 8, DBD-Oracle1.14, Oracle 9.2.0.1.0, Perl 5.8.0
Hi all, I'm having problems getting the make process go through. The platform is Solaris 8 on 64-bit Sparc, Oracle is 64-bit 9.2.0.1.0 and Perl is the latest package from sunfreeware, DBI is 1.35. First hurdle is to get make to link with the 32 bit libraries, but I managed to fix this. The next one is rather unclear to me, though... The tail of the output from make: Running Mkbootstrap for DBD::Oracle () chmod 644 Oracle.bs rm -f blib/arch/auto/DBD/Oracle/Oracle.so LD_RUN_PATH="/disk/oracle/product/920/lib32:/disk/oracle/product/920/rdbms/lib32" gcc -B/usr/c...
Does ODAC 9.2.0.7.0 work with Oracle database version 9i 9.2.0.6.0 using VS2005?
I am using VS2005 and need to connect to an Oracle database. The Oracle database version is Oracle 9i 9.2.0.6.0 I have taken a look at the Oracle site (http://www.oracle.com/technology/software/tech/windows/odpnet/index.html). I can download the Oracle Data Access Component - Oracle9i Release 2 ODAC 9.2.0.7.0, but will this work with our current Oracle database version 9i 9.2.0.6.0 ? Any help appreciated. Regards, Paul. Apsolutely.Install it, it will work w/o problems. Regards,Dejan VesićMCAD for .Net technologies | http://www.vesic.org/english/ | Blog: http://www.vesic.org...
Powerbuilder 8 / Oracle 8.1.7.0.0 error
When I run my PB 8 build 9506 application using Oracle 8.1.7.0.0 client, I get the following error. If I use Oracle 8.0.5 client, it works. Please advise as I need to be on Oracle 8i. Number 3120 Select error: ORA-03120: two-task conversion routine: integer overflow What version of Oracle is the server? Perhaps it's an Oracle bug. On 10 Sep 2003 06:42:55 -0700, Marsha Jacobs wrote: >When I run my PB 8 build 9506 application using Oracle >8.1.7.0.0 client, I get the following error. If I use Oracle >8.0.5 client, it works. Please advise as I need to be on >Oracl...
Compile problems: Solaris 8, DBD-Oracle1.14, Oracle 9.2.0.1.0, Pe rl 5.8.0
> I ran into this same problem while trying to do a "make" while installing > DBD::Oracle 1.14 on Solaris 8 (64-bit) with Oracle 9.2.0.3.0 and Perl 5.8. > After seeing "ld: warning: option -o appears more than once, first setting > taken", I decided to try and delete all instances of "-o build" from the > Makefile so that I'd be left with just a "-o > blib/arch/auto/DBD/Oracle/Oracle.so" since Oracle.so was the file that it > seemed to be looking for. This allowed me to finish the make and go on > to successfully make...
Web resources about - Datawindow's Date argument with PowerBuilder 8.0.1 and Oracle 9i 9.2.0.1 - sybase.powerbuilder.databaseResources last updated: 12/25/2015 5:22:03 PM