Problems within Datawindow Painter (SQL Painter)

When in the SQL Painter I receive a Database error when exiting and any 
changes to the SQL are lost.  I just installed the EBF Build 8046.  Within 
the documentation for this EBF it speaks to not being able to use '*=' any 
longer.  We do not use that syntax but rather 'LEFT OUTER JOIN'.  I copied 
the syntax that was in the EBF notes but this also gave the same error. 
Looking for someone who has had this problem and has a work around.  There 
are things within the 8046 build that we require, but if this can not be 
fixed I guess I will have to go back to 8011.

Thanks,
Jonathan
0
jonathan_duncan
10/12/2000 3:50:46 PM
sybase.powerbuilder.datawindow 28057 articles. 4 followers. Follow

2 Replies
667 Views

Similar Articles

[PageSpeed] 17

Jonathan,
There is a tedious but effective workaround for this problem.  Translate the
SQL to syntax mode and use the ODBC escape sequences to bracket the outer
joins.  So, your query might look like this:

FROM {oj table1  left outer join table2 on table1.col = table2.col}

Then you should be able to reconvert that back to graphics mode.  If that
doesn't work, you may have to export and edit the source and re-import...

Paul Horan [TeamSybase]
Buffalo, NY

<jonathan_duncan@dmr.ca> wrote in message
news:09037D6F5F4B330300570BA385256976.00570BB885256976@webforums...
> When in the SQL Painter I receive a Database error when exiting and any
> changes to the SQL are lost.  I just installed the EBF Build 8046.  Within
> the documentation for this EBF it speaks to not being able to use '*=' any
> longer.  We do not use that syntax but rather 'LEFT OUTER JOIN'.  I copied
> the syntax that was in the EBF notes but this also gave the same error.
> Looking for someone who has had this problem and has a work around.  There
> are things within the 8046 build that we require, but if this can not be
> fixed I guess I will have to go back to 8011.
>
> Thanks,
> Jonathan


0
Paul
10/12/2000 7:20:51 PM
Enclose your table list in brackets:
select ...
from (a left join b...)

HTH

Simon

--
Simon Caldwell
Get Real Systems Ltd
Holtby Manor, Stamford Bridge Road, York, YO19 5LL
Tel 01904 481999 Fax 01904 481666
Visit us at www.getrealsystems.com

Specialists in e-Procurement and supply chain technology


<jonathan_duncan@dmr.ca> wrote in message
news:09037D6F5F4B330300570BA385256976.00570BB885256976@webforums...
> When in the SQL Painter I receive a Database error when exiting and any
> changes to the SQL are lost.  I just installed the EBF Build 8046.  Within
> the documentation for this EBF it speaks to not being able to use '*=' any
> longer.  We do not use that syntax but rather 'LEFT OUTER JOIN'.  I copied
> the syntax that was in the EBF notes but this also gave the same error.
> Looking for someone who has had this problem and has a work around.  There
> are things within the 8046 build that we require, but if this can not be
> fixed I guess I will have to go back to 8011.
>
> Thanks,
> Jonathan


0
Simon
10/13/2000 8:47:14 AM
Reply:

Similar Artilces:

Problem with SQL parsing in datawindow painter....
PB 6.5, NT latest and greatest when working in the datawindow painter in graphics or text mode, the following part of my SQL statement gives me an error (something like "unable to convert VARCHAR value '0' to a DATETIME field " ) Part of SQL follows..... ( pmacs_security_group.end_date > convert(datetime, :as_system_date) OR pmacs_security_group.end_date IS NULL) If I change the "OR" to a "AND" the statement gets through PB's parsing, but this is not the statement I need.... Has anyone run into this and a way to get around it? -...

datawindow painter problem
Hi, I am using PB 6 and i have this funny problem with the datawindow painter. When i switch from a graphic to a sql view i almost always seem to loose the menu (File, Window etc) This always happens when i open a datawindow from the library painter or from the form window. If i open a datawindow via the datawindow painter icon it happens less. Any ideas? Thanks N ...

Powerbuilder Datawindow Painter.
We have developed an application that allows user to create custom data entry windows using datawindow painter dw60.exe (PB 6.5.1). This works very well for our users who are non IT people. The problem we have is that dw60.exe is distributed with the Powerbuilder but not sold as a separate purchasable product. After discussions with Sybase representatives we have each user purchase a copy of Infomaker to make them 'legal'. We are not totally happy with this situation as we move forward to PB 8 also we are not sure if there is a dw80.exe or whether this will be supp...

Datawindow painter excruciatingly slow on some datawindows
PB 7.0.03 Bld 10009, Oracle 7.3 What kinds of things make the datawindow and/or SQL painters "stop and think"? The client has some datawindows that are *painfully* slow when opening the SQL painter for the datawindow. The one I'm waiting on right now is in grid style. The SQL is in non-graphic mode and has a select with 14 tables with appropriate joins and a long list in the GROUP BY section. Preview mode is off. I've been waiting for 5 minutes. I've had these take 8 - 10 minutes before. This takes a mean bite out of productivity. jshark I wo...

SQL
pb 7.0.3 I cant seem to make the following query in SQL data source painter: SELECT coa.coa_code, coa.account_group1, accountgroups.ac_group_code FROM coa INNER JOIN accountgroups ON coa.account_group1=accountgroups.ac_group_code; it appears that the SQL data source painter in dw allows INNER JOIN where names of columns are same in both the tables. The above works when i issues Raw select command in my scripts or use createfromsynatx() .. Is there a way to write manual queries that can be made as data source of a datawindow ? Thanks Nohman oh well i didnt look at the...

Datawindow SQL Painter sometimes crashes when opening SQL in PB9
We recently migrated from PB7 to PB9. I have a few datawindows that open fine in PB7 but when I open the SQL in PB9, PowerBuiler crashes. These datawindows work fine in the executable PB9 application, but I can't open the SQL. Termination error reads: "AppName: pb90.exe AppVer: 9.0.0.5507 ModName: pbsql90.dll ModVer: 9.0.0.6066 Offset: 0005c8f" I don't know of any common thread in these few datawindows that would make them have problems while most of the other datawindows do not. I noticed that a few other people have posted this (or a s...

DataWindow Within DataWindow
How Can I access/modify object/control from a Datawindow within Datawindow. When i access/modify object/control from a Datawindow i used dw_1.modify("name.text = 'new val'") but within another datawindow or child datawindow it doesnt work. Your description is difficult to understand due to the terminology. First, a datawindow is assigned to a control - either a datawindow control or a datastore. Second, the Modify function can only be called within a script. With that as a basis, can you rephrase the question and describe more precisely what you want to do? ...

Datawindow SQL Painter crashes sometimes when opening the SQL in PB 9
I have datawindows that open fine in PB 8 and when I open the SQL in PB 9, Powerbuilder crashes. It has happened with several windows in an application that I migrated to Powerbuilder 9. These datawindows seem to work fine in the executable application but I can't open the SQL. I can't see any common thread in them. None of them are trying to open in graphics view. What database? On Fri, 30 May 2003 18:06:01 -0400, in powersoft.public.powerbuilder.datawindow <jmoen> wrote: >I have datawindows that open fine in PB 8 and when I open the SQL in PB 9, &...

Using SQL in datawindow painter
I have learned by trial and error some ways to use the datawindow painter to make SQL statements and computed columns. For instance on the "Computed Column" line in the SQL Select page of the datawindow painter I can do things like: 0 "copy_from" 0 || widthno grid_width ' ' linetype '000' totals_sort Is there any documentation on how to do this? How can I create columns with different data types, like decimal. The ones above are char(3), or longs, etc. Where do you learn about using ||, etc? Are there any other tricks? Thanks, paul@...

Cannot convert in DataWindow SQL Painter
Hi I'm using PB7.02 / ASA 7.0.3. When I write the following statement in the datawindow SQL painter: convert( datetime, substring( :as_Start,1,4) + '-' + right(:as_End,2) + '-1') and want to return I got the message: Cannot convert 0-0-1 to a timestamp. Version 5.5.05 of SQL Anywhere was fine with this. Any ideas. Regards Arthur ...

DataWindow Painter problem #2
Hi, 1. Table 't' with column 'c' was created in sql-anywhere 2. A datawindow was created with 'select c from t' (graphic mode-connected to anywhere) 3. Table 'T' with column 'C' was created in ms-sql-server 4. Both databases are not case sensitive 5. I tried to preview the datawindow connected to ms and worked fine 6. I tried to change the sql and connected to anywhere and PB was not able to maintain the datawindow in graphic mode Ok the tables were created with different cases, but if it doesn't matter for sql operations, I'd lik...

Frustrating Datawindow painter problem
Hi, I am using PB 6 and i have this funny problem with the datawindow painter. When i switch from a graphic to a sql view i almost always seem to loose the menu (File, Window etc) This always happens when i open a datawindow from the library painter or from the form window. If i open a datawindow via the datawindow painter icon it happens less. Any ideas? Thanks N I haven't seen this behavior recently. The last time I saw "funny" GUI behavior was when I was using Windows 95, where there were more resource constraints. With Windows 2000, that is much less o...

DataWindow SQL Painter Syntax
Does anyone know what the proper syntax is for the DataWindow Painter SQL syntax to accept SQL 6.5 style JOIN statements. For example I was trying to get the SQL style statement such as this to create my datawindow : SELECT distinct CoABC_order.order_id, CoABC_order_ids.cust_order_id, CoABC_order.order_date, CoABC_order_item.prod_id, CoABC_member_a.sip_tag, CoABC_member_a.CoABC_mem_alias, CoABC_member_a.CoABC_mem_alias, CoABC_member_b.CoABC_mem_alias, CoABC_billing.last_name, CoABC_billing.first_name, CoABC_shipping.last_name, CoABC_sh...

Copying within Datawindow Painter
I just noticed that I no longer can copy, paste, and then move multiple columns in the painter. I have several columns (like 20) in a group band. I want to copy all of them to another band so I select all the cols, copy, then paste...and while the cols are still selected I try to move them, but I cannot. They become un-selected. I remember I used to be able to move them. So now, I have to select the cols, copy then paste. Un-select the cols, then select them one by one via (ctrl+click) then move them. (The paste will paste right over the copied columns). If I do a select a...

Web resources about - Problems within Datawindow Painter (SQL Painter) - sybase.powerbuilder.datawindow

PowerBuilder - Wikipedia, the free encyclopedia
PowerBuilder is an integrated development environment owned by Sybase , a division of SAP . It has been in use since 1991, peaking around 1998 ...

Intelligent Versus Surrogate Keys
Should I use business columns as primary key fields for tables in thedatabase, or generate artificial primary key values? When business-related ...

chevy volt
ProEXR File Description =Attributes= channels (chlist) compression (compression): Zip dataWindow (box2i): [0, 0, 5119, 2475] displayWindow (box2i): ...

Enable - A comprehensive solution for the localization of PowerBuilder applications Untitled Document ...
Enable is localization/ translation tool used by PowerBuilder developers to make their applications multilingual.Enable is a powerful tool that ...

comp.lang.clipper.visual-objects - Google Groups
comp.lang.clipper.visual-objects 1-20 von 33006 Themen werden angezeigt Integrity of a file marcosm...@gmail.com 09:35 Combobox value Lu 08:12 ...

Sybase PowerBuilder tool readied for Microsoft's .Net
Developers can choose Win32 or newer style .Net development

PowerToTheBuilder - PowerBuilder UI Controls
HOME - COMPONENTS - PB UI DESIGNER - DOWNLOAD\PURCHASE - SUPPORT - FAQ - ABOUT Take Control of your UI with PB Ultimate Suite PowerToTheBuilder.com ...

Beautiful iPad Mini 3 Concept Reimagines Appleā€™s Tablet With iPhone 6 Design, Gold Color [Images]
The iPhone 6 may be grabbing all of the recent headlines due to its impending announcement, but spare a thought for those who prefer to stay ...

Java Networking - Real's HowTo
Real's HowTo Custom Search Java Language String and Number Applet AWT Swing Environment IO Javascript interaction JDBC Thread Networking JSP ...

Business Intelligence Products - Database Management, Data Warehousing & Mobility Software - Sybase Inc ...
Sybase offers a variety of Business Intelligence (BI) software like products for database management, data warehousing and mining, data integration ...

Resources last updated: 12/8/2015 1:41:25 AM