Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations Rhinorhino on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  1. SitesMasstec

    Cursor in Data Environment

    Hello colleagues! A have a Form which has in its Data Environment the table TEMPREC2.DBF (it is a temporary table with selected records from another table). Is it possible to have a Cursor in the Data Environment of the Form, instead of that table? Cursor has a random name, so I could not...
  2. SitesMasstec

    Strange error

    Dear colleagues: Sometimes I got an error when running VFP programs, in the development environment. When this happens I write these lines in the command window: CANCEL CLOSE DATABESES CLEAR ALL SET VIEW TO VFPlimpo && The first time I opened VFP, I write the command CREATE VIEW VFPlimpo...
  3. SitesMasstec

    Combobox not populated with array

    Hello colleagues! I am trying to put in a Combobox the data from an array. These are the data from the array I am using (just to be sure that the array has these data; the similar code is in the procedure Init in the Form): This is the Form: As you can see, the data from the array are not...
  4. SitesMasstec

    Window displaying differently outside VFP environment

    Hello colleagues! I defined a window to appear in some circunstances during a program execution: DEFINE WINDOW JanelaAviso IN SCREEN; FROM 10,10 TO 26,110; FONT 'Courier New',11; STYLE 'B'; COLOR RGB(51,51,51, &AmareloClaro), RGB(0,0,0, 255,255,255) When I run a program in...
  5. SitesMasstec

    Change words (language) in button set

    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...
  6. SitesMasstec

    Progress of report being processed

    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...
  7. SitesMasstec

    Report layout differs when running

    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...
  8. SitesMasstec

    Sorting an array

    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...
  9. SitesMasstec

    Report not showing selected records

    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...
  10. SitesMasstec

    Copy fields from one table to another

    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...
  11. SitesMasstec

    Sum of values in a Report Detail band

    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...
  12. SitesMasstec

    Report with no Data Environment

    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...
  13. SitesMasstec

    Cleaning fields with zeroes

    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"...
  14. SitesMasstec

    Set a TAG for a field programmaticaly

    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...
  15. SitesMasstec

    A way to make all ReadOnly

    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...
  16. SitesMasstec

    Combobox populated with data from a table

    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...
  17. SitesMasstec

    SetFocus not working

    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...
  18. SitesMasstec

    Update data in a Cursor

    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...
  19. SitesMasstec

    Selecting record from a Grid for use in another form

    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...
  20. SitesMasstec

    How to order a column of data in a Grid

    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...

Part and Inventory Search

Back
Top