odbc + visualfoxpro +ms access

[pomawo]

Hello,<br><br>I have three questions about odbc <br>First some information : I have made an odbc link between an visual fox pro relation sales system and an accesss<br>Invoice system. The odbc link works fine.<br><br>My first question is (see *) <br>How can I make this statement correct, so that the value of ln_test wil be passed in the statement <br><br>My second question is<br>How can I put an array or cursor in an sql-insert statement. If i want to insert more attributes of an record.<br>I wanrt to point here to array klant_odbc<br><br>My third question<br>How can I search with an sql statement to a value and how can I filter ( such as set filter to in Visual Fox Pro) the records of the access database (so that it is possible to add,delete and modify waht is not possible by a view query)<br><br><br>Thanks to everyone who helps me<br><br>&&& koppeling met access databas<br>ln_klantid = thisform.relatie.value<br>ln_test = &quot;MAART7&quot;<br>SELE klanten<br>SELECT klantid,naambedrij,voornaamco from klanten where klantid = thisform.relatie.value  into array klant_odbc<br><br>lnhandle = sqlconnect('factuur')<br>IF lnhandle &lt;= 0<br>MESSAGEBOX('Kan geen verbinding maken', 16, 'SQL Connect Error')<br>ELSE<br>MESSAGEBOX('Verbinding gemaakt', 48, 'SQL Verbinding met <br>facturerings systeem')<br><br>* sqlexec(lnhandle,&quot;insert into klanten (klantid) values &quot; + (ln_test))<br><br>SQLDISCONNECT(lnhandle)<br>ENDIF