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 Chriss Miller 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: *

  • Users: alisaif
  • Content: Threads
  • Order by date
  1. alisaif

    How to make index fast

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

    Divide Monthly Sales in 4 equal weeks.

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

    memo field

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

    Record Duplication in Grid

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

    Invoice Display/Print Error

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

    How to apply progressive bar on SQL-Select

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

    How to optimize this query

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

    Sql-Select Using Union

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

    Not Able to Register DLL Files

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

    How To Get Rid Of Error

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

    Column Wise Report

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

    Set Decimal to 4 digit

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

    How To Apply ICase

    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"...
  14. alisaif

    Installation

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

    How to convert Grid contents into excel

    Hi, How can I perform the subject. Thanks Saif
  16. alisaif

    How to check duplicate record?

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

    Using Control

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

    How to open blank Ms-Word and Ms-Excel within VFP

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

    VFP-64Bit

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

    Printing on Dot Matrix Epson LQ Printer

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

Part and Inventory Search

Back
Top