Search results for query: *

Hi all I have a function that works well most of the time. I have no clue who wrote it, it just works. The start looks like this: IsExeRunning() oLocator = CreateObject('WBEMScripting.SWBEMLocator') oWMI = oLocator.ConnectServer()...

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

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

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