Hi Albert,

First, you don't need SqlPrepare. Second, the parameters in SqlExec starts with '?'.

l_fehler = SQLEXEC(l_verbindungsnr,'INSERT into t_adressen SET adressnr = ?l_adressnr, name1 = ?l_tester')

Third, you can use AERROR() function to get detailed indo about ODBC error.

>Hello everybody !!
>I'm experimenting with Foxpro and a My_SQL Database (Windows) !
>The server is up and running ! I can connect ! I can read data into Foxpro cursors !
>
<snip>