🚀 go-pugleaf

"Bradley J. Bell" <bradleyjbell@attb3i.c1o2m> wrote in message
news:3e041ac9$1@newsgroups.borland.com...
>
> 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"?

Anywhere that teaches SQL-92 standard SQL is pretty good - Interbase is
quite compliant. For example it uses full join syntax (INNER | OUTER LEFT |
RIGHT).

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

For performance this is best served using a stored proc where you can test
like this:

  if (exists(select * from table where myuniquekey = :keyparam)) then
    update table set ...
  else
    insert into table ...;


--
Wayne Niddery - Logic Fundamentals, Inc. (www.logicfundamentals.com)
RADBooks: http://www.logicfundamentals.com/RADBooks/delphibooks.html
"The only reason some people get lost in thought is because it's unfamiliar
territory." - Paul Fix