pcsoft.us.windevCopyright 2026, PC SOFT28 Jul 2016 07:19:00 Z23 Jul 2016 08:45:00 ZHello, Windev 20, HFSQL I display a table from a query with left outer joins. When run in Control center, I get correct values, but when displayed in a table, I get ##### instead of correct values. Couldn't figure out what's wrong. Anything I'm missing ? Query is like this. Select t1.a, t1.b, t1.c, t1.d, t2.k, t3.l, t4.m, t1.d, t1.e From File t1 Left Outer Join File t2 On t2.q = t1.q Left Outer Join File t3 on t3.w = t1.w Where t1.z = 'xxxx' Order by t1.1 I edited the query by hand instead of using the query editor of windev. Happiness Always BKR Sivaprakash30WEBDEVen_UShttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/58813-getting-fields-table/read.awpmoderateur@pcsoft.fr (El moderador)webmaster@pcsoft.fr (El webmaster)guestpcsoft.us.windevhttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/58813-getting-fields-table-solved-58875/read.awp28 Jul 2016 07:19:00 ZHello, Found the problem and corrected it. It was my problem. My code was. table1.browsedfile = "queryname" I change…https://forum.pcsoft.fr/es-ES/pcsoft.us.windev/58813-getting-fields-table-solved-58875/read.awphttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/58813-getting-fields-table-solved-58875/read.awpRe: Getting #### in fields in Tableguestpcsoft.us.windevhttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/58813-getting-fields-table-58833/read.awp25 Jul 2016 16:49:00 ZError while reading an item: the item does not exist, the data file is empty, ... Check if your control is linked to what you…https://forum.pcsoft.fr/es-ES/pcsoft.us.windev/58813-getting-fields-table-58833/read.awphttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/58813-getting-fields-table-58833/read.awpRe: Getting #### in fields in Tableguestpcsoft.us.windevhttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/58813-getting-fields-table-58832/read.awp25 Jul 2016 15:24:00 ZIn Description pane, 1. Input mask is empty. Not set anything. 2. Length is 0. Tried setting double (100 chars) to actual le…https://forum.pcsoft.fr/es-ES/pcsoft.us.windev/58813-getting-fields-table-58832/read.awphttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/58813-getting-fields-table-58832/read.awpRe: Getting #### in fields in Tableguestpcsoft.us.windevhttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/58813-getting-fields-table-58827/read.awp25 Jul 2016 08:27:00 ZThink that you have to make the witdh of the field in the table bigger, that's your problem Marc :cool:https://forum.pcsoft.fr/es-ES/pcsoft.us.windev/58813-getting-fields-table-58827/read.awphttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/58813-getting-fields-table-58827/read.awpRe: Getting #### in fields in Tableguestpcsoft.us.windevhttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/58813-getting-fields-table-58826/read.awp24 Jul 2016 13:47:00 ZHi. 1) i don't speak about length field. I'm speaking about display mask (display format of data). 2) Sometimes the IDE pu…https://forum.pcsoft.fr/es-ES/pcsoft.us.windev/58813-getting-fields-table-58826/read.awphttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/58813-getting-fields-table-58826/read.awpRe: Getting #### in fields in Tableguestpcsoft.us.windevhttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/58813-getting-fields-table-58823/read.awp23 Jul 2016 16:32:00 ZHello, Thanks for your reply Ruben Sanchez Pena.... What I'm not getting are all string fields (few unicode strings, few n…https://forum.pcsoft.fr/es-ES/pcsoft.us.windev/58813-getting-fields-table-58823/read.awphttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/58813-getting-fields-table-58823/read.awpRe: Getting #### in fields in Tableguestpcsoft.us.windevhttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/58813-getting-fields-table-58821/read.awp23 Jul 2016 13:28:00 ZHi. You must change the display mask. Your current display mask doesn't allow display big numbers. Rubénhttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/58813-getting-fields-table-58821/read.awphttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/58813-getting-fields-table-58821/read.awpRe: Getting #### in fields in Tableguestpcsoft.us.windevhttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/58813-getting-fields-table-58820/read.awp23 Jul 2016 09:31:00 ZNot all fields display #####, only few fields.https://forum.pcsoft.fr/es-ES/pcsoft.us.windev/58813-getting-fields-table-58820/read.awphttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/58813-getting-fields-table-58820/read.awpRe: Getting #### in fields in Table