Diese Seite mit anderen teilen ...

Informationen zum Thema:
WinDev Forum
Beiträge im Thema:
Erster Beitrag:
vor 1 Jahr, 12 Monaten
Letzter Beitrag:
vor 1 Jahr, 11 Monaten
Beteiligte Autoren:
Sivaprakash, Ruben Sanchez Peña, Paulo Oliveira, Marc De Swert

Re: Getting #### in fields in Table

Startbeitrag von Sivaprakash am 23.07.2016 06:45


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 Sivaprakash


Re: Getting #### in fields in Table

Not all fields display #####, only few fields.

von Sivaprakash - am 23.07.2016 07:31

Re: Getting #### in fields in Table

Hi. You must change the display mask. Your current display mask doesn't allow display big numbers.


von Ruben Sanchez Peña - am 23.07.2016 11:28

Re: Getting #### in fields in Table


Thanks for your reply Ruben Sanchez Pena....

What I'm not getting are all string fields (few unicode strings, few normal strings).... All are declared with sufficient length...

Happiness Always
BKR Sivaprakash

von Sivaprakash - am 23.07.2016 14:32

Re: Getting #### in fields in Table


1) i don't speak about length field. I'm speaking about display mask (display format of data).

2) Sometimes the IDE put a value "0" instead the correct display mask. For example, if you define the display mask as "Uppercased character" or "None" the IDE put 0 in the rest languages.


von Ruben Sanchez Peña - am 24.07.2016 11:47

Re: Getting #### in fields in Table

Think that you have to make the witdh of the field in the table bigger, that's your problem

Marc :cool:

von Marc De Swert - am 25.07.2016 06:27

Re: Getting #### in fields in Table

In Description pane,

1. Input mask is empty. Not set anything.
2. Length is 0. Tried setting double (100 chars) to actual length (50 chars).

No impact. Getting the same #####.

The field to display is CityName, which is a unicode field in file. It's a lookup table. And the city name is not compulsory in another Master File. So the need of a left outer join to display all records from Master File, in the Table.

Another field is Telephone no. which is from the Master File. Same problem as above for this field too.

At one point, we changed the Table to list from Master File instead of from Query, then again changed it to list data from Query. At that point, every thing was perfect. A small change made in the table, reverted back to #####. Couldn't succeed again by repeating the same steps.

Happiness Always
BKR Sivaprakash

von Sivaprakash - am 25.07.2016 13:24

Re: Getting #### in fields in Table

Error while reading an item: the item does not exist, the data file is empty, ...

Check if your control is linked to what you expect.

check the help for the function ControlError to see the meaning of #####

von Paulo Oliveira - am 25.07.2016 14:49

Re: Getting #### in fields in Table [ SOLVED ]


Found the problem and corrected it. It was my problem.

My code was.

table1.browsedfile = "queryname"

I changed it to.

table1.browsedfile = ""
table1.browsedfile = "queryname"

I missed the hexecutequery which seems a must to retrieve data, as this query retreves data from other files (using left outer join). For few other tables, which shows data from single file, my earlier code was working perfect.

Thanks for your kind support.

Happiness Always
BKR Sivaprakash

von Sivaprakash - am 28.07.2016 05:19
Zur Information:
MySnip.de hat keinen Einfluss auf die Inhalte der Beiträge. Bitte kontaktieren Sie den Administrator des Forums bei Problemen oder Löschforderungen über die Kontaktseite.
Falls die Kontaktaufnahme mit dem Administrator des Forums fehlschlägt, kontaktieren Sie uns bitte über die in unserem Impressum angegebenen Daten.