Re: Dates me to

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

Article #111

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

#111

From: Ken Mayer [TeamB]
Date: Sat, 16 Jan 1999 00:00

25 lines
1263 bytes

"John Williamson" <datam@mail.hubwest.com> wrote:

>have simple select but did not pay attention when there was talk about this
>dates. Here is my line that I have trouble with, it does not like the word
>date
>select * from rppt where date >= mfdate and date <= mtdate
>date is a field in rppt
>mfdate and mtdate are public variables
>I could use a simple filter but would like to take a stab at this sql stuff

"date" is a reserved word. Either change the field name in your table,
or use:

   rppt."date"

and see if that solves it ...

Ken
---
Ken Mayer [TeamB]
Golden Stag Productions
http://www.mindspring.com/~hirschv/homepage.htm
http://www.mindspring.com/~hirschv/dbase/dbase.htm
Visual dBASE and InterBase WebRing - http://www.fghoche.com/dbasering.htm
TeamB: http://www.teamb.com

Technical Details

Message-ID: <36a02724.788810@forums.borland.com>

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

References: <77p454$4l01@forums.borland.com>

Show Full Headers

Complete Article Headers

X-Google-Language: ENGLISH,ASCII-7-bit
X-Google-Thread: ff5a1,2e2d582e6be9dacb
X-Google-Attributes: gidff5a1,public
From: supportInfo@borland.com (Ken Mayer [TeamB])
Subject: Re: Dates me to
Date: 1999/01/16
Message-ID: <36a02724.788810@forums.borland.com>
X-Deja-AN: 433237340
References: <77p454$4l01@forums.borland.com>
Organization: Golden Stag Productions
Reply-To: teamb@opto-pps.com
Newsgroups: borland.public.vdbase.data.sql

Reply to Parent Message