pcsoft.us.windevCopyright 2026, PC SOFT29 Sep 2015 07:29:00 Z28 Sep 2015 04:06:00 ZHello, Windev 20 66r Planning to develop a generic application with no predefined Database or Table (File). A GUI to choose the following 1. Connection type (OLE DB / ODBC etc.) 2. Server , Database , Userid, Password 3. Select Table 4. Field selection (I need 6 fields, but the name of the field(s) need not be predefined) by the user need to be presented and based on the user selection, further processing need to be done. Need to show the tables and fields for selection by the user. ie, after connection, the GUI is to list database and the user will select one. After selecting the database, the table has to be chosen from the list. Problem(s) faced. 1. Problem in preparing Analysis. Since no predefined table, how to proceed. Not sure whether I can proceed without any analysis. 2. To show the list of fields from a table (file) not from analysis but from the user chosen table (file). 3. Not sure how to construct SQL to select, insert, update, delete data. Happiness Always BKR Sivaprakash30WEBDEVen_UShttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/54172-generic-application/read.awpmoderateur@pcsoft.fr (El moderador)webmaster@pcsoft.fr (El webmaster)guestpcsoft.us.windevhttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/54172-generic-application-54215/read.awp29 Sep 2015 07:29:00 ZPaulo Oliveira, With empty records I could fetch all column names, so that I thought of querying like asQuery = " Select *…https://forum.pcsoft.fr/es-ES/pcsoft.us.windev/54172-generic-application-54215/read.awphttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/54172-generic-application-54215/read.awpRe: Generic applicationguestpcsoft.us.windevhttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/54172-generic-application-54203/read.awp28 Sep 2015 16:34:00 ZI'm not sure if it work for every db engine but normally if you only need to get the list of fields something like this can do t…https://forum.pcsoft.fr/es-ES/pcsoft.us.windev/54172-generic-application-54203/read.awphttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/54172-generic-application-54203/read.awpRe: Generic applicationguestpcsoft.us.windevhttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/54172-generic-application-54197/read.awp28 Sep 2015 15:47:00 ZYes Paulo Oliveira, you are right. Performance problem is an issue. Is there any generic SQL query to fetch the top 1 record …https://forum.pcsoft.fr/es-ES/pcsoft.us.windev/54172-generic-application-54197/read.awphttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/54172-generic-application-54197/read.awpRe: Generic applicationguestpcsoft.us.windevhttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/54172-generic-application-54195/read.awp28 Sep 2015 15:02:00 ZHDeclareExternal works fine with SQL Server, but if select * is OK for you (be carefull with the performance problems if your ha…https://forum.pcsoft.fr/es-ES/pcsoft.us.windev/54172-generic-application-54195/read.awphttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/54172-generic-application-54195/read.awpRe: Generic applicationguestpcsoft.us.windevhttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/54172-generic-application-54192/read.awp28 Sep 2015 14:33:00 ZThanks Paulo Oliveira, HListItem on the query did the trick. I got it. Think I made the things more complex by trying out …https://forum.pcsoft.fr/es-ES/pcsoft.us.windev/54172-generic-application-54192/read.awphttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/54172-generic-application-54192/read.awpRe: Generic applicationguestpcsoft.us.windevhttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/54172-generic-application-54190/read.awp28 Sep 2015 13:48:00 Zyou can list the fields from the query using HListItemhttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/54172-generic-application-54190/read.awphttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/54172-generic-application-54190/read.awpRe: Generic applicationguestpcsoft.us.windevhttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/54172-generic-application-54189/read.awp28 Sep 2015 13:45:00 ZIf you don't use any analysis to list the files/fields may be different depending on the DB type. Which DB type are you plann…https://forum.pcsoft.fr/es-ES/pcsoft.us.windev/54172-generic-application-54189/read.awphttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/54172-generic-application-54189/read.awpRe: Generic applicationguestpcsoft.us.windevhttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/54172-generic-application-54188/read.awp28 Sep 2015 13:35:00 ZHello, Is there any command to get list of field names after executing a query like, asFile = CMB_DBFiles..DisplayedValue …https://forum.pcsoft.fr/es-ES/pcsoft.us.windev/54172-generic-application-54188/read.awphttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/54172-generic-application-54188/read.awpRe: Generic applicationguestpcsoft.us.windevhttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/54172-generic-application-54184/read.awp28 Sep 2015 12:35:00 ZThanks Fabrice Harari for your reply. But my system is not that complex. Here I'm just going to send SMS from the data availa…https://forum.pcsoft.fr/es-ES/pcsoft.us.windev/54172-generic-application-54184/read.awphttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/54172-generic-application-54184/read.awpRe: Generic applicationguestpcsoft.us.windevhttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/54172-generic-application-54181/read.awp28 Sep 2015 12:20:00 ZThanks Paulo Oliveira. I could get list of files in a database with HListFile, without any analysis. Is there any function…https://forum.pcsoft.fr/es-ES/pcsoft.us.windev/54172-generic-application-54181/read.awphttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/54172-generic-application-54181/read.awpRe: Generic applicationguestpcsoft.us.windevhttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/54172-generic-application-54180/read.awp28 Sep 2015 12:17:00 ZHi what you are describing is possible, but will be quite complex to achieve. You can use a generic analysis in which you …https://forum.pcsoft.fr/es-ES/pcsoft.us.windev/54172-generic-application-54180/read.awphttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/54172-generic-application-54180/read.awpRe: Generic applicationguestpcsoft.us.windevhttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/54172-generic-application-54179/read.awp28 Sep 2015 12:05:00 ZYou don't need any analysis for this just use the HExecuteSQLQuery function with hQueryWithoutCorrection. To build the query …https://forum.pcsoft.fr/es-ES/pcsoft.us.windev/54172-generic-application-54179/read.awphttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/54172-generic-application-54179/read.awpRe: Generic applicationguestpcsoft.us.windevhttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/54172-generic-application-54177/read.awp28 Sep 2015 11:53:00 ZHello, Thanks Al for your clarification. Yes, I'm new to Wx products and terminologies. I'm trying to develop one generic …https://forum.pcsoft.fr/es-ES/pcsoft.us.windev/54172-generic-application-54177/read.awphttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/54172-generic-application-54177/read.awpRe: Generic applicationguestpcsoft.us.windevhttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/54172-generic-application-54174/read.awp28 Sep 2015 08:47:00 ZHello Sivaprakash First you need to get the Windev terminology correct. In Windev "tables" are NOT files inside a database, t…https://forum.pcsoft.fr/es-ES/pcsoft.us.windev/54172-generic-application-54174/read.awphttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/54172-generic-application-54174/read.awpRe: Generic applicationguestpcsoft.us.windevhttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/54172-generic-application-54173/read.awp28 Sep 2015 08:38:00 ZHello, HListFile(Connection, hLstFile) list all Tables found in a database, whether it's in analysis or not. Is there a…https://forum.pcsoft.fr/es-ES/pcsoft.us.windev/54172-generic-application-54173/read.awphttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/54172-generic-application-54173/read.awpRe: Generic application