[Catgen-developer] IOB notes

[Marc B. <mbe...@ho...>]

(Alexey, Eugene - make sure you are both subscribed to =
catgen-developer.)

I want to explain difference between $TPCode$ and $TPCode||text$.  The =
last will surround item in quotes and also escape embedded quotes.  So =
for instance:

condition=3D"TPCode =3D '$TPCode' "=20

and=20

condition=3D"TPCode =3D $TPCode||text"=20

are equivalent (since TPCode cannot contain embedded quotes), and =
therefore use the last one preferentially because it is more clear.

Consequently, when inserting numeric item into database, do not use say =
$isLive||text$ but only $isLive|0$. (the last is default value, =
important in case of numeric columns).

Also, as I mentioned, explore inserting current date into any dbStore =
operation as=20
<iob:dbStore
    columns=3D"abc,...,isSynchronized,DateUpdated"
    values=3D"...,0 ,$sysdate$".  (or, $sysdate||text$)

And also always remember to update isSynchronized as above.  This is =
very important.

Marc.