0 Replies Latest reply on Apr 3, 2013 1:11 PM by jhaughey10

    ESS Shadow Table Not Showing SQL rowversion column

    jhaughey10

      Title

      ESS Shadow Table Not Showing SQL rowversion column

      Post

           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?

            

           Thanks!