Subscribe via RSS
Toggle Submenu
  1. Categories
  2. Recent
  3. Tags
View Replies (1)

Resolved Insert into Select statement in a datawindow

  1. How-to
0
Votes
Undo
  1. Raymond Longoria
    Raymond Longoria
  2. PowerBuilder
  3. Monday, 13 March 2023 21:43 PM UTC

I want to use an Insert into Select statement in a datawindow but I get the following message:

Is there any way to do this?

  1. DataWindow
Work with Cluld Sqlanywhere database
Detecting and read a smart card from PowerBuilder
Accepted Answer
Chris Pollach @Appeon
Chris Pollach @Appeon Accepted Answer Pending Moderation
  1. Monday, 13 March 2023 21:54 PM UTC
  2. PowerBuilder
  3. # Permalink

Hi Raymond;

  For that type of DML statement, you would need to use PowerScript "inline" SQL.

Regards ... Chris 

Comment
Raymond Longoria
  1. Raymond Longoria
  2. Monday, 13 March 2023 22:05 PM UTC
OK that is what I thought. I was wondering if there is another way. Thanks!
  1. Helpful
Gregory Rusak
  1. Gregory Rusak
  2. Tuesday, 14 March 2023 01:02 AM UTC
What about using a Datawindow and setting the dwitemstatus (SetItemStatus) to New! or NewModified! ?
  1. Helpful
Chris Pollach @Appeon
  1. Chris Pollach @Appeon
  2. Tuesday, 14 March 2023 01:23 AM UTC
Hi Greg;

That would work but would be extremely slow compared to a "Select into...." DML command.

Regards ... Chris
  1. Helpful
There are no comments made yet.
Responses (1)


There are replies in this question but you are not allowed to view the replies from this question.
We use cookies which are necessary for the proper functioning of our websites. We also use cookies to analyze our traffic, improve your experience and provide social media features. If you continue to use this site, you consent to our use of cookies.