U++ forum: Welcome to the forum

Search on this site

Search in forums

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

Show: Today's Messages :: Show 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

Re: Sqlite foreign key question [message #39810 is a reply to message #39809]

Thu, 02 May 2013 14:59

Runik
Messages: 5
Registered: February 2013
Location: France

Promising Member

Mmmh ... looks like incorrect data was written to the table, leading to this strange behaviour.
I'll add more checks before writing to the database Rolling Eyes

Report message to a moderator

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: Fri Apr 19 11:23:22 CEST 2024

Total time taken to generate the page: 0.03402 seconds