I think you guys missed the point. The objective of Scott post is to obtain
information from an RBase engine through ODBC. If on the Tango editor you
pick SQL Query [Ctrl]Q and was to enter:
SHOW VERSION or (CVAL('VERSION')), ODBC returns an error message:
"This command is currently unsupported (1120)S1000"
HOWEVER, if you type:
SELECT (CVAL('Version')) FROM anyloggedtable WHERE LIMIT= 1
ODBC returns from RBase:
Oterro 2000 v6.5++ Windows (32-bit), U.S. Version, Build:
1.842xRT03
This is a great trick to get RBase function *** not a part of ODBC or SQL
*** from RBase!
I LIKE IT!
Thanks,
Manuel
Bill Downall wrote:
> Jim,
>
> Take your anti-anxiety medications, and don't worry. Scott is either
> making extra work for himself, or being lazy, depending on your point of
> view.
>
> You could also do this:
>
> SET V vVersion = (CVAL('VERSION'))
> SHO V vVersion
>
> Scott is using a technique that lets him do it with a single command,
> by selecting the "expression" -- and no columns -- from a table that he
> knows you have in your database. By the time he adds the WHERE
> clause, so that you only see the answer once, it's probably as much
> work as the two commands above.
>
> Many developers create a one row, one column table named Dummy to
> enable tricks like Scott's.
>
> Bill
>
> On Fri, 21 Sep 2001 16:28:05 -0400, Jim Limburg wrote:
>
> >Where on earth did you learn a command like this...?
> >Where is it in the docs?
> >
> >Someone's holding out on me...
> >I,I,I just don't know what to think about how
> >deprived I feel right now...
> >
> >OK, OK,,, I'm settled down now...
> >Whew... I still am interested in learning more
> >about this...
begin:vcard
n:de Aguiar;Manuel
tel;fax:(323)661-7698
tel;work:(323)660-3511
x-mozilla-html:FALSE
url:http://www.mdenterprises.net
org:M|D Enterprises
adr:;;2412 No. Commonwealth Avenue;Los Angeles;California;90027-1206;USA
version:2.1
email;internet:[EMAIL PROTECTED]
title:Developer
note;quoted-printable:The information contained in this e-mail may be privileged, confidential,=0D=0Aand protected from disclosure. If you are not the intended recipient, you=0D=0Aare hereby notified that any dissemination, distribution or duplication of=0D=0Athis communication is strictly prohibited. If you have received this=0D=0Acommunication in error, please notify the sender immediately and delete all=0D=0Acopies.=0D=0A=0D=0Ahttp://www.mdenterprises.net=0D=0Ahttp:/www.databasedeveloper.com=0D=0Ahttp://www.MdrBASE.com=0D=0A
x-mozilla-cpt:;-1
end:vcard
