Recent content by gkratnam

Apologies, if I am confusing everyone. First, let me go through the reference materials posted by Tom. Then I will have good understanding and hopefully can ask better questions. Thanks!

Thanks for all your inputs. Just to clarify, we have major desktop application that was built in VFP. We are doing some co-operation with a third party tool (About 10 fields get imported and exported back). There are many business reasons to do this. From the end user point of view, we can...

Thanks for opening up another avenue for this Chriss! My understanding is for someone else to use our service, we need to create and host a service. Please correct me if I am wrong. We have a VFP application and a client app needs to export some data from it and our VFP app need to import some...

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

Thanks for sharing the knowledge Chriss. SELECT * FROM oldtable into TABLE newtable This command created DBF and FPT only. No index CDX were created. Anyway, the timing is not a big deal. This table conversion is just a one time thing. I am good with all of your feedback. Thanks!

Tried the conversion with SET EXCLUSIVE, it still took about the same amount time (about ah hour), but it is not an issue. All good. Thanks for all the help and knowledge sharing!

Thank you both! For the converted table without type changes, Sys(2029) returned 245 (Previous versions of FoxPro with a memo field). Yes, I can open it in both versions. Then tested another table with adding an Integer, Sys(2029) returned 48 (Visual FoxPro with or without a memo field). No...

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

Thanks Rick, that did it! Those parameters are 0 in Excel. OEXCEL.Selection.ShapeRange.ScaleWidth(0.6465763895,0,0) OEXCEL.Selection.ShapeRange.ScaleHeight(0.7867755625,0,0) Thank you everyone for all your inputs.

Thanks for all of your inputs. Able to insert a picture at a specific location. Recorded a macro to resize the picture. But having some trouble converting into VFP code. This is the excel macro for resizing. Selection.ShapeRange.ScaleWidth 0.6465763895, msoFalse, msoScaleFromTopLeft...

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

Thanks Rick for your mini story, it is fun [bigsmile]. It stays fresh in memory when we make it enjoyable. I may not apply apply this question. But I can definitely make use of it for other purposes.

I got the solution from this forum. Yes, this solved it. a = "PETER~SMITH~DAVIDLU~" b = "DAVID~" &&Added '~' at the end ?ALLTRIM(b)$ a Learned from Mike, optimal solution is to do '~' at the begging and end. It can handle all the scenario. Thanks!

Learned something from All, thanks for your assistance. First off I made a mistake on the question, my apologies. However, I learned the correct way to do this from Griff's answer. a = "PETER~SMITH~DAVIDLU~" b = "DAVID" &&I wrote this as "DAVIDLU" ?ALLTRIM(b)$ a Thanks!

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!