SQL_insert in Diadem 8

[markbolc]

Hello,

I would like to copy the path of a measurement file in an access-Database with the command "SQL_insert" (I'm still working with Diadem 8):

Problem: The Path contains an apostrophe:

T3:='c:\va's_neu\test';
SQL_INSERT('mes_Leistung_konst','Ablablagepfad',T3);

produces an error message

I tried the following commands:

SQL_Connect('Versuchsauftrag_be','user1','',''); 

SQL_INSERT('mes_Leistung_konst','VANr','va's');

SQL_Disconnect;

-> error mesage: Fehler in Autosequenz - Übersetzung in Zeile: 3 - Autosequenz - Texte müssen in Hochkommata eingeschlossen sein

SQL_Connect('Versuchsauftrag_be','user1','',''); 

SQL_INSERT('mes_Leistung_konst','VANr',"va's");

SQL_Disconnect;

-> error mesage:

Fehler im ODBC-Befehl: [Microsoft][ODBC Microsoft Access Driver] Syntax error in string in querry expression 'va's)'. SQL: INSERT INTO mes_Leistung_konst (VANr) VALUES (va's)

Is there al solution for this Problem? Perhaps with the SQL_ExecDirect-command?

Thanks a lot!

Markus

[Twigeater]

Hello Markus!

SQL_INSERT('Tabelle1','Test',"'va''s'");

worked on a 'Text' field in an Access DB.

Matthias

[markbolc]

Hello Matthias,

That works,

thank you very much!

Markus