Re: [libreoffice-users] SQL Syntax UPDATE

On Tue, 2019-07-23 at 16:21 +0200, Robert Großkopf wrote:
> Hi Harvey,
> > The SQL editor is rejecting this UPDATE query that, I believe,
> > obeys
> > the standard SQL syntax.
> >
> > UPDATE 'Adressensammlung'.'Adressen' SET 'Adressen'.'Print_flag' =
> > TRUE
> > WHERE 'Adressen'.`Xmas` = TRUE;
> >
> > I'm no SQL expert but I cannot for the life of me understand what
> > is
> > wrong with that command.
>
> You have to mask tablenames and fieldnames with ", if you are using
> the
> internal databases.
>
> UPDATE "Adressensammlung"."Adressen" SET "Adressen"."Print_flag" =
> TRUE
> WHERE "Adressen"."Xmas" = TRUE;
>
> Could be you are using MySQL/MariaDB (I see there is a database-name
> in
> the code). So you could also mask databasename, tablename and
> fieldname
> with `.
>
> UPDATE `Adressensammlung`.`Adressen` SET `Adressen`.`Print_flag` =
> TRUE
> WHERE `Adressen`.`Xmas` = TRUE;
>
> Everything, which is masked with ', will be detected as text, not as
> a
> name of the database, table or field.
>
> Regards
>
> Robert

Hallo Robert,

nice to hear from you again!

even with 
UPDATE "Adressensammlung"."Adressen" SET "Adressen"."print_flag" = TRUE
WHERE "Adressen"."Xmas" = TRUE;

I'm getting "Syntax error, unexpected $end, expecting BETWEEN or IN or
SQL_TOKEN_LIKE"

Or with
UPDATE "Adressensammlung"."Adressen" SET "Print_flag" = FALSE;

I'm getting  "Can not issue data manipulation statements with
executeQuery()."

Cheers
Harvey

-- 
To unsubscribe e-mail to: users+unsubscribe@global.libreoffice.org
Problems? https://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: https://wiki.documentfoundation.org/Netiquette
List archive: https://listarchives.libreoffice.org/global/users/
Privacy Policy: https://www.documentfoundation.org/privacy