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 Chriss Miller 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. eric0524

    Not getting desired SQL Remote View Results

    Thanks Olaf, That was what I just came up with. But I also set near on and set exact off (not sure if they had anything to do with it but it works) LOL -Eric
  2. eric0524

    SQL Field nvarchar(300) getting back unicode encoded memo

    Olaf That worked. Thanks, Eric
  3. eric0524

    Not getting desired SQL Remote View Results

    I am trying to set a filter on a remote view in the data remote view designer to get a dataset back. When I call: cSearchStr = "BANK" SELECT DISTINCT Sdn.ent_num, Sdn.SDN_Name, Sdn.SDN_Type, Sdn.Program,; Sdn.Title, Sdn.Call_Sign, Sdn.Vess_type, Sdn.Tonnage, Sdn.GRT, Sdn.Vess_flag...
  4. eric0524

    SQL Field nvarchar(300) getting back unicode encoded memo

    SITUATION: I am working with a select statement calling from sql 2008 that pulls two fields from SQL ent_num, int and sdn_name nVarChar(300). When I get me result set back the sdn_name is a memo field and on top of that it is unicode. I was doing a: SELECT sdndata replace sdndata.sdn_name...
  5. eric0524

    Timer Question?

    Thanks Rick, That's the ticket. I don't know how to close a post but I got my answer now.
  6. eric0524

    Timer Question?

    I am using a timer on my form, set to an interval of 120000 so it will get data from the National Treasury every two minutes. Question: How can I show how much time is left before the timers, timer event fires? I was thinking about using a second timer that checks timer1 every second. My...
  7. eric0524

    Trying to use your XML Parser

    Thank You Olaf. You have got me on track now. I am going to use the CSV files and them together as needed. -Eric
  8. eric0524

    Trying to use your XML Parser

    OlafDoschke, You are right it can create one cursor that way. But I was told that there are several tables within the XML file and they update the XML file every time a new bad guy is found. Sorry about the syntax issue I just put that in after I pasted the data from VFP. Your code now is...
  9. eric0524

    Trying to use your XML Parser

    Mike, I tried that. It just blows through. I am stuck with VFP 9 if I had my way it would be using VFP 7 :( I know the XML file has 10 tables in it. I have installed all the new service packs for VFP and MSXML4.
  10. eric0524

    Trying to use your XML Parser

    I am trying to use the code you posted a long time ago that creates multiple cursors from an XML but I am getting an error "OMXL is not found" error. I am trying to run it by highlighting the code in a prg file. Can you tell me what boneheaded mistake I am making here? PLEASE! * test Local...

Part and Inventory Search

Back
Top