U++ forum: Welcome to the forum

Re: How to make complex indexes? [message #27822 is a reply to message #27821]

Thu, 05 August 2010 12:41

mirek
Messages: 14265
Registered: November 2005

Ultimate Member

jeremy_c wrote on Thu, 05 August 2010 06:25

Well, I guess they are not really complex, but one more than just an INDEX attribute on a field, for example:

sqlite> CREATE INDEX qsos_dup_idx ON qsos(callsign, qso_date, mode_id, band_tx_id);

Thanks,

Jeremy

TABLE_(TABLE)
   INT_ (COL1)
   INT_ (COL2)
   INDEX_LIST	(TABLE_INDEX, "COL1, COL2")
END_TABLE

Also, you are of course not limited to .sch files. If you e.g. need triggers, just issue SQL.Execute("create trigger...").

Usually, I have such "schema creation code" active in debug mode, .sch is just a part of process. In my current application, there is about 700 lines of .cpp to create the schema... Smile

Report message to a moderator