Allow for negative values in Emitter Incdex

Product improvement suggestions or feature requests can be made in this forum.
Post Reply
armandobastos
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

Post by armandobastos »

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.
You do not have the required permissions to view the files attached to this post.
User avatar
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

Post by jovivier »

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
armandobastos
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

Post by armandobastos »

Thank you for clearing this matter. I think we will proceed with index zero and fixed flow.
Thanks again :D
Post Reply