🚀 go-pugleaf

What is it about SQL syntax that you cannot find in the InterBase
manuals?

In IB if an index is unique then you cannot insert a row with the same
value as an existing row. For rows that exist you must use an UPDATE.

On Sat, 21 Dec 2002 01:39:55 -0600, "Bradley J. Bell"
<bradleyjbell@attb3i.c1o2m> wrote:

>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
>


--
Bill (TeamB)
(TeamB cannot respond to questions received via email)