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::SetDistinct()

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::SetDistinct() [message #7480 is a reply to message #7411]

Sun, 31 December 2006 05:19

Novo is currently offline

Novo
Messages: 1430
Registered: December 2006

Ultimate Contributor

Thank you!

I got the idea. Just two remarks:

1) DISTINCT doesn�t break editing of data. You just need to add a list of columns from DISTINCT to a WHERE part. DISTINCT breaks master-detail relationship.

2) Instead of building an SQL statement in place you can analyze an already build statement and retrieve a list of columns to select and a FROM part. You already have a tree, which represents an SQL statement. You do not have to parse anything. You are a lucky man!

Happy New Year !!!

Regards,
Novo

Report message to a moderator

Send a private message to this user

[Message index]

		SqlArray::SetDistinct() By: Novo on Wed, 27 December 2006 23:45
		Re: SqlArray::SetDistinct() By: mirek on Wed, 27 December 2006 23:52
		Re: SqlArray::SetDistinct() By: Novo on Sun, 31 December 2006 05:19
		Re: SqlArray::SetDistinct() By: mirek on Sun, 31 December 2006 09:23

Previous Topic:	SqlArray::Join when a foreign key has more than one field
Next Topic:	SqlArray Limit and Offset

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

] [

PDF

]

Current Time: Sun Aug 24 13:14:17 CEST 2025

Total time taken to generate the page: 0.04381 seconds