Home » U++ Library support » U++ SQL » Fields of the same name in diff tables
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: 13975 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
|
|
|
|
|
Fields of the same name in diff tables
|
|
|
Re: Fields of the same name in diff tables
|
|
|
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
|
|
|
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
|
|
|
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
|
|
|
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
|
|
|
Re: Fields of the same name in diff tables
|
|
|
Re: Fields of the same name in diff tables
|
|
|
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
|
Goto Forum:
Current Time: Fri Mar 29 05:45:15 CET 2024
Total time taken to generate the page: 0.01538 seconds
|