RetroBBS - comp.lang.clipper.visual-objects - Re: SQL

SQL - fieldget freeze

<aca794aa-7cda-4f1f-8a6e-561596389ca9n@googlegroups.com>

https://www.rocksolidbbs.com/devel/article-flat.php?id=1413&group=comp.lang.clipper.visual-objects#1413

copy link Newsgroups: comp.lang.clipper.visual-objects

X-Received: by 2002:a05:620a:2904:b0:76f:1b38:e73d with SMTP id m4-20020a05620a290400b0076f1b38e73dmr29225qkp.10.1695819165232;
Wed, 27 Sep 2023 05:52:45 -0700 (PDT)
X-Received: by 2002:a05:6870:1a81:b0:1d7:d1d:8c9d with SMTP id
ef1-20020a0568701a8100b001d70d1d8c9dmr895203oab.0.1695819164981; Wed, 27 Sep
2023 05:52:44 -0700 (PDT)
Path: i2pn2.org!i2pn.org!weretis.net!feeder6.news.weretis.net!border-2.nntp.ord.giganews.com!nntp.giganews.com!news-out.google.com!nntp.google.com!postnews.google.com!google-groups.googlegroups.com!not-for-mail
Newsgroups: comp.lang.clipper.visual-objects
Date: Wed, 27 Sep 2023 05:52:44 -0700 (PDT)
Injection-Info: google-groups.googlegroups.com; posting-host=91.183.222.54; posting-account=JsAULgoAAABqHARBDjjSISV6PoSTSdrb
NNTP-Posting-Host: 91.183.222.54
User-Agent: G2/1.0
MIME-Version: 1.0
Message-ID: <aca794aa-7cda-4f1f-8a6e-561596389ca9n@googlegroups.com>
Subject: SQL - fieldget freeze
From: jls@igsoft.be (j...@igsoft.be)
Injection-Date: Wed, 27 Sep 2023 12:52:45 +0000
Content-Type: text/plain; charset="UTF-8"
Lines: 16

by: j...@igsoft.be - Wed, 27 Sep 2023 12:52 UTC

Hello

I have a problem with SQLConnection and SQLSelect (MySql 8)

c:= "SELECT CFORMAT FROM FACTURE WHERE NUMFACT=15400"
oserver := SQLSelect{c,osql}
IF oserver:Execute()
cvar := oserver:fieldget("CFORMAT") ==> Freeze
endif

All other fieldget are working, but not this one.

Any idea ?

Jean-Luc

Re: SQL - fieldget freeze

<852d012e-e822-4372-8aee-fec4f9b25f20n@googlegroups.com>

copy mid

https://www.rocksolidbbs.com/devel/article-flat.php?id=1414&group=comp.lang.clipper.visual-objects#1414

copy link Newsgroups: comp.lang.clipper.visual-objects

X-Received: by 2002:a05:620a:4886:b0:774:20c8:bf4b with SMTP id ea6-20020a05620a488600b0077420c8bf4bmr16935qkb.7.1695911530650;
Thu, 28 Sep 2023 07:32:10 -0700 (PDT)
X-Received: by 2002:a05:6808:2022:b0:3a7:b55e:a54 with SMTP id
q34-20020a056808202200b003a7b55e0a54mr565200oiw.1.1695911530258; Thu, 28 Sep
2023 07:32:10 -0700 (PDT)
Path: i2pn2.org!i2pn.org!usenet.blueworldhosting.com!diablo1.usenet.blueworldhosting.com!peer01.iad!feed-me.highwinds-media.com!news.highwinds-media.com!news-out.google.com!nntp.google.com!postnews.google.com!google-groups.googlegroups.com!not-for-mail
Newsgroups: comp.lang.clipper.visual-objects
Date: Thu, 28 Sep 2023 07:32:09 -0700 (PDT)
In-Reply-To: <aca794aa-7cda-4f1f-8a6e-561596389ca9n@googlegroups.com>
Injection-Info: google-groups.googlegroups.com; posting-host=119.12.44.196; posting-account=Cej_ZAoAAAAXywdXd6C1XyTkFea_PrC2
NNTP-Posting-Host: 119.12.44.196
References: <aca794aa-7cda-4f1f-8a6e-561596389ca9n@googlegroups.com>
User-Agent: G2/1.0
MIME-Version: 1.0
Message-ID: <852d012e-e822-4372-8aee-fec4f9b25f20n@googlegroups.com>
Subject: Re: SQL - fieldget freeze
From: alessandro@computerscenter.com (Alessandro Vacchiano)
Injection-Date: Thu, 28 Sep 2023 14:32:10 +0000
Content-Type: text/plain; charset="UTF-8"
Content-Transfer-Encoding: quoted-printable
X-Received-Bytes: 1762

by: Alessandro Vacchiano - Thu, 28 Sep 2023 14:32 UTC

Go and post here for help:

https://www.xsharp.eu/forum/17

Bye Alessandro

Il giorno mercoledì 27 settembre 2023 alle 14:52:46 UTC+2 j...@igsoft.be ha scritto:
> Hello
>
> I have a problem with SQLConnection and SQLSelect (MySql 8)
>
> c:= "SELECT CFORMAT FROM FACTURE WHERE NUMFACT=15400"
> oserver := SQLSelect{c,osql}
> IF oserver:Execute()
> cvar := oserver:fieldget("CFORMAT") ==> Freeze
> endif
>
> All other fieldget are working, but not this one.
>
> Any idea ?
>
> Jean-Luc

Lack of skill dictates economy of style. -- Joey Ramone

devel / comp.lang.clipper.visual-objects / Re: SQL - fieldget freeze

Subject	Author
SQL - fieldget freeze	j...@igsoft.be
Re: SQL - fieldget freeze	Alessandro Vacchiano