LabVIEW

cancel
Showing results for 
Search instead for 
Did you mean: 

How to write a string containing an asterik to an access database.

When updating a string to an access database, the asterik contained in the string is causing an error in the query. How can you get around this?
0 Kudos
Message 1 of 2
(2,561 Views)
Hi Ron,

The easiest way would be to send that as text datatype e.g

INSERT INTO mytable (textcol) VALUE ('*')

I just tried that and it works. hope this would work out for you.

A Rafiq
0 Kudos
Message 2 of 2
(2,561 Views)