If only the where expression changes then it should be relatively easy with one SDO. Take a look of the setQueryWhere function in the on-line help. Other useful function might be addQueryWhere.
Hope this helps...
year first
You can do
SUBSTITUTE('&1&2&3', YEAR(d), STRING( MONTH(d),'99'), STRING( DAY(d),'99') )
which will output yyyymmdd
Replace d with today or what ever date variable you want.
Shared variables in trigger procedures
This is what you want to do: tell Epicor it is a bad bad thing to have shared variables especially in triggers!
In the mean time you may be able to find out from the error messsage what variables are needed and define those in your procedure.
I am the compiler
If I would be the compiler and see for each statement with today function I would think I have to find out what is the value of today function for each row I fetch from the database. It might be time consuming...
If there would be a constant value it would be a lot...
If you can avoid it?
If the same tab settings must be set for the whole document it might be easier to create a .dot file with all necessary settings and styles done. Then you just base your new document to that template and use those styles for your paragraphs.
CR/LF or just separate lines?
On the subject you said you'd need CR/LF terminated lines but in the text there was just you'd want fields to be on separate lines. So the answer depends what you really need.
If it is enough to have all fields appear on a line of it's own try
export...
You can try to override db triggers
You can write your own trigger which overrides the stored trigger if it is overridable (which I doubt since the initial value is not overridable).
on write of shiphead override do:
/* nothing */
end.
your code goes here
Maybe You really should...
You have to buy it
Hi!
You have to buy a licence for Progress appServer just like you buy for the database products. Contact PSC and they will be more than :biggrin: to sell you all the needed pieces for deployment.
Hope this helps...
You had the answer in your question
I thought of three possible solutions:
(Note, these are examples only - No error checking, typos included, warranty not...) Sorry, this is rather long answer.
1. memptr
Read the whole file into memptr at once and then loop through the file.
It is...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.