General information
Category:
Databases,Tables, Views, Indexing and SQL syntax
Doug,
I am still experiencing the same problem.
It is surprising that the portion of the program that's supposed to take care of my problem, which I pasted below, has not executed at all-I inserted a code here to log the event when it happens and none has ever been logged! I believe that this should not be reality because at least once my users can easily be on the same record.
CASE upper(lcField) = 'CTD_NSTAINCT' or ;
upper(lcField) = 'CTD_NREPAIRCT' or ;
upper(lcField) = 'CTD_NWATERWASHCT' or ;
upper(lcField) = 'CTD_NBRCT' or ;
upper(lcField) = 'CTD_NWORNCT' or ;
upper(lcField) = 'CTD_NCANCELCT' or ;
upper(lcField) = 'CTD_NSHPMISCCT' or ;
upper(lcField) = 'CTD_NISSUECT' or ;
upper(lcField) = 'CTD_NRCVDCT'
lnOtherUserChange = luCurVal - luOldVal
lnThisUserChange = luValue - luOldVal
*
replace (lcField) with luOldVal + lnOtherUserChange + lnThisUserChange
Could I be missing something here? I really need more help from you or anyone.
TIA,
Evelyn
Previous
Next
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only