Hi Janet,
The column "Name" is a reserved word. I would change the column to a
different name.
Best regards,
Mike Young
On Wed, 08 Aug 2001 07:24:04 -0700, Janet Thomas wrote:
>QUOTES are single (the default also).
>EXACT syntax is:
>
>SELECT * FROM Students WHERE name CONTAINS 'Valdez' ORDER
BY name ASC
>
>
>Janet
>
>>>> [EMAIL PROTECTED] 08/07/01 06:18PM >>>
>
>Janet,
>
>Make sure that you are using the correct QUOTES setting
>around any TEXT values, i.e:
>
>"Valdes" vs. 'Valdes'
>
>You need to use the Database Default QUOTE SETting!
>
>Hope that helps!
>
>Very Best Regards,
>
>Razzak.
>
>PS. It might help to debug if you could post the EXACT syntax.
>
>At 02:38 PM 8/7/2001 -0700, Janet Thomas wrote:
>
>>What needs to be done to correct this problem?
>>
>>Running Rbase 6.5++ Build 1.842xRT03 on a Win98 machine....
>>
>>Set up a query to show entries in student table where
>>student name = 'valdez'....... when the Browse Query is
>>activated it shows EVERY ENTRY in the student table -
>>not just the names "Valdez"....
>>
>>Runs correctly from a sample application menu but cannot
>>get this to display correct data from the Query by Example
>>Menus....
>>
>>Any suggestions on what is wrong?
>
>===================================-===================
=========
>R:BASE Developers's Conference: http://www.rbase.com/conference
>Official R:BASE List Server: mailto:[EMAIL PROTECTED]
>RBTI Events/Training: http://www.rbase2000.com/events
>R:DCC Members: http://www.rbase2000.com/rdcc
>======================================================
==========
>R:BASE, Oterro & R:Tango are registered trademarks of RBTI.
>==================================-====================
=========
>
