Search results for query: *

It can take up to 3-4 minutes. It does the same thing when I open the datawindow object in the powerbuilder editor and hit the retrieve button.

It's being accessed via OLE. It's worked fine since there was last an issue and nothing was changed. No new updates/patches were applied. Again, the issue seems to happen sporadically.

I have a stored procedure that runs in less than a second in SQL Server Query Analyzer, but sometimes it takes up to 3-5 minutes to run that same stored procedure in a data window retrieve. This doesn't constantly happen, it's been about a month since it last happened, and there were no changes...

I was doing dw_control.object.datawindow.print.collate = FALSE. I tried several things and variations to this, and finally had to re-create the datawindow and do some filtering with that, use the collate and override print options (which wasn't available in 8). Thanks for the reply though.

Having no experience with scripting for procomm+ or File Link, how difficult is it to convert? Anyone attempt this or have any pointers? (Is there a file link forum)? :) Your help is appreciated.

I have a report that on occassion will have multiple pages and need to print it w/o Collate. Several copies of each report are printed and the paper is color coded for who it goes to so on the multi-page reports it needs to print all the copies of page 1, then all the copies of page 2 then all...

Is there a way to build an update statement piece by piece? For example, depending on which variables have values I would like to add them to the WHERE clause and then execute the update statement. so when variable var1 is greater than 100 it would add AND var1 > 100 to the where...