Update databse using FP Editor

S

swalt

I have a database (ACCESS) on a my website that will need to be edited and
updated online. The editor page was created using Front Page. Here's the
thing it will allow the records to be deleted or added but not edited. I am
using FP 2002.
When I try to edit using the editor the editor page displays and allow
records to be changed but then returns the following message
" Database Results Error"
"Description: Syntex error in update statement"
Number:-214721900 (0x80040E14)
Source: microsoft jet database engine

Research show this to be related to Timestamp. I don't see timestamp
anyplace in my code but I do see date?
 
S

swalt

UPDATE exportvehicles SET DATE = '::DATE::' , VINID = '::VINID::' , YEAR =
'::YEAR::' , MFR = '::MFR::' , MODEL = '::MODEL::' , MODELTRIM =
'::MODELTRIM::' , COLOR = '::COLOR::' , MILEAGE = '::MILEAGE::' , ENGINE =
'::ENGINE::' , PRICE = '::pRICE::' , INETPRICE = '::INETPRICE::' , WARRBOX =
'::WARRBOX::' , DLRCODE = '::DLRCODE::' , OPT1 = '::OPT1::' , OPT2 =
'::OPT2::' , OPT3 = '::OPT3::' , OPT4 = '::OPT4::' , OPT5 = '::OPT5::' , OPT6
= '::OPT6::' , OPT7 = '::OPT7::' , OPT8 = '::OPT8::' , OPT9 = '::OPT9::' ,
OPT10 = '::OPT10::' , OPT11 = '::OPT11::' , OPT12 = '::OPT12::' , OPT13 =
'::OPT13::' , OPT14 = '::OPT14::' , OPT15 = '::OPT15::' , OPT16 = '::OPT16::'
, OPT17 = '::OPT17::' , OPT18 = '::OPT18::' , OPT19 = '::OPT19::' , OPT20 =
'::OPT20::' , OPT21 = '::OPT21::' , OPT22 = '::OPT22::' , OPT23 = '::OPT23::'
, OPT24 = '::OPT24::' , OPT25 = '::OPT25::' , OPT26 = '::OPT26::' , OPT27 =
'::OPT27::' , OPT28 = '::OPT28::' , OPT29 = '::OPT29::' , OPT30 = '::OPT30::'
, OPT31 = '::OPT31::' , OPT32 = '::OPT32::' , FOTO = '::FOTO::' , GROUPNAME =
'::GROUPNAME::' , BKPRICE = '::BKPRICE::' , NPRICE = ::NPRICE:: , NINETPRICE
= ::NINETPRICE:: , NBKPRICE = ::NBKPRICE:: , NMILEAGE = ::NMILEAGE:: ,
VEHTYPE = '::VEHTYPE::' , CERTIFIED = '::CERTIFIED::' , INTCOLOR =
'::INTCOLOR::' , ITEXT = '::ITEXT::' , EXTRA1 = '::EXTRA1::' , EXTRA2 =
'::EXTRA2::' , EXTRA3 = '::EXTRA3::' , EXTRA4 = '::EXTRA4::' WHERE (STOCKID
= ::STOCKID::)
 
S

swalt

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

Similar Threads

Cascade update / delete in Microsoft access sql editor 1
Creating a Search using a combo box and then creating a report. 4
Page numbering with Merged Document and IF statements 1
Dumb question alert! What program to use? 0
Outlook Add-in - Javascript based using React JS - VS Code + WebPack - Unable to call external Web Service 0
Error in Update Message 1
VSTO C# add in Outlook.Appointment error 0
Mail merge labels 8 per page, but 84 is not divisible by 8 3

Top