pcsoft.us.windevCopyright 2026, PC SOFT17 Apr 2015 18:54:00 Z15 Apr 2015 07:18:00 Zi am try to this query but not work SELECT QuestionMaster.QuestionMasterID AS QuestionMasterID, QuestionMaster.QM_SM_Id AS QM_SM_Id, QuestionMaster.QM_CM_ID AS QM_CM_ID, QuestionMaster.QM_DetailQuestion AS QM_DetailQuestion, QuestionMaster.QM_Name AS QM_Name, QuestionMaster.QM_AnsA AS QM_AnsA, QuestionMaster.QM_AnsB AS QM_AnsB, QuestionMaster.QM_AnsC AS QM_AnsC, QuestionMaster.QM_AnsD AS QM_AnsD, QuestionMaster.QM_CurrectAns AS QM_CurrectAns, QuestionMaster.QM_Remark AS QM_Remark, ChapterMaster.ChapterMasterID AS ChapterMasterID, ChapterMaster.CM_SM_ID AS CM_SM_ID, ChapterMaster.CM_Name AS CM_Name, ChapterMaster.CM_Mark AS CM_Mark, Random AS Rs FROM QuestionMaster LEFT JOIN ChapterMaster ON ChapterMaster.ChapterMasterID=QuestionMaster.QM_CM_ID ORDER BY ra ASC LIMIT ChapterMaster.CM_Mark AS CM_Mark30WEBDEVen_UShttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/51532-order-list-query-not-work/read.awpmoderateur@pcsoft.fr (El moderador)webmaster@pcsoft.fr (El webmaster)guestpcsoft.us.windevhttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/51532-order-list-query-not-work-51596/read.awp17 Apr 2015 18:54:00 Zthank you, all of Sir, my problem is solied. thank you, thank you,sirhttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/51532-order-list-query-not-work-51596/read.awphttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/51532-order-list-query-not-work-51596/read.awporder by list in query not workguestpcsoft.us.windevhttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/51532-order-list-query-not-work-51593/read.awp17 Apr 2015 16:08:00 ZAs far as i can see RAND() isn't suported by HFSQL, but you should know that, DerekT told you in your previous post in january r…https://forum.pcsoft.fr/es-ES/pcsoft.us.windev/51532-order-list-query-not-work-51593/read.awphttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/51532-order-list-query-not-work-51593/read.awporder by list in query not workguestpcsoft.us.windevhttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/51532-order-list-query-not-work-51592/read.awp17 Apr 2015 15:41:00 Zinstead of Info(HNbRec(CustomerQry)) use info(ErrorInfo(errFullDetails)) and post the result here.https://forum.pcsoft.fr/es-ES/pcsoft.us.windev/51532-order-list-query-not-work-51592/read.awphttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/51532-order-list-query-not-work-51592/read.awporder by list in query not workguestpcsoft.us.windevhttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/51532-order-list-query-not-work-51591/read.awp17 Apr 2015 15:39:00 ZHi, The error you are presenting is the error you get when you access a data source from a query that failed to execute. You…https://forum.pcsoft.fr/es-ES/pcsoft.us.windev/51532-order-list-query-not-work-51591/read.awphttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/51532-order-list-query-not-work-51591/read.awporder by list in query not workguestpcsoft.us.windevhttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/51532-order-list-query-not-work-51588/read.awp17 Apr 2015 14:48:00 Zi am use this code -------------------------- QRY_SubjectWaysChapterList.Param1=1 HExecuteQuery(QRY_SubjectWaysChapterList) …https://forum.pcsoft.fr/es-ES/pcsoft.us.windev/51532-order-list-query-not-work-51588/read.awphttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/51532-order-list-query-not-work-51588/read.awporder by list in query not workguestpcsoft.us.windevhttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/51532-order-list-query-not-work-51571/read.awp16 Apr 2015 20:13:00 ZMaybe an extra SELECT will work? SELECT * FROM (SELECT QuestionMaster.QuestionMasterID AS QuestionMasterID, QuestionMaster…https://forum.pcsoft.fr/es-ES/pcsoft.us.windev/51532-order-list-query-not-work-51571/read.awphttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/51532-order-list-query-not-work-51571/read.awporder by list in query not workguestpcsoft.us.windevhttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/51532-order-list-query-not-work-51570/read.awp16 Apr 2015 20:03:00 ZHi Vijay, If you are not using version 20 you cannot use a parameter to control the LIMIT clause. The solution left for you i…https://forum.pcsoft.fr/es-ES/pcsoft.us.windev/51532-order-list-query-not-work-51570/read.awphttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/51532-order-list-query-not-work-51570/read.awporder by list in query not workguestpcsoft.us.windevhttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/51532-order-list-query-not-work-51569/read.awp16 Apr 2015 19:24:00 Zno.. over software version is windev17 but version in not generatred not above over write query..sir, error is ORDER B…https://forum.pcsoft.fr/es-ES/pcsoft.us.windev/51532-order-list-query-not-work-51569/read.awphttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/51532-order-list-query-not-work-51569/read.awporder by list in query not workguestpcsoft.us.windevhttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/51532-order-list-query-not-work-51565/read.awp16 Apr 2015 15:38:00 ZAre you using version 20?https://forum.pcsoft.fr/es-ES/pcsoft.us.windev/51532-order-list-query-not-work-51565/read.awphttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/51532-order-list-query-not-work-51565/read.awporder by list in query not workguestpcsoft.us.windevhttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/51532-order-list-query-not-work-51561/read.awp16 Apr 2015 14:09:00 ZHi Vijay, Help us helping you: what is the error? Please post the whole error message. Kind regards, Alexandre Leclerchttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/51532-order-list-query-not-work-51561/read.awphttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/51532-order-list-query-not-work-51561/read.awporder by list in query not workguestpcsoft.us.windevhttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/51532-order-list-query-not-work-51558/read.awp16 Apr 2015 13:44:00 Zi am try to this code but give error SELECT QuestionMaster.QuestionMasterID AS QuestionMasterID, QuestionMaster.QM_SM_Id …https://forum.pcsoft.fr/es-ES/pcsoft.us.windev/51532-order-list-query-not-work-51558/read.awphttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/51532-order-list-query-not-work-51558/read.awporder by list in query not workguestpcsoft.us.windevhttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/51532-order-list-query-not-work-51547/read.awp15 Apr 2015 18:30:00 Zwhat is the error? not the expected results, wx error? Why Random AS Rs and ORDER BY ra ASC, if you use rs in the select you …https://forum.pcsoft.fr/es-ES/pcsoft.us.windev/51532-order-list-query-not-work-51547/read.awphttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/51532-order-list-query-not-work-51547/read.awporder by list in query not workguestpcsoft.us.windevhttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/51532-order-list-query-not-work-51546/read.awp15 Apr 2015 18:21:00 Zhello, rs is random data select field , but i am get output a random record selecte rs is random and how many record get …https://forum.pcsoft.fr/es-ES/pcsoft.us.windev/51532-order-list-query-not-work-51546/read.awphttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/51532-order-list-query-not-work-51546/read.awporder by list in query not workguestpcsoft.us.windevhttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/51532-order-list-query-not-work-51543/read.awp15 Apr 2015 15:28:00 ZHi Vijay, What is the "ra" field? Usually you must specify the table name to. Like "ChapterMaster.ra". Best regards, Alex…https://forum.pcsoft.fr/es-ES/pcsoft.us.windev/51532-order-list-query-not-work-51543/read.awphttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/51532-order-list-query-not-work-51543/read.awporder by list in query not work