BUT... MS-SQL doesn't support triggers as well as Interbase...
I doubt therefore it is "way behind" MS-SQL - seems to depend on who you
ask!
-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]On
Behalf Of Neven MacEwan
Sent: Friday, 15 December 2000 19:20
To:
Patrick
BUT... MS-SQL doesn't support triggers as well as Interbase...
You don't think nesting and recursion are good? Or are you just so stuck on
the before and after
trigger paradigm that anything else is not as good?
Lets list a few things interbase can't do
1/ Replication
2/ CASE,
BUT... MS-SQL doesn't support triggers as well as Interbase...
You don't think nesting and recursion are good? Or are you just so stuck
on
Nesting is fine. IB does it to. Ditto recursion, AFAIK.
the before and after
trigger paradigm that anything else is not as good?
well, can you do
Nic
Good to see you working on the weekend - hah
well, can you do "proper" cascade deletes? ie, delete from the master
table,
remove the children automatically?
Declaritively not in 6.5 but in 2000 yes - but I use triggers to enforce RI
anyway so yes
2/ CASE, COALESCE and NULLIF (also
On Sat, 16 Dec 2000, Neven MacEwan wrote:
So unfortunately does MSDE - and don't dump that small footprint dogma
pitch IB as a 'light weight, low cost, low maintenance database' ie imbedded
Last time I tried installed MSDE I -had- to install Access 2000 first,
that doesn't seem much of a
Mark
Last time I tried installed MSDE I -had- to install Access 2000 first,
that doesn't seem much of a small footprint to me..
Don't see why? you prob just need MDAC
Re PostgreSQL returning a result set I've heard of some sort cludgey
solutions
(which I'll track down) but I think it is the
=20001215
===
Created by Mail2Sig - http://pdunford.godzone.net.nz/software/mail2sig/
---
New Zealand Delphi Users group - Delphi List - [EMAIL PROTECTED
Nic
Good to see you working on the weekend - hah
that implies I work during the week :) seriously, tho, DUG stuff aint
usually work - it comes into my home account, hence on my own time.
well, can you do "proper" cascade deletes? ie, delete from the master
table,
remove the
istchurch, NZ - http://pdunford.godzone.net.nz/
Rejoice with those who rejoice; mourn with those who mourn.
-- Romans 12:15
http://www.heartlight.org/cgi-shl/todaysverse.cgi?day=20001215
===
Create
