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

    SELECT SQL and free tables

    Hello colleagues! I changed my code and almost got the result I expected: SELECT 0 USE RESERVAS ORDER TAG LOCALIZA SELECT 0 USE PASSAGEIROS ORDER TAG CHAVEPAX SELECT RESERVAS.LOCALIZA, RESERVAS.EMISSAO, RESERVAS.CODAGENTE, RESERVAS.NOMAGENTE, RESERVAS.NOMECIA, RESERVAS.NOMENAV, ...
  2. SitesMasstec

    SELECT SQL and free tables

    Igor: After the change you suggested, I got another error:
  3. SitesMasstec

    SELECT SQL and free tables

    So why is this not working? SELECT 0 USE RESERVAS ORDER TAG LOCALIZA SELECT 0 USE PASSAGEIROS ORDER TAG LOCALIZA SELECT LOCALIZA, EMISSAO, CODAGENTE, NOMAGENTE, NOMECIA, NOMENAV, NUMCAB, TIPCATCAB, DATASAIDA, VENDEDOR, VOUCHER FROM RESERVAS ; RIGHT JOIN PASSAGEIROS ; ON RESERVAS.LOCALIZA...
  4. SitesMasstec

    SELECT SQL and free tables

    Hello Joe! Well, I have written SELECT SQL commands to select data from a single table, for many years. Now I will have to SELECT data based on 2 tables. My question is: SELECT SQL commands work for free tables or only with tables inside a Database? Thank you.
  5. SitesMasstec

    SELECT SQL and free tables

    Hello colleagues! I am trying to SELECT data from two free tables, but I am not achieving to do this. I question has arisen: Is it possible to use the code bellow (taken from What's New in Nine...) with free tables only? Or must I stick the tables in a Database? SELECT CustLast.Customer_ID...
  6. SitesMasstec

    Cursor in Data Environment

    ....txtRcust.Value=YRCUST .txtRrend.Value=YRREND .txtRunid.Value=YRUNID .txtRpper.Value=YRPPER .txtRpesu.Value=YRPESU * etc etc ENDWITH FOR X=1 TO 20 strX=STR(X,2) IF SUBSTR(strX,1,1)=" " strX="0"+SUBSTR(strX,2,1) ENDIF...
  7. 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...
  8. SitesMasstec

    Combobox not populated with array

    Mark: Very good example using Grid to display data, and the resulted report. I appreciated it. Thank you. Those 12 x 4 textboxes are for data entry. But besides these 48 textboxes I have other dozens textboxes (different from each other) inside the same form, so I have to use the design mode...
  9. SitesMasstec

    Combobox not populated with array

    ..." strY="0"+SUBSTR(strY,2,1) ENDIF YdtNFADTPg="dtNFADTPg"+strY ADD OBJECT YdtNFADTPg as TextBox WITH Top = (30*Y), Left = 258, Width = 90, Height = 24, Anchor = 3, ToolTipText = "Payment Date" NEXT Y If there is a way, I don't know... I mean, to create the form using...
  10. SitesMasstec

    Combobox not populated with array

    ...I thought it would be very useful to automate text boxes creation, when they have same dimensions, for example: FOR Y = 1 TO 9 YtxtName="txtName"+STR(Y,1) ADD OBJECT YtxtName as TextBox WITH Top = (30*Y), Left = 258, Width = 90, Height = 24, Anchor = 3, ToolTipText = "Name" NEXT Y Thank you.
  11. SitesMasstec

    Strange error

    Chriss: So, when that error appears, the best thing to do is to quit VFP using Windows Task Manager. I think other option is, after CLEAR ALL, to close the Project and open it again, so VFP will setup VFP2C32.FLL again... I can try this when the error occurs again. Thank you.
  12. SitesMasstec

    Strange error

    Hello! Chriss: as I had issued CLEAR ALL before the error appeared, according to what you have said above, it may have caused VFP to miss VFP2C32.FLL (ctl32_vfp2c32.prg is in my project and has reference to VFP2C32.FLL)! So, from now on, I will not use CLEAR ALL anymore. Thank you.
  13. 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...
  14. SitesMasstec

    Combobox not populated with array

    Dear colleagues: I do not put any code in the AddItem or AddListItem. Instead, I just put this code in the LostFocus procedure in the Combobox (the second column of the row should not be displayed; indeed I need its value, which is the record number - variable NumeRegi - in the original table...
  15. SitesMasstec

    Combobox not populated with array

    Mark: Great! Simple and direct. Except that the Combobox doesn't show the second data (Record Number, from the original RESERVAS.DBF table) from each row in the array (please see my first post, running a PRG file: it shows the Record Number from a table): SELECT NOMAGENTE+" (" +...
  16. SitesMasstec

    Combobox not populated with array

    Hello, Joe! It doesn't work, either. Please see the code in the Init procedure in the Form: DECLARE NOMES(1,1) NOMES(1,1)="-" thisform.txtNOME.Value=YNOMECLI NOMECLI=YNOMECLI IF NOMECLI<>SPACE(34) NOMECLI=UPPER(ALLTRIM(NOMECLI)) SELECT NOMAGENTE+" ("...
  17. SitesMasstec

    Combobox not populated with array

    Hello, Greg! I uderstand your method works . But as I have an array in memory, why not just my code in the AddItem in the Combobox doesn't work?
  18. 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...
  19. SitesMasstec

    Window displaying differently outside VFP environment

    Dylim: My Window Display Settings is 1366 x 768 , Scale 100%. But other users may have this setting at 1280 x 720, or 1024 x 768...
  20. SitesMasstec

    Window displaying differently outside VFP environment

    Arrayname and Joe: Yes, I will follow your advice. Really, form is more convenient, as we cannot preview the resolution/size of the user's screen. Thank you.

Part and Inventory Search

Back
Top