Page 1 of 1

TVariantField not supported in SaveToFile/SaveToStream

Posted: Tue 11 Sep 2007 11:20
by yeohray
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.

Posted: Wed 12 Sep 2007 13:21
by Antaeus
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.

Posted: Wed 12 Sep 2007 13:42
by yeohray
I tried saving to XML, but the resulting file is far too large. Thanks.

Posted: Fri 14 Sep 2007 10:47
by yeohray
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.

Posted: Fri 14 Sep 2007 15:08
by Antaeus
We will include fix to this problem in the next SDAC build. It will be released in the nearest time.