pcsoft.us.windevCopyright 2026, PC SOFT6 Jan 2015 14:35:00 Z4 Jan 2015 15:29:00 ZSELECT ExamData.ExamDataID AS ExamDataID, ExamData.Index_Id AS Index_Id, ExamData.ED_Que AS ED_Que, ExamData.ED_Ans_A AS ED_Ans_A, ExamData.ED_Ans_B AS ED_Ans_B, ExamData.ED_Ans_C AS ED_Ans_C, ExamData.ED_Ans_D AS ED_Ans_D, ExamData.ED_currectAns AS ED_currectAns FROM ExamData ORDER BY Index_Id RAND LIMIT 100 -------------------- i am try to above query excu. but this query in give error windev17 please give help me30WEBDEVen_UShttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/49700-random-record-found-database-table/read.awpmoderateur@pcsoft.fr (El moderador)webmaster@pcsoft.fr (El webmaster)guestpcsoft.us.windevhttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/49700-random-record-found-database-table-49742/read.awp6 Jan 2015 14:35:00 Zthank you sirhttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/49700-random-record-found-database-table-49742/read.awphttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/49700-random-record-found-database-table-49742/read.awprandom record found in database tableguestpcsoft.us.windevhttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/49700-random-record-found-database-table-49713/read.awp5 Jan 2015 13:36:00 ZYou can try something like this: SELECT ExamData.ExamDataID AS ExamDataID, ExamData.Index_Id AS Index_Id, ExamData.ED_Que AS…https://forum.pcsoft.fr/es-ES/pcsoft.us.windev/49700-random-record-found-database-table-49713/read.awphttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/49700-random-record-found-database-table-49713/read.awprandom record found in database tableguestpcsoft.us.windevhttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/49700-random-record-found-database-table-49711/read.awp5 Jan 2015 12:08:00 ZVijay Your error explains the problem RAND() is not supported in the HFSQL language. 2 options... 1. Change to a datab…https://forum.pcsoft.fr/es-ES/pcsoft.us.windev/49700-random-record-found-database-table-49711/read.awphttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/49700-random-record-found-database-table-49711/read.awprandom record found in database tableguestpcsoft.us.windevhttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/49700-random-record-found-database-table-49709/read.awp5 Jan 2015 11:18:00 ZVIjay, I have never used this feature but I think there is no facility to randomize results of a Query in HFSQL. Generally in…https://forum.pcsoft.fr/es-ES/pcsoft.us.windev/49700-random-record-found-database-table-49709/read.awphttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/49700-random-record-found-database-table-49709/read.awprandom record found in database tableguestpcsoft.us.windevhttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/49700-random-record-found-database-table-49708/read.awp5 Jan 2015 11:09:00 ZHi, 1. What does ErrorInfo(hErrFullDetails) tell you? 2. Do you have the hQueryWithoutCorrection parameter flagged? 3... …https://forum.pcsoft.fr/es-ES/pcsoft.us.windev/49700-random-record-found-database-table-49708/read.awphttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/49700-random-record-found-database-table-49708/read.awprandom record found in database tableguestpcsoft.us.windevhttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/49700-random-record-found-database-table-49707/read.awp5 Jan 2015 11:01:00 ZHi Vijay , If you donnot give us more information we cannot help you. Is there an error or does the query generate other r…https://forum.pcsoft.fr/es-ES/pcsoft.us.windev/49700-random-record-found-database-table-49707/read.awphttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/49700-random-record-found-database-table-49707/read.awprandom record found in database tableguestpcsoft.us.windevhttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/49700-random-record-found-database-table-49705/read.awp5 Jan 2015 06:26:00 Zdatabase id hyperfile does not generat query error is unexpected word:RAND()https://forum.pcsoft.fr/es-ES/pcsoft.us.windev/49700-random-record-found-database-table-49705/read.awphttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/49700-random-record-found-database-table-49705/read.awprandom record found in database tableguestpcsoft.us.windevhttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/49700-random-record-found-database-table-49702/read.awp4 Jan 2015 15:40:00 ZHi 1. What error ? 2. What code do you use to run this query? 3. On what type of database? Are we supposed to devine all…https://forum.pcsoft.fr/es-ES/pcsoft.us.windev/49700-random-record-found-database-table-49702/read.awphttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/49700-random-record-found-database-table-49702/read.awprandom record found in database table