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 » How to display fields from different tables in one SQLArray
Re: template + convert problem [message #23156 is a reply to message #23154] Sat, 19 September 2009 22:37 Go to previous messageGo to previous message
sergeynikitin is currently offline  sergeynikitin
Messages: 748
Registered: January 2008
Location: Moscow, Russia
Contributor

Zbych wrote on Sat, 19 September 2009 21:30

sergeynikitin wrote on Sat, 19 September 2009 14:22

The mapping of the field from another table I made with the converter.


Can you tell me why you didn't use 'join', 'where' or 'view', to connect those tables?



The reasons may be several:
1. SqlArray is not support join
2. This method saves SQL trafic and network speed on Huge Database.
3. View may not be fully compatible with some database engine.


SergeyNikitin<U++>( linux, wine )
{
    under( Ubuntu || Debian || Raspbian );
}
 
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
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: DBF crash error while writing record
Next Topic: PATCH/BUGFIX Oracle asTable Failure - Solution
Goto Forum:
  


Current Time: Sun May 12 07:55:23 CEST 2024

Total time taken to generate the page: 0.02638 seconds