Thanks all. Well, I should have qualified my question by mentioning that the server in question is in the US, and I'm in Ireland!
But all those methods would work I presume ... The core problem is that I'm using SQLXML to return data, then XMLTOCURSOR in VFP to create a cursor from the data. Which is all fine, except if the SQL table has no rows, in which case you get no XML back, and consequently you don't get a cursor. So what I want to do is pre-create an empty cursor with the right structure so that I'll just have an empty cursor if no rows come back. _______________________________________________ Post Messages to: [email protected] Subscription Maintenance: http://leafe.com/mailman/listinfo/profox OT-free version of this list: http://leafe.com/mailman/listinfo/profoxtech Searchable Archive: http://leafe.com/archives/search/profox This message: http://leafe.com/archives/byMID/profox/[EMAIL PROTECTED] ** All postings, unless explicitly stated otherwise, are the opinions of the author, and do not constitute legal or medical advice. This statement is added to the messages for those lawyers who are too stupid to see the obvious.
