Re: [sqlite] Novice Question about SQLite Insert Command

2006-11-04 Thread viking2
Igor Tandetnik wrote: > > viking2 <[EMAIL PROTECTED]> wrote: >> I have a database (*.db3) with 3 tables: >> >> CREATE TABLE TB_Signature (Filename TEXT, FileSignature TEXT, FileSize >> INTEGER, FileDate INTEGER, PRIMARY KEY (FileSignature,FileSize)); >> >> CREATE TABLE TB_FileRecords (pszFilena

[sqlite] Novice Question about SQLite Insert Command

2006-11-03 Thread viking2
I have a database (*.db3) with 3 tables: CREATE TABLE TB_Signature (Filename TEXT, FileSignature TEXT, FileSize INTEGER, FileDate INTEGER, PRIMARY KEY (FileSignature,FileSize)); CREATE TABLE TB_FileRecords (pszFilename TEXT PRIMARY KEY, nFileSize INTEGER, nFileSignature TEXT); CREATE TABLE TB_