Re: OPO: QueryWhere()

On Mon, 06 May 1996 22:37:30 GMT, cwd7_at_cornell.edu (Christopher Desforges) wrote:

>I was hoping somebody could tell me if I am using QueryWhere
>correctly.
>
>I am trying to populate a repeater display whose RecordSource is a
>View. I would also like to give the user the ability to filter out
>data by either using a popup list or a radio-frame (and depending on
>their selection different information will be displayed).
>I've been trying to use the QueryWhere method to modify the data but
>to no avail. It seems to work only once per form call. I have
>included an example of the code in my popup list's PostChange() (Note
>thant repapn is the name of the repeater):
>
>PostChange()
>REM msgbox Self.value
>REM temp = Self.value
>REM EXEC SQL SELECT part_a_pn INTO :a_desc FROM tbl_parts WHERE
>part_typeid = :temp
>REM msgbox sqlerrtext()
>REMmsg = a_desc(0) & CHR$(13) & a_desc(1) & CHR$(13) & a_desc(2)
>REM msgbox msg
>
>frmParts.repapn.QueryWhere("part_typeid = " & Self.value)
>
>
>Is this the correct to program this functionality?
Try
frmParts.repapn.QueryWhere("Part_typeid = '" & Self.Value & "'")

Kasu Sista
Links Technology Corp. Received on Wed May 08 1996 - 00:00:00 CEST