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 » SqlArray Join

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

Return to the default flat view

Create a new topic

Submit Reply

Re: SqlArray Join [message #4068 is a reply to message #4062]

Wed, 19 July 2006 11:11

mirek is currently offline

mirek
Messages: 14265
Registered: November 2005

Ultimate Member

To insert / remove rows, use

SqlArray arr;
.....
arr.Removing().Appending();

SqlDetails are reserved for quite rare 1:1 relations (means - one table is represented by SqlArray and for each line of this SqlArray there is _single_ record in another joined table, which is edited by SqlDetails Ctrls).

If what you want to do is to edit some columns of record of single table in SqlArray rows and rest in separate Ctrls, just add those Ctrls to SqlArray (ArrayCtrl::AddCtrl).

Important thing to understand here is that not every "index" in ArrayCtrl "row" corresponds to single column in ArrayCtrl (SqlArray is ArrayCtrl derivative). Some indicies can be bound to external Ctrls, some can be completely hidden and respectively, some columns of ArrayCtrl can "merge" more indicies (e.g. you have YEAR, MONTH and DAY columns in your database and you want to display them in single SqlArray column).

Mirek

Report message to a moderator

Send a private message to this user

[Message index]

		SqlArray Join By: rbmatt on Wed, 19 July 2006 02:47
		Re: SqlArray Join By: rbmatt on Wed, 19 July 2006 07:27
		Re: SqlArray Join By: mirek on Wed, 19 July 2006 11:11
		Re: SqlArray Join By: rbmatt on Wed, 19 July 2006 17:07
		Re: SqlArray Join By: mirek on Wed, 19 July 2006 17:13
		Re: SqlArray Join By: rbmatt on Wed, 19 July 2006 18:36
		Re: SqlArray Join By: mirek on Wed, 19 July 2006 21:17
		Re: SqlArray Join By: rbmatt on Wed, 19 July 2006 22:53
		Re: SqlArray Join By: mirek on Wed, 19 July 2006 23:48
		Re: SqlArray Join By: rbmatt on Thu, 20 July 2006 00:09
		Re: SqlArray Join By: rbmatt on Fri, 21 July 2006 06:35
		Re: SqlArray Join By: mirek on Fri, 21 July 2006 14:33
		Re: SqlArray Join By: rbmatt on Fri, 21 July 2006 17:16
		Re: SqlArray Join By: rbmatt on Sat, 22 July 2006 07:42
		Re: SqlArray Join By: forlano on Sat, 10 March 2007 18:44
		Re: SqlArray Join By: mirek on Sun, 23 July 2006 19:15
		Re: SqlArray Join By: rbmatt on Sun, 23 July 2006 19:49

Previous Topic:	ODBC ?
Next Topic:	MS SQL Server connection possible?

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

] [

PDF

]

Current Time: Mon Jul 07 23:28:54 CEST 2025

Total time taken to generate the page: 0.03513 seconds