Home » U++ Library support » U++ SQL » How to make complex indexes?
How to make complex indexes? [message #27821] |
Thu, 05 August 2010 12:25 |
jeremy_c
Messages: 175 Registered: August 2007 Location: Ohio, USA
|
Experienced Member |
|
|
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
|
|
|
Re: How to make complex indexes? [message #27822 is a reply to message #27821] |
Thu, 05 August 2010 12:41 |
|
mirek
Messages: 14039 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...
|
|
|
|
Goto Forum:
Current Time: Fri Sep 20 12:10:33 CEST 2024
Total time taken to generate the page: 0.02772 seconds
|