U++ forum: Welcome to the forum

Search on this site

Search in forums

Home » U++ Library support » U++ SQL » How to make complex indexes?

Show: Today's Messages :: Show Polls :: Message Navigator
E-mail to friend

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

Report message to a moderator

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

Thu, 05 August 2010 12:41

mirek
Messages: 13975
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

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

Thu, 05 August 2010 16:42

jeremy_c
Messages: 175
Registered: August 2007
Location: Ohio, USA

Experienced Member

Thanks!

Report message to a moderator

Previous Topic:	Oracle8: UTF8 charset Patch
Next Topic:	transactions and sql

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

] [

]

Current Time: Thu Apr 18 16:06:44 CEST 2024

Total time taken to generate the page: 0.01887 seconds