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
PowerBuilder connect to Azure database using SqlAu...
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.