DRW Error

J

John Parker

This one is driving me nuts.. I get the error below ONLY when I try to edit
a record. When I add a new record its fine. And when I set this up it was
fine it just started showing the error. There are no required fields empty,
and the only 2 required fields have a defaukt value.

One time I tried "Verify" database connection and it worked, but now its
down again.

Can anyone point me in the right direction?

Thanks
John Parker


Database Results Wizard Error
Description: Syntax error in UPDATE statement.
Number: -2147217900 (0x80040E14)
Source: Microsoft JET Database Engine

One or more form fields were empty. You should provide default values for
all form fields that are used in the query.
 
J

John Parker

I just tried it again by adding a test record with every field with an entry
and I still get the same error!

John P.
 
J

John Parker

I am sorry, I dont know how to do that..

I use the DRW as I am not very good at the programming bit!

JP
 
J

John Parker

I really appreciate you help.. hope this is the section you meant.

<%
fp_sQry="UPDATE projector SET Display = ::Display:: , Education =
::Education:: , SortGroup = ::SortGroup:: , Top10 = ::Top10:: , Manuf =
'::Manuf::' , Category = '::Category::' , Model = '::Model::' , Resolution =
'::Resolution::' , Brightness = '::Brightness::' , Summary = '::Summary::' ,
Description = '::Description::' , Image = '::Image::' , sImage =
'::sImage::' , PDF = '::pDF::' , manuf_logo = '::manuf_logo::' , cust1 =
'::cust1::' , cust2 = '::cust2::' , cust3 = '::cust3::' , cust4 =
'::cust4::' , cust5 = '::cust5::' , cust6 = '::cust6::' WHERE (ID =
::ID::)"
fp_sDefault="Display=0&Education=0&SortGroup=0&Top10=0&Manuf=&Category=&Model=&Resolution=&Brightness=&Summary=&Description=&Image=&sImage=&PDF=&manuf_logo=&cust1=&cust2=&cust3=&cust4=&cust5=&cust6=&ID=0"
fp_sNoRecords="Record updated in table."
fp_sDataConn="product"
fp_iMaxRecords=1
fp_iCommandType=1
fp_iPageSize=0
fp_fTableFormat=False
fp_fMenuFormat=False
fp_sMenuChoice=""
fp_sMenuValue=""
fp_sColTypes="&ID=3&Display=11&Education=11&SortGroup=3&Top10=11&Manuf=202&Category=202&Model=202&Resolution=202&Brightness=202&Summary=203&Description=203&Image=202&sImage=202&PDF=202&manuf_logo=202&cust1=202&cust2=202&cust3=202&cust4=202&cust5=202&cust6=202&"
fp_iDisplayCols=16
fp_fCustomQuery=True
BOTID=0
fp_iRegion=BOTID
%>
 
J

John Parker

Thanks, I see that now.. I guess I need to start from scratch and recreate
all my pages after I re-run the Wizard to ensure the database field names
are correct. I guess the old saying is true do it right the first time or
waste a whole bunch of time doing things over..

I really appreciate your help.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top