Hi all,

we have an application that's basically a scriptable data pumper: we
use it for all db replication needs.

Now and then, I catch the following error in its log file:

15/10/2003 17.37.54:SESSIONIOPERATORE (1 nuovi, 0 agg., 0 errori, 4 rec/secondo)
15/10/2003 17.37.54:SESSIONIMACCHINARIO (0 nuovi, 0 agg., 0 errori, 0 rec/secondo)
15/10/2003 17.37.55:SESSIONIATTIVITA (0 nuovi, 0 agg., 0 errori, 0 rec/secondo)
15/10/2003 17.37.55::ISC ERROR CODE:335544382

ISC ERROR MESSAGE:
cannot sort on a field that does not exist

The app is doing the following pseudo-code:

while not SourceQuery.EOF do
Set ExistsQuery.Params from current rec
if ExistsQuery.Execute then
// the record exists: UPDATE tab SET ...
Set UpdateQuery.Params from SourceQuery's current record
UpdateQuery.Execute
else
// it's a new record: INSERT INTO tab (...)
Set InsertQuery.Params from SourceQuery's current record
InsertQuery.Execute
Next

Since there is a daemon that runs the app every minute, the next run
works just fine, without any error.

Any hint on where the source of the problema may be?

Thanx a lot,
bye, lele.
--
nickname: Lele Gaifax | Quando vivrò di quello che ho pensato ieri
real: Emanuele Gaifas | comincerò ad aver paura di chi mi copia.
email: lele@... | -- Fortunato Depero, 1929.