pcsoft.us.windevCopyright 2026, PC SOFT24 Oct 2014 16:33:59 Z23 Oct 2014 11:14:04 ZGood day I have a USER_RIGHTS table. It has a USER Column, PAGE Column and RIGHTS Column. How would I lookup to see that a user has the rights to look at a page? I know how to Find 1 bu using: [code:wl] hreadseekfirst(USER_RIGHTS,ID,EDT_USER IF HFOUND(USER_RIGHTS) THEN ....... END [/code] How will I then tell it that now that you found the user look in that same table for the requested page, if that is found what is the RIGHTS.... [code:wl] If rights = 1 then "Go to that page" else info("You do not have rights to view this page" END [/code] Thanks30WEBDEVen_UShttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/48620-lookup-multiple-data-database-table/read.awpmoderateur@pcsoft.fr (El moderador)webmaster@pcsoft.fr (El webmaster)tbc92pcsoft.us.windevhttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/48620-lookup-multiple-data-database-table-48653/read.awp24 Oct 2014 16:33:59 ZRuan a écrit : > > Hi > > Unfortunately this is now the first time I see this, I have never had the need for Composite-K…https://forum.pcsoft.fr/es-ES/pcsoft.us.windev/48620-lookup-multiple-data-database-table-48653/read.awphttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/48620-lookup-multiple-data-database-table-48653/read.awpLookup Multiple data in Database TableRuanpcsoft.us.windevhttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/48620-lookup-multiple-data-database-table-48634/read.awp23 Oct 2014 21:58:24 ZJoel wrote: > Some documentation that could help you : > > http://doc.windev.com/en-US/… > http://doc.windev.com/en-US/… >…https://forum.pcsoft.fr/es-ES/pcsoft.us.windev/48620-lookup-multiple-data-database-table-48634/read.awphttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/48620-lookup-multiple-data-database-table-48634/read.awpLookup Multiple data in Database Tablefromwebpcsoft.us.windevhttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/48620-lookup-multiple-data-database-table-48632/read.awp23 Oct 2014 19:16:36 ZHi Ruan if you do not understand what I meant, it means that you NEED to START by reading in details the TUTORIAL that come…https://forum.pcsoft.fr/es-ES/pcsoft.us.windev/48620-lookup-multiple-data-database-table-48632/read.awphttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/48620-lookup-multiple-data-database-table-48632/read.awpLookup Multiple data in Database Tabletbc92pcsoft.us.windevhttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/48620-lookup-multiple-data-database-table-48631/read.awp23 Oct 2014 17:45:16 ZSome documentation that could help you : http://doc.windev.com/en-US/?3044178&name=Composite_keys http://doc.windev.com/en-U…https://forum.pcsoft.fr/es-ES/pcsoft.us.windev/48620-lookup-multiple-data-database-table-48631/read.awphttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/48620-lookup-multiple-data-database-table-48631/read.awpLookup Multiple data in Database TableRuanpcsoft.us.windevhttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/48620-lookup-multiple-data-database-table-48630/read.awp23 Oct 2014 17:15:04 ZFabrice Harari wrote: > Hi Ruan > > you need to declare a composite key on USER+Page > > this way, a simple hreadseek(MyF…https://forum.pcsoft.fr/es-ES/pcsoft.us.windev/48620-lookup-multiple-data-database-table-48630/read.awphttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/48620-lookup-multiple-data-database-table-48630/read.awpLookup Multiple data in Database TableRuanpcsoft.us.windevhttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/48620-lookup-multiple-data-database-table-48629/read.awp23 Oct 2014 17:13:47 ZFabrice Harari wrote: > Hi Ruan > > you need to declare a composite key on USER+Page > > this way, a simple hreadseek(MyF…https://forum.pcsoft.fr/es-ES/pcsoft.us.windev/48620-lookup-multiple-data-database-table-48629/read.awphttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/48620-lookup-multiple-data-database-table-48629/read.awpLookup Multiple data in Database Tablefromwebpcsoft.us.windevhttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/48620-lookup-multiple-data-database-table-48628/read.awp23 Oct 2014 16:14:07 ZHi Ruan you need to declare a composite key on USER+Page this way, a simple hreadseek(MyFile,MyCompositeKey,[File,Page]) w…https://forum.pcsoft.fr/es-ES/pcsoft.us.windev/48620-lookup-multiple-data-database-table-48628/read.awphttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/48620-lookup-multiple-data-database-table-48628/read.awpLookup Multiple data in Database Tableinfopcsoft.us.windevhttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/48620-lookup-multiple-data-database-table-48627/read.awp23 Oct 2014 15:56:16 ZHi Ruan, Then the 'problem' is in the fact you only look for and only will find the first record with 'HreadSeekFirst'. You h…https://forum.pcsoft.fr/es-ES/pcsoft.us.windev/48620-lookup-multiple-data-database-table-48627/read.awphttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/48620-lookup-multiple-data-database-table-48627/read.awpLookup Multiple data in Database TableRuanpcsoft.us.windevhttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/48620-lookup-multiple-data-database-table-48626/read.awp23 Oct 2014 14:41:39 ZRudolf van Roosmalen wrote: > Hi, Ruan, > > In this case it is really a merge of your pieces of code > > HReadSeekFirst(U…https://forum.pcsoft.fr/es-ES/pcsoft.us.windev/48620-lookup-multiple-data-database-table-48626/read.awphttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/48620-lookup-multiple-data-database-table-48626/read.awpLookup Multiple data in Database Tableinfopcsoft.us.windevhttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/48620-lookup-multiple-data-database-table-48624/read.awp23 Oct 2014 14:11:26 ZHi, Ruan, In this case it is really a merge of your pieces of code [code:wl] HReadSeekFirst(USER_RIGHTS,ID,EDT_USER) IF …https://forum.pcsoft.fr/es-ES/pcsoft.us.windev/48620-lookup-multiple-data-database-table-48624/read.awphttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/48620-lookup-multiple-data-database-table-48624/read.awpLookup Multiple data in Database TableRuanpcsoft.us.windevhttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/48620-lookup-multiple-data-database-table-48623/read.awp23 Oct 2014 12:18:47 ZRudolf van Roosmalen wrote: > Hi Ruan, > > As far as I can understand you just have to merge your two pieces of code: > >…https://forum.pcsoft.fr/es-ES/pcsoft.us.windev/48620-lookup-multiple-data-database-table-48623/read.awphttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/48620-lookup-multiple-data-database-table-48623/read.awpLookup Multiple data in Database Tableinfopcsoft.us.windevhttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/48620-lookup-multiple-data-database-table-48622/read.awp23 Oct 2014 11:55:15 ZHi Ruan, As far as I can understand you just have to merge your two pieces of code: [code:wl] HReadSeekFirst(USER_RIGHTS,…https://forum.pcsoft.fr/es-ES/pcsoft.us.windev/48620-lookup-multiple-data-database-table-48622/read.awphttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/48620-lookup-multiple-data-database-table-48622/read.awpLookup Multiple data in Database Table