U++ framework: U++ SQL » Sqlite foreign key question

Home » U++ Library support » U++ SQL » Sqlite foreign key question

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

Sqlite foreign key question [message #39809]

Thu, 02 May 2013 11:37

Runik
Messages: 5
Registered: February 2013
Location: France

Promising Member

Hi there,

I have a little question about sqlite data handling, not sure if it's related to upp or to sqlite itself ...

To put it simply, I have 2 tables :

TABLE_(FAULT)
	INT	(ID) PRIMARY_KEY AUTO_INCREMENT
	STRING	(LABEL, 200) INDEX
END_TABLE

TABLE_(MACHINE)
	INT	(ID) PRIMARY_KEY AUTO_INCREMENT
        STRING  (NAME, 200) INDEX
	INT_	(FAULT_ID) REFERENCES(PCB_STATE.ID)
END_TABLE

Whenever I execute a sql statement to get data from the MACHINE table, FAULT_ID is automatically replaced by FAULT.LABEL in the result set (might be related to schema introspection ?)
Is there a way to get the value of MACHINE.FAULT_ID instead of the linked label ?
Removing the REFERENCES statement didn't improve anything ...

Thanks for reading me Smile

Report message to a moderator

[Message index]

		Sqlite foreign key question By: Runik on Thu, 02 May 2013 11:37
		Re: Sqlite foreign key question By: Runik on Thu, 02 May 2013 14:59

Previous Topic:	Some unexpected differences between Sqlite3 and MySql in Upp
Next Topic:	[BUG?]Like() always case sensitive on MySql

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

] [

]

Current Time: Tue Nov 03 15:44:37 GMT+1 2026

Total time taken to generate the page: 0.99104 seconds