Sybase NNTP forums - End Of Life (EOL)

The NNTP forums from Sybase - forums.sybase.com - are now closed.

All new questions should be directed to the appropriate forum at the SAP Community Network (SCN).

Individual products have links to the respective forums on SCN, or you can go to SCN and search for your product in the search box (upper right corner) to find your specific developer center.

setitem and querymode

3 posts in DataWindow Last posting was on 2008-10-10 17:51:55.0Z
marmozzo Posted on 2008-10-09 08:56:34.0Z
From: marmozzo <marco06@aliceposta.it>
User-Agent: Thunderbird 2.0.0.17 (Windows/20080914)
MIME-Version: 1.0
Newsgroups: sybase.public.powerbuilder.datawindow
Subject: setitem and querymode
Content-Type: text/plain; charset=ISO-8859-15; format=flowed
Content-Transfer-Encoding: 7bit
NNTP-Posting-Host: vip152.sybase.com
X-Original-NNTP-Posting-Host: vip152.sybase.com
Message-ID: <48edc742@forums-1-dub>
Date: 9 Oct 2008 01:56:34 -0700
X-Trace: forums-1-dub 1223542594 10.22.241.152 (9 Oct 2008 01:56:34 -0700)
X-Original-Trace: 9 Oct 2008 01:56:34 -0700, vip152.sybase.com
Lines: 8
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub sybase.public.powerbuilder.datawindow:87952
Article PK: 417205

I would like do setitem in a datawindow in querymode, but it not works.
Why?
I have to read the argument "data" in itemchanged of a field and I have
to prepare the string for the datawindow in querymode, I believe I can
do setitem and all works, but not!
Someone can help me?
Thank
Marco


R. Pods Posted on 2008-10-09 09:41:46.0Z
From: "R. Pods" <r.pods@gmx.net>
User-Agent: Thunderbird 2.0.0.17 (Windows/20080914)
MIME-Version: 1.0
Newsgroups: sybase.public.powerbuilder.datawindow
Subject: Re: setitem and querymode
References: <48edc742@forums-1-dub>
In-Reply-To: <48edc742@forums-1-dub>
Content-Type: text/plain; charset=ISO-8859-15; format=flowed
Content-Transfer-Encoding: 7bit
NNTP-Posting-Host: vip152.sybase.com
X-Original-NNTP-Posting-Host: vip152.sybase.com
Message-ID: <48edd1da@forums-1-dub>
Date: 9 Oct 2008 02:41:46 -0700
X-Trace: forums-1-dub 1223545306 10.22.241.152 (9 Oct 2008 02:41:46 -0700)
X-Original-Trace: 9 Oct 2008 02:41:46 -0700, vip152.sybase.com
Lines: 13
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub sybase.public.powerbuilder.datawindow:87953
Article PK: 417209

If you use setcolumn/settext to set a string into the edit control for
the colunn (as the user would do), then change the querymode to "no",
that should do the trick.

marmozzo write:

> I would like do setitem in a datawindow in querymode, but it not works.
> Why?
> I have to read the argument "data" in itemchanged of a field and I have
> to prepare the string for the datawindow in querymode, I believe I can
> do setitem and all works, but not!
> Someone can help me?
> Thank
> Marco


Chris Pollach Posted on 2008-10-10 17:51:55.0Z
From: "Chris Pollach" <cpollach@travel-net.com>
Newsgroups: sybase.public.powerbuilder.datawindow
References: <48edc742@forums-1-dub>
Subject: Re: setitem and querymode
Lines: 27
X-Priority: 3
X-MSMail-Priority: Normal
X-Newsreader: Microsoft Outlook Express 6.00.2900.3138
X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2900.3350
X-RFC2646: Format=Flowed; Response
NNTP-Posting-Host: vip152.sybase.com
X-Original-NNTP-Posting-Host: vip152.sybase.com
Message-ID: <48ef963b$1@forums-1-dub>
Date: 10 Oct 2008 10:51:55 -0700
X-Trace: forums-1-dub 1223661115 10.22.241.152 (10 Oct 2008 10:51:55 -0700)
X-Original-Trace: 10 Oct 2008 10:51:55 -0700, vip152.sybase.com
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub sybase.public.powerbuilder.datawindow:87974
Article PK: 417232

Hi Marco;

When in "Query Mode", make sure you use the SetColumn + SetText methods
to get the data into the DW object. Then, when you bring the DWO out of
Query Mode at the end of all of that the SQL Query should be well formed.
:-)

HTH

--
Regards ... Chris
ISUG - NA RUG Director
http://chrispollach.pbdjmagazine.com

"marmozzo" <marco06@aliceposta.it> wrote in message
news:48edc742@forums-1-dub...
>I would like do setitem in a datawindow in querymode, but it not works.
> Why?
> I have to read the argument "data" in itemchanged of a field and I have to
> prepare the string for the datawindow in querymode, I believe I can do
> setitem and all works, but not!
> Someone can help me?
> Thank
> Marco