jing tung wong
Rank: #33495
14Views
7Comments
Solved
Delete Statement error
Question
SQL
Database

Halo,

I am facing error when to do my delete statement, anyone of you can help me?

Please find the attached file.


Thank you



deletestatementerror.png

0
0
on 8th Feb
Copy link to comment
João Marques
Rank: #55
Solution

Hi Jing,


Try it like this:


DELETE FROM {Visitor}

WHERE NOT EXISTS (SELECT 1 FROM {Visit} WHERE {Visit}.[VisitorId] = {Visitor}.[Id])


EDIT: Besides the syntax, you will also need to add an output structure like it is mentioned below.

Hope it helps.


Kind Regards,
João

0
0
on 8th Feb
Copy link to comment

Hi Jingtung,

As mentioned in the error message, you still need to put an Output structure (same requirement for Select) for a delete process.

Kind regards,

Chris

0
0
on 8th Feb
Copy link to comment
Sachin Waghmare
Rank: #300

Hello,

Please set a structure under Output Entities / Structures folder available into the screen you had shared.  I have highlighted for your reference.

Thanks & Kind Regards,

Sachin


0
0
on 8th Feb
Copy link to comment
jing tung wong
Rank: #33495

Halo All,

Thanks for your replied.

Like this correct? 

Please find the attached file.


Thank you


sample1.png

0
0
on 8th Feb
Copy link to comment
João Marques
Rank: #55

Since the DELETE operation in SQL doesn't return you anything, you actually just need to place an output structure or entity because Service Studio needs one.


So you can place there any entity and it would be good :)


0
0
on 8th Feb
Copy link to comment
Sachin Waghmare
Rank: #300

Yes, that is correct. However, I guess you need only first one.

0
0
on 8th Feb
Copy link to comment
jing tung wong
Rank: #33495

Replying to João Marques' comment on 08 Feb 2021 11:28:40

ok, so I just leave it like this.

Thank you so much

0
0
on 8th Feb
Copy link to comment