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
Re: Fields of the same name in diff tables [message #21723 is a reply to message #21718] Tue, 02 June 2009 14:47 Go to previous messageGo to previous message
mirek is currently offline  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
 
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: Fri Mar 29 05:45:15 CET 2024

Total time taken to generate the page: 0.01538 seconds