Search results for query: *

Hi, I have one item master file (icode.dbf) which contains around 5000 records. Item codes are like; B1236, W529, H1026 and a lot more. All these items are heavy transaction in stock file (stock.dbf) which contains around 1 million records. If I take records between some specific date, it is...

Hi, I want to divide the whole month sales into 4 equal weeks, how can I use SQL to perform this task. Thanks Saif

Hi, First time, I am going to use memo field. Please let me know the following: 1. How can I define memo field in cursor define ( create cursor .. 2. How can I display on form. ( Like textbox or edit box.) 3. How can I save it in cursor/table. Thanks Saif

Hi, I am facing a very strange problem since long time. Though it is not common, means it is not showing all the time. Sometime it is showing duplicate record. Please go through the image. The upper one is grid in which the record is duplicate. And, down the table in which normal record is...

Hi, I want to print invoice in landscape mode, giving this error. Please find the attached pics relating to this. Please guide what's wrong with this. Thanks

Hi, Please refer to my previous thread thread184-1781999 Kindly let me know how to use progressive bar for the same. Thanks Saif

Hi All, I have two tables: 1. hAccount.dbf ( Contains records from 01/01/2003 to 31/12/2016 } 2. Account.dbf ( Contains records from 01/01/2017 till todate ) I am running this query: Select hAccount.creference, hAccount.cdate, hAccount.ccode, Code.full_name...

Hi All, I want to add two tables into one using SQL-Select with "Union" which is as follows: Select hAccount.creference, hAccount.cdate, hAccount.ccode, Code.full_name,; hAccount.remarks, Code.chead, hAccount.debit, hAccount.credit; FROM ; village!hAccount ...

Dear All Please go through the image, I am trying to register ContextMenuLib.Dll in SysWOW64 directory in Windows 10 64 bit, but not getting through. Please guide what's wrong with this? Thanks Saif

Hi, Please refer to the subject, what is the solution of this error? It is not going if we click on ignore unless we go to the task manager and remove the app from there. Please suggest. Thanks Saif

Hi, Please refer to my thread thread184-1723072. Two codes were suggested: dt1 = {01/01/2017} dt2 = {31/12/2017} Sele Year(cdate) As theyear, ; month(cdate) As themonth, ; sum(debit) As debit, ; sum(credit) As credit, ; SUM(debit-credit) as net ; from actran where BETWEEN(cdate,dt1,dt2) and...

Hi, I am using the following in order to obtain the rate from sales invoice in descending order SELECT DISTINCT Simain.pcode, Sisub.icode, Sisub.ratemin; FROM ; village!simain ; INNER JOIN village!sisub ; ON Simain.sino = Sisub.sino; WHERE simain.invdate > {31/12/2015} ; INTO...

Hi, How can I use I case for some conditions of SrCode in grid, like With This.parent.parent.ContSrDisp.Grid1 .Width = 1146 .Height = 145 .Top = 84 .Left = 6 && Adjust Grid position .ColumnCount = 10 .HeaderHeight = 24 .ReadOnly = .T. .FontName = "Tahoma"...

Hi, I am installation visual foxpro on my new pc after attacking RANSOMWARE. I installed VFP Now I want to install Service Packing. After Google I found SP3 . Is it safe to installed. I am using 32 Bit Operating Systems. Thanks Saif

Hi, How can I perform the subject. Thanks Saif

Hi, I want to check LPO (Purchase Order #) in a table which contains around 900K records using the following: LOCATE FOR ("&mlpo")$lpo IF ! EOF() BROWSE ENDIF But it is very slow. Can I seek it rapidly? Thanks Saif

Hi, Can I use these controls in my VFP SP2 application?? https://www.dbi-tech.com/ Thanks Saif

Hi, Please refer to the subject, kindly let me know how to do the same. Thanks Saif

Hi, Is it safe to use VFP-64 Bit. [link ]http://www.baiyujia.com/vfpadvanced/f_vfpa_about.asp[/url] Please advise. Thanks Saif

Hi, Is it possible to print the multiple page invoice on Dot Matrix from VFP9 like it is printing from FPD26? Thanks Saif