ProFox

profox@leafe.com

2704 discussions

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

Re: "Cannot load 32-bit DDL wwipstuff.dll"
by Gene Wirchenko 20 Apr '18

20 Apr '18

At 23:03 2018-04-18, Jerry Wolper <jwolper(a)swanzoco.com> wrote: > > Win10, 674-bit fully updated. > >I'm glad to hear your problems have subsided. Those 674-bit systems can be >awfully temperamental. Well, his hardware and software issues are better, but now, he has smartass punsters. Sincerely, Gene Wirchenko

1 0

FoxinCloud 2.26.2 is released
by Thierry Nivelet 20 Apr '18

20 Apr '18

More details on blog post… http://foxincloud.com/blog/2018/04/19/FoxInCloud-2.26.2-is-released.html -- Thierry Nivelet FoxInCloud Give your VFP app a second life in the cloud http://foxincloud.com/ VisitFoxInCloud Blog <http://foxincloud.com/blog/> WatchFoxInCloud Marketing Videos <https://www.youtube.com/channel/UCUzzqO5375-fA7dLDds-wOQ> WatchFoxInCloud Technical Videos <https://www.youtube.com/channel/UCrEohAtbuf3uOXBH2pjp5Vw> Stay tuned onFoxInCloud Roadmap <http://foxincloud.com/roadmap.php> Learnhow to use FoxInCloud <http://foxincloud.com/how-to.php> DownloadFoxInCloud Adaptation Assistant <http://foxincloud.com/download.php> for free

1 0

Re: "Cannot load 32-bit DDL wwipstuff.dll"
by Jerry Wolper 20 Apr '18

20 Apr '18

> Win10, 674-bit fully updated. I'm glad to hear your problems have subsided. Those 674-bit systems can be awfully temperamental. -Jerry --- StripMime Report -- processed MIME parts --- multipart/alternative text/plain (text body -- kept) text/html ---

2 1

Grids, Again
by Gene Wirchenko 20 Apr '18

20 Apr '18

Hello: I now have the time to dig into grids again. I hope this lasts long enough for some real results. I took a look yesterday at "1001 Things ...", chapter 6 (Grids: The Misunderstood Controls). The number of gotchas is quite high. I find one particular thing especially weird. Why, oh why, does BeforeRowColChange fire before the active cell's Valid and LostFocus fire? To me, it seems obvious that the most likely reason why one would deny a row-col change is because the active cell's validation failed. I will go further: why else would one deny a row-col change? My previous approach has gotten horribly baroque and still was not enough. There are nasty things happening such as 1) the current control's value not being assigned until after the BeforeRowColChange, 2) the validation using the previous value when I try to correct after some errors (but not always) but only for the first time, and it goes on. Correct one problem, and something else breaks. I am wondering if anyone would be willing to write a simple example of a grid IN CODE to a spec I provide. This is the example that I am trying to implement. Maybe, I am overlooking something crucial. I sure have not seen any examples of grids other than trivial. Sincerely, Gene Wirchenko

2 1

Jump to page:

2026

2025

2024

2023

2022

2021

2020

2019

2018

2017

2016

ProFox