I have a dbf with some record and I must take a record from this archive but on randomize
How I can make ?
FiveTech Software tech support forums
www.FiveTechSoft.com
RANDOMIZE
6 posts • Page 1 of 1
RANDOMIZE
by Silvio.Falconi » Thu Jan 31, 2013 10:24 am
Since from 1991/1992 ( fw for clipper Rel. 14.4 - Momos)
I use : FiveWin for Harbour November 2023 - January 2024 - Harbour 3.2.0dev (harbour_bcc770_32_20240309) - Bcc7.70 - xMate ver. 1.15.3 - PellesC - mail: silvio[dot]falconi[at]gmail[dot]com
I use : FiveWin for Harbour November 2023 - January 2024 - Harbour 3.2.0dev (harbour_bcc770_32_20240309) - Bcc7.70 - xMate ver. 1.15.3 - PellesC - mail: silvio[dot]falconi[at]gmail[dot]com
-
Silvio.Falconi - Posts: 7069
- Joined: Thu Oct 18, 2012 7:17 pm
Re: RANDOMIZE
by sambomb » Thu Jan 31, 2013 10:49 am
Select YOURDBF
DbGoTo( nRandom(LastRec()-1)+1 )
nRandom is 0 to nParam
LastRec() is your total recs
You need the -1 on LastRec to compensate the 0 start from nRandom and the +1 is to compensate the -1
DbGoTo( nRandom(LastRec()-1)+1 )
nRandom is 0 to nParam
LastRec() is your total recs
You need the -1 on LastRec to compensate the 0 start from nRandom and the +1 is to compensate the -1
Email: SamirSSabreu@gmail.com
xHarbour 1.2.3 + Fwhh 20.2
xHarbour 1.2.3 + Fwhh 20.2
-
sambomb - Posts: 388
- Joined: Mon Oct 13, 2008 11:26 am
- Location: Itaocara - RJ - Brasil
Re: RANDOMIZE
by Silvio.Falconi » Thu Jan 31, 2013 12:48 pm
NRANDOM HAVE PROBLEM
i REMEMBER THERE WAS ANOTHER WITH HB_
i REMEMBER THERE WAS ANOTHER WITH HB_
Since from 1991/1992 ( fw for clipper Rel. 14.4 - Momos)
I use : FiveWin for Harbour November 2023 - January 2024 - Harbour 3.2.0dev (harbour_bcc770_32_20240309) - Bcc7.70 - xMate ver. 1.15.3 - PellesC - mail: silvio[dot]falconi[at]gmail[dot]com
I use : FiveWin for Harbour November 2023 - January 2024 - Harbour 3.2.0dev (harbour_bcc770_32_20240309) - Bcc7.70 - xMate ver. 1.15.3 - PellesC - mail: silvio[dot]falconi[at]gmail[dot]com
-
Silvio.Falconi - Posts: 7069
- Joined: Thu Oct 18, 2012 7:17 pm
Re: RANDOMIZE
by sambomb » Thu Jan 31, 2013 1:42 pm
I never had a problem with nRandom, but...
DbGoTo( HB_Random(1, LastRec() ) ) should solve too.
DbGoTo( HB_Random(1, LastRec() ) ) should solve too.
Email: SamirSSabreu@gmail.com
xHarbour 1.2.3 + Fwhh 20.2
xHarbour 1.2.3 + Fwhh 20.2
-
sambomb - Posts: 388
- Joined: Mon Oct 13, 2008 11:26 am
- Location: Itaocara - RJ - Brasil
Re: RANDOMIZE
by James Bott » Thu Jan 31, 2013 2:56 pm
I think you are going to need to convert the values to integers.
And, I assume for what you want you will need to generate an array so you can check for duplicates and not add them. You are looking to create an array of unique values.
James
And, I assume for what you want you will need to generate an array so you can check for duplicates and not add them. You are looking to create an array of unique values.
James
-
James Bott - Posts: 4840
- Joined: Fri Nov 18, 2005 4:52 pm
- Location: San Diego, California, USA
6 posts • Page 1 of 1
Return to FiveWin for Harbour/xHarbour
Who is online
Users browsing this forum: Google [Bot] and 67 guests