Formatter removes double quotes wrongly.

Problems, tips, hints - all about usage.

Formatter removes double quotes wrongly.

Postby edwinyzh » Mon Apr 17, 2017 7:18 am

Original statement:
Code: Select all
REPLACE INTO _Variables (
                           Name,
                           TextValue
                       )
                       VALUES (
                           "varNowTime",
                           strftime("%Y-%m-%dT%H:%M:%S", "now", "localtime")
                       );


Wrongly formatted code:
Code: Select all
REPLACE INTO _Variables (
                            Name,
                            TextValue
                        )
                        VALUES (
                            varNowTime,
                            strftime("%Y-%m-%dT%H:%M:%S", now, localtime)
                        );


As you can see, all the double quotes "" in the VALUES clause were removed unexpectedly.

PS, if you ask me why not using single quotes, the answer is that I use Delphi and Free Pascal which uses single quotes for strings :)
edwinyzh
 
Posts: 1
Joined: Mon Apr 17, 2017 7:13 am

Re: Formatter removes double quotes wrongly.

Postby Googie » Thu Apr 20, 2017 10:23 pm

Googie
Site Admin
 
Posts: 780
Joined: Wed Jul 27, 2011 8:04 pm


Return to Usage

Who is online

Users browsing this forum: No registered users and 1 guest

cron