Less code for toggling T/F value for a check box:
thisform.checkbox.value = !thisform.checkbox.value
Or for toggling a T/F property value:
thisform.mybutton.visible = !thisform.mybutton.visible
In my application, I use a commandgroup button and a pageframe class together. The pageframe is set to hide the tabs at runtime. I have customized the commandgroup as my own class to control the highlighting of the buttons. The buttons in the commandgroup each correspond to a page in the...
gbcpastor-
The cause of the status window is a bug in Windows that is ignoring the flag FOF_SILENT. This has been reported to MS. I think the status window was not shown in Win7; somewhere in the updates of Win10 the bug appeared.
Chriss--
Yes, the intention was to provide a means to create and control cell formatting without automation. Some of my users do not have MS Office and instead use other open source alternatives which does not support the automation.
What sets my class apart from Cetin's or Vilhelm's...
gbcpastor--
See the above reply for a download of the updated class. You should be able to now have leading spaces and the class automatically assign to preserve the spaces. However, if you are trying to indent the text over an amount, you should use the following methods to create a style...
@atlopes
I have incorporated your suggestions into the class and will post a new release update. However, I did not add the line #20 as you suggested to the method WriteSheetXMLs; instead the preserve is added to the cell value as an attribute. Also, it is not necessary to add the line to...
Please send me the xlsx file that you generated. I will check the internal value being written. I suspect that Chriss is right and the culprit is now Excel triming the spaces. I also know that a single quote should fix the issue as well.
I would suggest the following:
CREATE TABLE RESERVAS (LOCALIZA C(12), EMISSAO D, DOLAR N(8,5), CODAGENTE N(6), NOMAGENTE C(40))
INDEX ON LOCALIZA TAG LOCALIZA
INDEX ON BINTOC(CODAGENTE) TAG CODAGENTE
If you index CODAGENTE (a numeric value) you will not get a numerical order if converted to...
Look at the method WriteSheetXMLs, starting at line 163. This starts a loop to write all the cell values by row and column order. I found the problem at lines 220 AND 270. Here I do an ALLTRIM() again. This would eliminate the leading/trailing spaces from the value being written into the...
Hello--
I wrote the class. If you are writing the value as a character, then the method is doing an ALLTRIM() on the value before saving. First you should download the current release which is R44. Then open the class and edit the method SetCellValue(). Go to line number 40 which is...
Mandy--
More on the use of RLOCK... Chriss's points are valid about having to check for locking by other users. I only use the RLOCK command to lock something for an extended period of time and not for a field update only (automatic locking takes care of this for me with the increased setting...
You might (most likely) not need to use the FLOCK command; but rather, the RLOCK command. As others have said, the FLOCK command locks the entire table and no one else can then access it and this would cause problems when they try to open a form when the table to be used is LOCKED. I think you...
If I understand correctly, you are asking for a given column in a grid control, what field is this being populated from? Is this correct? If so, you should be able to get the answer from the property:
?thisform.grdGrid.Column1.ControlSource
?thisform.text1.ControlSource
Another option would...
I also wrote a program for browsing tables. My implementation is meant to be run as a stand alone app from within the VFP Design-Time environment. However, it should be able to be executed from a VFP .exe program without any problems. Here is the link to the program's compiled app and source...
Since the report Data Environment is not defined, it will use the currently selected cursor/table (in your case it is curClientes). As long as the table and field names are defined in the report, it will work.
Greg
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.