INSERT INTO statement

[bboggessswcg]

I am building an SQL statement on the fly in my program from a recordset. My problem is that there are comma's in the data that is messing up my SQL string. Could you please help me find an answer to this as soon as possible. The only thing I have tried is putting in the Chr code for comma, but that did not work, or I have the wrong syntax. This data is being inserted into a .dbf file. Thanks in advance.

 

[poltergeist]

Have you any code example,

I suppose you havn't set a brackets arround a numeric Value

peterguhl@yahoo.de

 

[zemp]

The best way, IMHO, use ADO paramters.

See chiph's post in thread222-640856.

Thanks and Good Luck!

zemp