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 derfloh 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: gkratnam
  • Content: Threads
  • Order by date
  1. gkratnam

    Creating a HTTP Web Service in VFP

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

    Convert Foxpro 2.x table to VFP 9

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

    Inserting picture in a specific cell in Excel

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

    Search for a word in a string

    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!
  5. gkratnam

    Sum vs Sum Nooptmize

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

    Insert picture in Excel sheet automatically

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

    Changing Class library path to relative

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

    Table with 2million records

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

    VFP using REST service and parsing JWT token

    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 =...
  10. gkratnam

    FPW2.6 for windows double sided printing

    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

Part and Inventory Search

Back
Top