Currently in the form when it loads should check to see if there are any freight

sudhirp804 over 10 years ago

Currently in the form when it loads should check to see if there are any freight options already there and show them (as it does now) then when the user submits the form the existing freight rows in the DB should either be updated or deleted and overwritten. Could anyone let me know in how I can use the Query Database smart service and what query I should write so that existing freight row should be updated or deleted and overwritten. This query we have used earlier and in this case it deleted the existing freight detail (DELETE FROM prmprojectfreight WHERE projectid = ac!projectId and amount>0)

What we need instead of deleting the existing frieght it should be updated or deleted and overwritten in DB.
...

workflow.docx

Discussion posts and replies are publicly visible

Parents

0 sudhirp804 over 10 years ago

Any update would be helpful. I have tried Delete from Data Store Entities Smart Service to remove them from the database. Its getting me to the same page instead of deleting the record it adding a duplicate record. Could someone suggest Query Database Smart service to updated or deleted and overwritten in DB.
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel

Reply

0 sudhirp804 over 10 years ago

Any update would be helpful. I have tried Delete from Data Store Entities Smart Service to remove them from the database. Its getting me to the same page instead of deleting the record it adding a duplicate record. Could someone suggest Query Database Smart service to updated or deleted and overwritten in DB.
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel

Children

No Data