Re: Visual Studio Incorrect Syntax Near The Keyword Default Information



The error message indicates that there is a problem in a SQL statement, and
as you haven't shown us the SQL statement it's difficult to say what the
error might be. If I had to take a wild guess at it, I'd wonder if perhaps
you've used the keyword 'default' as a field name or part of a field name?
If so, try putting square brackets around the field name in the SQL
statement.

--
Brendan Reynolds


"JMUApache" <magichydra@xxxxxxx> wrote in message
news:90lkh1dpd8o1mktvldibk56k6hlgj98sh0@xxxxxxxxxx
> Hi,
>
> I have got a error message while I run a sample OLEDB program. It
> says "Incorrect Syntax Near The Keyword Default Information".
>
> platform: Windows XP + Visual Studio 2005 Beta 2 + SQL Server 2000
>
> I goole it, somebody says the reason is the database file size up
> to its limit, and set the Maximum File Size to Unrestricted File
> Growth. But it's not suite my case.
>
> I was not sure why it be, any help would be appriciate!
>
> thanks
>
> //chen
>
>
>
>


.



Relevant Pages

  • Re: newbie - get memory error message when close .exe
    ... I get no error message when I click the "X" at top right ... > window to close on my laptop running XP, ... > a recordset and use a sql statement to populate the flexgrid. ... >> Veign's Resource Center ...
    (microsoft.public.vb.general.discussion)
  • Re: 2 table Query Error
    ... Post the SQL statement of the query that is giving you this error. ... It is a Country club member accounting database. ... > member ID to member ID) I get the afore memtioned error message. ...
    (microsoft.public.access.queries)
  • Re: Error syntax in Query SQL
    ... > I made application where is a part of code using SQL syntax with ADODB ... I get error message at SQL Statement when It used in other machine ... > that was choose regional setting by Indonesia (OS: ...
    (microsoft.public.vb.database)
  • Re: Inline CrossTab Query
    ... The SQL I used I just copied from the three queries in the Query Design ... >> I am trying to produce a SQL statement to bring together 3 queries ... >> I am getting an error message that says there is an Error in the ...
    (microsoft.public.access.queries)
  • Re: "actual argument keyword name"
    ... I have an error message after compiled using Compaq Visual Fortran ... Sc are all assumed-shape dummy arrays. ... Of course I use that module containg "subroutine show_wbeta" when I ... I don't understand what "actual argument keyword name" means. ...
    (comp.lang.fortran)