Recent content by MikeL91

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

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

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.

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

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

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

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.

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

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

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

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

It is set to my documents in there.... but still trys to save to 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...

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

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