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

    Query too Slow

    ...the first grid will show custmomers with transactions date = date() and amount > 2000 thisform.grid1.RecordSource = '' nSecsSta = SECONDS() * 1st Query SELECT rem_first, rem_last; FROM INVOICE; WHERE date = DATE(); ORDER BY rem_last, rem_first; GROUP BY rem_last, rem_first; INTO CURSOR...
  2. guillermo88

    Query too Slow

    Yes, all the tables are sitting on a network, and the exe is in every local computer
  3. guillermo88

    Query too Slow

    This is my dummy query in the init event of the form. I added a msgbox to check how long it takes the query. And the msgbox comes very fast the I click the msgbox button and that's where it takes time. In this case now it takes time to load the form. SELECT COL_AGT, INV_NO, DATE, REM_TEL1...
  4. guillermo88

    Query too Slow

    The problem seems to loading the the grid with the cursor. I just tried the same select statement from the command line an it works very fast.
  5. guillermo88

    Query too Slow

    I going to create another method with dummy select statement in it so it will run only once. Thanks. Something else Is it any difference in using RecordSourceType=Alias and SQL Statement? I have another with very similar criteria and it works fine
  6. guillermo88

    Query too Slow

    I added a table in my DE (Invoices)
  7. guillermo88

    Query too Slow

    Hey Mike, But do you need to then resize the grid columns on top of that? The reason why I resize it's because when I re-query the columns change the width. This line of code in the DE is in the init event Thisform.grid2.recordsource = “” If I don't, grid will try to load the table...
  8. guillermo88

    Query too Slow

    QUERY TAKES TOO LONG I have a form with a grid I have an invoice table. I want to display records that match certain criteria: First_name, last_name I also have indices for each field first_name and last_name. The problem that I am having is it takes too long that query and sometimes I have a...
  9. guillermo88

    GRID IS VERY SLOW THE 1ST TIME

    I have and index already. It is on Agent + invoice
  10. guillermo88

    GRID IS VERY SLOW THE 1ST TIME

    I thought I fixed the problem but I didn't. The new shortcut that I create was reading the data from the local directory and not from the directory in the network. I create I new directory Test in my C drive and Test\data for my tables in the drive F: and the same behavior when loading the form...
  11. guillermo88

    GRID IS VERY SLOW THE 1ST TIME

    I don't why but seems having the executable on the network slow down loading the grid only the first time. I created another shorcut but this time the executable was in local drive and the data was and the network and it seem that fixed the problem
  12. guillermo88

    GRID IS VERY SLOW THE 1ST TIME

    I forget to mention that this aplication is running on the network (Executable and data)
  13. guillermo88

    GRID IS VERY SLOW THE 1ST TIME

    ...In the init event I set the Search criteria to Agent = ‘-9999’ cFilter = “Agent = ‘-9999’ ” cOrderBy = “Agent” mySQL = “SQL statement is SELECT * FROM invoices WHERE “ + cFilter + “ ORDER BY “ + cOrderBy Grid1 recordsourcetype = 4 Grid1 recordsource = mySQL In Init Event of the DE...
  14. guillermo88

    Does anyone have any experience wit

    Dave, I am just trying to use modem for now. Thanks.
  15. guillermo88

    Does anyone have any experience wit

    Dave, I am just trying to use a regular modem right for now Thanks.
  16. guillermo88

    Help with Grid class and tables

    Ian, that was it! It's working. I forgot to remove "1". I did this expectng an error but nothing happen before. Now I can resuse this grid class to browse Cursor. And I guess I have to invoke the method setColor only once. I dont konw Why it dosnt work using this.tableName instead of...
  17. guillermo88

    Does anyone have any experience wit

    Hey Dave, Thanks for your quick reply. I am trying to create the simplest wayt to send a file to another computer. One computer will be the client will be the host. I just purchased Commtools. I don't really how to start. I was thinking to create a form with button (send file). If you can give...
  18. guillermo88

    Help with Grid class and tables

    Ian, that was it! It's working. I forgot to remove "1". I did this expectng an error but nothing happen before. Now I can resuse this grid class to browse Cursor. And I guess I have to invoke the method setColor only once. Thanks Again
  19. guillermo88

    Does anyone have any experience wit

    Does anyone have any experience with CommTools / Sax Comm Objects? Any input will be apreciated. Thanks
  20. guillermo88

    Help with Grid class and tables

    Ian, I createed a method called setColor and a property tableName in the parent class. Within my form set mygrid.TableName = "C_INVOICE" Then set myGrid.RecordSource = SQLvariable Then call myGridRecordSource.SetColor wich is the follow: SELECT (this.tablename)...

Part and Inventory Search

Back
Top