Groups | Search | Server Info | Keyboard shortcuts | Login | Register [http] [https] [nntp] [nntps]
Groups > comp.lang.clipper.visual-objects > #5692
| From | "Willie Moore" <williem@wmconsulting.com> |
|---|---|
| Newsgroups | comp.lang.clipper.visual-objects |
| Subject | Re: SQLSelect does not return results when calling a stored procedure in VO 2.8 |
| Date | 2013-08-13 09:56 -0500 |
| Organization | Aioe.org NNTP Server |
| Message-ID | <kudhe9$3rb$1@speranza.aioe.org> (permalink) |
| References | <8c0142d0-4124-4d96-b593-fbb713b6c51a@googlegroups.com> |
Hey,
Have you run it through the debugger to make sure that you have a valid
connection in oConn? I have not used to VO SQL classes in years (I use
VO2ADO).
Regards,
Willie
Vulcan VIP
wrote in message
news:8c0142d0-4124-4d96-b593-fbb713b6c51a@googlegroups.com...
This (simple example) works in V0 2.7
-- sql code
CREATE PROCEDURE myProc
AS
BEGIN
SELECT 'A' as Column1, 'B' AS Column2
END
//-- VO code -------
oSel := SQLSelect("exec myProc",oConn)
oSel:FieldGet(1)
//------------------
In VO 2.8 the same code executes fine but returns nothing.
Any ideas?
Gerard
Back to comp.lang.clipper.visual-objects | Previous | Next — Previous in thread | Next in thread | Find similar | Unroll thread
SQLSelect does not return results when calling a stored procedure in VO 2.8 sudden2011@gmail.com - 2013-08-09 20:34 -0700
Re: SQLSelect does not return results when calling a stored procedure in VO 2.8 sudden2011@gmail.com - 2013-08-11 16:49 -0700
Re: SQLSelect does not return results when calling a stored procedure in VO 2.8 "Willie Moore" <williem@wmconsulting.com> - 2013-08-13 09:56 -0500
Re: SQLSelect does not return results when calling a stored procedure in VO 2.8 sudden2011@gmail.com - 2013-08-13 14:32 -0700
Re: SQLSelect does not return results when calling a stored procedure in VO 2.8 "Willie Moore" <williem@wmconsulting.com> - 2013-08-13 17:17 -0500
Re: SQLSelect does not return results when calling a stored procedure in VO 2.8 sudden2011@gmail.com - 2013-08-13 17:52 -0700
Re: SQLSelect does not return results when calling a stored procedure in VO 2.8 sudden2011@gmail.com - 2013-08-21 15:17 -0700
Re: SQLSelect does not return results when calling a stored procedure in VO 2.8 Willie Moore <williem@wmconsulting.com> - 2013-08-24 17:05 +0000
Re: SQLSelect does not return results when calling a stored procedure in VO 2.8 sudden2011@gmail.com - 2013-08-25 18:35 -0700
Re: SQLSelect does not return results when calling a stored procedure in VO 2.8 "Willie Moore" <williem@wmconsulting.com> - 2013-08-27 13:06 -0500
Re: SQLSelect does not return results when calling a stored procedure in VO 2.8 sudden2011@gmail.com - 2013-08-27 15:21 -0700
Re: SQLSelect does not return results when calling a stored procedure in VO 2.8 Willie Moore <williem@wmconsulting.com> - 2013-08-27 22:26 +0000
Re: SQLSelect does not return results when calling a stored procedure in VO 2.8 D.J.W. van Kooten <public@ic2remove.this.com> - 2013-09-11 23:19 +0200
Re: SQLSelect does not return results when calling a stored procedure in VO 2.8 sudden2011@gmail.com - 2013-08-13 18:03 -0700
Re: SQLSelect does not return results when calling a stored procedure in VO 2.8 codesys75@orange.fr - 2013-08-23 06:24 -0700
Re: SQLSelect does not return results when calling a stored procedure in VO 2.8 sudden2011@gmail.com - 2013-08-25 18:34 -0700
Re: SQLSelect does not return results when calling a stored procedure in VO 2.8 Daniel Costagliola <codesys75@orange.fr> - 2013-08-26 01:47 -0700
Re: SQLSelect does not return results when calling a stored procedure in VO 2.8 sudden2011@gmail.com - 2013-08-26 19:30 -0700
csiph-web