Recent content by eric0524

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

Olaf That worked. Thanks, Eric

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

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

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

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

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

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

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.

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