retrieving from row # to row #.I have over 750 000 rows to retrieve from a table using a datawindow, but
my system can only handle approx 30 000 rows and I would like to start from
the end of the table. Is it possible to set the row numbers to retrieve?
For example, start the retrieve from row 750 000 and stop at row 720 000.
There must be a way.
thanks,
Vern
what backend are you using?
<Vern> wrote in message
news:6BA241541AAD7F2F0063357385256C40.0063358685256C40@webforums...
> I have over 750 000 rows to retrieve from a table using a datawindow, but
> my system can only handle approx 30 ...
Datawindow not retrieving rowsHi All
I have an application developed in PB 11.2 & SQL server
2005.
One datawindow is not returning rows . If I run the sql of
the DW from the back end I get 139 rows.I tried by
retrieving thru DW in design time by passing the
parameters.It has three parameters.
(%,'S',1) . when I supply this the DW does not return rows.
But if I hard code the parameters in the SQL of the DW I get
139 rows. Seems very strange . Please help.
Thaks
Anand
Have you tried setting trace for this application ?
What is return code for retrieve?
Are you sure you have setTrans(Object) called ...
Retrieving all rows not just 1 rowI have a dw that is retrieving all rows not just the row that is supplied by
the retrieval argument.
Have debugged and everything seems to work fine.
This only happens at runtime as the retrieval arg is passed from another
window.
Have posted the entire question in the pfc group but was hoping for a quick
answer????
Thanks
When you run from the datawindow painter does it retrieve just the
one record? What about running through the powerbuilder IDE checking the
return code of teh retrieve? Check the value of the retrieval argument you
pass to the datawindow, does i...
How to stop a retrieval before first row is retrieved???????How can a retrieval be stopped before the first row is retrieved. My connection
is asynchronous and I have a button to stop the retrieval, but it does not work
until the first row is retrieved. It triggers some code in the retrieve row
event to stop the retrieval. Is there a better way to do this and how can I do
it to where the retrieval is stopped before the first row is retrieved. Thanks
a bunch for the help, I really appreciate it.
---== Posted via the PFCGuide Web Newsreader ==---
http://www.pfcguide.com/_newsgroups/group_list.asp
--------------7C8F5B8C898E794DE897B2DB
Content-Type: text/plain; charset=us-ascii
Content-Transfer-Encoding: 7bit
never start it. I will assume you have a dataobject assigned to a dwcontrol thru the
properties tab. take it out of there- in you window open
do:
dw_1.dataobject = "d_mydata"
dw_1.SetTransObject(transation)
Then you won't need to stop the retrieval and you can use the button to start
HTH
Jerry
=====================================================
Jerry Neppl
PowerTeam, Inc.
www.powerobjects.com
jerry@powerobjects.com
=====================================================
Seminar on April 26 and 27, Don't Miss it!
www.powerobjects.com/seminar
Dave wrote:
> How can a retrieval be stopped before the first row is retrieved. My connection
> is asynchronous and I have a button to stop the retrieval, but it does not work
> until the first row is retri...
[question] retrieving some rows from a specific row ?Hi,
I'm trying to retrieve some rows from a specific row number in a
datawindow. I don't know how I compose sql statement in sybase. I'm sure
this facility is in oracle.
Anybody help me.
thanks in advance.
The PB function is called reselectrow(row #). it Accesses the database to
retrieve values for all columns that can be updated and refreshes all
timestamp columns in a row in a DataWindow control or DataStore. The
values from the database are redisplayed in the row.
As far as recreating the Sybase statement then you would just recreate the
where statement using the key values.
string whatsindw
whatsindw = dw_1.getitemstring(row, col)
select .... from ... where key = :whatsindw;
If you want them to doubleclick on a row then display the rows for that row
then you would:
get the key they double clicked on
retrieve another dw using that key as the retrieval argument.
You can look at some of the examples in powerbuilder from retrieval
arguments.
HTH
--
Dawn T Brown Eyes (TeamPS)
Seong Moon <seong@grigg.chungnam.ac.kr> wrote in article
<8AxhOeng#GA.50@forums.sybase.com>...
> Hi,
> I'm trying to retrieve some rows from a specific row number in a
> datawindow. I don't know how I compose sql statement in sybase. I'm sure
> this facility is in oracle.
>
> Anybody help me.
> thanks in advance.
>
>
>
...
Loop to retrieve data from a table row after row
Hello,
how do I have to write the loop (SQL-code) if I want to retrieve the content of the first row from a table that consists of one column and many rows and then do some calculation, next get the content of the next row and do a calculation ... until the end of the column?
Thanks in advance.
Bendo
I'm assuming you are using Visual Web Developer or Visual Studio 2008 (or something similar to the two) and you have a SQL Server database.
You can do calculations using a ExecuteReader() and a reader. I can help you further with this. Would a d...
Retrieve row value for row with delete button?
Hello,I am developing a simple ticket system and I can't figure out how to retrieve the value of a record that is not selected. For example, I have a button in a gridview which changes the "Closed" value of that record from No, to Yes, which closes the ticket. My problem is, I have searched and search and I can't find a way to find out what the value of the record that contains the clicked button.This is my SQL statement: myCommand = New SqlCommand("Update Tickets Set Closed='Yes',ClosedDate='" & DateTime.Now & "' WHER...
Too many rows to retrieve on datawindowDear all,
I got a problem of retrieving data in datawindow. I am using Sybase SQL
Anywhere DB and PB5. My Problem is there are too many records in the table
more than 35,000 ), no joining, and it needs a lot of time to retrieve them
to the datawindow. Are there any methods to improve it. ( The data is used
to show only, no need to retrieve ).
Thanks.
Billy
Hi Billy,
I think your users will go mad. 35,000 rows is way to much to browse
through. I would use some extra arguments, filled in by the user, to
decrease the number of rows returned.
HTH
--
Met vri...
Help! Retrieve rows in the datawindowHi,
When I retrieve too many rows in the datawindow preview, I get error
message of access violation from Dr. Waston and pb7 terminates. What I
can do is limited the retrieved rows. Has anyone seen this problem
before??? And any tips on improving the performance when retrieving
the data in the powerbuilder.
Thanks.
The only thing you can do to limit the number of rows retrieved is to
place a filter onto the dw. You can also hit the cancel toolbar item to
stop the retrieval before it finishes.
Out of curiosity, how many rows are you returning?
You may want to report this as...
DataWindow: Retrieving Huge No Of RowsA general question:
Suppose I create a dynamic datawindow. The Retrieve() may bring back a
huge number of rows (too many to fit into memory).
Is it safe for me to use the RowsMove() function in the RetrieveRow event?
The idea is to take, say, 1000 rows, copy them to another datawindow,
insert them to the destination database, and to have the original
Retrieve() function continue to execute (getting the next 1000 rows for the
same process all over again).
TIA
VictorReinhart
Aside from the fact that what you're doing sounds a lot like a
pipeline, and given a choice,...
datawindow does not retrieve more than 10280 rowsHi,
Is there any limit as to the maximum number of rows that a datwindow can
retrieve?
I think this should depend more on the size of each row. But is there any
limitation on the datawindow?
Thanks in Advance,
Prasad
I don't think there is any limitation for Retrieving Rows, Since we have a
table
Which is having about 1.5 Lakhs, I'm able to retrieve all records.
We are using PB 6.0
Bye
Vasu
It is only limited by available memory. If your rows are 2K wide, expect
to retrieve 10 times less rows that if your rows are 200 bytes wide.
steve
[TeamS...
Retrieve data row by row and multiple SELECT statements.
hai to all experts out there,can somebody help me please! I would like to do this sql select statement in vb.net in order to display the output in a gridview.
I have a table name TBL_DOC consist of ID,DOC_NO,PIC_FLAG,MPIC1,MPIC2,MPIC3,MPIC4 ,MPIC5 columns.
My intention is first i want to retrieve PIC_FLAG column data from all rows in TBL_DOC table row by row like this:
SELECT PIC_FLAG FROM TBL_DOC
and then if PIC_FLAG = 'MPIC1' i want to do another select statement like this in the same table:
SELECT ID,DOC_NO,PIC_FLAG,MPIC1 FROM TBL_DOC where PIC_FLAG = 'MPIC1' AND MPIC1 ='USER_EMAIL'
and then if PIC_FLAG = 'MPIC2' i want to do another select statement like this:
SELECT ID,DOC_NO,PIC_FLAG,MPIC2 FROM TBL_DOC where PIC_FLAG = 'MPIC2' AND MPIC2 ='USER_EMAIL'
and the same if PIC_FLAG = 'MPIC3' and 'MPIC4' and 'MPIC5'
Can i combine all this select statement into 1 statement only.
The final output display in the gridview will be all document that have the USER_EMAIL in all MPIC list based on the PIC_FLAG.
Could someone please give me an idea or example because i'm just a beginner and totally blind in this.
Thanks in advance.
Do you use StoredProcedure? If yes, you just need to pass the parameters Flag and UserEmail like:
Declare @SQL Varchar(MAX)
SET @SQL = 'SELECT ID,DOC_NO,PIC_FLAG,''' + @Flag + ''' FROM TBL_DOC where...
Retrieving Datawindow children across rowsHi-
I want to do something, but as of yet, been unable and maybe it is not
possible. Here's what I want.
I have a datawindow with multiple rows and 2 columns. The first column
is a job title column and the second is a drop-down datawindow with
employee names. I want the drop-down datawindow column to be retrieved
based on the value of the job title column. When I use the getchild and
retrieve method in the retrievestart event for the 2nd column, it will
retrieve all dropdowns to the same value, whichever I specify in the
retrieval. If I use script in the retrieve row even...
'row changed between retrieve and update' locks the row?My app got a 'row changed between retrieve and update'
error.
I understand why this happens. I have seen this before w/
oracle and sysbase back ends and I could just exit the
window or app, reenter and it will be 'cleared' and you can
go back in and do a update. But w/ sql server when I try and
update the same row after reentering the same message
appears. We even bounced the DB engine and nothing seems to
'clear' the lock or whatever is being held. the dw is using
the 'delete then insert' update switch. Anybody have any
ideas? THANKS!
What do you ha...
ROWS RETRIEVEDHi all!!
Thanks good I have newsgrowps!
I have a greed data window, an I have to display between 35,000 and 70,000
rows.
I'm using SetPointer(HourGlass!) function, but this function can't say me
if the data is being retrieved.
Can any body say me how can I use a progress bar when retrieve data in the
datawindow?
Or can be something like displaying the current row that is being retrieved
in a static text to show the user to be patien.
Thanks!
You need to use the RetrieveRow event to do this, however, be warned
that this may impact your performance....
No Rows RetrievedI am familiar with the datawindow but a novice with VB.net. I am trying to
do a simple retrieval with one argument (a case number) but it is returning
0 rows. It works fine in the database painter for .Net datawindow, but not
in the application. Any help would be appreciated. Below is the relevant
code (I think):
'
'gnv_tran
'
Me.gnv_tran.AutoCommit = True
Me.gnv_tran.Database = "imdsplus"
Me.gnv_tran.Dbms = Sybase.DataWindow.DbmsType.OleDb
Me.gnv_tran.DbParameter = "PROVIDER='SQLOLEDB',DATASOURCE='dw-dev'"
Me....
Can the dw tell me how many rows are going to be retrieved before the retrieve starts?Hi folks
I want to implement a progress bar to show a reasonably accurate
representation of rows retrieved and the realtime progress of such. I
could do this cheaply by just saying it's 50% at start and 100% at
retrieve end but that's not very realistic.
Therefore I need to know how many rows will be retrieved prior to
actually starting the retrieve. Is there an dw event that offers such a
value?
The only way I can think of doing this if the above idea is not possible
is by stripping out unnecessary columns and do a bare bones retrieve
first, but that seems like ...
datawindow problem: Row Changed Between Retrieve and UpdateHello.
I am using a stored procedure inside a datawindow to update one table.
when I ran my datawindow inside DataWindow Builder, I got an error
message said: "Row Changed Between Retrieve and Update, No change made
to database." When I used the same datawindow inside PowerJ3.5, i got
the same error message, but the stored procedure was called
successfully. The database was updated even though the error message
from datawindow said it didn't.
I don't understand why the stored procedure inside my datawindow worked
in PowerJ but not in dataWindow Builder, and i don...
Datawindow retrieve with "ROWS As Needed" ON.I work with Access database and I have a table with hundred of thousand
of rows and I need to retrieve rows to the datawindow just page by page
( So I would not have to wait along time after retrieving all data at
once ) , so I set the property (in the data window builder) for " ROWS |
Retrieve | As Needed " this works except it always pops up an ODBC
select datasource browser .
When I run exactly the same code except the "ROWS | Retrieve | As
Needed" is OFF
every thing is OK and NO datasource browser shown.
Is anyone no what should I do to prevent the datasource browser pops up
?
If you look a the documentation, it says that DataWindows
that have sorted data or contain aggregate functions like SUM
won't work with 'Rows as Needed'. Maybe specifying 'Rows as
Needed' on these type of DataWindows confuses the OCX?
Since all of the DataWindows I use are sorted and/or contain
aggregate functions, I haven't had any use for this 'feature'.
best regards,
jeff
Lili Even wrote:
> I work with Access database and I have a table with hundred of
> thousand
> of rows and I need to retrieve rows to the datawindow just page by
> page
> ( So I would not have to wait along time after retrieving all data at
> once ) , so I set the property (in the data window builder) for " ROWS
> |
> Retrieve | As Needed " this works except it always pops up an ODBC
> select datasou...
Getting a datawindow with a retreival argument to retrieve all rows.How do you get a datwindow to retrieve all rows if it has a retrival
argument?
ie:
dw_1.Retrieve(100) // all employees in dept 100
dw_1.Retrieve(*) // how do I get the dw to select * ???
Thanks
Gene
Change your select statement to use a like:
select * from employees
where dept_id like :dept
Now you can pass a wildcard like '%'
Or alternatively you need to modify your select at runtime and remove the
where clause.
Terry Dykstra (TeamPS)
Gene C <genec@cat.bbsr.edu> wrote in article
<01bc9e9f$d92c2970$3e01a8c0@genec>...
> How do ...
Datawindow stop to retrieve if there is no row for Inkpicture ObjectHi All
I put in a datawindow some columns and an InkPicture object, which gets blob
data from another table. I retrieve the datawindow but it stops to retrieve
without any error, if there is no row for InkPicture object in the table.
I suppose that InkPicture gets the data as a compute column but it doesn't.
I think it is a bug. Dou you have any sollution?
Thanks
Murat Yelkovan
InkPictrue is not usefull. I retrieve 30.000 rows in datawindow and
InkPicture try to retrieve 30.000 picture. But it is freeform datawindow.
Is there any option to retri...
Datawindow based on stored procedure does not retrieve all rowsI built a datawindow (PB10.2.1.9731) based on a stored procedure (MS SQL
Server 2000). The datawindow is missing random rows from the stored
procedure's output. If I run the stored procedure in TSQL, using my
"sample" argument values I get 300 rows (a number I believe to be correct).
When I use the datawindow to run the stored procedure (using the exact same
values that I used in TSQL), I get 281 rows. The data window has no
filters, computations, etc., to cause this behavior. I have no idea how to
even begin to troubleshoot the problem. Suggestions? Please......
Retrieving several Rows, but present them in one DataWindowMy problem is, that I have one DataWindow and there should appear
more rows I previously retrieved. Is this possible or should I split up
my DataWindow?
Thanks!
Do you mean you want to retrieve some rows without discarding the rows that
were already there? If so, then return 2 from the retrievestart event.
Simon
"Christian Schmidbauer" <christian.schmidbauer@mapware.de> wrote in message
news:ndPbGWbDAHA.281@forums.sybase.com...
> My problem is, that I have one DataWindow and there should appear
> more rows I previously retrieved. Is this possible or sh...
Datawindow retrieve with "ROWS As Needed" ON.I work with Access database and I have a table with hundred of thousand
of rows and I need to retrieve rows to the datawindow just page by page
( So I would not have to wait along time after retrieving all data at
once ) , so I set the property (in the data window builder) for " ROWS |
Retrieve | As Needed " this works except it always pops up an ODBC
select datasource browser .
When I run exactly the same code except the "ROWS | Retrieve | As
Needed" is OFF
every thing is OK and NO datasource browser shown.
Is anyone no what should I do to prevent the datasource b...