By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
424,680 Members | 2,139 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 424,680 IT Pros & Developers. It's quick & easy.

Returning data from a stored procedure

P: n/a
Hey All,

How should one return a single data element from a VFP stored procedure to a
..NET caller? The basic thing that keeps hanging me up is that VFP doesn't
return sets of data--at least not in the same sense that something like a
SQL Server does, but Execute___ commands are expecting sets back.

TIA,

John
Jul 21 '05 #1
Share this Question
Share on Google+
3 Replies


P: n/a
You could try ExecuteScalar() ... that returns one value boxed in an
object which you must then cast.

Joel Martinez
http://www.onetug.org - Orlando .NET User Group
http://www.codecube.net - blog

Jul 21 '05 #2

P: n/a
Thanks Joel,

It has a lot to do with me being an idiot! I had tried the unboxing, but
when I was trying it I hadn't been careful with my stored procedure, which
turned out to be returning a logical/bool rather than the int I was
intending. Dumb dumb dumb dumb dumb.

- John

PS - I'll be in your area in a couple days, can you serve up some good
weather? <g>

<jd********@ea.com> wrote in message
news:11**********************@z14g2000cwz.googlegr oups.com...
You could try ExecuteScalar() ... that returns one value boxed in an
object which you must then cast.

Joel Martinez
http://www.onetug.org - Orlando .NET User Group
http://www.codecube.net - blog

Jul 21 '05 #3

P: n/a
HAHAHA, don't hit yourself too much. We have all done stupid things like
that, and sometimes what's worse is it takes days (and a couple bottles of
aspirin) to figure it out.

"John Spiegel" <js******@YETANOTHERSPAMHATERc-comld.com> wrote in message
news:u$****************@tk2msftngp13.phx.gbl...
Thanks Joel,

It has a lot to do with me being an idiot! I had tried the unboxing, but
when I was trying it I hadn't been careful with my stored procedure, which
turned out to be returning a logical/bool rather than the int I was
intending. Dumb dumb dumb dumb dumb.

- John

PS - I'll be in your area in a couple days, can you serve up some good
weather? <g>

<jd********@ea.com> wrote in message
news:11**********************@z14g2000cwz.googlegr oups.com...
You could try ExecuteScalar() ... that returns one value boxed in an
object which you must then cast.

Joel Martinez
http://www.onetug.org - Orlando .NET User Group
http://www.codecube.net - blog


Jul 21 '05 #4

This discussion thread is closed

Replies have been disabled for this discussion.