Hi, recently i had to log a drip tape in the Database, but it has a different behaviour compared to other tapes, as its flow decreases as pressure rises (see image attachment).
The field only allow ZERO or positive numbers, and this limitation is blocking me from proceeding with this project.
Is there a way to allow for negative indexes?
Thank you in advance.
I'm available if further clarifications are needed.
Allow for negative values in Emitter Incdex
-
- Posts: 2
- Joined: Thu Jan 04, 2024 12:51 am
- Company: Minas Bombas
- City / Town: Vitória da Conquista
Allow for negative values in Emitter Incdex
You do not have the required permissions to view the files attached to this post.
- jovivier
- Site Admin
- Posts: 928
- Joined: Thu Mar 12, 2009 2:57 pm
- Company: Lincoln Agritech Ltd, IRRICAD Software
- City / Town: Lincoln
- Location: Canterbury, New Zealand
- Contact:
Re: Allow for negative values in Emitter Incdex
Negative values can be inputted via the Query tab however this is not something we would recommend as Detailed Analysis will not be able work and there is likely to be some cosmetic issues in the reports (where positive and negative signs are used).
Note that if the tape is nominally pressure compensating use an index of zero.
To add a negative value, access the tape's parameters via the "Query":-
To turn on the Query tab in the database go to Tools|Options in the Database Editor and enable "Show Query tab".
The Query tab will now be visible after the Nozzle tab on the far right.
1. In the bottom panel copy and paste the below SQL:-
SELECT Components.Description, Tapes.Reals1 AS [Emitter Constant], Tapes.Reals2 AS [Emitter Index], Tapes.Reals3 AS [Emitter Barb Factor], Tapes.Reals4 AS [Emitter Spacing] FROM Tapes INNER JOIN Components ON Tapes.[Pipe Key] = Components.[Component Key]
2. Now action Query|Execute Query.
3. Locate the required product and enter the negative index.
If you wish to save the query, then copy and paste:-
Show Tape Emitter Coefficients and Spacing
in to the "Query name" field at the top and action Query|Save Query
The IRRICAD team
Note that if the tape is nominally pressure compensating use an index of zero.
To add a negative value, access the tape's parameters via the "Query":-
To turn on the Query tab in the database go to Tools|Options in the Database Editor and enable "Show Query tab".
The Query tab will now be visible after the Nozzle tab on the far right.
1. In the bottom panel copy and paste the below SQL:-
SELECT Components.Description, Tapes.Reals1 AS [Emitter Constant], Tapes.Reals2 AS [Emitter Index], Tapes.Reals3 AS [Emitter Barb Factor], Tapes.Reals4 AS [Emitter Spacing] FROM Tapes INNER JOIN Components ON Tapes.[Pipe Key] = Components.[Component Key]
2. Now action Query|Execute Query.
3. Locate the required product and enter the negative index.
If you wish to save the query, then copy and paste:-
Show Tape Emitter Coefficients and Spacing
in to the "Query name" field at the top and action Query|Save Query
The IRRICAD team
-
- Posts: 2
- Joined: Thu Jan 04, 2024 12:51 am
- Company: Minas Bombas
- City / Town: Vitória da Conquista
Re: Allow for negative values in Emitter Incdex
Thank you for clearing this matter. I think we will proceed with index zero and fixed flow.
Thanks again
Thanks again
