Search results for query: *

if he makes replies like how he does, I am sorry, but he is definitely not contributing to the un-aging of VFP:.

Steve, IMHO, maybe, I guess it's a difference of upbringing/culture/value sets? No judgement here okay? I was tolerant at his hubris and inconsiderate remarks. And in your words, I simply "tolerated". When I read GGUEROS's reply to Chris's brash comments, I simply seconded the same...

Welcome to the club GGUERA! And for a while I thought, it was just me. People who really want to help should be kind as well. Not brash, insulting, and full of hubris. Cheers! Romans 12:16: "Be alike affected to each other: not aiming at high things, but accommodating yourselves to...

Well, that is why I stated or expressed apologies for my ignorance. Once again, my sincerest apologies if your mental stratosphere is beyond mine.

Noted on this sir. Do you think it is a good idea to keep a table of MONTHS in the database to forego generating it each and everytime?

Zazzi, Thanks for your reply. Pardon my ignorance, but the code is about inserting the actual sales totals per month?

In MySQL or MariaDB, in lieu of NVL(), I can use IFNULL(), right? Is it a good idea to just keep a "static table" of the 12 Months in my production database? Thanks.

Hi Guys, I guess the thread title is pretty self explanatory. I need to show sales summary of a customer by monthly totals, including months when there are zero sales. Like so: January - P34,000 February - P44,500 March - P0.00 April - P123,500 May - P0.00 ...... etc.... Thanks in advance...

How do you fetch your data from MySQL? SQLEXEC()? Do you use CursorAdapters (CA)? In CAs, there is a property called CursorSchema, wherein you tell VFP which columns/fields will have what field data type.

So far, and I am glad I am done with this, I have used the following combination as my safe, conservative setup: MySQL Server 5.7.40 MySQL ODBC 8.0.31 Good riddance though. I backed up all my stuff and just did a clean install of Windows 11 on my laptop and installed: MariaDb Server 11.7.2...

Hi gguera, Allow me to share my very own horrific experience. I have been using VFP with MySQL 5.7 and ODBC 3.51 for the longest time. When I tried to level up to MySQL 8 and ODBC 8, all hell broke loose. Classes which I have been using for decades suddenly exhibit erratic behaviour, and...

How about custom page sizes like maybe a special paper for pay slips? If we set them at our VFP REPORTS designer, will this be complied with when "Microsoft Print to PDF" is used? Thanks.

That is going to be my next level up. Have you tried dabbling into VFPA 64 bit sir? If so, any feedback favorable or otherwise? I read somewhere that modules like VFPEncryption.FLL and FoxyPreviewer.app will not run anymore? (this is a bummer; are there alternatives to these that you know?) Am...

Will you be shifting to MariaDB as well? Or have you already for a long time? As for me, I am trying out all features and functionalities on a project I am working on on a test laptop with Windows 11, MariaDB 11.7.2 and ODBC 3.2.5. So far, so good. It is basically more seamless, hassle free...

Hi Chriss, Thank you for your intricate example. Would the following be "sound design"? All my apps have a global variable oApplication, an object variable from my Application class, which has object references to my Security an Connection manager classes, among others. My data entry form...

Chriss, Just to share sir: ? SQLEXEC(h,'/* */' ) && this worked; there should be a space between the asterisks ? SQLEXEC(h,'/**/' ) && this did not work; if there is no space between the asterisks ? SQLEXEC(h, [DO '/**/'] ) && this worked; even if there is no space between the...

Hi Atlopes: This did not work: m.ActiveConnection = SQLEXEC(m.ConnectionHandle, "-- " + 0h0d0a) == 1 But this did: (I had to add a DO): m.ActiveConnection = SQLEXEC(m.ConnectionHandle, [DO "--"] == 1 Thank you for being kind.

Chriss, For now, I will use your suggestion: SQLEXEC(h,'Do @dummy=0') I get your point regarding having empty non-queries. I just hate the idea of having to programmatically erase/delete the resulting returning cursor each and every time my system queries this. I use this in a timer event...

Hi, Pardon my ignorance, but how do you execute a comment sir? I tried this first in Workbench, but no response or feedback. Thanks.

Hi Guys, With MySQL, I use "DO 1" to check for the server's online status. Works like a charm. But MySQL 8.x has caused me so much pain by way of unknown errors I cannot seem to understand and correct. So, I tried MariaDb, installed the latest GA todate, 11.7.2 and used the latest ODBC 3.2.5...