>>May I know if possible to use VFP to CRUD data from SQL server with Always Encrypted turned on?
>>1) Unable to filter encrypted field even we are even though we are using parameterised (sql exec)
>>2) Failed to update encrpyted field at all (view / sql exec)
>>We are using ODBC 18
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.
"... They ne'er cared for us
yet: suffer us to famish, and their store-houses
crammed with grain; make edicts for usury, to
support usurers; repeal daily any wholesome act
established against the rich, and provide more
piercing statutes daily, to chain up and restrain
the poor. If the wars eat us not up, they will; and
there's all the love they bear us."
-- Shakespeare: Coriolanus, Act 1, scene 1
