I am using FP 2002 w/MSA DB backend

[bluzegtr]

I am using FP 2002 w/MSA DB backend. SELECT statements work fine. I get the the following error when executing and UPDATE query:

Description: [Microsoft][ODBC Microsoft Access Driver] Too few parameters. Expected 1.
Number: -2147217904 (0x80040E10)
Source: Microsoft OLE DB Provider for ODBC Drivers

PRACTID field is text field so I used "None" as the default. There 8 fields total in this

Here is the dieted code (Note that even with undieted code this is still the error I get):

<!--#include file=&quot;_fpclass/fpdblib.inc&quot;-->
<% if 0 then %>
<SCRIPT Language=&quot;JavaScript&quot;>
document.write(&quot;<div style='background: yellow; color: black;'>The Database Results component on this page is unable to display database content. The page must have a filename ending in '.asp', and the web must be hosted on a server that supports Active Server Pages.</div>&quot;
</SCRIPT>
<% end if %>
<%
fp_sQry=&quot;UPDATE TabA SET Numb = '%%Numb%%', Jobs = '%%Jobs%%' WHERE PRACTID = :RACTID::&quot;
fp_sDefault=&quot;PRACTID=None&quot;
fp_sNoRecords=&quot;No records returned.&quot;
fp_sDataConn=&quot;Database2&quot;
fp_iMaxRecords=256
fp_iCommandType=1
fp_iPageSize=0
fp_fTableFormat=False
fp_fMenuFormat=False
fp_sMenuChoice=&quot;&quot;
fp_sMenuValue=&quot;&quot;
fp_iDisplayCols=16
fp_fCustomQuery=True
BOTID=0
fp_iRegion=BOTID
%>
<!--#include file=&quot;_fpclass/fpdbrgn1.inc&quot;-->
<!--#include file=&quot;_fpclass/fpdbrgn2.inc&quot;-->

Ideas?

&quot;I feel more like I do now than when I got here.&quot;
~ Defcon Moderator ~

 

[bluzegtr]

For anyone who cares, I discovered when usign the WHERE clause, the syntax must be as follows:

- For numeric fields -
WHERE this_value = ::that_value::

- For text fields -
WHERE this_value = '::that_value::'

&quot;I feel more like I do now than when I got here.&quot;
~ Defcon Moderator ~