updata in database

[yangyang-rexxar]

Hello,Labviewers

    I have a question in database operation.I passed a labview cluster which contains different types data to an  access table field.This type is OLE in access.

    When I updata log I can't find a vi that pass the new cluster to access,I can but updata a string type,I have no ideal updata a cluster type.

Regards.

paulbin

from china

[Aitortxo]

Hi Paulbin:

I would manage a table with columns of different types instead of columns of cluster types: You can have 4 columns (2 DBL and 2 INT) instead of the cluster you want as OLE.

Then you could update every column with SQL sentences as you try to.

[yangyang-rexxar]

Hi Aitortxo:

    I have another similar question.I have inserted successfulaccess log when I use cluster,it's binary data. Labview show error when I replace the cluster with a float number follow your advice,It's "insert into expression error".The diagram have no more change.

paulbin

from china