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

  1. TariqMehmod

    Get vouchers of single date

    Respected Seniors I want to display all vouchers of single date 31-12-2020 So I have these parameters dt@ SELECT Distinct t0."DocDate" From ORDR t0 num@ SELECT t1."NumAtCard" From ORDR t1 Where (t1."DocDate" = '@dt') And this is selection formula {Command.DocDate} = {?dt@ SELECT...
  2. TariqMehmod

    Which JDBC Driver

    Sir I have installed JAVA 15 windows 7 64bit I want to ask what Microsoft JDBC Driver version for SQLSERVER 2014 should I download. Please
  3. TariqMehmod

    Upload File

    I refer to this link [link] https://www.tek-tips.com/viewthread.cfm?qid=480895 [/url] Where I am trying codes of sir DSummZZZ I have following codes with my following parameter lcHost ,lcUser ,lcPassword,lcSource ,lcTarget *... ftpPut.prg ... PARAMETERS lcHost, lcUser, lcPassword...
  4. TariqMehmod

    Whatsapp automation with VFP

    Dear All, Here is an attempt to send text messages,images,contents to whatsapp. No need of any third party dll etc. I have tested all method before uploading. All methods work fine. Before testing any method, you must have Whatsapp installed on your system Link Please enter whatsapp number...
  5. TariqMehmod

    Release file

    Sir I am converting frx into jpg then copy converted jgp file to clipboard. So I have these codes Set Safety Off Public yout Do declaration Do create_jpg Do image_to_clipboard *--------------------------------------------------------- * this procedure converts frx into jpg Procedure...
  6. TariqMehmod

    Copy tif to clipboard

    Respected Sir, I have a tif file that contains 2 pages. I am trying to copy it to _clipboard So I have these codes Declare Integer OpenClipboard In User32 Integer Declare Integer CloseClipboard In User32 Declare Integer EmptyClipboard In User32 Declare Integer SetClipboardData In User32...
  7. TariqMehmod

    File to Clip

    Respected Seniors, First of all I refer to this link https://www.tek-tips.com/viewthread.cfm?qid=1806946 The codes in above thread send image to whatsapp perfectly, Now I want to send a PDF to whatsapp. I found this link fruitful...
  8. TariqMehmod

    Calling Modal Form on Top Level Form

    Respected Tek-Tipsers I have 2 forms. The first one is a TOP LEVEL FORM and the second is a MODAL FORM. I run Form1 and then call Modal Form with command DO excel_griff This a prg based form. But form does not appear. I have following codes in config.fpw files SCREEN=OFF HELP=OFF...
  9. TariqMehmod

    Auto Cropping

    ear Experts I have following excel file I want to create an image based on usedcells (B3:J22) Is it possible to crop required range then create an image. I think GDIPLUS can do this, so I found these links but still confuse how to do this...
  10. TariqMehmod

    Whatsapp attachment

    Sir I am using these code to send text message on whatsapp. Declare Integer FindWindow In WIN32API String , String Declare Integer SetForegroundWindow In WIN32API Integer Declare Integer ShowWindow In WIN32API Integer , Integer Declare Integer ShellExecute In shell32.Dll ; INTEGER...
  11. TariqMehmod

    How to use Enter in string

    Sir I am trying to send message on whatsapp with following codes Declare Integer FindWindow In WIN32API String , String Declare Integer SetForegroundWindow In WIN32API Integer Declare Integer ShowWindow In WIN32API Integer , Integer Declare Integer ShellExecute In shell32.Dll ; INTEGER...
  12. TariqMehmod

    Database Fields : Command

    I prepare query in SAP while using HANA DATABASE after preparing query I copy this query to Crystal Reports Command box Now I go to crystal report, Field Explorer and get all fields which I have selected with command Now my question: Is it possible to add more fields in command?
  13. TariqMehmod

    Query from Sqlserver to Crystal Report

    Sir I have this query in sqlserver query editor SELECT man1, gate, vehicle,weight/(IIF(LEN(man1)=0, 0, 1)+IIF(LEN(man2)=0, 0, 1) +IIF(LEN(man3)=0, 0, 1)+IIF(LEN(man4)=0, 0, 1))as wages FROM Table_1 WHERE LEN(man1)>0 UNION ALL SELECT man2, gate, vehicle,weight/(IIF(LEN(man1)=0, 0...
  14. TariqMehmod

    Need 4 Speed

    Sir, I have following codes select cr_sum index on acc_code to myindex set order to myindex go top scan scatter memvar lnamt = m.payable mydate=date mycode=m.acc_code vouchersx="crs"+sys(2015) select date,vou_no,acc_code,balance,vou_type; from vouchers; where...
  15. TariqMehmod

    Kill Network Connection

    Respected Sir, There are 3 clients attached with Server and network connection is shown like this I want to disconnect all clients by Disabling network connection. Is it possible with VFP codes? Or is there any other method to disconnect clients from Sqlserver database. Please
  16. TariqMehmod

    Variable value in query

    Sir I have these codes db1='xyz' file_name='E:\HOURLY\at20\20190901_1159' if m.con1>0 TEXT TO cmd noshow backup database <<db1>> to disk='<<file_name\db1..bak>>' endtext if sqlexec(m.con1,cmd)<0 aerror(laerror) messagebox(laerror[1,2]) return.f. ENDIF It says...
  17. TariqMehmod

    Discount on 30 Days

    Dear Experts I am working on 30 Days Trade Credit and refer to these links https://blog.apruve.com/the-difference-between-net-30-and-due-in-30-days https://crushthecpaexam.com/accounting-glossary/2-10-n-30/ In short: Net 30 refers to the trade credit offered to a customer for the sale of...
  18. TariqMehmod

    Disable keyboard input in Barcode textbox

    Dear Experts I have a textbox1 which gets input from Barcode scanner. I want this textbox not to accept input from keyboard. Background: I scan barcodes of new products and save in database. Some times user enters some wrong data into this textbox and save it in db. I want to block user to...
  19. TariqMehmod

    Wrong Calculation

    Sir while using SQLSERVER 2012 I have these codes select top 1 reading,emp_start,emp_end from bin1_final order by date SELECT top 1 reading,(datediff(second,emp_start,emp_end)) as x, 3600 as y from bin1_final SELECT top 1 (reading/(datediff(second,emp_start,emp_end))*3600) as y from...
  20. TariqMehmod

    Update table

    Sir while using sqlserver, I have this data I want to update TIK column as like this Formula: If found tik=1 then it pick up weight that is 375 Now 375-25=350 Update table_1 set tik= 1 where weight between 350,375 Please help

Part and Inventory Search

Back
Top