🚀 go-pugleaf

RetroBBS NetNews Server

Inspired by RockSolid Light RIP Retro Guy

Article View: borland.public.interbase.sql
Article #10989

Learning Interbase "style"

#10989
From: Bradley J. Bell
Date: Sat, 21 Dec 2002 07:39
24 lines
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-mail

Show 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