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 Chriss Miller 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. MikeL91

    Help with my first grid.

    I think I understand what you mean. You are talking about creating the form & grid from scratch in the code & populating it all at run time correct? I have 2 questions, Do you have any examples of that? I saw one on MSDN that I think was close to that, but can not seem to find it now. Also...
  2. MikeL91

    Help with my first grid.

    Is there a sample, FAQ, or something that shows a simple form where the user choses a path & dbf file, and then it populates a data grid on the form for him. I can easily use the wizzard to create a grid & bind it to an existing table, but I want it to be dynamic for whatever dbf file is...
  3. MikeL91

    Help With SQL Command

    Jim is correct, I was using excel, so the file grew by 25 AZ records in row 1, and that is a 9.09% total increase 25/275 and then format for %. The SQL command you gave me gives me the 275-250 25 so I am going to use excel & automate it to do the % calc. thanks again.
  4. MikeL91

    Help With SQL Command

    Thanks Borislav, this is what worked from that: SELECT FileA.State AS State,FileA.Qty AS Qty,; FileB.State AS StateB, FileB.Qty AS QtyB,; NVL(FileB.Qty,00000.000)-NVL(FileA.Qty,00000.000) AS Diff ; FROM FileB ; FULL JOIN FileA ON FileB.State = FileA.State ; INTO CURSOR crsTest I am...
  5. MikeL91

    Help With SQL Command

    I have 2 files that are the result of a cursor from a select cnt of a state field. One is ran the 1st of the month, and the second is ran the 30th of the month. I want to generate a file from the 2 files and add 2 fields Difference, and Percent. FileA.dbf (1st of the month) State Qty AZ...
  6. MikeL91

    Need Ideas on a report

    I need to create a report that shows a tables growth, that I can run once a month. I was thinking of running some counts on a few standard fields like state, city or zip, maybe phones etc. and show a previous qty, a new qty and a percentage. Does anyone have any helpful tips on the best way...
  7. MikeL91

    Do Loop problem

    wow, those suggestions will not only help me here, but moving forward, thank you. nUpdates is just a variable I initiate to 1 in the begining. just a counter. qty is the same for all like values in the field Idcode, it is a count of how many I need to select from the big file.
  8. MikeL91

    Do Loop problem

    I am trying to replace a field called SEL with a flag ('Y') for up to the value in a matched field (IDcode). Everything seems to be working ok, but when the idcode changes I can not figure out where to clear my counter. Mental block here please help. here is the code: select Input go top...
  9. MikeL91

    Select Matching records in 2 tables - loose

    Thanks for the help. I have another quick question, on this command: SELECT * FROM TableA ; WHERE Name IN ; (SELECT Name FROM Table B) This will show all records in TableA with a name that is = name in TableB. Is there a way in this command to include the names from TableB that matched...
  10. MikeL91

    Select Matching records in 2 tables - loose

    I need to select all records in tableA where the name matches the name in tableB, but I want the match to be as loose as it can be so I can still match after MAJOR spelling errors. Can I adjust the matching degree? and is there a way to veiw both fields in the querry window? thanks in...
  11. MikeL91

    XLstart

    no, its a default folder in different locations depending on the version of windows. c:\program files\microsoft office\office111\xlstart\ (or like that) or c:\documents & settings\username\application data\microsfot\xlstart\ like that
  12. MikeL91

    XLstart

    It is set to my documents in there.... but still trys to save to XLSTART.
  13. MikeL91

    XLstart

    I have created a template called X.XLT & X.XLS and placed them in XLSTART. It works great, the new spreadsheet has all my formating that I want standard. My only problem is when I chose save as, it trys to save all new documents to XLSTART, unless I change the path back to my documents. How...
  14. MikeL91

    SQL Select & Count

    I'm on VFP8.0. I will try dumping the city. Thanks everyone for your insight. -Mike
  15. MikeL91

    SQL Select & Count

    More information. I apologize for not wording it better. The problem is in fact that the ZIPS are showing duplicates. I need the output to look like that, with COUNTY,CITY,ZIP,QTY however, I want the output to be unique on ZIP. That code I showed produces this: COUNTY CITY...
  16. MikeL91

    SQL Select & Count

    I use this code to run a frequency: select county,city,zip, cnt(*) as qty from testfile ; group by county,city,zip into cursor mike My problem is I get duplicate city names in my select file. like this: COUNTY CITY ZIP QTY ORANGE ANAHEIM...
  17. MikeL91

    Help - 2GB Limit Hit

    Maybe try opening the DBF file in a text editor like Ultra Edit and removing a block of data at the front of the file to reduce its size enough to extract your data at the end. I have opened files that size & larger in Ultra Edit, it just takes a few minutes. Good Luck. -Mike
  18. MikeL91

    Help with Sum

    Thank You Stella
  19. MikeL91

    Help with Sum

    This is what I have: select piecedesc,pieceid,county,litcode,litcode2,litcode3,phonecnt,nophonecnt,totalcnt, cnt(*) as qty from AgeinOutput ; group by piecedesc,pieceid,county,litcode,litcode2,litcode3,phonecnt,nophonecnt,totalcnt into cursor mike What I need is a report with all those...
  20. MikeL91

    Help with SQL statement

    Thanks for your help anyway, I guess I'll keep playing with it. The Select * command works though, thasts whats wierd, so I don't suspect the data, but I am new to .net. It should be in a stored proc. but im using access DB, so I thought this would be a way around that.

Part and Inventory Search

Back
Top