Inverted sort on time

[rlgiordano]

Hi,
I am trying to do a inverted sort on a embedded browser with date, time.
They are caludated fields in my table, Date as a date field = Date() and Time1 as a time field = now(). Date works fine but the time dosen,t. I tried using invert(cshorttime(Time1)), but that didn't work. I have the time formated in the browser as HH:MM AM.

Thanks
BobG

[Stan Mathews]

Re: Inverted sort on time

The help indicates

Sortable Time Value
C
CDATE( Time_Variable ) + TIME("hms", Time_Variable )

and

Sortable Short Time
C
TIME("hms", Time_Variable )

[G Gabriel]

Re: Inverted sort on time

and Time1 as a time field = now()

If Time field =now(), there is nothing to sort there. They all equal now().
P.S.:
Unless your computer is capable of nano-seconds calculations, they will all be the same, or almost the same.

[rlgiordano]

Re: Inverted sort on time

All time fields are stamped with now() in the time1 (field rules). First should I use a shorttime or time. When I use shortime and give a calulated rule as now() I get a error.

Thanks

[Stan Mathews]

Re: Inverted sort on time

When I use shortime and give a calulated rule as now() I get a error.

Thanks

Use

convert_type(now(),"Y")

[rlgiordano]

Re: Inverted sort on time

Hi Stan,

That works great, the only problem is when I add a new reord the browser dosent refresh to the new record.

Thanks
Bob

[Stan Mathews]

Re: Inverted sort on time

Have the same problem with the default form for the set? If not you may have a problem with your form. Seems to work for the sample I tested.

I'm thinking now that you mean that the browse doesn't sync to the new record by placing it at the top of the browse and selecting it. If you know that you will at most have say about 10 child records, code the onsave event of the browse

for i = 1 to 15
    [COLOR="Red"]browse1[/COLOR].fetch_prev()
next i

Use the actual browse object name.

[CALocklin]

Re: Inverted sort on time

This isn't a response to the exact question but I think it's very pertinent to what you are doing.

You mentioned in the first post that you are using calculated fields. This is probably NOT the thing to do. See this post and also this one.

[rlgiordano]

Re: Inverted sort on time

Thank you Cal and stan for your input, I will change them to non-cal fields and try it.

The other problem I have is the way the browser display's after entering a new record. I have attached 2 jpg files. Open form is the way the browser looks when opening the form. The browser is ordered by date and time, which is what I want. After a add a new record, (attachement after record) the scroll bar goes to the first record of the bottom of the browser. How can I make it display like the openform browser attachement which the scroll bar is at the last record?

Thanks
Bob

[martinwcole]

Re: Inverted sort on time

in the browse onsave event try
browse1.resynch() 'resynch() in V10 works better for me than in any other version
browse1.fetch_first()

although, for the record, I think this approach will prove to be troublesome, and the new record row will still be at the bottom of the browse.

[rlgiordano]

Re: Inverted sort on time

Martin,

This dosen't work, The browser is set for read only because all actions will be done by a companion form.

Thanks
Bob

[martinwcole]

Re: Inverted sort on time

then use the same code after coming back from the companion form