And of course you could always embed an IE page in the form and use the 
<Marquee> tag to scroll the text.

If you want to know how to do this then just shout.

Dave

-----Original Message-----
From: [email protected] [mailto:[email protected]] On Behalf Of 
James Harvey
Sent: 22 May 2012 12:43
To: 'ProFox Email List'
Subject: how best to scroll results

I'm hoping for advice on how to show values from a cursor in six text boxes 
positioned in a straight line across the form so that it appears the numbers 
are scrolling.

First thought was to create a cursor of the values to scroll (returns around
175 - 200 records):

Select VAL(stnhorse.hip_no) AS HIP_NO From stnhorse Left Join stnpaper On 
stnhorse.arr_no = stnpaper.arr_no WHERE !empty(stnpaper.out) ORDER By 
stnhorse.hip_no Into Cursor lcfile1

Then I thought that I could show the first hip in the first textbox for one 
second, then move that hip to the second textbox, and show the second hip in 
the first textbox, and then after one second assign the first hip to the third 
textbox, the second hip to the second textbox and the third hip to the first 
textbox.

Keep going that until the end of the cursor then run the select statement again 
and repeat.

I started to try to write code for this and thought maybe someone has a better 
idea, or has already done this and had a quick example?

Or maybe there is a control out there created specifically for this type of 
presentation?

James E Harvey
Corresponding Officer/M.I.S.
Hanover Shoe Farms, Inc.
www.hanoverpa.com
office: 717-637-8931
cell: 717-887-2565
fax: 717-637-6766



[excessive quoting removed by server]

_______________________________________________
Post Messages to: [email protected]
Subscription Maintenance: http://leafe.com/mailman/listinfo/profox
OT-free version of this list: http://leafe.com/mailman/listinfo/profoxtech
Searchable Archive: http://leafe.com/archives/search/profox
This message: 
http://leafe.com/archives/byMID/profox/[email protected]
** All postings, unless explicitly stated otherwise, are the opinions of the 
author, and do not constitute legal or medical advice. This statement is added 
to the messages for those lawyers who are too stupid to see the obvious.

Reply via email to