Overview
Examples
Screenshots
Comparisons
Applications
Download
Documentation
Tutorials
Bazaar
Status & Roadmap
FAQ
Authors & License
Forums
Funding Ultimate++
Search on this site
Search in forums












SourceForge.net Logo
Home » U++ Library support » U++ SQL » Sqlite foreign key question
Sqlite foreign key question [message #39809] Thu, 02 May 2013 11:37 Go to next message
Runik is currently offline  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
Re: Sqlite foreign key question [message #39810 is a reply to message #39809] Thu, 02 May 2013 14:59 Go to previous message
Runik is currently offline  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
Previous Topic: Some unexpected differences between Sqlite3 and MySql in Upp
Next Topic: [BUG?]Like() always case sensitive on MySql
Goto Forum:
  


Current Time: Sat Jul 20 05:16:54 CEST 2024

Total time taken to generate the page: 0.01598 seconds