Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations TouchToneTommy on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  1. MathiasB

    oAuth 2 protocol, Microsoft Azure cloud services

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

    Outlook Template replace text

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

    Missing Column Encryption checkbox on ODBC setup on Win 11

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

    Missing Column Encryption checkbox on ODBC setup on Win 11

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

    Missing Column Encryption checkbox on ODBC setup on Win 11

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

    Displaying dates only part of datetime (from sql server)

    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 :)
  7. MathiasB

    Displaying dates only part of datetime (from sql server)

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

    Displaying dates only part of datetime (from sql server)

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

    Tableupdate() on updatable view not working

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

    Tableupdate() on updatable view not working

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

    Deploying ODBC connection

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

    Deploying ODBC connection

    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'...
  13. MathiasB

    Incremental data fetch from sql server to a vfp client

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

    Incremental data fetch from sql server to a vfp client

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

Part and Inventory Search

Back
Top