|
Home > Archive > Programming with dBASE > January 2006 > executesql()
You are viewing an archived Text-only version of the thread.
To view this thread in it's original format and/or if you want to reply to
this thread please [click here]
|
|
|
| HI all,
Does databse.executesql() return anything.
I am trying to execute a SP, which returns a value. But I cant seem to get
that value back to dbase
Thanks
Robert
| |
| Roland Wingerter 2006-01-05, 7:23 am |
| "rb" wrote
>
> Does databse.executesql() return anything.
> I am trying to execute a SP, which returns a value. But I cant seem to get
> that value back to dbase
------
According to the OLH, it does not return anything.
"Use executeSQL( ) to perform an SQL operation ... where no rowset is
desired"
Perhaps SQLExec() does what you want?
(The see-also-reference is missing in the OLH).
Roland
| |
|
| I thought of useing SQLexec() but then would have to manually open and set
the database, where as I already have an active database object. I was
hoping to use that
Robert
"Roland Wingerter" <ich@hier.de> wrote in message
news:Dl6b$oeEGHA.1800@news-server...
> "rb" wrote
get[color=darkred]
> ------
> According to the OLH, it does not return anything.
>
> "Use executeSQL( ) to perform an SQL operation ... where no rowset is
> desired"
>
> Perhaps SQLExec() does what you want?
>
> (The see-also-reference is missing in the OLH).
>
> Roland
>
>
>
| |
| Roland Wingerter 2006-01-05, 7:23 am |
| "rb" wrote
>I thought of useing SQLexec() but then would have to manually open and set
> the database, where as I already have an active database object. I was
> hoping to use that
------
OK, I understand.
Roland
| |
| *Lysander* 2006-01-05, 7:23 am |
| In article <EECSj6eEGHA.2104@news-server>, me@u.com says...
> I thought of useing SQLexec() but then would have to manually open and se=
t
> the database, where as I already have an active database object. I was
> hoping to use that
see in the other newsgroup.
use a StoredProc-Object or try fooling dBase by just "SELECTING" from=20
the StoredProc.=20
--=20
ciao,
Andr=E9
|
|
|
|
|