{"id":199,"date":"2015-09-30T17:04:21","date_gmt":"2015-09-30T16:04:21","guid":{"rendered":"http:\/\/www.riedmann.it\/blog\/?p=199"},"modified":"2015-09-30T17:08:00","modified_gmt":"2015-09-30T16:08:00","slug":"firebird-syntax-differences-to-other-sql-databases","status":"publish","type":"post","link":"https:\/\/blog.riedmann.it\/?p=199","title":{"rendered":"Firebird syntax differences to other SQL databases"},"content":{"rendered":"

Insert statements<\/strong><\/p>\n

Until now, I have used insert statements in the form<\/p>\n

insert into mytable field1 = 1, field2 = ‘hello world’<\/p><\/blockquote>\n

Firebird does not like this, it needs the form<\/p>\n

insert into mytable ( field1, field2 ) values ( 1, ‘hello world’ )<\/p><\/blockquote>\n

Masking apostrophes<\/strong>
\nAlso Firebird does not likes masking apostrophes with the backslash<\/p>\n

‘Hello, I\\’m Wolfgang’<\/p><\/blockquote>\n

but needs two apostrophes<\/p>\n

‘Hello, I”m Wolfgang’<\/p><\/blockquote>\n

Autoincrement fields<\/strong>
\nFirebird unfortunately does not have autoincrement fields as MS SQL or MySQL, but needs a trigger and a generator (other databases call it sequence), as it needs also the Oracle database.<\/p>\n

Database managment tools<\/strong>
\nUntil now, used DBTools Manager Professional or Navicat Premium Essentials to manage my SQL databases. Unfortunately, DBTools Manager does not work very well with Firebird, and Navicat has no Firebird support. The FlameRobin is very “basic” and has also some problems working with it, so after searching for a low-cost and good-working alternative I have decided for IBExpert Desktop.<\/p>\n","protected":false},"excerpt":{"rendered":"

Insert statements Until now, I have used insert statements in the form insert into mytable field1 = 1, field2 = ‘hello world’ Firebird does not like this, it needs the form insert into mytable ( field1, field2 ) values ( 1, ‘hello world’ ) Masking apostrophes Also Firebird does not likes masking apostrophes with the […]<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[22],"tags":[19],"class_list":["post-199","post","type-post","status-publish","format-standard","hentry","category-firebird-database","tag-firebird"],"_links":{"self":[{"href":"https:\/\/blog.riedmann.it\/index.php?rest_route=\/wp\/v2\/posts\/199","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/blog.riedmann.it\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/blog.riedmann.it\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/blog.riedmann.it\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/blog.riedmann.it\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=199"}],"version-history":[{"count":3,"href":"https:\/\/blog.riedmann.it\/index.php?rest_route=\/wp\/v2\/posts\/199\/revisions"}],"predecessor-version":[{"id":202,"href":"https:\/\/blog.riedmann.it\/index.php?rest_route=\/wp\/v2\/posts\/199\/revisions\/202"}],"wp:attachment":[{"href":"https:\/\/blog.riedmann.it\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=199"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/blog.riedmann.it\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=199"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/blog.riedmann.it\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=199"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}