PV Ramone
17th April 2002, 10:35
We have just installed c4 (incl sp9 and some weekly patches) and upgraded to portingset 6.1c.06.02
After the upgrade one of our customized scripts is malfunctioning:
Somewhere in the script a select statement was done to select all items without a "/" on position 8. (special items in our company)
it said something like :
select ...
from psfrm010
where
and psfrm010.fitm(8;1) <> "/"
...
it was this line that caused the problem.
Nothing was selected although lots of items fulfill the conditions.
During some more testings I changed the line into
... and psfrm010.fitm(8;1) not like "/" ...
and now it works.
It must be something to do with the newer tools version (somewhere in a service pack) or the portingset.
I have no clue yet on any specific objects or programs to check.
Has Baan changed the functionality in order that a "/" is a special character in sql in c4 ?
After the upgrade one of our customized scripts is malfunctioning:
Somewhere in the script a select statement was done to select all items without a "/" on position 8. (special items in our company)
it said something like :
select ...
from psfrm010
where
and psfrm010.fitm(8;1) <> "/"
...
it was this line that caused the problem.
Nothing was selected although lots of items fulfill the conditions.
During some more testings I changed the line into
... and psfrm010.fitm(8;1) not like "/" ...
and now it works.
It must be something to do with the newer tools version (somewhere in a service pack) or the portingset.
I have no clue yet on any specific objects or programs to check.
Has Baan changed the functionality in order that a "/" is a special character in sql in c4 ?