Database Variant To Data memo

[PJGCC1]

I am tring to read back a memo field from a MS access database using labview 8.2's  Database vi "Database Variant To Data" with a string wired to the type terminal. I get an error message to say the data type is incorrect.

Anyone got any ideas on how to read the memo field back.

OS windows XP
Labview 8.2
MS Access 2000

[mickeyw]

Hi,

From initial research this seems like a common problem, as well as people not being able to place the variant to data icon on the block diagram.

I have attached some example code which may solve your problem. Have you tried unistalling and re-installing Labview and MAX? This should solve any corrupted installation issues. This thread is of a similar vein, and may be of some assistance in your application.

I wish you success with your application, let me know of any further problems.

Regards,

[PJGCC1]

Mike

Thanks for the information, firstly I could not open your vi as I am still using LV8.2, we can not afford the time to revalidate over a 1000 vis.

As far as the use of Database Variant to Data vi, I use it a lot, but the problem is that when you set a field within MS Access to Memo the DVtD vi (with string type) returns with an error the say wrong data type.

The reason for using data type memo, is because access limits text to 255 characters.

Peter

[mickeyw]

Hi Peter,

I have attached the VI again, but saved in 8.2. Let me know if you manage to open it and if it is useful. If not, we can go back to the drawing board. Was the other information helpful? Meanwhile, maybe you could send your code so I can have a look myself and see if I can solve the problem here. I am assuming you have the database connectivity toolkits installed? 

I hope this is of some assistance. If the examples are in a later version of Labview, let me know and I can save to 8.2 and post them.

Regards,

[PJGCC1]

Sorry Mike

But your code is still seen as 8.5.

Yes I am using Database Connectivity Toolkit, .UDLs to link to the access database. I am reading & writing data to the DB not trouble at all, but when reading the BinNoHistory memo field it objects. We have always had trouble in writing to a memo field (when inserting a new data record), we insert a small amont of data and then update it using the attached vi.

Peter

I have attached the DB table & Memo updating vi

[mickeyw]

Hi Peter,

Sorry for the delayed reply. There may be a problem with your database connectivity toolkit, in which case this article gives known issues with the toolkit and suggests work-arounds for each problem.

There is also a database connection demo at Start>>>Programs>>>National Instruments>>> Labview Database Connectivity Toolkit>>> Database Connectivity Demo. I believe it will open in Labview 8.2.

I hope this is of some assistance to you.

Regards,