Search results for query: *

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

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)

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

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

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

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

Now, I understad. Thank you

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

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

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

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

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

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

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

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

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

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

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

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.

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