Unfortunately this is a select statement in a web page. So I cannot do multiple commands.
Did not know about the where count = …. Dan Goldberg From: [email protected] [mailto:[email protected]] On Behalf Of Buddy Walker Sent: Tuesday, August 9, 2016 11:11 AM To: [email protected] Subject: RE: [RBASE-L] - pick a random row Dan PROJECT TEMPORARY TABLE TemporarTableName usi all where …….. SEL COUNT(*) INTO vrows FROM TemporarTableName SET TIME FOR HH:MM:SS.SSS SET VAR vRowSelect = (IFRC(.#TIME)) LABEL ChkRowCount IF vRowSelect > .vRow THEN SET VAR vRowSelect = (IFRC(.#TIME)) GOTO ChkRowCount ELSE SEL ……. FROM TemporaryTable WHERE COUNT = .vRowSelect ENDIF Make sure to set your TIME FORMAT back to your defaut setting. Buddy From: [email protected]<mailto:[email protected]> [mailto:[email protected]] On Behalf Of Dan Goldberg Sent: Tuesday, August 9, 2016 1:06 PM To: [email protected]<mailto:[email protected]> Subject: [RBASE-L] - pick a random row I have a select statement that I need to create that will pick one random row based on the where clause. SELECT *FROM averyweb_items WHERE iditemscategory = 4 AND itemsstatus = 1 I can do a random function but not sure on how to implement it. I cannot figure out what I need to do. Any help is appreciated. TIA Dan Goldberg MIS Manager Lance Camper Mfg. Corp (661) 949-3322 Ext 252 www.lancecamper.com<http://www.lancecamper.com/> -- You received this message because you are subscribed to the Google Groups "RBASE-L" group. To unsubscribe from this group and stop receiving emails from it, send an email to [email protected]<mailto:[email protected]>. For more options, visit https://groups.google.com/d/optout. -- You received this message because you are subscribed to the Google Groups "RBASE-L" group. To unsubscribe from this group and stop receiving emails from it, send an email to [email protected]<mailto:[email protected]>. For more options, visit https://groups.google.com/d/optout. -- You received this message because you are subscribed to the Google Groups "RBASE-L" group. To unsubscribe from this group and stop receiving emails from it, send an email to [email protected]. For more options, visit https://groups.google.com/d/optout.
