Skip to main content

In the docu for the Esri Geodatabase SDE Reader (ArcObjects) it says about the ARCHIVE WHERE CLAUSE:

ARCHIVE_WHERE

... One or both of the GDB_FROM_DATE or GDB_TO_DATE column names must be specified in order to form a valid where clause. If the GDB_FROM_DATE is not specified, the creation date of the archive will be assumed. If the GDB_TO_DATE is note specified, the current date will be assumed.

...

Suggestion:

It wouldn't hurt to add the detailed sytax to the docu, which is output to the FME Log only if you do something wrong in the WHERE CLAUSE:

i.e.:

The archive where clause must be in the format

'GDB_FROM_DATE|GDB_TO_DATE <logical operator> <date>

[AND GDB_FROM_DATE|GDB_TO_DATE <logical operator> <date>]*'

and be space delimited


Things like "(" or ")" which are standard in SQL are NOT allowed.


Michael


https://docs.safe.com/fme/html/FME-Form-Documentation/FME-ReadersWriters/geodatabase/GEODATABASE_SDE_writer.htm