Search results for query: *

Hello dear colleagues! I created a small form for data entry, using Wizard. I came with the buttons I need, to add, delete and edit records, as you can see in the image bellow. It runs fine, but I would like to change the terms, as my native language is Portuguese Brazilian. For example...

Hello colleagues! I created a Report which uses data from a cursor, that has about two hundred of records, selected from thousands of records from a table. Well, the generated Report (about 25 pages) is fine. It is acceptable that it takes about 10-20 seconds to show the report on screen...

Hello colleagues! I have been wasting more time to fine ajust the position of objects when design a report than creating the report itself. Is it a fault in VFP 9? I have tried even (instead of moving labels through the report using arrows) to set the position "From left" (for example 5,614...

Hello colleagues! I have been trying to sort an array in alphabetical order, but errors appear: PUBLIC ARRAY Cabine(30) FOR I=1 TO 30 IF XTIPOCAB(I)<>SPACE(3) Cabine(I)=XTIPOCAB(I) + " - " + XCATEGCAB(I) + " ("+ ALLTRIM(XNOMECAB(I)) + ") " ENDIF NEXT I ASORT(Cabine) && Sort...

Hello colleagues! I am trying to display in a report only records which have in the PSTAT field the content "PENDENTE". This field lenght is set to 10 characters. The variable QualStatus is defined during run time, and the user typed "Pendente" to be stored in it. The code is: SELECT * FROM...

Hello colleagues! I have 2 tables: Table A has 30 fields and Table B has 34 fields. The 30 first fields in table B are the same (names) in table A. So, Table B has 4 additional fields. How can I select and copy some filtered records from Table A to Table B, without excluding the last 4 fields...

Dear colleagues: I have a report which displays values from some records (parent + child): Now I need to calculate some total values, as shown in the above red squares. In a Form, I displayed these total values after calculating them in the Form, Init procedure, but in a Report... I do not...

Hello colleagues! Is it possible to create a report with no Data Environment? That is, I am running a form, and this form has lots of variables read from 2 files. Each field in a file, for example, the field NOMAGENT is stored in the memory variable YNOMAGENT, and then displayed in the form...

Hello colleagues! I have this in a form: I have used a way to blank the field in the third column (when there are zeroes): FOR NF=1 TO 12 strNF=STR(NF,2) IF SUBSTR(strNF,1,1)=" " strNF="0"+SUBSTR(strNF,2,1) ENDIF * Some commands here frase="thisform.txtNFAVRPg"...

Hello colleagues! I have a free table named ETIQUETA.DBF: Now I want to create a TAG (ascending) for the field CCIDA, but programmaticaly. I tried many commands like ALTER TABLE ETIQUETA ... TAG CCIDA, but I failed. Is it possible? In fact, I want this for another table, derived from...

Hello colleagues! I have a form with dozens of objects (ComboBox, TextBox, etc) for data entry. And I can alter previously recorded data in this form. Is there a way to make all these objects Read Only, without having to declare each object in the form .ReadOnly=.T. ? (there is no...

Hello colleagues! In my form (bellow) I give the user the option to select a name from a table (names are showed in alphabetical order). The user can filter the result of the report by a chosen name, or he/she can leave it blank. I achieved this by appending a blank record to the table. For...

Hello, colleagues! I created a form, which has a field for date, which must not be blank: the user must type a date. If the field for the date LostFocus and is blank the field becomes red and the cursor have to stay in the field (please see bellow). But when I run it, if I leave the field...

Hello colleagues! I have this form, with data in a Grid, with this command: SELECT LOCALIZA, EMISSAO, CODAGENTE, NOMAGENTE, NOMECIA, NOMENAV, DATASAIDA, DOCUMENTO FROM RESERVAS; WHERE (EMISSAO>=XQualPDEmissao AND EMISSAO<=XQualUDEmissao) INTO CURSOR curReservas So, the data in the Grid...

Hello collegues! I have a Form with a Grid populated with just some data from file RESERVAS.DBF: When I locate the record I need, I want the form above to desappear and open another Form which has all data from that selected record: The field "Localizador" is a unique key for each record in...

Hello colleagues! I created a Grid on a form with data from a table. It has 7 columns. Sometimes I will need to order ascending numerical or alphabetical columns. When I click on the Header of the 4th column (Agente), nothing happens, in spite of the fact thar I have the following code in the...

Hello colleagues! I have a form with this code in the Init procedure: WITH thisform ... .dtSaida.Value=YDATASAIDA ... Where YDATASAIDA stores a Date (I have confirmed that YDATASAIDA, is a D (Date) VARTYPE, so I am sure its type is Date). This is the portion on...

Hello colleagues! In a ComboBox inside a Form I have 2 fields being shown fom a table named CIAS: SIGLACIA and NOMECIA, with a " - " (space separator space) between these two fields. Well, I selected one option in the Combobox and it was recorded in another table (RESERVAS.DBF). This is ok...

Hello colleagues! I know how to create a free table programatically: CREATE TABLE RESERVAS (LOCALIZA C(12)) && Cod.Localizador USE ALTER TABLE RESERVAS ADD COLUMN EMISSAO D && Data de Emissão da Reserva ALTER TABLE RESERVAS ADD COLUMN DOLAR N(8,5) && Cotação do Dolar ALTER...

Hello colleagues! In a table I have a field named EMAANEX1 C 50 (Character, NOT a General field) Inside that field it has this content (just the name of a picture): JOHNDOE.JPG The John Doe picture (JOHNDOE.JPG) is saved in the sub-folder named \ANEXOS in the current application folder. So...