Search results for query: *

I find convinient to just code my own com component in c#. Then use that in vfp.

MathiasB Programmer Aug 21, 20191301GB From what I recall, we had to use courier new or one of those plain text format fonts

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...

That's great Mike I'll have a play with that cheers KR Mathias

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...