Datawindow Error: Select error: #2
during the stage of upgrade PB application from v6.51 to
9.0(backend upgrade from Oracle 8.1.6 to Oracle 9.2.0.), I
want to use O84 driver in PB9 instead of O73 in PB6.5.1, but
I got the error like this:"Datawindow error: Select error"
in one of my datawindow when I try to preview it. here's my
SQL statement for the datawindow.
"SATREV_REPORT_VIEW"."APPLIED_YEAR&...Error message in PowerBuilder Datawindow #2
Can anyone help me decipher the following error message that I get when
trying to retrieve from a datawindow:
Select error: SQLSTATE = 37000
[Sybase][ODBC Driver][Adaptive Server Anywhere]Syntax error or
access violation: invalid expression near ':?+'"
I am using PB 7.0.1 and Sybase ASA 6.0.2.
Thanks in advance!
Turn your DataWindow into syntax mode. It probably will be easier to see
what is wrong. If you can't see what it wrong then post the SQL syntax
here and we'll take a look at it.
Jim Egan [TeamSybase]
Dynamic Data Solutions...Datawindow Error: Select Error:
The title of the messagebox: Datawindow Error
Message is: Select Error:
Migrated 6.5 libraries to 8.0.
SQL is build on the fly using dot notation(datawindow.table.select)
add the where clause and set the sql using dot
The datawindow still work fine in the 6.5 environment but not in the 8.0
Why are the messageboxes coming up?
I've recreated on of the datawindow and the select error goes away but
there are many windows with datawindows retrieving data and we can't
recreate our entire app...DataWindow This, DataWindow That...
Blah blah blah
You've heard it enough that you don't even want to comment on how many
....but it can't be enough anymore...can it?
This from one of our colleagues
(and yes my apologies for taking it out of context)...
"...PB covers all you need to do that in ONE Tool. This
includes Windowprogramming ( meaning the interface to the user:
Windows, Sheets, diallougeboxes, etc.), Database operability AND
Reporting! Well, I see als well as many other PB users that some of
the implementations and features PB offers are improvable. But thi...Error selecting arguments to Composite DataWindow #2
After creating 2 reports to Composite DataWindow, I try to select arguments
to both reports, but i'm not getting. In the moment of select, it print
this message: " '(' expected after function name ".
...Datawindow Error from Web-Datawindow
I got sometimes a Datawindow Error on my Webpage IE 5.5 ( PB 7.03 10108 )
"Select error: java.net.SocketException: Socket read failed"
...DATAWINDOW ERROR : SELECT ERROR 1
I am getting above error while retrieving a datawindow thru my application.
The datawindow is made using stored procedure as data source and manual
result set. I have taken only one column in result set. but its not working.
while other datawindow with made using another stored procedure have no
problem also it don't have any retrieval argument.
I have searched forums already for this but is not of much help.
Can you retrieve this datawindow in the datawindow painter? What do you
mean by "I have taken only one column in result s...Datawindow create error: datawindow error has incorrect release number
I have the following table:
CREATE TABLE dbo.APP_REPORTS (
rec_id numeric(18,0) NOT NULL,
dw_state image NULL,
dw_structure image NULL,
CONSTRAINT RAPPORTEN PRIMARY KEY NONCLUSTERED(rec_id)
In this table I have stored reports generated from datawindows in PB9.
Now we are migrating to PB11, but I get an error retrieving/generating
the datawindows/reports from this table containing PB9 versions.
In powerbuilder I have following code (in short):
//ids_buffer is a datastore containing the report to preview
//datawindow creation (from dw...Is DataWindow 2.5 in Dw.Net is same as DataWindow in PB11.2
Hi there ,
Can anybody confirm the said subject is a valid statement ?
Dw.Net2.5 = PB11.2.DataWindow ????
How about the future enhancements which are planned for PB11.5 and future
releases of PB...
Will it not always be in the same codestreamline ?
Regards , Van
I mean how will be co-relate the three products from Sybase
1) DataWindow.Net 2.5 for Visual Studio 2008
2) PocketPowerBuilder Datawindows
3) PowerBuilder11.2 and Powerbuilder1x.x Datawindows
All everthing is remain the same in all the above three products as far as
Datawindow properties / events /...html datawindow error ERROR: Datawindow definition not set urgent
I have datawindow in a html page, when I created the page in the ActiveX
sybase html datawindow properties I choose from source file (*.src) and
I get this message ERROR: Datawindow definition not set from my browser
are there anybody to help me
Select the Generate Absolute path in the DTC.
Francisco Javier Pardo Weaver wrote in message
>I have datawindow in a html page, when I created the page in the ActiveX
>sybase html datawindow properties I choose from source file ...1 Xml -> 2 DataWindows; 2 DataWindows -> 1 Xml
Is it possible to import an Xml file like
to one Datawindow ?
On the other hand is it easily possible to assemble data
from two Datawindows in one XML file ?
Thomas Kovasits wrote:
> Is it possible to import an Xml file like
> &l...selected row in the datawindow to displayed in the other datawindow
iam unable to display the data which is selected data in one datawindow to
see IsSelected functions and transfer those rows to the other DW
"Vasu D" <firstname.lastname@example.org> wrote in message
> iam unable to display the data which is selected data in one datawindow
> other datawindow.
Hello Vasu D,
Are u using shared dw's?
In this case you'll only have to use the function
dw_secundary.scrolltor...DataWindow Error : DataWindow does not have UPDATE capability
I have faced the above error message when I clicked on my saved button
which is suppose to save any updates. The strange thing is, the changes
are being captured! When I retrieve the particular record I changed, I
reflected the changes I made to it. I created a window with a few tab
pages, with 1 datawindow control on each tab page, anyway, my other
window with a few tab pages works fine. So what's wrong?
Any help will be appreciated! :)
> I have faced the above error message when I clicked on my saved button
> which is suppose to save...How can I count number of rows in each datawindow in composit datawindow then access and set item in each row in each datawindow! #2
This is a multi-part message in MIME format.
I created a composite datawindow includes three datawindow. How can I
count the number of rows in each datawindow? (Rowcount() function can =
works). Also, I need access in each row then reset the value that I want =
each row in each datawindow. I use the property to access to get data in
each row in each datawindow, but the right value only happens in the =