Or you could issue a CURSORSETPROP("MapBinary",.t.), if you are using VFP 9,
before the sqlexec().John Harvey -----Original Message----- From: [email protected] [mailto:[email protected]] On Behalf Of MB Software Solutions, LLC Sent: Monday, December 13, 2010 12:09 AM To: ProFox Email List Subject: Re: Needing to create file from General field (SOLVED) On 12/12/2010 11:38 PM, MB Software Solutions, LLC wrote: > VFP9SP2 / MySQL backend > > I ran a query against a MySQL database, LongBlob field. I get back a > General field in my cursor. That's an .EXE that I want to create the > file locally and then run it. However, when I do > STRTOFILE(MyCursor.AppToRun,addbs(sys(2023))+"_setup.exe"), it throws an > error: "Function argument value, type, or count is invalid." > > What am I doing wrong? > Solved it. Just needed CAST. I just had to add CAST(MyCursor.AppToRun as Blob) and it now works fine. I'm making a new loader utility to replace my old ones and that will run from a web database repository instead of the traditional VFP way. -- Mike Babcock, MCP MB Software Solutions, LLC President, Chief Software Architect http://mbsoftwaresolutions.com http://fabmate.com http://twitter.com/mbabcock16 [excessive quoting removed by server] _______________________________________________ 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/008001cb9a92$21a8e290$64faa7...@[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.
