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

    Update Records From Another Table

    sorry for the delay. i still haven't found anything from the prg files yet. i think the programmer used clipper 5.2. i saw a folder named "clip52" and a file inside named "clipper.52".
  2. wrgt9740

    Update Records From Another Table

    Thank you for the offer, but I wouldn't want to bother much of your time. I'll just keep scanning the PRG files.
  3. wrgt9740

    Update Records From Another Table

    The two descriptions are the same. This database design is not ideal, but it's what the programmer created. If in ITEMS.DBF, PEN and BLUE as CODE and DESCRIPTION would be one record, then TRANSACT.DBF would also have PEN and BLUE as CODE and DESCRIPTION, plus other details like invoice number...
  4. wrgt9740

    Update Records From Another Table

    I've been reviewing the clipper code of our programmer who has already left, and I could not see how he was able to update records of a different table. The two tables involved are ITEMS.DBF and TRANSACT.DBF. ITEMS.DBF has fields CODE and DESCRIPTION, while TRANSACT.DBF has fields INVOICE, CODE...
  5. wrgt9740

    How To Insert Into Table Values From Textboxes And Cursor?

    Hi Chriss, thanks for your great reply. This will serve as my guide in making the ideal database design. I'll take a look into your solution. I'll just need some time to think on how to apply it on my form.
  6. wrgt9740

    How To Insert Into Table Values From Textboxes And Cursor?

    Hi. I'm making a customer purchase form with textboxes, a cursor, and a table. The textboxes are txtInvoice and txtName. The cursor is csrPurchases with fields "ITEM" and "PRICE". The table tblTransactions has fields "INVOICE", "NAME", "ITEM", and "PRICE". Is it possible to get values from...
  7. wrgt9740

    I Don't Understand <>

    Hi Chris. It's been a while. After a lot of reading and researching on the internet and playing around with Foxpro, I'm going to let the users manually add the missing salesman codes, if there are any. I could not apply _TALLY and WHERE EXISTS as suggested, but I used the opposite of SELECT...
  8. wrgt9740

    I Don't Understand <>

    Hi Chriss, I haven't played around with my project yet as I've been swamped with work since returning to the office after the holidays. I have no idea what "code reference" is in foxpro. I also didn't know it exists in foxpro. I'll read more about this when I have free time. It never fails that...
  9. wrgt9740

    I Don't Understand <>

    Chris, thanks for your replies. I agree with what you posted. You understand how beginners in Foxpro think, and your explanation clarifies where I went wrong and why. I appreciate you taking the time. I will change my approach with this problem by taking into consideration the suggestions posted...
  10. wrgt9740

    I Don't Understand <>

    Chris, I'm sorry if the code I posted was confusing. I attempted to simplify the code, as the original is quite long. Basically, the user would enter into the database the items sold and their corresponding amount, and that amount would also go to the salesman table and we would compute how much...
  11. wrgt9740

    I Don't Understand <>

    Atlopes, I tried with GO TOP and without GO TOP, and the results were the same, so I guess going to top of table is irrelevant. Your suggestion may work with my personal project. I was so obsessed with solving this problem using <>, that I did not think that the solution might be using = or ==...
  12. wrgt9740

    I Don't Understand &lt;&gt;

    Hi. I have a simple code: create cursor csr1 (name C(5)) insert into csr1 (name) values ("A") insert into csr1 (name) values ("B") insert into csr1 (name) values ("C") insert into csr1 (name) values ("D") insert into csr1 (name) values ("E") create cursor csr2 (name C(5), exist N(1)) insert...
  13. wrgt9740

    How To Remove Repeating Blank Rows Due To Blank Records

    Yes, sorry for this.
  14. wrgt9740

    How To Remove Repeating Blank Rows Due To Blank Records

    Yes, the "query" I mentioned is a browse grid. I typed in the command window SELECT * FROM TRANS ORDER BY ITEMCODE and a query appeared in the data session window. The results of ? ISNULL(itemcode) are .F. on the blank itemcode. Out of curiosity, I also tried ? ISBLANK(itemcode) and they came up...
  15. wrgt9740

    How To Remove Repeating Blank Rows Due To Blank Records

    Chris, I opened the items.dbf and trans.dbf into query (it looked like a grid). I clicked on some of the blank itemcode, and the cursor would appear at the beginning of the cells. So I guess they're really blank. Mike, I followed your suggestion and deleted the records where ISBLANK(itemcode)...
  16. wrgt9740

    How To Remove Repeating Blank Rows Due To Blank Records

    In the Clipper report, there two groups of blank itemcode and only one record per group are shown. In the Foxpro report with your code, the first group showed only one record, which is fine, but the second group disappeared. At the end of the report, reccount() displayed 100 records, but the...
  17. wrgt9740

    How To Remove Repeating Blank Rows Due To Blank Records

    Almost. The Clipper report only showed one blank row per group of 35 blank rows, and I was hoping to produce similar results.
  18. wrgt9740

    How To Remove Repeating Blank Rows Due To Blank Records

    Mike, I followed your advise, and I cannot understand the result. Before, the report produced two groups of 35-rows of blank itemcode. After your code, the report showed the first group with one blank itemcode, while the second group disappeared. What I don't understand is the reccount() on the...
  19. wrgt9740

    How To Remove Repeating Blank Rows Due To Blank Records

    Mike, yes you are correct. I'll try your suggestion on my next free time. Edit: I've given some thought about this without trying on Foxpro yet. Should the code be: CREATE CURSOR... INSERT INTO CURSOR ; SELECT [fields] ; FROM TRANS ; INNER JOIN ITEMS ; ON TRANS.ITEMCODE = ITEMS.ITEMCODE...
  20. wrgt9740

    How To Remove Repeating Blank Rows Due To Blank Records

    Yes, there are also blank itemcode records in the trans.dbf. I don't know if the records without itemcode in both tables are relevant, and I'm afraid to delete them as it might cause an immediate or future undesirable consequence in the Clipper program. Asking the original programmer is not...

Part and Inventory Search

Back
Top