You could add "Order_ID" in List() function in Firebird, for requirement 1 and
two, but Order_Date and Salesman_ID must be displayed, as same Salesman could
have multiple orders, so those could be displayed in one row separated by
comma, which List() function does.
On Tuesday, 18 July 2017 11:18 PM, "Vishal Tiwari [email protected]
[firebird-support]" <[email protected]> wrote:
Hi All,
I am still trying but could not get maximum data per date, as Order_ID and
Salesman_ID fields are coming in between.
With Best Regards.
Vishal
On Monday, 17 July 2017 9:54 AM, "Vishal Tiwari [email protected]
[firebird-support]" <[email protected]> wrote:
@Mark: I guess, asking for help, is never be like demanding. It is more
over expecting cooperation according to me.
But anyways.... no more talk on that issue...
On Monday, 17 July 2017 9:32 AM, Vishal Tiwari <[email protected]>
wrote:
Hi Mark,
Kindly don't get me rude here. I always respected everyone in this group.
Till today firebird is the only database I love a lot.
About asking for the help, it was not actually demanding.
In past, me and SET had lot of valuable conversation here.
I just know two ppl here, Ms. Helen and SET.
Believe me my friend, if I knew you, definitely I would have call you as well.
Anyways, I apologies, if i hurt you or anyone here, but that was never my
intention.
Hope, it clarifies all misunderstandings.
With Love and Regards.
Vishal
On Monday, 17 July 2017 8:05 AM, "Mark Rotteveel [email protected]
[firebird-support]" <[email protected]> wrote:
On 17-7-2017 13:31, Vishal Tiwari [email protected]
[firebird-support] wrote:
> HI SET,
>
> Please help.
I find it rather rude to expect (almost demand) someone to just help
you, and to then ignore the fact that there are also other people here
who would also might help you. Not to mention that you do this just an
hour after posting your original question.
Mark
--
Mark Rotteveel
#yiv5474439772 #yiv5474439772 -- #yiv5474439772ygrp-mkp {border:1px solid
#d8d8d8;font-family:Arial;margin:10px 0;padding:0 10px;}#yiv5474439772
#yiv5474439772ygrp-mkp hr {border:1px solid #d8d8d8;}#yiv5474439772
#yiv5474439772ygrp-mkp #yiv5474439772hd
{color:#628c2a;font-size:85%;font-weight:700;line-height:122%;margin:10px
0;}#yiv5474439772 #yiv5474439772ygrp-mkp #yiv5474439772ads
{margin-bottom:10px;}#yiv5474439772 #yiv5474439772ygrp-mkp .yiv5474439772ad
{padding:0 0;}#yiv5474439772 #yiv5474439772ygrp-mkp .yiv5474439772ad p
{margin:0;}#yiv5474439772 #yiv5474439772ygrp-mkp .yiv5474439772ad a
{color:#0000ff;text-decoration:none;}#yiv5474439772 #yiv5474439772ygrp-sponsor
#yiv5474439772ygrp-lc {font-family:Arial;}#yiv5474439772
#yiv5474439772ygrp-sponsor #yiv5474439772ygrp-lc #yiv5474439772hd {margin:10px
0px;font-weight:700;font-size:78%;line-height:122%;}#yiv5474439772
#yiv5474439772ygrp-sponsor #yiv5474439772ygrp-lc .yiv5474439772ad
{margin-bottom:10px;padding:0 0;}#yiv5474439772 #yiv5474439772actions
{font-family:Verdana;font-size:11px;padding:10px 0;}#yiv5474439772
#yiv5474439772activity
{background-color:#e0ecee;float:left;font-family:Verdana;font-size:10px;padding:10px;}#yiv5474439772
#yiv5474439772activity span {font-weight:700;}#yiv5474439772
#yiv5474439772activity span:first-child
{text-transform:uppercase;}#yiv5474439772 #yiv5474439772activity span a
{color:#5085b6;text-decoration:none;}#yiv5474439772 #yiv5474439772activity span
span {color:#ff7900;}#yiv5474439772 #yiv5474439772activity span
.yiv5474439772underline {text-decoration:underline;}#yiv5474439772
.yiv5474439772attach
{clear:both;display:table;font-family:Arial;font-size:12px;padding:10px
0;width:400px;}#yiv5474439772 .yiv5474439772attach div a
{text-decoration:none;}#yiv5474439772 .yiv5474439772attach img
{border:none;padding-right:5px;}#yiv5474439772 .yiv5474439772attach label
{display:block;margin-bottom:5px;}#yiv5474439772 .yiv5474439772attach label a
{text-decoration:none;}#yiv5474439772 blockquote {margin:0 0 0
4px;}#yiv5474439772 .yiv5474439772bold
{font-family:Arial;font-size:13px;font-weight:700;}#yiv5474439772
.yiv5474439772bold a {text-decoration:none;}#yiv5474439772 dd.yiv5474439772last
p a {font-family:Verdana;font-weight:700;}#yiv5474439772 dd.yiv5474439772last p
span {margin-right:10px;font-family:Verdana;font-weight:700;}#yiv5474439772
dd.yiv5474439772last p span.yiv5474439772yshortcuts
{margin-right:0;}#yiv5474439772 div.yiv5474439772attach-table div div a
{text-decoration:none;}#yiv5474439772 div.yiv5474439772attach-table
{width:400px;}#yiv5474439772 div.yiv5474439772file-title a, #yiv5474439772
div.yiv5474439772file-title a:active, #yiv5474439772
div.yiv5474439772file-title a:hover, #yiv5474439772 div.yiv5474439772file-title
a:visited {text-decoration:none;}#yiv5474439772 div.yiv5474439772photo-title a,
#yiv5474439772 div.yiv5474439772photo-title a:active, #yiv5474439772
div.yiv5474439772photo-title a:hover, #yiv5474439772
div.yiv5474439772photo-title a:visited {text-decoration:none;}#yiv5474439772
div#yiv5474439772ygrp-mlmsg #yiv5474439772ygrp-msg p a
span.yiv5474439772yshortcuts
{font-family:Verdana;font-size:10px;font-weight:normal;}#yiv5474439772
.yiv5474439772green {color:#628c2a;}#yiv5474439772 .yiv5474439772MsoNormal
{margin:0 0 0 0;}#yiv5474439772 o {font-size:0;}#yiv5474439772
#yiv5474439772photos div {float:left;width:72px;}#yiv5474439772
#yiv5474439772photos div div {border:1px solid
#666666;min-height:62px;overflow:hidden;width:62px;}#yiv5474439772
#yiv5474439772photos div label
{color:#666666;font-size:10px;overflow:hidden;text-align:center;white-space:nowrap;width:64px;}#yiv5474439772
#yiv5474439772reco-category {font-size:77%;}#yiv5474439772
#yiv5474439772reco-desc {font-size:77%;}#yiv5474439772 .yiv5474439772replbq
{margin:4px;}#yiv5474439772 #yiv5474439772ygrp-actbar div a:first-child
{margin-right:2px;padding-right:5px;}#yiv5474439772 #yiv5474439772ygrp-mlmsg
{font-size:13px;font-family:Arial, helvetica, clean, sans-serif;}#yiv5474439772
#yiv5474439772ygrp-mlmsg table {font-size:inherit;font:100%;}#yiv5474439772
#yiv5474439772ygrp-mlmsg select, #yiv5474439772 input, #yiv5474439772 textarea
{font:99% Arial, Helvetica, clean, sans-serif;}#yiv5474439772
#yiv5474439772ygrp-mlmsg pre, #yiv5474439772 code {font:115%
monospace;}#yiv5474439772 #yiv5474439772ygrp-mlmsg *
{line-height:1.22em;}#yiv5474439772 #yiv5474439772ygrp-mlmsg #yiv5474439772logo
{padding-bottom:10px;}#yiv5474439772 #yiv5474439772ygrp-msg p a
{font-family:Verdana;}#yiv5474439772 #yiv5474439772ygrp-msg
p#yiv5474439772attach-count span {color:#1E66AE;font-weight:700;}#yiv5474439772
#yiv5474439772ygrp-reco #yiv5474439772reco-head
{color:#ff7900;font-weight:700;}#yiv5474439772 #yiv5474439772ygrp-reco
{margin-bottom:20px;padding:0px;}#yiv5474439772 #yiv5474439772ygrp-sponsor
#yiv5474439772ov li a {font-size:130%;text-decoration:none;}#yiv5474439772
#yiv5474439772ygrp-sponsor #yiv5474439772ov li
{font-size:77%;list-style-type:square;padding:6px 0;}#yiv5474439772
#yiv5474439772ygrp-sponsor #yiv5474439772ov ul {margin:0;padding:0 0 0
8px;}#yiv5474439772 #yiv5474439772ygrp-text
{font-family:Georgia;}#yiv5474439772 #yiv5474439772ygrp-text p {margin:0 0 1em
0;}#yiv5474439772 #yiv5474439772ygrp-text tt {font-size:120%;}#yiv5474439772
#yiv5474439772ygrp-vital ul li:last-child {border-right:none
!important;}#yiv5474439772
