<div>
Thanks for the help. I just stuck with doing things the way I have done before and works.<br />
Less work for me too ;)
</div>


Thanks for the help. I just stuck with doing things the way I have done before and works.
Less work for me too ;)

<div>
<div class="content wysiwyg-content">
I'm trying to figure out how to access data from a cursor alias.<br />
Normally I do this:<br />

<pre><code id="code-10-27861745-1">lnResult=SQLEXEC(pnConnection,lcQuery,'cCursor')</code></pre>
and the data is at cursorname.fieldname<br />
<br />
I am trying to do this: <br />
<br />

<pre><code id="code-10-27861745-2">lcCursor = &quot;cCursor&quot;
lnResult=SQLEXEC(pnConnection,lcQuery,lcCursor)</code></pre>
<br />
and ALLTRIM(cCursor.fieldname)<wbr /> doesn't work.<br />
<br />
maybe it's cause I've been up for nearly 30 hours now that it's not working??
</div>
</div>


I'm trying to figure out how to access data from a cursor alias.
Normally I do this:
(CODE)
and the data is at cursorname.fieldname

I am trying to do this: 

(CODE)

and ALLTRIM(cCursor.fieldname) doesn't work.

maybe it's cause I've been up for nearly 30 hours now that it's not working??

VFP Access Data from Cursor Alias

Visual FoxPro (VFP), and its predecessor FoxPro, is a data-centric, object-oriented, procedural, database programming language and IDE from Microsoft last released in 2007 that still has some active use due to its low cost of deployment and fairly rapid development. In 2008, Microsoft released a set of add-ons for VFP's xBase components to allow interoperability with various Microsoft technologies. It allows data processing against its native file-based data tables or database servers such as SQL Server.