Hi
I think the best way to do the ordering is on the query, add a order by
clause in the sql so that the data is already ordered when it comes to
the report.
when it comes to date searching - i usually have all my controls use the
date set at the control panel - but on the sql (since the server can be
on a different computer with a different date format) i use the format
'dd mmm yyyy' - so for americans they type in 04/06/2006 and for
europeans they'd type in 06/04/2006 but my query would be 06 apr 2006
and most sql servers understands that date format with no ambiguity -
for this i use formatdatetime('dd mmm yyyy',x) where x is the control's
date property.
Arsen Khachatryan wrote:
>
>
> Hi all people how are you?
> I have a few problem in delphi and dopn´t know what to
> do?
>
> How can I order in quich report the lists with date or
> price or names?? is it possible put anything and if
> user want to order by price or by date then print.
>
> And second in query the default date format is
> MM/DD/YY and when I want to search by date I have to
> put MM/DD/YY, how can I change the format,that the
> user can search it like DD/MM/YY?
>
> Please help me with this if someone can.
>
> Thank You a lot
>
>
--
PO Box 26453 00504
Nairobi, Kenya.
TEL: +254722996532
[EMAIL PROTECTED]
------------------------ Yahoo! Groups Sponsor --------------------~-->
Great things are happening at Yahoo! Groups. See the new email design.
http://us.click.yahoo.com/TISQkA/hOaOAA/yQLSAA/i7folB/TM
--------------------------------------------------------------------~->
-----------------------------------------------------
Home page: http://groups.yahoo.com/group/delphi-en/
To unsubscribe: [EMAIL PROTECTED]
Yahoo! Groups Links
<*> To visit your group on the web, go to:
http://groups.yahoo.com/group/delphi-en/
<*> To unsubscribe from this group, send an email to:
[EMAIL PROTECTED]
<*> Your use of Yahoo! Groups is subject to:
http://docs.yahoo.com/info/terms/
