Search results for query: *

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

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

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

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

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

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

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

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

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

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

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

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?

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

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

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

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

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

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

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

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