>>From VFP command line, what happens if you perform simple queries filtered on primary key. If you don't see records you know >>are there, check the connection string. How is AlwaysEncrypted activated? The standard way is by including >>ColumnEncryption=Enabled . If that's not it, maybe post a redacted connstr anyway, in case somebody can spot >>something. Also if you can post some sample queries with details of deterministic versus randomized column encryption, >>somebody here can probably advise.

Hi
We have field "ypaybasic" is encrypted

By using connection string "Driver=ODBC Driver 18 for SQL Server;Server=xxxx;Trusted_connection=yes;Encrypt=yes;Database=xxxx;ColumnEncryption=Enabled;TrustServerCertificate=yes", I've successfully returned data from "Always Encrypted with secure enclaves" database.

Would like to enquire following issues:
"1) Retrieving data with filters on encrypted field, eg. SELECT * FROM Employees WHERE BasicPay>=1000.
Hit error ""Connectivity error: [Microsoft][ODBC Driver 18 for SQL Server][SQL Server]Operand type clash: smallint is incompatible with smallint encrypted with (encryption_type = 'RANDOMIZED', encryption_algorithm_name = 'AEAD_AES_256_CBC_HMAC_SHA_256', column_e""...

Even if I change to:
DECLARE @myvalue money=1000;
SELECT * FROM Employees WHERE BasicPay>=@myvalue
I hit error: ""Connectivity error: [Microsoft][ODBC Driver 18 for SQL Server][SQL Server]Encryption scheme mismatch for columns/variables '@myvalue'. The encryption scheme for the columns/variables is (encryption_type = 'PLAINTEXT') and the expression near line '2' e""..."

"2) How to update encrypted field through remote view?
I'm using USE (view) IN 0 ALIAS mycursor. Data is not updated using TABLEUPDATE().
Hit error ""Connectivity error: [Microsoft][ODBC Driver 18 for SQL Server][SQL Server]Operand type clash: decimal(19,4) encrypted with (encryption_type = 'RANDOMIZED', encryption_algorithm_name = 'AEAD_AES_256_CBC_HMAC_SHA_256', column_e""..."

"3) What is the best way to return or prepare a cursor which is grouped or sorted on encrypted field.
Example: SELECT COUNT(1) FROM Employee GROUP BY Basicpay"