Ultimate++ 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

Re: Fields of the same name in diff tables [message #21723 is a reply to message #21718]

Tue, 02 June 2009 14:47

mirek
Messages: 13060
Registered: November 2005

Ultimate Member

Well, this works:

Quote:

TABLE_(SUPPLIER)
INT_ (ID) PRIMARY_KEY AUTO_INCREMENT
STRING_ (NAME, 80) NOT_NULL SQLDEFAULT("")
STRING_ (ADDRESS1, 128)
STRING_ (ADDRESS2, 128)
STRING_ (CITY, 128)
STRING_ (STATE, 80)
STRING_ (POSTAL_CODE, 24)
STRING_ (PRIMARY_PHONE, 35)
STRING_ (SECONDARY_PHONE, 35)
STRING_ (EMAIL, 128)
STRING_ (WEB_ADDRESS, 500)
BLOB_ (DESCRIPTION)
END_TABLE

Hard to say what it dislikes.. I guess this is rather question to the sqlite3 forum...

Mirek

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: Thu Jan 28 17:12:38 CET 2021

Total time taken to generate the page: 0.01759 seconds