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

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

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

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

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

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

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

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.

I need some help from the experts. I currently using this popup menu; DEFINE POPUP OUTPUT from 5,27 SHADOW ; FONT 'LUCIDA SANS TYPEWRITER',12 STYLE 'B' TITLE 'Select an Option' DEFINE BAR 1 OF OUTPUT PROMPT 'Send to Printer' DEFINE BAR 2 OF OUTPUT PROMPT 'Convert to PDF' ON selection BAR 1 OF...

Hello, I'm currently running a report and displaying data from 1 table. The table contains a field that is either transactions = 't' and credits = 'c' I would like to print and separate the sections on the same report. On the top I would like to displays the data where the expression equals...

Hello all, Everyday I'm learning and getting better at SQL, with the help of some folks here at the forum I have made good improvements. I just need some help, the code below works but takes a bit to get the data from 2 tables that are sitting on a server in a network. Can you please glance at...

Hello, Here's what I would like to accomplish but i'm not sure if is even possible. Here's a the data; Table1 item ordqty shipqty price 1234 25 23 5.99 SELECT table1.item, SUM(table1.ordqty - table1.shipqty)as total_result...... I would like to multiply the result of the...

Hello, I'm currently learning SQL and I need some help with the request below; I currently have a Table called CUSTABLE1 with the following FIELDS: cus_name, cus_id, pur_date, sales_type, sales_total, I need help making a query to export the fields above listing only when pur_date is...

Hi all, I need of your help. I have a few dbfs that are used in a foxbase program. I needed to see some data and opened one of them using Visual Fox Pro 9. Right after double clicking the dbf I received a windows titled "Code Page" telling me that the file "....." is not marked with a code...

Hi, I have the following sql query. I would like to be able to create a form by which a user can select their date range maybe inputting the date in a textbox for startdate and another for enddate. Also give the option to select from b.category an option of 4 categories stored in the table...

Hi I need some help form the experts with this error, I can't seem to find the problem, I've attached the file here https://www.dropbox.com/s/063p14mggpl45ih/ProgramTest.prg also here as a text file https://www.dropbox.com/s/pez8z853v165qax/ProgramTest.txt also attached is an image of where the...

Hi im using a code found at www.foxite.com which generates barcodes using a font called "upca" I just have 1 problem with the last digit. For example im passing the following digits 555555125215 which is a upc number of 12 digits that i have stored on a dbf in VFP9 (please see the link to the...

Hi, im trying to print to a label and i can make it to print a line using a specific font. I read several forums and people suggest to use the ? to print on dot matrix printer for the types of labels im using, well i tried and most of the data shows in the printout except a field where i have a...