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!

  • Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Recent content by Luiz Eduh

  1. Luiz Eduh

    Help filtering data from a table using the select statement (sql)

    Hello, I need some help from the experts. I have an inventory vfp9 table that has over 6000 items. I want to use the select statement to filter out all those items that has data stored on a field called sku. There are some items that don't have anything stored on that "sku" field, so I dont...
  2. Luiz Eduh

    Need help understanding a piece of code

    Thank you!!! One more question, how can I modify this part of the code to accept the following input on the item field; Lets say I want to input this on that item field; MBT1006 or vise versa 1006MBT or 12345 or simply a 2 letter input TE (any combination of 2 letters)
  3. Luiz Eduh

    Need help understanding a piece of code

    Hello, I came across this piece of code in a program but I cant seem to fully understand its purpose or what it does. Can someone if possible explain me what would be the purpose of this? Here's the code; if m->item # ' ' .and. ...
  4. Luiz Eduh

    help making a query to update a field using 3 tables

    Hello, I need help from the experts making a query Here's my scenario; I have a table where I want to update the prices column from another table but only for a specific date range from a 3rd table, something like this; update table1.price from table2.cost where table1.transnum =...
  5. Luiz Eduh

    VFP9 Report only displays uppercase text on a field when previewing.

    Thanks I actually found the data in the report, but im kinda confuse. Before running the report im sorting the data before and putting it in the table with order by category asc, but when I see the data on the report all the products with caterogy "A" and "W" show first and then on then on the...
  6. Luiz Eduh

    VFP9 Report only displays uppercase text on a field when previewing.

    Hello, I have designed a report in VFP9 where I grab the data from a table. The table stores a list of product and have a Character field named category which categorizes the product. Im using uppercase 'A', lowercase 'a', uppercase 'W' and lowercase 'w' on that category field. Anyways on my...
  7. Luiz Eduh

    Need help from the experts building up an expression in a VFP9 report

    Olaf and TamarGranor, Yes, is in a report, I have everything working as requested thanks to your instructions. Now i'm having a little problem getting to print a field where i'm multiplying qtyship*price but only print when discount is either 'N' or empty. What expression can I use? Thank you
  8. Luiz Eduh

    Need help from the experts building up an expression in a VFP9 report

    Thank you Olaf, Im able to get the right number when I do the following round2((1-disc-num/100)*(.price)) but if I add IIF(discount='Y',round2((1-disc-num/100)*(.price))) VFP tells me theres a comma missing, what am i doing wrong? Thank you
  9. Luiz Eduh

    Need help from the experts building up an expression in a VFP9 report

    I currently have the following fields in a report; qtyship = 6 price = 1.15 disc_num = 5 (this is stored as a number but would be treated as a percentage when calculating) discount = y (this can be either "Y" or "N" I want to be able to subtract PRICE - DISC_NUM only when Discount = "Y" and...
  10. Luiz Eduh

    How can I remove all records from a dbf VFP9 and just keep what was entered today 8/7/17

    Thank you all for the help, I really appreciate it. By the way, I will change my username to display my real name. Thank you
  11. Luiz Eduh

    How can I remove all records from a dbf VFP9 and just keep what was entered today 8/7/17

    Hello, I know this is simple, but would like to double check with the experts. I need to remove records from a dbf and only keep what those that were entered on a specific date. Thank you
  12. Luiz Eduh

    Converting a string to a numeric value when exporting from a dbf to excel

    Hi all, I need of your help. I'm currently using this code to export data to excel from 2 dbf and it works fine, except 2 fields export data as text and i would like to convert them into numeric, the fields are Price and totalprice; select line, order.itemno, percentage, invoice, cusno...
  13. Luiz Eduh

    Help transfering data from one table to another where records are identical.

    Mr. Olaf, Nothing updates, the message on the bottom of VFP9 saids, Updated 0 records in 0 seconds. On both tables I have zipcodes, but on Counties(table) I have listed all the counties with their zipcode. Im searching the customers table, where there's a zipcode that matches on both tables...
  14. Luiz Eduh

    Help transfering data from one table to another where records are identical.

    Hello, im back. Im not sure what im doing wrong, I have use the update command on other tables and works fine, but for some reason i'm trying to grab data from table2 into table1 and nothing transfers; here's what I have; table2 named counties, it stores counties.zip, counties.city and...

Part and Inventory Search

Back
Top