How to write a query with = operator?

Relational programmable database with GUI

Brought to you by: lkppo, steffengutmann

#32 How to write a query with = operator?

Milestone: BeeBase V1.1

Status: wont-fix

Owner: Steffen Gutmann

Labels: None

OS: Windows

Priority: 5

Updated: 2024-09-17

Created: 2024-09-16

Creator: Stéphane Aulery

Private: No

After consulting the manual I did not understand how to express a simple equality condition such as:

SELECT * FROM Adresse WHERE VilleAdresse = 'Bages'

SELECT * FROM Adresse WHERE (= VilleAresse 'Bages')

2 Attachments

2024-09-17 00_46_21-syntax error.png

annuaire.bee

Discussion

Stéphane Aulery - 2024-09-16

OS: Amiga --> Windows
If you would like to refer to this comment somewhere else in this project, copy and paste the following link:

Steffen Gutmann - 2024-09-17

You need to use double quotes for strings, see https://beebase.sourceforge.io/index.php?page=documentation&mbdoc=16&lang=en#SEC202

If you would like to refer to this comment somewhere else in this project, copy and paste the following link:
- Stéphane Aulery - 2024-09-17
  
  I'll test again tonight then.
  
  If you would like to refer to this comment somewhere else in this project, copy and paste the following link:
  - Stéphane Aulery - 2024-09-17
    
    Ok, double quotes is the right syntax.
    
    If you would like to refer to this comment somewhere else in this project, copy and paste the following link:

Stéphane Aulery - 2024-09-17

status: open --> wont-fix

assigned_to: Steffen Gutmann
If you would like to refer to this comment somewhere else in this project, copy and paste the following link:

Log in to post a comment.