Re: Database Wizard P*****G me off

Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance

From: John Jansen \(MSFT\) (johnjan_at_online.microsoft.com)
Date: 05/06/04 

Date: Thu, 6 May 2004 09:58:28 -0700

Here is an article about this as well:
http://support.microsoft.com/default.aspx?scid=kb;en-us;256136 

-- 
Thanks!
John Jansen
Microsoft Office FrontPage
This posting is provided "AS IS" with no warranties, and confers no rights.
"Kevin Spencer" <kspencer@takempis.com> wrote in message 
news:%23LB3NC4MEHA.740@TK2MSFTNGP12.phx.gbl...
> In the SQL language, which the DRW uses to perform database operations, as
> the language is pure text, data types are defined by punctuation in the 
> SQL
> Statement. Numeric values are not delimited. Text values are delimited by
> single quotes. In Access, dates are delimited by "#" characters. A typical
> UPDATE statement might look like the following:
>
> UPDATE SomeTable SET SomeTextField = 'Some Value', SomeNumericField = 5
>
> The DRW plugs in the values from, in this case, a form. If a form 
> containing
> a numeric value is blank, the SQL Statement will look like the following:
>
> UPDATE SomeTable SET SomeTextField = 'Some Value', SomeNumericField =
>
> Hence, the syntax error. And hence, the message that indicates one or more
> form fields were blank.
>
> -- 
> HTH,
> Kevin Spencer
> .Net Developer
> Microsoft MVP
> Big things are made up
> of lots of little things.
>
> "jonathan" <jonathan@cbimports.co.uk> wrote in message
> news:OSOnPq3MEHA.3380@TK2MSFTNGP11.phx.gbl...
>> I have run the Database wizard in FP2003 so that a database that is being
>> written to can also be edited all the pages are built, I can add, report 
>> &
>> delete records but when I try to edit a record I get an error message in
> the
>> webpage -
>>
>> 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.
>>
>> Can anyone help with this very frustrating wizard problem!?
>>
>> TIA
>>
>>
>> Jonathan
>>
>>
>>
>
>

Relevant Pages

  • Re: Database Editor results error for me
    ... >> Database Results Wizard Error ... > Source: Microsoft JET Database Engine ... One or more form fields were empty. ...
    (microsoft.public.frontpage.client)
  • Re: Database Wizard P*****G me off
    ... In the SQL language, which the DRW uses to perform database operations, as ... data types are defined by punctuation in the SQL ... Syntax error in UPDATE statement. ... > One or more form fields were empty. ...
    (microsoft.public.frontpage.programming)
  • Re: MS Access DAO -> ADO.NET Migration
    ... William Vaughn ... Microsoft MVP ... Hitchhiker's Guide to Visual Studio and SQL Server ... My migration app works building a SSCE database file with imported data ...
    (microsoft.public.dotnet.framework.adonet)
  • Re: Database Connectivity
    ... But, MSDE has been know to work very reliably in small user LANS, ... > just a simple step to attach the tables from MSDE to SQL Server. ... database, or pay for an "industrial-strength" version of it when there ... Don't like Microsoft?, sounds like a personal problem to me. ...
    (comp.lang.python)
  • Performance optimization vs satisficing (was Language Oriented Programming)
    ... >machines that were too small. ... Microsoft has been a leading offender here. ... >arcane issue for server engines. ... magnitude slower, yes, I recall working on a 200mb database, trying to ...
    (comp.object)