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)

Re: [sqlite] any command to find last rowid in a table

Dude, Are you even reading what others have (very patiently) tried to explain you? Here's one more attempt. My advice (like everyone else in here) is to let SQLITE handle that for you with autoincrement. Asuming you don't take the advice, you can also try: int main() { ... .. . ... maxId = sql

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

[sqlite] Search in multiple fields.

Hello all, I have a table with file information (path, filename, extension, size, etc), and I would like to enable search on this table based on different fields with a single input, and/or concatenation of the same. For example.. Say I have the following record in my DB: Path: /home/media/mymus

[sqlite] Error opening db file

go, and that may have triggered this error, because it was working properly before that. Any ideas? Thank you in advance for any help you can provide. Let me know if more info is needed. German Escallon ___