NetTalk Central

Author Topic: For Jason - Exam question  (Read 2030 times)

terryd

  • Hero Member
  • *****
  • Posts: 759
    • View Profile
    • Davcomm
    • Email
For Jason - Exam question
« on: January 15, 2018, 11:30:05 PM »
Hi Jason. Sorry I cant reply to your message it produces error 500
Just off the top of my head.
Do a count of records in the table RECORDS(table)
Generate random number x# = RANDOM(1,RECORDS(table))

GET(table,x#)   GET using File,filepointer)
Terry Davidson
Windows 10 64 bit/Windows7 64bit
Clarion 9.1.11529/Clarion10 12567
Nettalk 913
Nettalk 1015
StringTheory267/Winevent515/XFiles298/MessageBox239/Cryptonite186

ntnewbies

  • Full Member
  • ***
  • Posts: 168
    • View Profile
    • Email
Re: For Jason - Exam question
« Reply #1 on: January 16, 2018, 01:41:08 AM »
Hi Terry,
Thank you very much for the prompt reply.

My situation is a bit more complex.

Need to choose randomly among the filtered records.

For example,


Category File - Field: CategoryName
User File - Field: User ID
Product File - Field: CategoryName, ProductName, UserID


If user id 1 opens the product file, it should pick randomly a record from Product File but it must be within that user id.

Jason