U++ forum: Welcome to the forum

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