<div>
I'm New to using FoxPro Tables... The ONLY Thing I've Used FoxPro Tables for previously was to convert from dbf to SQL Server 7 or M$ Access...<br />
<br />
This Did The Trick!<br />
<br />
Thank You VERY VERY VERY MUCH!!!<br />
<br />
:)<br />
<br />
I've Upped this to 100 pts. &nbsp;Thank You Again!<br />
<br />

</div>


I'm New to using FoxPro Tables... The ONLY Thing I've Used FoxPro Tables for previously was to convert from dbf to SQL Server 7 or M$ Access...

This Did The Trick!

Thank You VERY VERY VERY MUCH!!!

:)

I've Upped this to 100 pts.  Thank You Again!



<div>
Hi FirstBorn<br />
<br />
not a problem, post a comment on here if you have any further VB/VFP questions with a link to the posted question and I'll have a look at it for you - I've been using both VB and VFP for 9+ years<br />
<br />
thanks for the points
</div>


Hi FirstBorn

not a problem, post a comment on here if you have any further VB/VFP questions with a link to the posted question and I'll have a look at it for you - I've been using both VB and VFP for 9+ years

thanks for the points

<div>
<div class="content wysiwyg-content">
Using a FoxPro 6 Free Table, I keep getting the following error:<br />
Operator/operand type mismatch error<br />
<br />
below is sample code that generates the error. &nbsp;I've had no previous problems working with (viewing, editing, updating, adding new, deleting, etc...) these tables before.<br />
<br />
strSQL = &quot;Select field1, default from FoxProTable where field1 = '&quot; &amp;&nbsp;Text1.Text &amp;&nbsp;&quot;' And default = 'True' &quot;&nbsp;<br />
<br />
With rstSQL<br />
&nbsp; &nbsp; .CursorLocation = adUseClient<br />
&nbsp; &nbsp; .CursorType = adOpenKeyset<br />
&nbsp; &nbsp; .LockType = adLockOptimistic<br />
&nbsp; &nbsp; .Open strSQL, cnnCnxn, , , adCmdText &nbsp;&lt;------ Error Occurs Here!<br />
End with<br />
<br />
Thanks in Advance!<br />
<br />
:)<br />

</div>
</div>


Using a FoxPro 6 Free Table, I keep getting the following error:
Operator/operand type mismatch error

below is sample code that generates the error.  I've had no previous problems working with (viewing, editing, updating, adding new, deleting, etc...) these tables before.

strSQL = "Select field1, default from FoxProTable where field1 = '" & Text1.Text & "' And default = 'True' " 

With rstSQL
    .CursorLocation = adUseClient
    .CursorType = adOpenKeyset
    .LockType = adLockOptimistic
    .Open strSQL, cnnCnxn, , , adCmdText  <------ Error Occurs Here!
End with

Thanks in Advance!

:)


Operator/operand type mismatch error

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.