Re: Why does this not work?

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

Article #648

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

#648

From: Ken Chan
Date: Mon, 27 Jul 1998 00:00

25 lines
1131 bytes

Nedim Buyukmihci wrote:

>   form.rowset.filter := "Zipcode >= '" + pcValue + "' and Zipcode <=
> '" + pcZipHigh + [']
> 
> you get an error, no matter how the statement is set up

How about just comparing one field with <= or >=

Are you sure you're referencing the correct rowset?

What is the SQL statement for the query?

Are you sure the variables have values? Try assigning the expression to a 
separate variable, and display that variable before assigning to filter.

Try another character field with a similar comparison.

> (including using colons preceding the variables)

That definitely won't work.

-- 
//Ken@Inprise
<Please follow-up to newsgroup; do not reply to email>

Technical Details

Message-ID: <MPG.1026bf322e50fe38989a37@forums.borland.com>

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

References: <35b5cc02.318528305@forums.inprise.com>

Show Full Headers

Complete Article Headers

X-Google-Language: ENGLISH,ASCII-7-bit
X-Google-Thread: ff5a1,80b2a41f1ab93db
X-Google-Attributes: gidff5a1,public
From: supportinfo@inprise.com (Ken Chan)
Subject: Re: Why does this not work?
Date: 1998/07/27
Message-ID: <MPG.1026bf322e50fe38989a37@forums.borland.com>
X-Deja-AN: 375533076
References: <35b5cc02.318528305@forums.inprise.com>
Organization: Inprise
Newsgroups: borland.public.vdbase.data.sql

Reply to Parent Message