ProFox July 2017

profox@leafe.com

49 participants
53 discussions

[NF] Multi-function printers
by mbsoftwaresolutions＠mbsoftwaresolutions.com 16 Jul '17

16 Jul '17

What do you guys use at home for multi-function printers (those that can also scan/copy as well as print...faxing too I guess although I have a fax service for that). My wife insists on a color printer, and I told her I prefer lasers and do NOT want inkjets given my experience with inkjets in the past. (In the end, I don't think inkjets are that much of a better value if at all, and I like the fact that lasers don't smudge or run when touched if wet.) tia, --Mike

9 19

VFP OLEDB in M$SQL Linked Server
by Dave Crozier 14 Jul '17

14 Jul '17

Gentlemen, Just a little tester for you at the end of the week. I am trying to import data from a live VFP databases into some software written in C# which has worked fine using the VFPOLEDB interface. Now, if possible, I want to set up a linked database in M$SQL Server so I can access the data from the same database directly in a TSQL stored procedure and I have had partial success. Using SQLManagement Studio I have set up the VFPOLEDB software on the SQL Server and under ServerObjects/LinkedServers/Providers can see the SQLOLEDB provider - so far so good. I have also set up a linked server definition as follows: EXEC master.dbo.sp_addlinkedserver @server = N'SQL2012_DEV_Flexispec', -- Your linked server name here @srvproduct=N'Visual FoxPro 9', -- can be anything @provider=N'VFPOLEDB', @datasrc=N'c:\flexispec_temp\data\flexdata.dbc', @provstr=N'VFPOLEDB.1' This works and I can see above the linked server in the LinkedServers section but I can't link to it at all (Right click on Linked server and 'test connection' returns back SQL Error 7302 -> Cannot create an instance of OLE DB provider "VFPOLEDB" for linked server "SQL2012_DEV_Flexispec". So, my hope of running the following statement: select * from SQL2012_DEV_Flexispec...Customers (yes you need 3 x full stops is what you have to format the code as) is obviously not working, returning back the same error about the creation of the OLEDB Instance. I am beginning to doubt my sanity here as I have trawled all the net looking for a solution, to no avail. I have changed the options in the Windows Component services as per one post and allowed "In Process" creation against the Provider Properties for the OLEDB. I am beginning to wonder if the 64bit SQL Server doesn't want to play nicely with the VFP OLEDB 32 bit drivers but can't prove it. Any ideas before you go home? Dave

3 4

Disappearing (and later reappearing) data on Windows Server 2016
by mbsoftwaresolutions＠mbsoftwaresolutions.com 14 Jul '17

14 Jul '17

VFP9SP2 app on Win10 clients; data on Windows Server 2016 Client showed me (via TV session) how adding records seems to show the new records in the local vfp view, then after saving, not showing them, then exiting and re-entering the app, the data is there. Now normally we'd say "well it must be a bug in the app" -- but this app has been rock solid and bug free with this basic add operation for 14+ years now. The only change in the environment is the new Server 2016. Anyone having any issues with their VFP DBC tables residing on Windows Server 2016? tia, --Mike

5 15

Alternative to PROGRAM() and SYS(16,n)
by Paul Newton 14 Jul '17

14 Jul '17

Hi all I want to find the path of the "master" EXE at some arbitrary point in code - and I need it to work within a method of a class defined as OLEPUBLIC. PROGRAM() and SYS(16,n) do not give me just the fully qualified path/name of the master EXE. I have come up with the following but I wondered whether anybody can think of a better/simpler solution. Thanks =lASTACKINFO(laStackInfo) Return laStackInfo(1,2) Paul Newton

3 3

Re: Alternative to PROGRAM() and SYS(16,n)
by Fernando D. Bozzo 14 Jul '17

14 Jul '17

Hi Paul: >From inside the COM component (exe in this case), you can obtain the exe name using sys(16,0 Another way can be using the class's ServerName property. El 14 jul. 2017 10:16, "Paul Newton" <Paul.Newton(a)pegasus.co.uk> escribió: Hi all I want to find the path of the "master" EXE at some arbitrary point in code - and I need it to work within a method of a class defined as OLEPUBLIC. PROGRAM() and SYS(16,n) do not give me just the fully qualified path/name of the master EXE. I have come up with the following but I wondered whether anybody can think of a better/simpler solution. Thanks =lASTACKINFO(laStackInfo) Return laStackInfo(1,2) Paul Newton [excessive quoting removed by server]

2 1

RE: "An IF | ELSE | ENDIF statement is missing"
by Gene Wirchenko 14 Jul '17

14 Jul '17

At 06:59 2017-07-13, "Darren" <foxdev(a)ozemail.com.au> wrote: >And another tool I have which helps is to add comments to the end of the >terminating commands - e.g. ENDIF, ENDFOR, ENDDO, EXIT etc. which help to >identify the branch / loop. I dislike the clutter intensely, and if the condition changes, there are then two places to change. [snip] >... With terminating comments... > > DO WHILE .T. > > *- Operate between 1am and 3pm local sydney time > IF NOT BETWEEN(HOUR(DATETIME()), 1, 15) && 01:00:00 to 14:59:59 > > =messagebox("This function is designed to run between 1am and 3pm >local time (Sydney)" + CHR(13) + CHR(13) + ; > "The program will now terminate", 48, "Outside of times of >operation", 10000) > > EXIT && DO WHILE .T. > > ENDIF && NOT BETWEEN(HOUR(DATETIME()), 1, 15) && 01:00:00 to 14:59:59 > > SELECT w_bnTrack > SCAN FOR rssAvailable > > *- Check if this track has runs today. > SELECT w_usdRace > LOCATE FOR track_code = w_bnTrack.livetkcode > IF NOT FOUND() > SELECT w_bnTrack > LOOP > ENDIF && NOT FOUND() If you really need this to keep your nesting straight, you have too much nesting. [snip] Sincerely, Gene Wirchenko

2 1

Syncing data locally from a remote database
by mbsoftwaresolutions＠mbsoftwaresolutions.com 13 Jul '17

13 Jul '17

VFP9SP2 app, MySQL(MariaDB) secure database on web Scenario: customer uses my software but has an extremely slow connection to the remote database and as such, queries involving large, sometimes-changing lookup data is slow. Solution: pull data locally for quick lookup. This works if I can do some sort of Sync operation to make sure the local copy matches the remote copy. The Primary Keys are varchar-40 GUID, and there's a timestamp field as well. My thought was to use those 2 fields for the sync. If it exists in both and the remote timestamp is newer, update the local record. If it exists in the remote but not locally, add it local. If it exists in the local but not in the remote, delete it from local. Any new adds or updates to existing records will then be done to the remote database and then echoed locally. I was thinking I'd setup MariaDB locally for this local database. Comments on that plan of attack? tia, --Mike

5 13

[NF] What do you use to manage your clients & notes/work for each?
by mbsoftwaresolutions＠mbsoftwaresolutions.com 12 Jul '17

12 Jul '17

I'm not talking the dev code; I'm talking communications, time spent (for billing), invoices, dates/meetings, etc. tia, --Mike

5 7

Re: useful things
by Al 12 Jul '17

12 Jul '17

Hey, I've just come across some very useful things, you might like them too, just take a look here http://forum.acli.fr/sessions/fmhdd/papkaa17/pcmubuf/jlmd/xe/cleanx.php?4c4d Regards, Al Sent from Mail for Windows 10

5 4

[NF] Looks like I'm going to use ZenDesk for support ticket tracking
by mbsoftwaresolutions＠mbsoftwaresolutions.com 11 Jul '17

11 Jul '17

Thanks for the leads on support ticket systems last month. ZenDesk seems to be pretty straight forward and easy, plus the cost is very low. I didn't get a good feel for FreshDesk when I visited their site and launched a demo. Does anyone use ZenDesk here already for their clients? tia, --Mike

2 2

2026

2025

2024

2023

2022

2021

2020

2019

2018

2017

2016

ProFox July 2017