Recent content by MathiasB

You are right just running the right query would be best practice. But it is bound to a grid on vfp form with lots of filters i wanted to keep it that way. One requery() does the job.

Yes that's correct only one of those produces and results. I tried a union it's as fast as running the single query. I wasn't convinced so I posted the same question on stackoverflow. Apparently union is the commonly known solution. I wanted the query to remain insi compliant so union it is.

Solution is split the query into 2 and do a Union

This was my question: Evaluating one side of OR in my query. I have a SQL Server query with 2 separate complex filters. The intention to combine them in one as follows: Declare @BoolSet Bit = 0 Select Distinct Top (1200) a.called, a.engineer, a.response, a.call_no From [tablea] a Inner...

Resolved

This is great Tom, Thank you so much. I will put it to test and roll it out there where the jury is. Much appreciated sir!

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