TVariantField not supported in SaveToFile/SaveToStream

yeohray · Post by **yeohray** » Tue 11 Sep 2007 11:20

Are there any plans to support the saving and loading of TVariantField in the future? These types of fields are unfortunately quite common in the Microsoft SQL Server world e.g. SELECT SERVERPROPERTY('productversion'), SELECT DATABASEPROPERTYEX('IsFulltextEnabled')

The workaround is to cast the value to a string type, but users don't want to have to always do that.

Thanks.

Antaeus · Post by **Antaeus** » Wed 12 Sep 2007 13:21

Try to use the SaveToXML method instead. It has limited support for saving/loading variant fields.
We will consider adding support for saving/loading TVariantField fields to the Virtual table format in the next builds/versions.

yeohray · Post by **yeohray** » Wed 12 Sep 2007 13:42

I tried saving to XML, but the resulting file is far too large. Thanks.

yeohray · Post by **yeohray** » Fri 14 Sep 2007 10:47

When a new version that supports saving/loading TVariantField is available, would this be available separately, or would I have to wait until a new version of the product license that I have (SDAC Pro) is available?

Thanks.

Antaeus · Post by **Antaeus** » Fri 14 Sep 2007 15:08

We will include fix to this problem in the next SDAC build. It will be released in the nearest time.