ESS Shadow Table Not Showing SQL rowversion column
We are using several SQL tables in our FileMaker solution. We access pre-built stored procedures via Execute SQL to retrieve rows and create new rows. There is no problem with this.
Now, we would like to use a FileMaker interface to UPDATE rows also. Problem is that our stored procedures require FileMaker to first obtain the old SQL rowversion, and pass it back with the updated data. That's a problem because that column seems to be unavailable in Filemaker.
Not sure if it's because it's a binary data type...or...? The rowversion field does not even appear on the available field list in the ESS shadow table.
Any ideas? Any workaround suggested?