Canceling a select

Is there a way to either:  1) dynamically modify the select statement
used as the data source for a pipeline, like Modify will do for a
datawindow, or 2) cancel a select executed dynamically from a script?  

I want to build a select statement in a string, execute it, and put the
results into a temporary table, but also be able to cancel the select
before it finishes.  If I do the select in a datawindow, I can cancel
with dbCancel but then it looks like I have to insert the rows one at a
time into the temporary table.

All ideas are welcome.  Thanks in advance.
0
Margaret
11/12/1997 9:59:18 PM
sybase.powerbuilder.general 62418 articles. 18 followers. Follow

1 Replies
529 Views

Similar Articles

[PageSpeed] 19

On Wed, 12 Nov 1997 13:59:18 -0800, Margaret Graichen
<mgraichen@ntia.doc.gov> wrote:

>Is there a way to either:  1) dynamically modify the select statement
>used as the data source for a pipeline, like Modify will do for a
>datawindow,

No.  It would be nice.  The only other alternative is the
'old-fashioned' way.  Use a single datawindow, do a retrieve, point it
at the target database, modify it as needed, do a SetItemStatus to get
the update spec you want and do an Update.

>or 2) cancel a select executed dynamically from a script?  

Not that I'm aware of.

>I want to build a select statement in a string, execute it, and put the
>results into a temporary table, but also be able to cancel the select
>before it finishes.  If I do the select in a datawindow, I can cancel
>with dbCancel but then it looks like I have to insert the rows one at a
>time into the temporary table.

You would have to insert the rows one at a time in an embedded select
to allow the cancel as well.  If you are doing that kind of work, why
aren't you doing this through a stored procedure on the server (except
that you want to be able to modify the parameters?).


Bruce Armstrong [TeamPS]		| Source Consulting
mailto:brucearm@ix.netcom.com		| mailto:jobs@sourcela.com
http://www.netcom.com/~brucearm/	| http://www.sourcela.com
                                        | http://www.experienceondemand.com

Preach the gospel at all times.If necessary, use words.	[Francis of Assisi]
0
NOCANSPAM_brucearm
12/1/1997 9:21:05 PM
Reply:

Similar Artilces:

superreview cancelled: [Bug 181105] Selection behaves badly when SpellCheck Selection is on : [Attachment 141155] Make alternate selection types render properly
Neil Deakin <enndeakin@sympatico.ca> has cancelled Boris Zbarsky <bzbarsky@mit.edu>'s request for superreview: Bug 181105: Selection behaves badly when SpellCheck Selection is on http://bugzilla.mozilla.org/show_bug.cgi?id=181105 Attachment 141155: Make alternate selection types render properly http://bugzilla.mozilla.org/attachment.cgi?id=141155&action=edit ...

does an insert on xforms-select event necessarily cancel select?
Hi, i would like to invoke an insert (on another data node) when the user selects an item in a select form control. however with an insert the normal select doesn't work anymore. i searched through the spec's and i couldn't find any reason why this should block the normal capture/ bubbling of xforms-select and cancel subsequent events... is this a current limitation of the plugin or did i miss something in the spec? thanks in advance claude On Feb 10, 3:14=A0am, bernstein <clauden...@gmail.com> wrote: > Hi, > > i would like to invoke an insert...

Select in Powerbuilder Database painter WORKS but does NOT in Powerbuilder run mode.
I have enclosed the actual information from a debug run. Will apprecaite any hints. Thanks Jim jimo@jdssc.com in ls_mod_string DataWindow.Table.Select="SELECT DISTINCT ~"inv_dtl~".~"inv_id~", ~"inv_dtl~".~"orig_cost~", ~"inv_dtl~".~"last_cost~", ~"inv_dtl~".~"regular_cost~", ~"inv_dtl~".~"orig_price~", ~"inv_dtl~".~"current_price~", ~"inv_dtl~".~"sugg_price~", ~"inv~".~"vend_id~", ~"inv~".~"style~", ~...

SELECT from SELECT
Hi! I remember seeing an example where you can do a select from a nested select, but I cannot seem to make it work. So it would be something like this: select max( name ) from ( select name from customer union select name from vendor ) Was I dreaming I saw that? Thanks! D In article <4500243f@forums-2-dub>, daniel_AT_infrontsoftware_DOT_com@N0SPAM.com says... > Hi! > > I remember seeing an example where you can do a select from a nested > select, but I cannot seem to make it work. No, you weren't. Try (UNTESTED!) adding a...

What generals generally do
Reading a McChrystal thread elsewhere, I came across someone quoting a US general http://en.wikipedia.org/wiki/Smedley_Butler > I spent 33 years and four months in active military service and > during that period I spent most of my time as a high class thug for > Big Business, for Wall Street and the bankers. In short, I was a > racketeer, a gangster for capitalism. I helped make Mexico and > especially Tampico safe for American oil interests in 1914. I helped > make Haiti and Cuba a decent place for the National City Bank boys to > collect revenues in. I ...

Select in Powerbuilder Database painter WORKS but does NOT in Powerbuilder run mode.
I have enclosed the actual information for a debug run. Will apprecaite any hints. Thanks Jim jimo@jdssc.com in ls_mod_string DataWindow.Table.Select="SELECT DISTINCT ~"inv_dtl~".~"inv_id~", ~"inv_dtl~".~"orig_cost~", ~"inv_dtl~".~"last_cost~", ~"inv_dtl~".~"regular_cost~", ~"inv_dtl~".~"orig_price~", ~"inv_dtl~".~"current_price~", ~"inv_dtl~".~"sugg_price~", ~"inv~".~"vend_id~", ~"inv~".~"style~",...

superreview canceled: [Bug 382369] Cannot select text in <label> associated with a <select>
Mats Palmgren <mats.palmgren@bredband.net> has canceled Mats Palmgren <mats.palmgren@bredband.net>'s request for superreview: Bug 382369: Cannot select text in <label> associated with a <select> https://bugzilla.mozilla.org/show_bug.cgi?id=3D382369 Attachment 280664: Alternative patch, rev. 1 https://bugzilla.mozilla.org/attachment.cgi?id=3D280664&action=3Dedit ------- Additional Comments from Mats Palmgren <mats.palmgren@bredband.net> Measure the distance from the mouse-down -- assume it's a selection gesture= =0D if more than 2 pixels. I...

Why is the select saying selected after an item is selected?
This was a whitelisting issue due to a software upgrade at hostgator..  Nothing wrong with my code..Scot King SEO Software Tool | Search Engine Optimization"Get your page rank high"  huh? It is smart to put your question in the body and not just in the title. Have no idea what your question is or if it even a question.Eric Pascarello.com | Twitter epascarello | LinkedIn use thisddl.options[ddl.selectedIndex].selected = false; //Clear the selection ddl.options[1].selected = trueMAKMark as Answer if this reply helps youMVP ASP/ASP.NetASP.Net Hosting : Host DepotMy Sit...

superreview canceled: [Bug 444209] Filter only selected messages in a folder : [Attachment 328569] Filter Selected Messages UI
Jeff Beckley <beckley@qualcomm.com> has canceled Jeff Beckley <beckley@qualcomm.com>'s request for superreview: Bug 444209: Filter only selected messages in a folder https://bugzilla.mozilla.org/show_bug.cgi?id=444209 Attachment 328569: Filter Selected Messages UI https://bugzilla.mozilla.org/attachment.cgi?id=328569&action=edit ------- Additional Comments from Jeff Beckley <beckley@qualcomm.com> Some of my local changes didn't get included in the initial patch. Now they are in there. ...

superreview cancelled: [Bug 56314] reverse selection colors when page background is similar to default selection background : [Attachment 164736] Patch
Masayuki Nakano (Mozilla Japan) <masayuki@d-toybox.com> has cancelled Masayuki Nakano (Mozilla Japan) <masayuki@d-toybox.com>'s request for superreview: Bug 56314: reverse selection colors when page background is similar to default selection background https://bugzilla.mozilla.org/show_bug.cgi?id=56314 Attachment 164736: Patch https://bugzilla.mozilla.org/attachment.cgi?id=164736&action=edit ...

superreview cancelled: [Bug 336457] Mark selected search engine in the drop-down list : [Attachment 220880] Boldfaces selected engine name
Pam Greene (Google) <pamg.bugs@gmail.com> has cancelled Pam Greene (Google) <pamg.bugs@gmail.com>'s request for superreview: Bug 336457: Mark selected search engine in the drop-down list https://bugzilla.mozilla.org/show_bug.cgi?id=336457 Attachment 220880: Boldfaces selected engine name https://bugzilla.mozilla.org/attachment.cgi?id=220880&action=edit ------- Additional Comments from Pam Greene (Google) <pamg.bugs@gmail.com> Using a class rather than an ID. Also, because of some concurrent changes to the patch for bug 335441, this patch is now independen...

superreview canceled: [Bug 444209] Filter only selected messages in a folder : [Attachment 328572] Filter Selected Messages UI
Jeff Beckley <beckley@qualcomm.com> has canceled Jeff Beckley <beckley@qualcomm.com>'s request for superreview: Bug 444209: Filter only selected messages in a folder https://bugzilla.mozilla.org/show_bug.cgi?id=3D444209 Attachment 328572: Filter Selected Messages UI - Take 2 https://bugzilla.mozilla.org/attachment.cgi?id=3D328572&action=3Dedit ------- Additional Comments from Jeff Beckley <beckley@qualcomm.com> Here's a new patch that addresses Neil's comments. The code to apply filte= rs manually can't deal with messages living in multiple f...

superreview cancelled: [Bug 364896] [FIX] Would like to see the preview pane show last select msg when selecting multiple msgs
Mats Palmgren <mats.palmgren@bredband.net> has cancelled superreview: Bug 364896: [FIX] Would like to see the preview pane show last select msg when selecting multiple msgs https://bugzilla.mozilla.org/show_bug.cgi?id=364896 Attachment 249598: Patch rev. 1 https://bugzilla.mozilla.org/attachment.cgi?id=249598&action=edit ------- Additional Comments from Mats Palmgren <mats.palmgren@bredband.net> I'm not going pursue this if the module owners doesn't approve. I really do think suggested new behavior is an improvement. When dealing with large amounts of mail...

superreview cancelled: [Bug 300779] Support multiple selection for xul:tree : [Attachment 189992] Assume that space does nothing in single select
Aaron Leventhal <aaronleventhal@moonset.net> has cancelled Aaron Leventhal <aaronleventhal@moonset.net>'s request for superreview: Bug 300779: Support multiple selection for xul:tree https://bugzilla.mozilla.org/show_bug.cgi?id=300779 Attachment 189992: Assume that space does nothing in single select https://bugzilla.mozilla.org/attachment.cgi?id=189992&action=edit ...

Web resources about - Canceling a select - sybase.powerbuilder.general

Mark Ruffalo on His “Man-Canceling” Avengers Outfit - YouTube
Scarlett Johansson talks about filming Avengers: Age of Ultron while pregnant and Mark Ruffalo comments on the “man-canceling” suit he had to ...

Mexico to compensate China's CRCC for canceling rail project
Mexico to compensate China's CRCC for canceling rail project

9to5Toys Lunch Break: 10400mAh power bank $17, Noise Canceling headphones 50% off, PS4 Bloodborne bundle ...
... Lumsing 10400mAh power bank $17 , Anker 25W 5-port charger $16 Prime shipped, more Tune out the riffraff with 50% off Sony Noise Canceling ...

'Jack Reacher' Director on Canceling Premiere Post-Newtown: Nobody Should Be Celebrating
Christopher McQuarrie, director and screenwriter of "Jack Reacher," said he endorsed Paramount's decision to cancel the Pittsburgh premiere of ...

Obama official confirms Russian gay crackdown played role in canceling Putin summit
The deteriorating human rights situation in Russia, specifically including gay and trans rights, played a role. .


Bose files suit against Apple-owned Beats over noise-canceling headphone patents
According to a tweet from CNBC , audio giant Bose has just filed suit against Apple-owned Beats over noise-canceling headphone technology patents. ...

Bose files lawsuit against Apple's Beats over noise canceling tech
Bose Corporation filed the complaint against Beats Electronics, LLC and Beats Electronics International Limited in a Delaware court, asserting ...

Visa Europe Offers iZettle Few Reasons For Canceling Their Contract
Earlier this week iZettle sent out e-mails to their users in Denmark, Finland and Norway that Visa Europe has cancelled their contract in those ...

Verizon Wireless makes canceling contracts up to $70 more expensive
Anthony Fine Verizon Wireless just made it more expensive to cancel service by delaying monthly reductions in early termination fees (ETFs) ...

Resources last updated: 1/22/2016 12:45:26 AM