Steve_Brooks

QUOTE(jennifer @ Jan 28 2008, 11:58 AM)

I want to show the first two strings in a row in a diagram. How can this be realized?

Jennifer,

I made a few additions to your VI. I don't know if this is exactly what you were looking for but the VI now lets you select a row then gives you the first two elements that are comma seperated.

Hope this helps.

Steve

Hi Steve,

what error do you get? Does this error come from the Toolkit VIs or maybe from the interface driver of the access database?

alex

3563[/snapback]

Here is the exact error:

Error -2147217887

Cmd Execute.vi->DB Tools Insert Data.vi->Section Sub.vi<ERR>Exception occured in Microsoft OLE DB Provider for ODBC Drivers, [Microsoft][ODBC Microsoft Access Driver]Invalid precision value . in Rec Create - Command.vi->Cmd Execute.vi->DB Tools Insert Data.vi->Section Sub.vi

It looks like the error is coming from the toolkit VIs.

Steve

I am writing data to an Access database using the database connectivity toolkit. I have a large text field that I need to write so I made the field a memo field instead of text. Text fields can only have 255 characters and memo fields are supposed to support 65,563 characters.

The problem is when I write more than 255 characters to the memo field I get an error. Has anyone been able to write more than 255 characters to a database field?

Thanks,

Steve

From the menu select "Edit - Import picture from file..."

Choose the file you want inserted

Go to front panel and paste picture.

:thumbup:

I pretty much agree with John H. I have done a few contract programs in LabVIEW but all of my cases have been production testers so the customer always wants the source code to be able to update. In these cases I do not sell them the reusable libraries but lock them out.

If I were to do an application where the final product was for re-sale, I would not sell the source code unless they agreed to pay a substantial amount to own it and I didn

....didierj definitely has the best solution ( way better than my first post ). This way you don't have to worry about any changes to the cluster.

If you know the index of the control in the cluster (cluster order) then you can use Index Array function and not have to go through the entire cluster in the for loop. The thing you have to be careful of here is if the cluster order changes.

You could also use the Search Array function to find it's index then use index array to get the controls reference that way.

Hope this helps. :thumbup:

Steve

There are many ways of doing this but here are two: If you have LabVIEW 7 Express you can show the VI in a sub panel window. If you don't have this version, you can just set the sub VI to pop up in it's own window. If you would like an example of a sub panel just email me.

sbrooks@baldor.com

I would appreciate it!