Article View: borland.public.interbase.sql
Article #10989Learning Interbase "style"
From: Bradley J. Bell
Date: Sat, 21 Dec 2002 07:39
Date: Sat, 21 Dec 2002 07:39
24 lines
1924 bytes
1924 bytes
I currently use Sybase at work and I am use to its SQL syntax. I've recently decided to do some "brushing up" with Delphi and have decided to try Interbase as the database. I'm having one heck of a time trying to learn Interabase's SQL syntax, Interbase's "way" of doing things. I have been unable to find one Interbase programming book. What little I've learned is from searching Deja.com, but it takes a long time just to learn how to do simple things. Can anyone point me to a good book or website that teaches Interbase "style"? TIA Bradley p.s. Just as a second question; in Sybase I can insert new records into a database with a unique key and not worry about duplicates by including "with ignore dups" when defining the index. Does Interbase have a similar option. Right now what I've been doing is to take all the possible new entries from my source table and deleting any entries that already exisit in the destination table. There has to be a better way (I hope). Again, TIA
Technical Details
Message-ID:
<3e041ac9$1@newsgroups.borland.com>Path:
arc1-ca.pugleaf.net!archiver1.google.com!news1.google.com!sn-xit-02!sn-xit-03!sn-xit-01!sn-xit-08!supernews.com!telocity-west!DIRECTV!203.109.225.2!nntp-relay.ihug.net!newsfeeds.ihug.co.nz!ihug.co.nz!newsgroups.borland.com!not-for-mailShow Full Headers
Complete Article Headers
X-Google-Language: ENGLISH,ASCII-7-bit X-Google-Thread: 114a0e,8dcbdc28ad264e66,start X-Google-Attributes: gid114a0e,public X-Google-ArrivalTime: 2002-12-20 23:44:59 PST From: "Bradley J. Bell" <bradleyjbell@attb3i.c1o2m> Newsgroups: borland.public.interbase.sql Subject: Learning Interbase "style" Date: Sat, 21 Dec 2002 01:39:55 -0600 Lines: 26 X-Priority: 3 X-MSMail-Priority: Normal X-Newsreader: Microsoft Outlook Express 6.00.2800.1106 X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2800.1106 NNTP-Posting-Host: 12.249.164.138 Message-ID: <3e041ac9$1@newsgroups.borland.com> X-Trace: newsgroups.borland.com 1040456393 12.249.164.138 (20 Dec 2002 23:39:53 -0800) Path: arc1-ca.pugleaf.net!archiver1.google.com!news1.google.com!sn-xit-02!sn-xit-03!sn-xit-01!sn-xit-08!supernews.com!telocity-west!DIRECTV!203.109.225.2!nntp-relay.ihug.net!newsfeeds.ihug.co.nz!ihug.co.nz!newsgroups.borland.com!not-for-mail