Filemaker Database, accessing "strings"

[CrystalTech]

I am able to connect to my Filemaker Database Tables.  I can see the specific tables and the key columns.  I can access the numeric data.

My problem is accessing strings.  The variant lists the strings as "Variant Type -> VT_BSTR" but I receive empty strings.  The "string array column" is initialized and empty, but the numeric string columns have the correct data.  I also have an issue with time and date, but retrieving STRING is the important issue for me.  Why do I receive all the numeric data, but not the strings?  I have received all the data from Filemaker when I used MS Excel.  I even copy and pasted the SQL script from Excel and still could not get the strings within Labview.

Thanks in advance, CrystalTech.

[Himanshu_Goyal]

Hi Crystal,

Change your data type from variant to varchar to get the string data. Same convert Date Time Stamp to string and then save to your database in varchar format

Share some more information or code to get the proper support.