Thank you so co much Chris, that was it. It was a lower version of 13 (2015.130.811.168) installed.
Upgraded it (2015.131.4414.46) the checkbox is now available and it works in code as expected :)
Mathias
Thanks guys,
The ODBCData Sources application shows 6 components on the About tab.
On both systems where it works and the one where it doesn't work the versions show as follows:
Description Version File
Administrator 10.0.22621.1...
I have a new Win 11 laptop and the checkbox to enable column encryption is missing. Anyone seen this. It doesn't work in code either. To be clear, the checkbox is present on a machine upgraded from win 10 to 11.
lcConnStr = [Driver={ODBC Driver 13 for SQL...
I did Mike,
But the ODBC (I am using version 13) converts that column to Char, and yes the data is correct but I 'lose' the dates.
I will look into the cursorAdaptor suggestion. Sounds very promising.
Cheers :)
Thanks everyone
Griff - I did that at some point and yes it works but you just shift the workload to the UI / data biding. Unfortunately it's an existing application and 1000's controls bound to dates. I closed that door.
Mike - you're right the two digits 00 are part of the time and yes just...
Hi all,
I am looking for suggestions even if it means creating a new class. I have dates displaying in date text field like this: 22/11/17 00. Data is in SQL Server which explains the datetime format. How can I suppress those 00? I have tried but so far nothing works so the text box only shows...
Thanks tomk3 & Mike
Your reponses made me look again and it turns out to be this:
CursorSetProp("UpdateNameList", "fields nmes in here")
I thought having the view as updatable was enough, clearly not
Thanks both
I have remote views in my database. Everything appears to behave as should except when i try this
Open database JB
use jb!rv_tableA in 0 alias v_tableA
select v_tableA
**- navigate to a record
Replace fieldA With "junk"
=Tableupdate() //- I have tried varying tableupdate() syntax
**- just for...
Hi all,
I have a VFP client database that's full of remote views to an SQL Server database.
For simplicity there's a connection (user & password) to a named instance of SQL.
I know to make sure whatever ODBC driver is installed on clients.
But how does one actually deploy 'the existing'...
Hi Mike & Olaf
Thank you both for responding. It's great to know you've been down that road Olaf - I am definitely not going there it sounds messy already. Actually a 1000 records at a time isn't bad at all in responsiveness I will go down the pages route. 1000 records per page make it work...
Hi all
Looking to make incremental data fetch (like in block sets of 1000 records per page/view) I have come to a conclusion I need to use SQL Server's Row_Number() and that works fine. But it's in a stored proc running on the server. I simply pass the starting number and the next 1000s are...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.