Set Filter

Article View: borland.public.vdbase.data.sql

Article #1238

Back to borland.public.vdbase.data.sql Previous Next

#1238

From: Enes Boric
Date: Mon, 16 Mar 1998 00:00

32 lines
1318 bytes

Have a interesting problem.
In 5.5 code is:...

Procedure FrontClrSet
      select frcol
      set filter to
      go top
      set filter to frcol->fStyle=left(ordhdr->hDStyle,3)
      go top
      form.cbFrCol.DataSource="FIELD frcol->frcol"
      form.cbFrCol.Value=ordhdr->hFrCol
Return


And when I try to set filter in 7.0 I hva a problem. What's wrong. Any
help will be appreciated.

Procedure FrontClrSet
      LOCAL f,d
      f=form.DATAMODREF1.ref.ordhdr1.rowset
      d=form.DATAMODREF1.ref.frcol1.rowset
      d.clearfilter()
      d.first()

d.applyfilter(d.fields["FSTYLE"].value=left(f.fields["HDSTYLE"].value,3))

      d.first()
      form.cbFrCol.DataSource=d.fields["FRCOL"].value
      form.cbFrCol.Value=f.fields["HFRCOL"].value
      form.rowset.refreshControls()
   Return

Technical Details

Message-ID: <350D5224.67F2D870@ionline.net>

Path: arc1-ca.pugleaf.net!unknown!not-for-mail

Show Full Headers

Complete Article Headers

X-Google-Language: ENGLISH,ASCII-7-bit
X-Google-Thread: ff5a1,b86967b852917692,start
X-Google-Attributes: gidff5a1,public
From: Enes Boric <eboric@ionline.net>
Subject: Set Filter
Date: 1998/03/16
Message-ID: <350D5224.67F2D870@ionline.net>
X-Deja-AN: 334580329
Content-Transfer-Encoding: 7bit
X-Priority: 3 (Normal)
Mime-Version: 1.0
Content-Type: text/plain; charset=us-ascii
Organization: Another Netscape Collabra Server User
Newsgroups: borland.public.vdbase.data.sql