The Useful Byte

Firebird
Auto Increment in Firebird

It seems not to be an easy task in firebird as it is in MySQL. So let's see how we do this step by step: We assume that you have already created a table and appointed theoreti…
byAlex R. •November 08, 2010
Working with Firebird in .NET

Firebird is an open source relational database whose major advantage is the flexibility of deployment. It's main competitor is SQLite and the Jet databases of Microsoft based …
byAlex R. •November 05, 2010
<script type='text/javascript'>
//<![CDATA[
/* Related Posts Loader */
(function(){function loadRelatedPosts(){var d=document.querySelector('.related-tag');if(!d)return;var label=d.getAttribute('data-label');var pid=d.getAttribute('data-id');if(!label)return;fetch(window.location.origin+'/feeds/posts/default/-/'+encodeURIComponent(label)+'?alt=json&max-results=7').then(function(r){return r.json();}).then(function(data){var entries=(data.feed&&data.feed.entry?data.feed.entry:[]).filter(function(e){return !e.id.$t.includes(pid) && (e.category||[]).some(function(c){return c.term==='lang-he';}) === document.documentElement.classList.contains('ss-he-page');}).slice(0,4);if(!entries.length){var w=document.getElementById('related-wrap');if(w)w.style.display='none';return;}d.innerHTML=entries.map(function(e){var t=e.title.$t;var u=((e.link||[]).find(function(l){return l.rel==='alternate';})||{}).href||'#';var th=(e['media$thumbnail']&&e['media$thumbnail'].url)?e['media$thumbnail'].url.replace('s72-c','s300-c'):'';var ds='';if(e.published&&e.published.$t){var dd=new Date(e.published.$t);ds=dd.toLocaleDateString('en-US',{month:'short',day:'numeric',year:'numeric'});}return'<a href="'+u+'" class="related-item">'+(th?'<div class="related-thumb" style="background-image:url('+th+')"></div>':'')+'<div class="related-info"><span class="related-title">'+t+'</span><span class="related-date">'+ds+'</span></div></a>';}).join('');}).catch(function(){});}if(document.readyState==='loading'){document.addEventListener('DOMContentLoaded',loadRelatedPosts);}else{loadRelatedPosts();}})();
//]]>
</script>
<script type='text/javascript'>
//<![CDATA[
(function(){
  function loadRelatedPosts(){
    var d=document.querySelector('.related-tag');
    if(!d)return;
    var label=d.getAttribute('data-label');
    var pid=d.getAttribute('data-id');
    if(!label)return;
    fetch(window.location.origin+'/feeds/posts/default/-/'+encodeURIComponent(label)+'?alt=json&max-results=7')
      .then(function(r){return r.json();})
      .then(function(data){
        var entries=(data.feed&&data.feed.entry?data.feed.entry:[])
          .filter(function(e){return !e.id.$t.includes(pid) && (e.category||[]).some(function(c){return c.term==='lang-he';}) === document.documentElement.classList.contains('ss-he-page');})
          .slice(0,4);
        if(!entries.length){
          var w=document.getElementById('related-wrap');
          if(w)w.style.display='none';
          return;
        }
        d.innerHTML=entries.map(function(e){
          var t=e.title.$t;
          var u=((e.link||[]).find(function(l){return l.rel==='alternate';})||{}).href||'#';
          var th=(e['media$thumbnail']&&e['media$thumbnail'].url)
            ?e['media$thumbnail'].url.replace('s72-c','s300-c'):'';
          var ds='';
          if(e.published&&e.published.$t){
            var dd=new Date(e.published.$t);
            ds=dd.toLocaleDateString('en-US',{month:'short',day:'numeric',year:'numeric'});
          }
          return'<a href="'+u+'" class="related-item">'
            +(th?'<div class="related-thumb" style="background-image:url('+th+')"></div>':'')
            +'<div class="related-info"><span class="related-title">'+t+'</span>'
            +'<span class="related-date">'+ds+'</span></div></a>';
        }).join('');
      })
      .catch(function(){});
  }
  if(document.readyState==='loading'){
    document.addEventListener('DOMContentLoaded',loadRelatedPosts);
  }else{
    loadRelatedPosts();
  }
})();
//]]>
</script>

<script type="text/javascript" src="https://www.blogger.com/static/v1/widgets/2650890479-widgets.js"></script>
<script type='text/javascript'>
window['__wavt'] = 'AKZvMzuDm-whg-ETqhett9Wgp2Ap:1794118717393';_WidgetManager._Init('//www.blogger.com/rearrange?blogID\x3d2139279071038304164','//www.sysseder.com/search/label/Firebird','2139279071038304164');
_WidgetManager._SetDataContext([{'name': 'blog', 'data': {'blogId': '2139279071038304164', 'title': 'The Useful Byte', 'url': 'https://www.sysseder.com/search/label/Firebird', 'canonicalUrl': 'https://www.sysseder.com/search/label/Firebird', 'homepageUrl': 'https://www.sysseder.com/', 'searchUrl': 'https://www.sysseder.com/search', 'canonicalHomepageUrl': 'https://www.sysseder.com/', 'blogspotFaviconUrl': 'https://www.sysseder.com/favicon.ico', 'bloggerUrl': 'https://www.blogger.com', 'hasCustomDomain': true, 'httpsEnabled': true, 'enabledCommentProfileImages': true, 'gPlusViewType': 'FILTERED_POSTMOD', 'adultContent': false, 'analyticsAccountNumber': 'G-YP8XPR9YJJ', 'analytics4': true, 'encoding': 'UTF-8', 'locale': 'en', 'localeUnderscoreDelimited': 'en', 'languageDirection': 'ltr', 'isPrivate': false, 'isMobile': false, 'isMobileRequest': false, 'mobileClass': '', 'isPrivateBlog': false, 'isDynamicViewsAvailable': true, 'feedLinks': '\x3clink rel\x3d\x22alternate\x22 type\x3d\x22application/atom+xml\x22 title\x3d\x22The Useful Byte - Atom\x22 href\x3d\x22https://www.sysseder.com/feeds/posts/default\x22 /\x3e\n\x3clink rel\x3d\x22alternate\x22 type\x3d\x22application/rss+xml\x22 title\x3d\x22The Useful Byte - RSS\x22 href\x3d\x22https://www.sysseder.com/feeds/posts/default?alt\x3drss\x22 /\x3e\n\x3clink rel\x3d\x22service.post\x22 type\x3d\x22application/atom+xml\x22 title\x3d\x22The Useful Byte - Atom\x22 href\x3d\x22https://www.blogger.com/feeds/2139279071038304164/posts/default\x22 /\x3e\n', 'meTag': '', 'adsenseClientId': 'ca-pub-9348007134072555', 'adsenseHostId': 'ca-host-pub-1556223355139109', 'adsenseHasAds': false, 'adsenseAutoAds': false, 'boqCommentIframeForm': true, 'loginRedirectParam': '', 'view': '', 'dynamicViewsCommentsSrc': '//www.blogblog.com/dynamicviews/4224c15c4e7c9321/js/comments.js', 'dynamicViewsScriptSrc': '//www.blogblog.com/dynamicviews/bc04e140f0b1968d', 'plusOneApiSrc': 'https://apis.google.com/js/platform.js', 'disableGComments': true, 'interstitialAccepted': false, 'sharing': {'platforms': [{'name': 'Get link', 'key': 'link', 'shareMessage': 'Get link', 'target': ''}, {'name': 'Facebook', 'key': 'facebook', 'shareMessage': 'Share to Facebook', 'target': 'facebook'}, {'name': 'BlogThis!', 'key': 'blogThis', 'shareMessage': 'BlogThis!', 'target': 'blog'}, {'name': 'X', 'key': 'twitter', 'shareMessage': 'Share to X', 'target': 'twitter'}, {'name': 'Pinterest', 'key': 'pinterest', 'shareMessage': 'Share to Pinterest', 'target': 'pinterest'}, {'name': 'Email', 'key': 'email', 'shareMessage': 'Email', 'target': 'email'}], 'disableGooglePlus': true, 'googlePlusShareButtonWidth': 0, 'googlePlusBootstrap': '\x3cscript type\x3d\x22text/javascript\x22\x3ewindow.___gcfg \x3d {\x27lang\x27: \x27en\x27};\x3c/script\x3e'}, 'hasCustomJumpLinkMessage': true, 'jumpLinkMessage': 'Blog Posts', 'pageType': 'index', 'searchLabel': 'Firebird', 'pageName': 'Firebird', 'pageTitle': 'The Useful Byte: Firebird', 'metaDescription': 'The Useful Byte: everyday technology, online safety, AI, hardware and energy explained simply. Small reads. Smarter digital life.'}}, {'name': 'features', 'data': {}}, {'name': 'messages', 'data': {'edit': 'Edit', 'linkCopiedToClipboard': 'Link copied to clipboard!', 'ok': 'Ok', 'postLink': 'Post Link'}}, {'name': 'template', 'data': {'name': 'custom', 'localizedName': 'Custom', 'isResponsive': true, 'isAlternateRendering': false, 'isCustom': true}}, {'name': 'view', 'data': {'classic': {'name': 'classic', 'url': '?view\x3dclassic'}, 'flipcard': {'name': 'flipcard', 'url': '?view\x3dflipcard'}, 'magazine': {'name': 'magazine', 'url': '?view\x3dmagazine'}, 'mosaic': {'name': 'mosaic', 'url': '?view\x3dmosaic'}, 'sidebar': {'name': 'sidebar', 'url': '?view\x3dsidebar'}, 'snapshot': {'name': 'snapshot', 'url': '?view\x3dsnapshot'}, 'timeslide': {'name': 'timeslide', 'url': '?view\x3dtimeslide'}, 'isMobile': false, 'title': 'The Useful Byte', 'description': 'The Useful Byte: everyday technology, online safety, AI, hardware and energy explained simply. Small reads. Smarter digital life.', 'url': 'https://www.sysseder.com/search/label/Firebird', 'type': 'feed', 'isSingleItem': false, 'isMultipleItems': true, 'isError': false, 'isPage': false, 'isPost': false, 'isHomepage': false, 'isArchive': false, 'isSearch': true, 'isLabelSearch': true, 'search': {'label': 'Firebird', 'resultsMessage': 'Showing posts with the label Firebird', 'resultsMessageHtml': 'Showing posts with the label \x3cspan class\x3d\x27search-label\x27\x3eFirebird\x3c/span\x3e'}}}, {'name': 'widgets', 'data': [{'title': 'Default Thumbnail', 'type': 'Image', 'sectionId': 'pbt-panel', 'id': 'Image52'}, {'title': 'JSON Variables', 'type': 'HTML', 'sectionId': 'pbt-panel', 'id': 'HTML50'}, {'title': 'The Useful Byte', 'type': 'Image', 'sectionId': 'main-logo', 'id': 'Image50'}, {'title': 'Explore', 'type': 'LinkList', 'sectionId': 'xdfcb-main-menu', 'id': 'LinkList200'}, {'title': 'Explore topics', 'type': 'LinkList', 'sectionId': 'headerbar', 'id': 'LinkList201'}, {'title': 'Watch on YouTube', 'type': 'LinkList', 'sectionId': 'headerbar', 'id': 'LinkList202'}, {'title': 'Blog Posts', 'type': 'Blog', 'sectionId': 'main', 'id': 'Blog1', 'posts': [{'id': '1414109935163150024', 'title': 'Auto Increment in Firebird', 'featuredImage': 'https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEgjrd0jiE_vdJPmEloLbtsGc7Stew0wD4L4exlKoizJ2cYfLX0r9yCzRgxU-SVz9mvhnxesMtcfIJmWOCquXKZGsmB6dvB611R3oDzfjNT395DV144_tkOC8aVrE36N1poaPaIjsfcH6cph/s400/1.jpg', 'showInlineAds': false}, {'id': '7698880172053891796', 'title': 'Working with Firebird in .NET', 'featuredImage': 'https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEjeFLwStrudVyqQqRQOeW5SGtpXbhwQ233PvdaZ_OqcYYBLm-lt-DXlvVSXsQMoqqn0PRx52HzFsZECboV-Y6TmzC3txXJXmSN-YobbeoR-M5sHYGVpZAvKbHtiTGu5g5PEC2BE3i3efbTk/s400/flamerobin.png', 'showInlineAds': false}], 'headerByline': {'regionName': 'header1', 'items': [{'name': 'share', 'label': ''}, {'name': 'author', 'label': 'by'}, {'name': 'timestamp', 'label': '\u2022'}]}, 'footerBylines': [{'regionName': 'footer1', 'items': [{'name': 'comments', 'label': '$type\x3d{blogger}'}, {'name': 'icons', 'label': ''}]}, {'regionName': 'footer2', 'items': [{'name': 'labels', 'label': 'Tags'}]}], 'allBylineItems': [{'name': 'share', 'label': ''}, {'name': 'author', 'label': 'by'}, {'name': 'timestamp', 'label': '\u2022'}, {'name': 'comments', 'label': '$type\x3d{blogger}'}, {'name': 'icons', 'label': ''}, {'name': 'labels', 'label': 'Tags'}]}, {'title': 'You might like', 'type': 'HTML', 'sectionId': 'xdfcb-related-posts', 'id': 'HTML51'}, {'title': 'The Useful Byte (Header)', 'type': 'Header', 'sectionId': 'sidebar', 'id': 'Header1'}, {'title': 'Most Popular Posts', 'type': 'PopularPosts', 'sectionId': 'sidebar', 'id': 'PopularPosts1', 'posts': [{'title': 'Claude Code 2.1.319: check refusals before trusting a finished job', 'id': '2608022372880788032'}, {'title': 'Google deprecates Gemini 2.5: prepare integrations for December routing', 'id': '4128699139730618207'}, {'title': 'Claude Code 2.1.318: verify permissions and saved settings', 'id': '8544538946639302275'}, {'title': 'Northflank urges secret rotation after reports of AI API-key misuse', 'id': '3295736776441807249'}, {'title': 'Codex banked resets: what to check before expecting more usage', 'id': '8596316016768193119'}, {'title': 'Okta removes the passkey MFA add-on requirement: review application policies', 'id': '930377138083200576'}]}, {'title': '', 'type': 'LinkList', 'sectionId': 'footer-menu', 'id': 'LinkList204'}]}]);
_WidgetManager._RegisterWidget('_ImageView', new _WidgetInfo('Image52', 'pbt-panel', document.getElementById('Image52'), {'resize': true}, 'displayModeFull'));
_WidgetManager._RegisterWidget('_HTMLView', new _WidgetInfo('HTML50', 'pbt-panel', document.getElementById('HTML50'), {}, 'displayModeFull'));
_WidgetManager._RegisterWidget('_ImageView', new _WidgetInfo('Image50', 'main-logo', document.getElementById('Image50'), {'resize': true}, 'displayModeFull'));
_WidgetManager._RegisterWidget('_LinkListView', new _WidgetInfo('LinkList200', 'xdfcb-main-menu', document.getElementById('LinkList200'), {}, 'displayModeFull'));
_WidgetManager._RegisterWidget('_LinkListView', new _WidgetInfo('LinkList201', 'headerbar', document.getElementById('LinkList201'), {}, 'displayModeFull'));
_WidgetManager._RegisterWidget('_LinkListView', new _WidgetInfo('LinkList202', 'headerbar', document.getElementById('LinkList202'), {}, 'displayModeFull'));
_WidgetManager._RegisterWidget('_BlogView', new _WidgetInfo('Blog1', 'main', document.getElementById('Blog1'), {'cmtInteractionsEnabled': false, 'navMessage': 'Showing posts with label \x3cb\x3eFirebird\x3c/b\x3e. \x3ca href\x3d\x22https://www.sysseder.com/\x22\x3eShow all posts\x3c/a\x3e', 'lightboxEnabled': true, 'lightboxModuleUrl': 'https://www.blogger.com/static/v1/jsbin/1398301468-lbx.js', 'lightboxCssUrl': 'https://www.blogger.com/static/v1/v-css/828616780-lightbox_bundle.css'}, 'displayModeFull'));
_WidgetManager._RegisterWidget('_HTMLView', new _WidgetInfo('HTML51', 'xdfcb-related-posts', document.getElementById('HTML51'), {}, 'displayModeFull'));
_WidgetManager._RegisterWidget('_HeaderView', new _WidgetInfo('Header1', 'sidebar', document.getElementById('Header1'), {}, 'displayModeFull'));
_WidgetManager._RegisterWidget('_PopularPostsView', new _WidgetInfo('PopularPosts1', 'sidebar', document.getElementById('PopularPosts1'), {}, 'displayModeFull'));
_WidgetManager._RegisterWidget('_LinkListView', new _WidgetInfo('LinkList204', 'footer-menu', document.getElementById('LinkList204'), {}, 'displayModeFull'));
</script>
</body>