Posts by Pablo Dos Santos Neves • 23 points
5 posts
-
0
votes3
answers405
viewsA: Trigger that inserts automatic value in a record
Good afternoon, I appreciate the help. I was able to solve thanks to your advice. The query was like this. BEFORE INSERT OR UPDATE ON TGFPAR --REFERENCING OLD AS OLD NEW AS NEW FOR EACH ROW DECLARE…
-
0
votes3
answers405
viewsQ: Trigger that inserts automatic value in a record
Good afternoon, guys. How are you? I’m trying to create a Rigger that when performing a partner registration it automatically marks that the partner is a client. In the database, this field is…
-
2
votes0
answers34
viewsQ: Trigger that validates the percentage of each tranche in a purchase note greater than x value
Good morning, I’m having a hard time creating a Rigger that checks on the Insert and update a higher apportionment number than x ( I’m using 30 for testing) on each purchase note. This is the first…
-
-1
votes1
answer28
viewsQ: Compare null field
Good afternoon guys, all right? I am putting together a financial report where I wish to create a field that returns me whether that amount has been paid or not. The query checks the date of the…
-
0
votes1
answer21
viewsQ: Problem with ireport Parameters 4.0.1
Good night, I’m doing a report on Ireport 4.0.1 and I’m having difficulty with some parameters. I have a billing report that requires the code here for some filters. The same are, the initial and…