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!

  • Congratulations strongm 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. Doug Lindauer

    Concatenate 2 fields in 1 field with condition

    You didn't specify the data types and lengths of the fields. It looks like they're character type but the code will be a little different depending. In any case you'll be using either padl() or chrtran() somewhere in there along with "replace all ...". Keep in mind when posting a question like...
  2. Doug Lindauer

    Update data in a Cursor

    Mike, won't regenerating the cursor cause a problem with RecordSource of the grid? You've created a new object even if it has the same name. I've had problems when I've used the builder to create a grid and then change something even like a ControlSource for a column. It seems to blow up the...
  3. Doug Lindauer

    Selecting record from a Grid for use in another form

    1. yes it would be indexing the cursor but you didn't use the readwrite option and the way I found it works is that you can only make one tag index if the cursor is read only. I get an error when I try to do more than one unless I specify "readwrite". 2. Yes, it would just close the table, not...
  4. Doug Lindauer

    Selecting record from a Grid for use in another form

    I suppose the simplest way would be to create tag indexes when you create the cursor. (But apparently the cursor has to be readwrite.) You could even write one procedure that would work for any column by making the tag name the same as the field name. Then you can reference the...
  5. Doug Lindauer

    Selecting record from a Grid for use in another form

    Another way to do this is to just create a container on the same form. The container has all the controls for the details of the grid row. When you design, just have it down below the grid and invisible. When you click a row in the grid, the code makes the grid invisible (or move it down out...
  6. Doug Lindauer

    Accessing an android device from within VFP

    Exit command is nice. I put one in the loop in my code. It will only save a few microseconds but it's neater. I didn't want the user of the program to have to install anything on their device or go through any special steps so I didn't really consider using an FTP app. So far in my testing...
  7. Doug Lindauer

    Accessing an android device from within VFP

    Mike, Griff, and especially Strongm ... you guys are on my Christmas List. And I won't have to check it twice.
  8. Doug Lindauer

    Accessing an android device from within VFP

    Ok, I stepped through with the debugger and changed a couple of things and it works! For me, this is incredibly HUGE! Here's my click event code. One of the subtle things that needed fixing was the copy command at the last line. It's a function so we needed to add parenthesis...
  9. Doug Lindauer

    Accessing an android device from within VFP

    FWIW I did read in a thread on stackoverflow that the names inside shell32 are case sensitive. So perhaps objItem.NAME, objItem.TYPE should be objItem.Name, objItem.Type (I've been spending all my time trying to understand how to use declare and things in the WinAPI. A lot to take in all at once.)
  10. Doug Lindauer

    Accessing an android device from within VFP

    I guess I need some help here. I don't do much with classes in VFP. The only syntax I'm familiar with is defining a class as a type of control like define class EventButton as CommandButton and later adding objects to a container like mNAME = "btn"+trim(curevents.EVENTCODE)...
  11. Doug Lindauer

    Accessing an android device from within VFP

    Yes that's what I've been doing and that seems to be what the problem is.
  12. Doug Lindauer

    Accessing an android device from within VFP

    Strong, I don't actually know what you mean by enumerate the drives. Never heard that term before. But here's my best guess at a translation for your code. Also I have no idea what that value is for thisPC. Where do you get that from? I'm also not sure what to use for AndroidFolder. I took...
  13. Doug Lindauer

    Accessing an android device from within VFP

    I used subst and gave the z drive the letter a. Z is the drive letter I used when I ran WebDAV Server. subst a: z: When I called up a dos window I could see both z and a and copy from them. But VFP still couldn't see them. I did "run cmd" in VFP and a dos window came up just like as if I had...
  14. Doug Lindauer

    Accessing an android device from within VFP

    The WebDAV Server app I found in the playstore is this one: https://play.google.com/store/apps/details?id=com.theolivetree.webdavserver&hl=en&pli=1 I had no idea that WebDAV was a protocol. I thought it was just some name they had made up. Turning on wifi is not a problem on the iX14. Turning...
  15. Doug Lindauer

    Accessing an android device from within VFP

    I need to be able to automate grabbing a binary file from my Android device from within VFP. In this case the device happens to be a Spektrum iX14 r/c transmitter and the binary file I want to grab is a telemetry file. I can connect my Android device via USB and it shows up in Windows file...
  16. Doug Lindauer

    eMail server that lets you send via CDO

    Ok, to all, much thanks. Gerrit, yes, that does work so my problem is solved without any change to code. I have a SENDMAIL table in both systems so all I have to do is update the data and voila. My kind of simple. For anyone who follows this thread with the same problem, the steps to turn on...
  17. Doug Lindauer

    eMail server that lets you send via CDO

    Mike, both of the clients have a website but their webhost services don't provide POP access. They want you to use their web interface to do email. But both clients do have Outlook 2010 installed. I don't really know anything about using Outlook automation but that sounds like a more...
  18. Doug Lindauer

    eMail server that lets you send via CDO

    I have a problem. :) Why do people always have to make life difficult and change things? Ok, I have 2 different systems in which I'm using CDO (Thank you Mike Gagnon https://www.tek-tips.com/faqs.cfm?fid=4969) to send emails. I HAVE been using free accounts in gmail to send them BUT gmail is...
  19. Doug Lindauer

    Do I need MS Word to create and edit a .docx file

    Nothing is ever as simple as you'd like it be in this business, is it? Although sometimes you get surprised that something you thought was going to be hard turns out to be easy. But it's usually vice versa. I hadn't tried looking around for legit copies of old Office versions but I'll give it...
  20. Doug Lindauer

    Do I need MS Word to create and edit a .docx file

    Thanks much for that info. Ok so using Createobject("Word.Application") actually tries to invoke MS Word. I didn't know that level of detail but it makes sense. I'm an analyst, modeler, and database developer and I have no actual idea even what active X, com objects, or automation is about...

Part and Inventory Search

Back
Top