ProFox November 2017

profox@leafe.com

45 participants
61 discussions

[NF] Bluetooth option in laptops
by mbsoftwaresolutions＠mbsoftwaresolutions.com 20 Nov '17

20 Nov '17

I'm spec-ing out my new laptop. One option comes with Bluetooth. I don't think I've ever used BT in my laptop nor will I in the future from my pov, but wanted to ask if anyone here takes advantage of BT in a laptop and how they do? tia, --Michael

8 13

16GB RAM vs 8GB in laptop
by mbsoftwaresolutions＠mbsoftwaresolutions.com 20 Nov '17

20 Nov '17

Is it ridiculous to double to 16 when 8 is probably great already on a new laptop with SSD hard drive?

4 4

[ADMIN] was Fwd: ✈hey! what's that?
by Ted Roche 20 Nov '17

20 Nov '17

Ed: Could you unsubscribe Al, please? I'm afraid he's not posting any more. RIP, Al. ---------- Forwarded message ---------- From: Al <al(a)gatwicksoftware.com> Date: Fri, Nov 17, 2017 at 7:23 PM Subject: ✈hey! what's that? To: profoxtech(a)leafe.com Hey! I must demonstrate something that I cannot understand, can you notify me what's that? Take a peek here [clipped] Al From: profox [mailto:profox@leafe.com] Sent: Friday, November 17, 2017 6:23 PM To: al(a)gatwicksoftware.com Subject: Survivors My current LHBS is sort of like this. I'll walk in with a recipe, consisting of what I would think are fairly common malts, and he won't have them. then I have to try to re-work my recipe with what he has on hand, or come up with a whole new recipe on the spot. I want to avoid that for my customers. It won't be possible to keep everything on hand, but I do want to have the most common ingredients available all the time. Sent from Mail for Windows 10 [excessive quoting removed by server]

4 3

Hex
by Matt Wiedeman 18 Nov '17

18 Nov '17

Hi everyone, I am working on a project where I need to insert SAP data into a vendor SQL Server database. To do so, my script will need to read a pipe delimited file down, do lookups in multiple other tables, and insert new rows into three tables. Most of the data I need uses normal tables with a key so it is pretty easy. However, one of the configuration tables needed uses a field that has an image field type. The field contains hex code. The hex string in each is over 8000 characters. I can't find a good way to parse this field out, though. Somehow, when the application users make changes or add a new record, it stores it in hex format which seems crazy but I confirmed this with the vendor. I can only guess that other languages do this more easily than TSQL. I have tried many variations of convert or cast to do this but am coming up empty. This website<https://www.csoft.co.uk/developer/support/hex-converter> does an ok job of converting the string but it has a bunch of garbage in it. So, using this list<http://www.theasciicode.com.ar/ascii-table-characters.pdf>, I created a little FoxPro program to read two characters at a time and store this to a variable. I could duplicate this using TSQL if it worked. Anyway, doing this is a little better than the converter sites but still not really useable. There are codes like: NULL, BEL, STX, ACK, SOH, STX, EOT, BS, HT, etc. that I'm not sure what to do with. I tried putting a space or dash in for these but that does not help. I would like to parse this hex string into a new table. Any suggestions? --- StripMime Report -- processed MIME parts --- multipart/alternative text/plain (text body -- kept) text/html ---

4 4

SQLite Problem - DSN-less Connection Doesn't Create A File
by Paul H. Tarver 18 Nov '17

18 Nov '17

Ok, I give up. I've been using Whil Hentzen's book "Using SQLite to Bypass The 2GB .DBF Filesize Limit" for a project I'm trying to develop and I have some weird behavior going on. I'm trying to use SQLite3 to deal with an import file that will have 350+ columns. I've been using the the examples and doing everything via the SQLite3.exe command prompt works as documented. I've also worked out a SQL script using SQLite Expert to drop a table if it exists, create an empty table and the corresponding indexes. Up to this point everything worked as expected. However, now I'm trying to migrate this code into VFP9 using SQL Pass-Through, but here's what I'm running into: If I create a DSN using the ODBC drive and then use SQLCONNECT('dsn-name'), the connection is made and if the database file "trnslate.db" doesn't already exist it is created in the folder I designated in the Database Name field of the DSN. However, if I create DSN-Less connection (SQLSTRINGCONNECT) using the connection string I get back using SQLGETPROP(lnhandle,"ConnectString") , I get a handle, but it is to a "trnslate.db" database that doesn't contain the table I previously created and if the "trnslate.db" table doesn't already exist in the designated folder, it is NOT created on the hard drive. However, it apparently IS created in memory. I can create a table and issue a select command and get back the results I expect, but a database file is NEVER physically created on the hard drive which I need to do for my purposes. Here is some sample code to see if you can tell me where I'm going wrong: liH = SQLSTRINGCONNECT( "DRIVER=SQLite3 ODBC Driver;" + ; "DBNAME=T:\trnslate.db;" + ; "PWD=;" + ; "StepAPI=0;" + ; "SyncPragma=;" + ; "NoTXN=0;" + ; "Timeout=;" + ; "ShortNames=0;" + ; "LongNames=0;" + ; "NoCreat=0;" + ; "NoWCHAR=0;" + ; "FKSupport=0;" + ; "JournalMode=;" + ; "OEMCP=0;" + ; "BigInt=0;" + ; "JDConv=0;" + ; "TraceFile=;") SQLExec(m.liH, "create table EmplImport (id int primary key, dummy varchar(50));") SQLExec(m.liH, "insert into EmplImport (id, dummy) values (1,'testing');") SQLExec(m.liH, "select * from EmplImport;",'dbtest') SQLDISCONNECT(liH) I've tried this process about hundred differ ways with different combinations of paired keys in the connection string without success. I've used a DSN-less connection program that I wrote which works perfectly with SQL, MySQL and others and though I never fail to get a handle; the database file never physically exists in any path on the hard drive. Complete searches of my hard drive for the database name yield no results The code above gives me a value for m.liH which is greater than zero, I never get errors thrown, I always get a valid handle, the table can be created, the data inserted and I get a cursor back from the select named 'dbtest' with the exact data inserted on the previous line. I've been on this for about six hours and I'm no closer to making this work as a DSN-less project even though Whil seemed to imply in the book that this was his preferred method of doing things. HELP! Paul H. Tarver Email: <mailto:paul@tpcqpc.com> paul(a)tpcqpc.com --- StripMime Report -- processed MIME parts --- multipart/alternative text/plain (text body -- kept) text/html ---

7 22

✈hey! what's that?
by Al 18 Nov '17

18 Nov '17

Hey! I must demonstrate something that I cannot understand, can you notify me what's that? Take a peek here http://www.manejodenematodos.com/cry.php?UE9wcm9mb3hAbGVhZmUuY29t Al From: profox [mailto:profox@leafe.com] Sent: Friday, November 17, 2017 6:23 PM To: al(a)gatwicksoftware.com Subject: Survivors My current LHBS is sort of like this. I'll walk in with a recipe, consisting of what I would think are fairly common malts, and he won't have them. then I have to try to re-work my recipe with what he has on hand, or come up with a whole new recipe on the spot. I want to avoid that for my customers. It won't be possible to keep everything on hand, but I do want to have the most common ingredients available all the time. Sent from Mail for Windows 10

1 0

[NF] Windows 10 Creators Edition Fall Update (W10CEFU)
by Ted Roche 17 Nov '17

17 Nov '17

Windows 10 Creators Edition Fall Update, the SP5 to Windows 10, or Windows 10.5, if you prefer, is coming to an office near you, real soon now. Be ware. [Editor's note: missing apostrophe in Creators is MSFT, not me.] https://blogs.windows.com/windowsexperience/2017/09/01/create-and-play-this… Inking! 3-D! Mixed Reality! Microsoft is excited! about their New Release! of their Update! With Lots! of Exclamation Points! But apparently, they don't need to support clients with real business apps, as the update seems to have broken a bunch of stuff so far this week: 1) A DRM package on a co-worker's machine threw Registry entry errors. (Part of an add-on to a Fox app, so may this is on-topic). Re-install, re-register seemed to resolve it. 2) A legacy, no-longer-supported version of a freely-distributable Cisco VPN product lost its Registry entries (hmm, a pattern there?) and had to be re-installed (hope you kept the old installer!) and a Registry entry edited in order to work. 3) Some 32-bit ODBC entries (kept in the Registry! Surprise!) were no longer valid and needed to be re-created. 4) On Twitter, Phil Borkholder reports, "And delays files from actually being deleted... via Windows Defender... interfering with the IF FILE() ... command." So, good news, Fellow Fox-ettes! W10CEFU means full employment for those of us of supporting Windows! -- Ted Roche Ted Roche & Associates, LLC http://www.tedroche.com

2 1

CompuServe forums - end of an era.
by Alan Bourke 16 Nov '17

16 Nov '17

"Dear Forum friends and family, We regret to inform you that the Forums will be removed from the CompuServe service effective *December 15, 2017*. For more than two decades, the CompuServe Forums paved the way for online discussions on a wide variety of topics and we appreciate all of the participation and comments you have provided over the years.All of your email, news, weather, sports, and entertainment information will remain available to you after this change. We are constantly evaluating the content and services that are available through the service, and look forward to bringing you new content and services in the future.Sincerely, The CompuServe Team" I have fond memories of the fantastic help I got from people on CompuServe back in the late 90s, when I was learning Visual FoxPro. -- Alan Bourke alanpbourke (at) fastmail (dot) fm --- StripMime Report -- processed MIME parts --- multipart/alternative text/plain (text body -- kept) text/html ---

6 5

VFP9 can run on Windows Server 2016?
by Fred Taylor 15 Nov '17

15 Nov '17

Does anyone know if VFP9 .EXEs can run on Windows Server 2016? I don't mean just access data on the server, actual run a runtime .EXE application on the server itself/ Thanks, Fred --- StripMime Report -- processed MIME parts --- multipart/alternative text/plain (text body -- kept) text/html ---

6 12

[NF] Open systems Drive you crazy
by Stephen Russell 15 Nov '17

15 Nov '17

Great watch here. Super Hacker George Hotz: I Can Make Your Car Drive Itself for Under $1,000 https://www.youtube.com/watch?v=aqdYbwY9vPU I like how he looks at a problem. -- Stephen Russell Sr. Analyst Ring Container Technology Oakland TN 901.246-0159 cell --- StripMime Report -- processed MIME parts --- multipart/alternative text/plain (text body -- kept) text/html ---

14 26

2026

2025

2024

2023

2022

2021

2020

2019

2018

2017

2016

ProFox November 2017