<div>
<div class="content wysiwyg-content">
dbs.Execute &quot;INSERT INTO Paulson &quot;&nbsp;_<br />
&nbsp; &nbsp;&amp; &quot;(Pnum,Hcode,Des,Ven,Cost,<wbr />Lstprc,Pri<wbr />ce,....) VALUES &quot;&nbsp;_<br />
&nbsp; &nbsp;&amp; &quot;(inPnum,inHcode,inDes,inV<wbr />en,inCost,<wbr />.......);&quot;<wbr /><br />
<br />
produces &nbsp; &nbsp; Run-time error '3061'<br />
&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;Too few parameters. Expected 12.<br />
<br />
Pnum is one of 12 valid fields defined on the existing Foxpro 2.6 database. This code follows my deletion of all records in the Foxpro database - the database is still open.<br />
&nbsp;<br />
inPnum is one of 12 valid variables each containing valid data.<br />
<br />
Any ideas?<br />
<br />

</div>
</div>


dbs.Execute "INSERT INTO Paulson " _
   & "(Pnum,Hcode,Des,Ven,Cost,Lstprc,Price,....) VALUES " _
   & "(inPnum,inHcode,inDes,inVen,inCost,.......);"

produces     Run-time error '3061'
             Too few parameters. Expected 12.

Pnum is one of 12 valid fields defined on the existing Foxpro 2.6 database. This code follows my deletion of all records in the Foxpro database - the database is still open.
 
inPnum is one of 12 valid variables each containing valid data.

Any ideas?



Using VB 5.0 to add Foxpro 2.6 records

Visual Basic is Microsoft’s event-driven programming language and integrated development environment (IDE) for its Component Object Model (COM) programming model. It is relatively easy to learn and use because of its graphical development features and BASIC heritage. It has been replaced with VB.NET, and is very similar to VBA (Visual Basic for Applications), the programming language for the Microsoft Office product line.