About between and ~~~~~~~~ `

nflssimon

first sentence
adoquery1.sql.add ('update daa074 set skqk = `` kasjhd' 'where daa074.elsyds between daa091.jdds2 and daa091.jdds2');
Second sentence
adoquery1.sql.add ('update daa074 set skqk = `` kasjhd' 'where daa074.elsyds between 1 and 1000');

If I write like the first sentence, I make a mistake
If you write like the second sentence, you can update successfully. Why? What should I write? ? ? ? ? ?

daa074, daa091 are dbf tables

lazying

adoquery1.sql.add ('update daa074 set skqk = `` kasjhd' 'where daa074.elsyds between daa091.jdds2 and daa091.jdds2');

and not both before and after daa091.jdds2

nflssimon

Front is jdds1

nflssimon

No mistakes in the program

ekinzou

BETWEEN begin_expression AND end_expression

The value in between must be a value, not a field or anything, and the types of begin_expression and end_expression must be the same

lazying

What is the error message?
What is daa091.jdds1, daa091.jdds2

nflssimon

Error message:
[Microsoft] [ODBC Visual FoxPro Driver] Command contains unrecognized phrase / keyword '

They are the same type
Are all numerical in the vf table

nflssimon

adoquery1.sql.add ('update daa074 set skqk = (SELECT `` kasjhd' 'from daa074 a, daa091 b where a.elsyds between b.jdds1 and b.jdds2)');
If you update like this, you will get this error
'[Microsoft] [ODBC Visual FoxPro Driver] Function name is missing)'

ekinzou

BETWEEN begin_expression AND end_expression

It's not a BETWEEN AND error. It's your SQL statement that is wrong. You can replace it with where a> 1 and a <100. VF has never been used.


daa091.jdds1, daa091.jdds2 should be fields, not fields, but should be an explicit value

nflssimon

daa091.jdds1, daa091.jdds2
Is the field

 where a> 1 and a <100

What I want to accomplish is this
I add a field skqk in daa074

Then update the value
In daa074, there is a field elsyds. If the value of skqk is between I and daa091.jdds1, daa091.jdds2, I will be empty.
Because I want to compare records one by one, I ca n’t fix the range, so I need to take those two fields.

There is a better way without this
Help me