U++ forum: Welcome to the forum

Search on this site

Search in forums

Home » U++ Library support » U++ SQL » Fields of the same name in diff tables

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

Fields of the same name in diff tables [message #21685]

Mon, 01 June 2009 02:43

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

Report message to a moderator

[Message index]

		Fields of the same name in diff tables By: jeremy_c on Mon, 01 June 2009 02:43
		Re: Fields of the same name in diff tables By: jeremy_c on Mon, 01 June 2009 05:27
		Re: Fields of the same name in diff tables By: mirek on Mon, 01 June 2009 08:41
		Re: Fields of the same name in diff tables By: jeremy_c on Mon, 01 June 2009 16:23
		Re: Fields of the same name in diff tables By: mirek on Mon, 01 June 2009 17:34
		Re: Fields of the same name in diff tables By: jeremy_c on Mon, 01 June 2009 20:34
		Re: Fields of the same name in diff tables By: mirek on Mon, 01 June 2009 23:09
		Re: Fields of the same name in diff tables By: jeremy_c on Mon, 01 June 2009 23:17
		Re: Fields of the same name in diff tables By: mirek on Mon, 01 June 2009 23:30
		Re: Fields of the same name in diff tables By: mirek on Mon, 01 June 2009 23:36
		Re: Fields of the same name in diff tables By: jeremy_c on Mon, 01 June 2009 23:58
		Re: Fields of the same name in diff tables By: andrei_natanael on Tue, 02 June 2009 07:36
		Re: Fields of the same name in diff tables By: jeremy_c on Tue, 02 June 2009 14:27
		Re: Fields of the same name in diff tables By: mirek on Tue, 02 June 2009 14:50
		Re: Fields of the same name in diff tables By: mirek on Tue, 02 June 2009 14:52
		Re: Fields of the same name in diff tables By: lectus on Thu, 20 December 2012 19:20
		Re: Fields of the same name in diff tables By: mirek on Sun, 23 December 2012 10:17
		Re: Fields of the same name in diff tables By: mirek on Tue, 02 June 2009 14:47
		Re: Fields of the same name in diff tables By: mr_ped on Tue, 02 June 2009 10:33

Previous Topic:	Weird Date bevaviour in Sqlite
Next Topic:	SqlLite3 crashes on Fetch()

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

] [

]

Current Time: Wed Apr 24 03:01:22 CEST 2024

Total time taken to generate the page: 0.03733 seconds