Re: Reverse Wildcard String Comparison

2019-07-02 Thread Ricardo Molina
There's no need for a UDF, VFP has a built-in function LIKE(). Create Cursor depts ( deptnum c(3), Descript c(10), Value i) Insert Into depts ( deptnum, Descript, Value) Values ( "1??", "Dept 1", 99930) Insert Into depts ( deptnum, Descript, Value) Values ( "2??", "Dept 2", 92382) Insert Into dept

Re: [NF] How to Get Black Bars on Monitor

2019-07-20 Thread Ricardo Molina
>From Display Settings, go to Advanced display settings, then Display Adaptor properties. On that form, there's a List All Modes button. For my graphics card (Intel HD 530) I can choose 1024x768 and this gives me black vertical bars. The result might be a bit blurred because it's not native resolu

Re: Working with multi-page PDF files and automatically labeling and later extracting select pages

2019-08-07 Thread Ricardo Molina
Another option available is Ghostscript. It has an exe that you can call from the command line. I used it once to extract text from a PDF but it can also split/merge. Here's something I knocked up to get you started: https://gist.github.com/medalark/31eb67305f0fec81cae1ba4a75407ac4 You need to cha

Re: SQL server connection

2019-08-21 Thread Ricardo Molina
Make sure you are using ODBC Data Sources (32-bit) and in the Drivers tab you'll see which drivers you have for SQL. I have ODBC Driver 17 for SQL Server, SQL Server and SQL Server Native Client 11.0 I prefer to use a connection string rather than DSN so that I don't have to set up a DSN on each cl

Re: [NF] Ideal language/Framework for web-based functionality like off-line views?

2020-05-10 Thread Ricardo Molina
I'm not saying this would be your ideal solution but if you're OK with NoSQL databases, it's worth having a look at Couchbase. It's commercial, but there is a free Community Edition. In the cloud, you will have Couchbase Server. On the client, install Sync Gateway which runs as a service and lets

Re: [NF] .NET Core build to runtime 3.1.5 with SDK for 3.1.6 installed - Possible?

2020-07-30 Thread Ricardo Molina
> 1 - Is there a way to build to a lower release of the runtime? Create a global.json file and specify the SDK version that you want to use. https://docs.microsoft.com/en-us/dotnet/core/versions/selection On Tue, 28 Jul 2020 at 18:11, Tracy Pearson wrote: > My searches on the internet are fe

Re: [NF] Replacing IE's "Export to Excel" in Edge

2017-10-10 Thread Ricardo Molina
> > This might be a good short-term solution until I develop an > export-to-CSV or -Spreadsheet-ML solution and roll it out. I don't > want to restrict the clients to a single-browser solution if I can > avoid it. > > An alternative is to pull the data from within Excel, so you don't have to create

Re: VFP: Task Scheduler

2018-06-12 Thread Ricardo Molina
If it's a modal dialog, then you can use SYS(2335) Unattended Server Mode and trap it. Ricardo. On 12 June 2018 at 11:44, Ted Roche wrote: > On Mon, Jun 11, 2018 at 6:35 PM, Fred Taylor wrote: > > If you're using drive letter mappings, those mappings do not exist for > the > > Task Scheduler.

Re: SQL MIN() et VFP MIN()

2014-10-29 Thread Ricardo Molina
You don't have to make as many comparisons as Paul suggested, make 3 comparisons, then 2 then 1: SELECT DISTINCT ta.codtarif AS tarif, ; sv.clef AS clefserv, sv.salle, sv.capacite AS servdispo, sv.libelle AS service, ; sal.capacite AS salledispo, sal.libelle AS nomsalle, ; ta.capacite AS

Re: [NF] NuSphere PhpED

2014-11-03 Thread Ricardo Molina
I've not had experience of NuSphere but I have used PHPStorm for debugging which worked well for me. It has a 30 day trial. Other products you might want to consider: http://www.sitepoint.com/best-php-ide-2014-survey-results Ricardo On 31 October 2014 20:36, Virgil Bierschwale wrote: > Anybo

Re: Formatted Browse Window

2014-11-05 Thread Ricardo Molina
How about trying BROWSE NORMAL >From the help file: NORMAL Opens the Browse window with its normal default settings, such as its colors, size, position, title, and control options (GROW, FLOAT, ZOOM, and so on). If you omit NORMAL, and the current output window is a user-defined window with its o