Search results for query: *

Thank you all. I have to prevent the second instance only to update the procedure. Normally users open many instances without any problems. I think working on the 'PROCEDURES myInstance' just being updated. Monty

I would say no. It's not my thread. A user launches the exe, I put online update, the user raises the exe but the update fails to copy the new version on the open file. I have to figure out if the program is already open.

The answer to this question I had already seen but can not find it anymore. I have to find if a user has multiple sessions open the same program. To do the upgrade. Thanks Monty

I did a test using in Init of each field: THIS.InputMask = "!"+REPLICATE("X",Len(Eval(This.ControlSource))-1) and THIS.InputMask = REPLICATE("X",Len(Eval(This.ControlSource))) not slows down the loading of the form. Nothing difference [thumbsup2] Monty

I have a doubt, if I use in Init of each field THIS.InputMask = "!"+REPLICATE("X",Len(Eval(This.ControlSource))-1) in VPN environment to read the ControlSource of 50-60 fields to slow down the loading of the form? Monty

jrbbldr TrueProper() function is very interesting, must be adapted to the Italian language. Thank Monty

I work with VFP 8.0 and there are no 'W' and 'U', but I prefer 'X' and '!' For example my users input "Castel San Pietro Terme" or "Sant'Agata sul Santerno" or "Via Garibaldi, 11/m". All combinations... Monty

Ok Olaf, You anticipated my next question with "Len(Eval(This.ControlSource))" So if upper the first letter THIS.InputMask = "!"+REPLICATE("X",Len(Eval(This.ControlSource))-1) if all lowers THIS.InputMask = REPLICATE("X",Len(Eval(This.ControlSource))) for all character TextBox with a field in...

Comic proposal to change the name to the forum... A group of "desperate people" asking for help to Olaf and Mike ;-);-);-);-);-);-) Monty

Right Mike better in Init of the testbox! even though I have more than 50 years I still have to learn a lot! Monty

Olaf, where do I put "!"+REPLICATE("X",LEN(field)-1) in Init of Form? THISFORM.TextBox1.InputMask = "!"+REPLICATE("X",LEN(field)-1) Monty

mm0000 I would like only first uppercase "Italy" not "ITALY

Thank Olaf I did not know Proper(), very interesting. But if I use This.Value = Proper(This.Value) in interactive change the cursor remains on the first character, if I put KEYBOARD '{END}' in interactive change does not create the space. Or something wrong? Can I use Proper() in Valid of the...

In a normal TextBox I use InputMask "!XXXXXXX" for a field of 8 characters (First upper others lower). In the fields of 30, 40 characters, Can I not use '! XXX .....' 40 times?. Make a function or use MaxLengh or use NODEFAULT... Thanks Monty

I think my situation is conducive to a field per table. I have a function myrlock() and there I can put a unique code. All grids display only selected fields. Then every weekend shut down the server and saturday morning I can make the changes exclusive (reindex, pack, modify structure ecc...) Monty

Considering my situation the best solution is: update database to have a field in any relevant table for the locking user (relevant table are 7-8 not more). Good idea, thank Olaf.

Thanks for the advice. Olaf, there is no problems in the network. I just wanted to give the message 'record locked by Johnny'. Too complex to manage the table with the record locked. All that remains! Monty

Maybe I ask too much. In an environment of Win XP client and a server WIN server 2003 using simple DBF tables CDX-where the blocks are managed by hand with RLOCK () it would be possible to determine which user (PC) locks a record? Thank Monty

Very elegant Olaf! Perfect Paolo

Thanks to all, optimal solutions OlafDoschke good solution, very dangerous near bottom file, but I work far from the bottom. Paolo