U++ forum: Welcome to the forum

Search on this site

Search in forums

Home » U++ Library support » U++ SQL » How to display fields from different tables in one SQLArray

Show: Today's Messages :: Show Polls :: Message Navigator
E-mail to friend

Re: template + convert problem [message #23163 is a reply to message #23156]

Sun, 20 September 2009 15:47

Zbych
Messages: 326
Registered: July 2009

Senior Member

sergeynikitin wrote on Sat, 19 September 2009 22:37

The reasons may be several:
1. SqlArray is not support join

You can always connect tables using 'where', or just use 'join' + ArrayCtrl and fill it "manually". It is simpler than your solution.

Quote:

2. This method saves SQL trafic and network speed on Huge Database.

If you have huge database, than you usually don't display everything at once. Beside, I guess, it is faster to send one query with 1000 rows, that 1000 queries with 1 row each.

Quote:

3. View may not be fully compatible with some database engine.

Than you should use databases, that supports views.

[Updated on: Sun, 20 September 2009 15:48]

Report message to a moderator

[Message index]

		How to display fields from different tables in one SQLArray By: sergeynikitin on Mon, 20 October 2008 14:14
		Re: How to display fields from different tables in one SQLArray By: zsolt on Mon, 20 October 2008 14:20
		Re: How to display fields from different tables in one SQLArray By: sergeynikitin on Mon, 20 October 2008 14:28
		Re: How to display fields from different tables in one SQLArray By: sergeynikitin on Mon, 20 October 2008 14:55
		Re: How to display fields from different tables in one SQLArray By: zsolt on Mon, 20 October 2008 22:51
		Re: How to display fields from different tables in one SQLArray By: sergeynikitin on Mon, 20 October 2008 23:00
		Re: How to display fields from different tables in one SQLArray By: sergeynikitin on Mon, 20 October 2008 23:04
		Re: How to display fields from different tables in one SQLArray By: sergeynikitin on Sun, 02 November 2008 14:12
		Re: How to display fields from different tables in one SQLArray By: mirek on Sun, 02 November 2008 16:47
		Re: How to display fields from different tables in one SQLArray By: sergeynikitin on Sun, 02 November 2008 16:54
		Re: How to display fields from different tables in one SQLArray By: unodgs on Sun, 02 November 2008 19:09
		Re: How to display fields from different tables in one SQLArray By: sergeynikitin on Sun, 02 November 2008 19:41
		Re: How to display fields from different tables in one SQLArray By: unodgs on Sun, 02 November 2008 20:44
		Re: How to display fields from different tables in one SQLArray By: sergeynikitin on Sun, 02 November 2008 21:50
		Re: How to display fields from different tables in one SQLArray By: sergeynikitin on Sun, 02 November 2008 21:58
		Re: How to display fields from different tables in one SQLArray By: mirek on Sun, 02 November 2008 22:01
		Re: How to display fields from different tables in one SQLArray By: mirek on Sun, 02 November 2008 21:59
		Re: How to display fields from different tables in one SQLArray By: sergeynikitin on Sun, 02 November 2008 22:09
		Re: How to display fields from different tables in one SQLArray By: mirek on Wed, 12 November 2008 22:23
		Re: How to display fields from different tables in one SQLArray By: sergeynikitin on Thu, 13 November 2008 11:26
		Re: How to display fields from different tables in one SQLArray By: mirek on Sat, 15 November 2008 15:02
		Re: How to display fields from different tables in one SQLArray By: sergeynikitin on Sat, 15 November 2008 15:48
		Re: How to display fields from different tables in one SQLArray By: sergeynikitin on Fri, 20 March 2009 17:06
		Re: How to display fields from different tables in one SQLArray By: mirek on Sun, 02 November 2008 21:55
		Re: How to display fields from different tables in one SQLArray By: mr_ped on Fri, 20 March 2009 21:37
		Re: How to display fields from different tables in one SQLArray By: sergeynikitin on Sat, 21 March 2009 08:04
		Re: How to display fields from different tables in one SQLArray By: sergeynikitin on Tue, 07 July 2009 09:47
		template + convert problem By: sergeynikitin on Sat, 19 September 2009 14:22
		Re: template + convert problem By: Zbych on Sat, 19 September 2009 19:30
		Re: template + convert problem By: andrei_natanael on Sat, 19 September 2009 19:59
		Re: template + convert problem By: sergeynikitin on Sat, 19 September 2009 22:45
		Re: template + convert problem By: sergeynikitin on Sat, 19 September 2009 22:37
		Re: template + convert problem By: Zbych on Sun, 20 September 2009 15:47
		Re: template + convert problem By: sergeynikitin on Mon, 21 September 2009 07:34
		Re: template + convert problem By: sergeynikitin on Thu, 30 April 2015 07:55

Previous Topic:	DBF crash error while writing record
Next Topic:	PATCH/BUGFIX Oracle asTable Failure - Solution

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

] [

]

Current Time: Sat May 11 07:39:53 CEST 2024

Total time taken to generate the page: 0.02982 seconds