Re: [sqlite] Multi-Table constraint

Uhmm.. Interesting. Thanks for your help. Jay A. Kreibich wrote: > On Fri, Feb 05, 2010 at 06:42:34PM -0500, German Escallon scratched on the > wall: > > >> create table X(xid integer primary key); >> create table Y(yid integer primary key, y_xid references X(xid) ); >> create table Z(zid

Re: [sqlite] Multi-Table constraint

On Fri, Feb 05, 2010 at 06:42:34PM -0500, German Escallon scratched on the wall: > create table X(xid integer primary key); > create table Y(yid integer primary key, y_xid references X(xid) ); > create table Z(zid integer primary key, z_xid references X(xid) ); > > create table Y_Z >( >

Re: [sqlite] Multi-Table constraint

German Escallon wrote: > Hello all, > > I'm facing a challenge, and I hope someone can give me a hand. > > I tried something along the lines of: > > create table X(xid integer primary key); > create table Y(yid integer primary key, y_xid references X(xid) ); > create

[sqlite] Multi-Table constraint

Hello all, I'm facing a challenge, and I hope someone can give me a hand. I tried something along the lines of: create table X(xid integer primary key); create table Y(yid integer primary key, y_xid references X(xid) ); create table Z(zid integer primary key, z_xid references X(xid) ); create