ProFox April 2018

profox@leafe.com

36 participants
51 discussions

ODBC or OLEDB to Oracle - Resources?
by Paul H. Tarver 27 Apr '18

27 Apr '18

I have been able to ODBC to an Oracle 11g database in the past for a previous client but I've picked up a new client who is also on Oracle 11g and I'm having a devil of a time to get the ODBC connection string working either from within Foxpro or even from ODBC32.exe Interestingly I'm using EMS's Oracle Manager software and it connects fine and returns queried data perfectly well. But no joy trying to connect directly with ODBC. I'm going to try uninstalling my Oracle ODBC drivers and install the latest version of the drivers to see if that changes anything and if that fails I need to investigate using OLEDB. However, I have not been working OLEDB and am not sure how to proceed with that option. So here's my question: Does anyone have any advice about connecting with ODBC to Oracle or do you have any resources you can point me to regarding using OLEDB to connect to Oracle. Thanks in advance! Paul --- StripMime Report -- processed MIME parts --- multipart/alternative text/plain (text body -- kept) text/html ---

6 11

Re: ON KEY LABEL limitation
by Gene Wirchenko 25 Apr '18

25 Apr '18

At 09:39 2018-04-25, Koen Piller <koen.piller(a)gmail.com> wrote: >Hi, >All News2News topics involving VFP can now be found on GitHub. >f.m. if you put following line in your startup.prg (Startup Program in File >Locations) >On Key Label Alt+D Do "D:\vfp9\debugger.prg" I use: on key label <somekey> set step on and do not need to worry about where the debugger is. This is some of the debugging code I was mentioning on Foxite. When I have a lot of debug output, it is sometimes hard to see exactly where a start point of trying something is. I like: on key label "Ctrl-H" sayhere() with sayhere() having a timestamp: activate screen ? "* "+transform(datetime())+" Here! *" >You have the debugger always under your keystrokes ALT+D in any situation. Stuff like this is useful when experimenting. [snip] Sincerely, Gene Wirchenko

1 0

ON KEY LABEL limitation
by Paul Newton 25 Apr '18

25 Apr '18

Hi all I would like an application to be able to trap a keypress with more than one "modifier", for example CTRL+ALT+S. Obviously I can't do this with ON KEY LABEL but I wondered if there might be another way ... any ideas much appreciated Many thanks Paul Newton

5 11

[NF] Microsoft’s Next OS is Based on Linux, Not Windows
by Ted Roche 25 Apr '18

25 Apr '18

Microsoft’s Next OS is Based on Linux, Not Windows https://www.thurrott.com/internet-of-things-iot/156628/microsofts-next-os-b… That's an eye-catching headline. But they're talking about embedded systems and I(DI)OT machines, secured with Windows Azure Cloud Services. -- Ted Roche Ted Roche & Associates, LLC http://www.tedroche.com

5 11

RE: INSERT INTO...SELECT Issue - SOLVED!!!
by Gene Wirchenko 23 Apr '18

23 Apr '18

At 11:29 2018-04-20, "Paul H. Tarver" <paul(a)tpcqpc.com> wrote: >I'd like to thank the Academy, my 7th grade guidance counselor who gave me >my first opportunity to debug a program and my peers here at ProFox who >voted for me to receive this award! > >Thank you all so much! :) > >PS: Does this mean I can raise my rates now? You can always raise your rates. Collecting can be an issue though. [snip] Sincerely, Gene Wirchenko

3 3

RE: INSERT INTO...SELECT Issue - SOLVED!!!
by Paul H. Tarver 23 Apr '18

23 Apr '18

Apparently, all of the SQL sins covered by the ODBC driver with the '*' wildcards are laid bare when you start trying to expand your SQL command with explicit field statements. Before I got Ted's message, I tried to delimit fieldnames with brackets like '[abc]' and I got a new ODBC error indicating I had created a circular reference. After I got Ted's email I tried again with the backtick '`abc`' and again got the circular reference error. On a whim, I decided to add an alias to the table (ie: sheet) name and then update the field names to the full bracketed column name notation '[xs].[abc]' along with the table/sheet alias in the query and incredibly it worked! Of course I was still in the development environment at the time, so I quickly compiled the new code to an exe and it worked there too! The relevant section of the query with the troublesome field now looks like this: "..., [xs].[3rdPartySickPay] AS xrdPartySickPay,..." Upon running the code with another Excel spreadsheet, I got a new error that was related to the fact that the column name aliases were the same as the original fieldnames unless the first character was a digit. Upon review, I just changed the program so that an underscore is added to the original column name which eliminates the need to check for first digits or keywords or uniqueness. Additional checks can be added going forward, but this is the fastest solution that covers multiple potential issues. Since these column headers are only used during the import process and are discarded after control is returned to the original program, the column name is irrelevant. So I've now have the code working to make Craig Boyd's AppendXLSX.prg work with column headers that start with numeric values instead of alpha characters. I'm sure my code could use some refining, but my modifications are now working in both development and compiled versions. If anyone is interested in getting a copy of the modified version of APPENDXLSX.prg, you can get it at https://pastebin.com/wxDnwFw2. Changes start on line 110 and go through line 170. Or you can just email me at paul AT tpcqpc DOT com. Paul -----Original Message----- From: ProfoxTech [mailto:profoxtech-bounces@leafe.com] On Behalf Of Ted Roche Sent: Thursday, April 19, 2018 3:32 PM To: profoxtech(a)leafe.com Subject: Re: INSERT INTO...SELECT Issue On Thu, Apr 19, 2018 at 4:26 PM, Paul H. Tarver <paul(a)tpcqpc.com> wrote: > > Unfortunately, now the ODBC Driver is throwing an error: > > "[Microsoft][ODBC Excel Driver] Syntax error (missing operator) in > query expression '3rdPartySickPay'." > Unsurprisingly, ODBC thinks it's a dumb name for a field, too. You'll probably need to "escape" it. I'm decades out of ODBC, so I don't recall if ODBC wants you to enclose the field name in single quotes, square brackets or back ticks (that `` funny key in the upper left corner no one ever uses). A web search might yield a suggestion, or you can just try the Usual Suspects... -- Ted Roche Ted Roche & Associates, LLC http://www.tedroche.com [excessive quoting removed by server]

3 5

Fun (not) with the report writer
by Richard Kaye 21 Apr '18

21 Apr '18

OK. Here's my conundrum of the day. I've got an invoice report. There are multiple group bands and multiple potential multi-line objects, and periodically I get just the right combination of text that I appear to get a 2 page report that should fit on one page. In the process of trying to figure out why this is happening, I've tried every trick I can think of including Cathy Putney's stretching of bands with dummy objects at the bottom of the bands, etc. No joy. I keep getting 2 pages. Then I dropped in the _pageno object in the header and my 2 pages are both appearing as page number 1... This has to be a clue but I figure it is time to call on the wisdom of the ProFox crowd as this one is driving me nuts. -- rk

5 10

RE: Facebook api
by Kent Belan 20 Apr '18

20 Apr '18

YES !! Please share when you have it updated !! Thanks so much -----Original Message----- From: ProFox <profox-bounces(a)leafe.com> On Behalf Of José Enrique Llopis Sent: Friday, March 9, 2018 4:40 AM To: 'ProFox Email List' <profox(a)leafe.com> Subject: RE: Facebook api The connection class form, sorry in spanish ------------- My real estate app has code to connect to FaceBook, Google drive, Azure,..., i'm now rewriting the Facebook gateway, I will try to share it when finished. Jose Enrique Llopis -----Mensaje original----- De: ProFox [mailto:profox-bounces@leafe.com] En nombre de Kurt at VR-FX Enviado el: jueves, 08 de marzo de 2018 3:09 Para: profox(a)leafe.com Asunto: Re: Facebook api Interesting Thread you started! To be honest - I heard a while ago from this one person that you could use some kind of programming to do social media marketing via FaceBook. Some way to spread the word about something via FB. But, I have no idea how to do it - and I certainly could use that technique some time soon! -K- On 3/7/2018 9:00 PM, Kent Belan wrote: > Hello, > > Does anyone have code to create a facebook post from your VFP9 app > preferably with a picture ? > > Thanks, > Kent > > [excessive quoting removed by server]

3 3

Re: INSERT INTO...SELECT Issue - SOLVED!!!
by Gene Wirchenko 20 Apr '18

20 Apr '18

At 08:50 2018-04-20, Ted Roche <tedroche(a)gmail.com> wrote: >On Fri, Apr 20, 2018 at 11:00 AM, Paul H. Tarver <paul(a)tpcqpc.com> wrote: > > > > On a whim, I decided to add an alias to the table (ie: sheet) name and then > > update the field names to the full bracketed column name notation > > '[xs].[abc]' along with the table/sheet alias in the query and > incredibly it > > worked! > >I'd like to nominate you for the WAG Of The Week Award! Well done! Seconded. Well done. >Glad you've got it working. Indeed. Sincerely, Gene Wirchenko

1 0

Re: Grids, Again
by Gene Wirchenko 20 Apr '18

20 Apr '18

At 22:32 2018-04-19, "Fernando D. Bozzo" <fdbozzo(a)gmail.com> wrote: >Hi Gene: Those events do not occur after RowColChange because you >can use RowColChange as a general validation event that works for >existent objects and for dynamically added one. Think of it as the >KeyPress of the form, that prevail to the objects Yes, but most of my trouble comes from having to work around BeforeRowColChange. Because the input object's Valid does not fire until after, I have to call the input object's validation from the BeforeRowColChange. I end up having to deal with the quirks of BeforeRowColChange, and there are lots. [snip] Sincerely, Gene Wirchenko

1 0

2026

2025

2024

2023

2022

2021

2020

2019

2018

2017

2016

ProFox April 2018