1. 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?

Accepted Answer
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 

  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
  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
  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.

There are replies in this question but you are not allowed to view the replies from this question.