Hi guys,
I have been using progress for the last 8 years. but i haven't touch any SQL Statement. Can anybody help me in my problem regarding SQL Trigger? Basically, this is what I wanted to do:
Problem: I'm accessing the Progress DB via ODBC and wanted to update a table x field depending on the changes on the field of table y (same DB). I found out the by using ODBC the 4GL trigger will not work.
Solution: I want to define a simple SQL-92 Trigger. My problem
1. I don't know how to define.
2. I don't know how to do SQL-92 coding.
3. My goal is this:
Update the status of UAPE.PESTS = UZWF.WFASTS when I wrote a new value to UZWF.WFASTS and When UZWF.WFSSYS = "WORKFLOW" (This is by using ODBC).
I hope anybody can help me.
thanks
Allan
Allan,
Have you tried the Knowledgecenter?
https://progress.atgnow.com/esprogress/searchResults.do
For example:
https://progress.atgnow.com/esprogress/resultDisplay.do?gotoLink=4135&docType=1000&contextId=5049%3A4135.4226%2C1965.2132%2C4319.4540&clusterName=CombinedCluster&contentId=0569a058-9293-4e49-b348-d27f93d37c52&responseId=a6b23249f80b7ff7%3A1b1fbf4%3A107e1ddb485%3A53cb&groupId=1&answerGroup=4&score=733&page=http%3A%2F%2Fprogress.atgnow.com%2Fesprogress%2Fdocs%2FProgress%2Fesupport.progress.com%2FEDocHTML%2FProgress%2F91e%2Fdbd%2Fdbd-12-1.html&result=3&excerpt=FormoreinformationoncreatingJavatriggersseetheProgressSQL-92Guideand+Reference.&resultType=5000#Goto4135
HIH
Salvador
Hi Guys
Please tell me how to get unique value in our database .
I want it to be automatically generated.
Ajay Kumar
Can you elaborate please?