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

    Now, I understad. Thank you
  8. 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
  9. 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
  10. Luiz Eduh

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

    ...Discount = "Y" and then multiply by qtyship On the fields above it would be 1.15 - 5% = 1.0925 but would need to be round off to 1.09 therefore 6 * 1.09 = 6.54 But like I mentioned, it would only calculate the percentage where Discount = "Y". I can't figure this out any help would be much...
  11. 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
  12. 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
  13. Luiz Eduh

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

    ...select line, order.itemno, percentage, invoice, cusno, table1.descrip as Description,; table1.sccal as Scientific_cal, str(int(Percentage/100*table1->pack),4) as pack,; val(price(table1.fob)) as price,; str(round2(int(Percent/100*table1->pack)*val(price( table1->Fob ))),7,2) as totalprice...
  14. 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...
  15. 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...
  16. Luiz Eduh

    Automate Excel with Visual foxpro 9 (help)

    Hi all, I'm in the process of learning how to export information to excel but came across an issue that I can seem to resolve. I have a table ("Testtable") with 4 records (4 rows and 5 columns) see image below In VFP9 im running this code; local oExcel, oSheet oExcel =...
  17. Luiz Eduh

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

    Great, Thanks, danfreeman and OlafDoschke. Your input helped accomplish what I want it.
  18. Luiz Eduh

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

    Hello, I need some help from the experts. I have 2 tables that have the same data on the first column (Name:ProdNum type:character width:8) The 1st table doesn't have a description for each prodnum, the second table does. How can I transfer the description from table 2 to table 1 where the...
  19. Luiz Eduh

    Help generating a pdf using VFP9 and Bullzip Pdf Printer

    Hello, I need some help. I currently have a vfp program that generates .prn files and puts them on a local directory on my c:\ drive. I was wondering if there's a way with code to automatically grab that prn file and convert it to a pdf file using bullzip pdf printer.
  20. Luiz Eduh

    How to deactivate a popup menu after a selection has been made?

    Great!! Thank you all for your help, I was able to accomplish what I wanted with your help.

Part and Inventory Search

Back
Top