Hi Mark,The problem is indeed still not resolved. I’ll try to explain better.We have a boolean/switch, include pickup (or delivery). When the outcome is Y, a transport row is created, the pickup or delivery: if @cursor_from_col_id = 'include_pickup'begin if @include_pickup = 1 begin INSERT INTO Transport (shipment_id, sequence, routing_type, modality_id, transport, contract_id, pickup_accou etc.When the boolean/switch is turned back to N, the transport row has to be deleted. But, users can have added new data to this row. We check this before and want to give a warning. Can the row be deleted or do you want to remove the data first? Check: else if @include_pickup = 0 and @is_deleted = 0 begin if ( @cost is not NULL or @transport_contract_id is not NULL or @pickup_transport_date_actual is not NULL or @pickup_remarks is not NULL orAfter check:begin exec dbo.tsf_send_message 'warning_delete_transport', null, 1 end else begin --exec dbo.tsf_send_mes
Thank you @Mark Jongeling for your answer, but it’s not a delete action from the user through a button or task I’m talking about.I want to use a message in a default procedure. So, after the if statement (boolean = N), I am going to delete a row in another table. But, if there are data in this row, the user get’s a message. I would like them to choose if the row will be deleted or not. Strangely enough, if I use a message in my code with severity error, the action is still taken, which is not described as such.
@Mark Jongeling Thanks! I knew the ALT option for a pop-up screen, but not this one and this indeed is the one I needed. Now I only have to solve the problem that the detail tiles open a new tab on the ‘shipment’ level and not on the detail level of the shipment(s). A whole new world to discover ;), I started learning and working with TW only two months ago! Grtz Saskia
Already have an account? Login
Enter your username or e-mail address. We'll send you an e-mail with instructions to reset your password.
Sorry, we're still checking this file's contents to make sure it's safe to download. Please try again in a few minutes.
Sorry, our virus scanner detected that this file isn't safe to download.