U++ forum: Welcome to the forum

Status & Roadmap

Authors & License

Funding Ultimate++

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

Return to the default flat view

Create a new topic

Submit Reply

How to display fields from different tables in one SQLArray [message #18765]

Mon, 20 October 2008 14:14

sergeynikitin is currently offline

sergeynikitin
Messages: 748
Registered: January 2008
Location: Moscow, Russia

Contributor

sergeynikitin@jabber.ru

How to display fields from different tables in one SQLArray.
Are there any analog View-Join

There are 2 tables:

TABLE_(PROJECT)
INT_ (PR_ID) PRIMARY_KEY AUTO_INCREMENT
INT_ (PR_CREATIONDATE)
INT_ (PR_USERID)
INT_ (PR_COMPANYID)
STRING_ (PR_TASKTODO,2000)
DOUBLE_ (PR_SUM)
INT_ (PR_PLANNEDDELIVERYDATE)
DOUBLE_ (PR_SUMFACT)
INT_ (PR_STATUS)
INT_ (PR_PAYSTATUS)
INT_ (PR_PLANNEDEXECUTIONTIME)
STRING_ (PR_COMMENT,2000)
END_TABLE

and

TABLE_(COMPANY)
INT_ (COM_ID) PRIMARY_KEY AUTO_INCREMENT
INT_ (COM_GROUPID)
STRING_ (COM_NAME,2000)
STRING_ (COM_INN,2000)
STRING_ (COM_KPP,2000)
STRING_ (COM_ADDRESSDOC,2000)
STRING_ (COM_ADDRESSFACT,2000)
STRING_ (COM_COMMENT,2000)
END_TABLE

They relate by field PR_COMPANYID

I need to display the first table, and instead of field PR_COMPANYID I need to display COM_NAME from second table. I found 2 solutions. First - do Join View on the SQL server. Second - do converter to display the column in the table. I think that there should be a 3rd - Correct.

Please Give the right decision.

SergeyNikitin<U++>( linux, wine )
{
under( Ubuntu || Debian || Raspbian );
}

Report message to a moderator

Send a private message to this user

[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) ] [

] [

PDF

]

Current Time: Fri Apr 19 16:50:25 CEST 2024

Total time taken to generate the page: 0.07114 seconds