Another Grid Problem

[franco]

Thanks again to all,
Serge,
I have got the problem solved.
I had to put in a grid_1 recall, and a grid_1 save, and a grid_1 refresh.
This put the information back into the grid.
This would only happen when I divided one field by another. It would not happen on an add or multiply.
It works good now. Very fast and I am working with fairly large tables, 100,000 records.
I took the code out of the forum because it was messy and hard to read. now that I got it working I want to clean
and straighten it up.
I down loaded 331 and when I compiled my complete program I had many errors.
Is there something I need to add to make it work. It says unicode at start.
It did not like my UNDO word in menus I needed to change to UNDO1.I am sure this is not necessary.
There were many more errors so I stopped using it for now.
Thanks again Franco

[Javier Tovar]

Que bueno que solucionaste tu problema!

Saludos

[serge_girard]

Great !

Serge

[mol]

My countryman is learning HMG and turned to me with problem with browse dbf file with gid.
Workarea is filtered.
When you want to go to last record with Ctrl-END grid stops somewhere in the middle of database:




When you move to last record with Down Arrow or Page Down Key, you can reach last record:



I'm attaching full sample for sb. who wants to test it, because I haven't any idea.
http://www.molsystemy.pl/hmg/20141020_g ... t_grida.7z


When I switched code to use BROWSE control, everything works OK!

[serge_girard]

Mol,

It is acting very strange, sometime the last record is the same as in your example, some another record is the last.
Could it be that some characters in NAZWA are control characters that provoke an EOF?

Serge

[mol]

Mol,

Could it be that some characters in NAZWA are control characters that provoke an EOF?

Serge

I don't think so. I've tested it on mine data set and effects were the same.

[edk]

Hello all. Sorry for my poor English.
I am a new user on the forum and just starting with HMG.
It's me, who have this problem which describes Mol.

@Mol: Dziekuje panie Marku. Wlasnie admin aktywowal moje konto.

@Serge: This is not a problem characters in the NAZWA. You can replace it with any character.

Notice that when you are editing a fake last record changes enroll in a truly last record.

The second problem: I do not know how to properly define the edit control field in the 'Grid'.
For example: if the field is of type 'C' and has a width 3 characters, to be available all characters to input (letters, numbers and specials). I can't set properly mask. Avaiable are "A" and "9" symbols only. If set "A" I can type only letters, if '9' - only digits. If I set mask as " ", I can type more than 3 characters. How to restrict to 3 characters?
{'TEXTBOX','CHARACTER',' '}
It seems to me, that the parameter is missing MAXLENGHT, as in the case of a TextBox Control.

Regards, Edward.

[serge_girard]

Marek,

I sorted your STANY.DBF on MG+GRUPA+TOWAR and now it seems OK...

Serge

[edk]

OK.
But I can't sort every time when change/append/delete records.. I have a database in which there are more than 100k records and MG's are more than 30.

Is it possible to define the skipBlock for a Grid, similarities as for TBrowse? I could not use filtering, but appropriately index and define skipBlock.

EdK.

[mol]

@Mol: Dziekuje panie Marku. Wlasnie admin aktywowal moje konto.
Regards, Edward.

Sorki, uznałem, że trzeba rozdzielić te problemy i zacząć od ważniejszego...
PS. Proszę mi mówić na ty...

English:
Sorry for Polish, but this message is significant for Edward only.