Select (SQLite) outputs String "System.Byte[]" for BLOB type fields

geloescht · March 26, 2018, 5:47pm

Hi everyone,
if a field has a BLOB value (binary data) in a SQLite database, the corresponding output pin has type string and is always set to “System.Byte[]” regardless of the data contained in the database. Would be nice if this could become a Raw pin or at least a hex representation of the data.
I hope this is the right place to report addonpack bugs.
Anyway, keep patchin’,
geloescht

joreg · March 28, 2018, 11:17am

hei geloescht,

in such a case it is always good to figure out who initially created the node and mention them here, so they have a chance to see your problem. so in this case you could ask @vux if he’d be up fixing this.

but even better of course, use the power of opensource and contribute a fix yourself or find someone who could do so. quickly browsing the sourcecode it seems to me the problem is here:

github.com

vvvv/vvvv-sdk/blob/develop/vvvv45/addonpack/src/nodes/plugins/Network/Databases/BaseDatabaseNodes/Nodes/AbstractSelectNode.cs#L273


        {

            this.FPinOutFields[fname].SliceCount = 0;

        }

    }



    for (int i = 0; i < rowcount; i++)

    {

        DataRow row = dst.Tables[0].Rows[i];

        foreach (string matchedfield in matchingfields)

        {

            this.FPinOutFields[matchedfield].SetString(i, Convert.ToString(row[matchedfield]));

        }

    }



    ondata = true;

    this.FPinOutStatus.SetString(0, "OK");

}

catch (Exception ex)

{

    this.FPinOutFieldNames.SliceCount = 0;

    this.FPinOutStatus.SetString(0, ex.Message);

system · March 28, 2019, 11:23am

This topic was automatically closed 365 days after the last reply. New replies are no longer allowed.