Search results for query: *

I would like to create a Webservice in VFP that can do HTTP GET/POST/PUT. We are not allowed to use any third party tools. We need to connect with another modern app to export/import data. I am fairly new to this concept and learned from this forum while ago about how to consume data using...

How do I convert an old foxpro 2.x table to a VFP9 version? Opened the table in VFP and added a field and did re-index. Would that do it? How do I check that it was updated? This is the table structure. Project_id N(10) Task_id N(10) User_id C(10) Notes M Bill_hours N(8,3) isBillable L I...

How do we insert a picture in a specific location in excel and adjust it's size? This inserts the picture. Need assistance with scaling. oExcel = CreateObject("Excel.Application") oWorkbook = oExcel.Workbooks.Add() oSheet1 = oWorkbook.Worksheets(1) oPictures = oSheet1.Pictures...

Hi, I am searching for a word in a string using '$', it did not work for the below scenario. a = "PETER~SMITH~DAVIDLU" b = "DAVIDLU" ?ALLTRIM(b)$ a &&This returns TRUE I was expecting a FALSE. Is there any other way to do this? Please assist. Thanks!

I like to optimize some old code here. Not sure it will have any negative impact. SELECT PrjTime SEEK cur_projid &&PrjTime table has an index on project id SUM NOOPTIMZE while (project_id = cur_projid) prj_hours to total_prjhours Would removing the NOOPTIMZE cause any issues? Please assist...

Trying to add a logo to Excel worksheet using the Sheet.Pictures.Insert property. But 'Insert' is not recognized. Please see here for the code. 'Insert' is not coming up as a property here. Is there any setup missing? Need to add a logo(.bmp or .png) in a specific cell. Is there any...

The frmcapacity class is being used my multiple applications and it has been working fine with the current absolute path setup. Class: frmcapacity ClassLibrary path: X:\vfpcondor\rwtracker\pmlibrary\vfpcasses.vcx The code is written like this. Set Default To (LPRGDIR) Set Classlib To...

I have a table with about 2million records. Here is the approximate size. TIME.CDX – 300,000KB TIME.DBF – 200,000KB TIME.FPT – 210,000KB TIME table structure (there are other fields too….) PROJECT_ID - N(8) TASK_ID- N(8) USER_ID C(10) TIME_HOURS N(8,3) TASK table structure (there are other...

My VFP application needs to use a REST service to connect to another application and import some data. I am able to establish a connection and get the response back. But I don't know how to parse the JWT-token. Here is my code. Contacting the server oXMLHttpRequest =...

How do I print reports double sided by default without setting the printer option manually everytime. Is there any set up I can do in foxprow when creating the reports? The command used is "REPORT FORM XXXX.FRX TO PRINTER PROMPT" Thanks