On 2014-01-15 18:04, Mike Copeland wrote:
Like you, I would also like to know if there is any way to retrieve a
value, for example just one field from one table, from a MySQL or
MariaDB server without going through the process of receiving it into
a VFP table, then accessing the table and the table's field, and then
closing the table. Like, just return the value into a memvar...
Maybe what seems to be a multi-step process is all just semantics to
standardize the process interface due to the ExecSQL?
Maybe VFP really isn't creating files on disk like it appears?
Maybe encapsulating the process in a function to hide the lengthy
mechanism would hide the complexity and "solve" the problem?
Maybe that's what everyone is talking about already?
Remember that VFP won't be making those cursors files on disk unless
they're too big to fit in memory.
I've created a routine to run the SQL, grab the value from the cursor,
then close the cursor and return the value.
Yeah...guess we're all on the same page on this one.
_______________________________________________
Post Messages to: [email protected]
Subscription Maintenance: http://mail.leafe.com/mailman/listinfo/profox
OT-free version of this list: http://mail.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.
