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: 14265 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: Sun Jul 13 02:56:32 CEST 2025
Total time taken to generate the page: 0.04296 seconds
|