how I can make to insert a registry in a table of Access with vfp 6, I did it with ado object, but insert does not work with more of a field, it gives error me.
pconn=createobject("ADODB.Connection")
pconn.open(strconn)
carti = '19999'
cchasi = "HDHDGSS"
ctipo = "CARRO"
cmarca = "TOYOTA"
cmodelo= "CAMRY"
ccolor = "NEGRO"
nano = "2005"
cplaca = "ABDG32"
cmotor = '763HSD'
xselect=[insert into vehiculos(articulo,chassis,tipo,marca,modelo,color,ano,placa,motor) values(&carti,&cchasi,&ctipo,&cmarca,&cmodelo,&ccolor,&nano,&cplaca)]
rstabla = createobject("ADODB.Recordset")
oconn =pconn
rstabla.cursorlocation = 3
rstabla.cursortype = 2
rstabla.locktype = 4
rstabla.open (xselect,oconn)
Jose Manuel Ramirez