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 » Fields of the same name in diff tables
Fields of the same name in diff tables [message #21685] Mon, 01 June 2009 02:43 Go to previous message
jeremy_c is currently offline  jeremy_c
Messages: 175
Registered: August 2007
Location: Ohio, USA
Experienced Member
I am confused about how to do this:

TABLE_(HIVE_ACCESSORY)
    INT_ (ID) PRIMARY_KEY AUTO_INCREMENT
    STRING_ (NAME, 128) NOT_NULL
END_TABLE

TABLE_(HIVE)
    INT_ (ID) PRIMARY_KEY AUTO_INCREMENT
    STRING_ (NAME, 128) NOT NULL
    BLOB_ (DESCRIPTION)
END_TABLE


This results in compilation errors of duplicate ID and NAME values. I saw elsewhere in the forum that you should use INT_ on first use and INT on subsequent (of the same name). However, when I do that my HIVE table has only the field DESCRIPTION. It does not contain ID or NAME.

Any thoughts on how to accomplish my task? Do I have to create unique field names for all table entries?

Jeremy
 
Read Message
Read Message
Read Message
Read Message
Read Message
Read Message
Read Message
Read Message
Read Message
Read Message
Read Message
Read Message
Read Message
Read Message
Read Message
Read Message
Read Message
Read Message
Read Message
Previous Topic: Weird Date bevaviour in Sqlite
Next Topic: SqlLite3 crashes on Fetch()
Goto Forum:
  


Current Time: Tue Sep 22 13:10:40 CEST 2020

Total time taken to generate the page: 0.02465 seconds