Search results for query: *

Ah yes. Been to Doug Hennigs', Rick Strahl's and Mike Lewis'.

Well, it is now MariaDB technically. *wink* *wink* Where do you get stuff from these legends sir? I have seen a few from them, like during the days when universalthread.com existed. (It is now levelextreme, right? It seems though that it is not so much active for VFP posts anymore. I may be...

Chriss, This is a treasure trove! Thanks bro! Dennis

Chriss, Will try this out sir. So basically, it is using "old-fashioned VFP commands" vs "SQL commands". Thanks as always.

Hi Joe, Agree with you on this in that a permanent table will be provide for a faster and snappier operation. However, this will be an ad hoc type of query, wherein the management checks for any missing invoices that were not posted. So basically, management will query the system for any...

This is confirmed Sir Tore. Code I used (thanks Tore): select nrefno+1 as missing from serial where nrefno+1 not in (select nrefno from serial ) It will detect the first "hole", it will not show if there is a second consecutive missing one. The desired query result should have been 4, 8, 10...

This is cool. Will check this out too. Thanks Tore!

Hi Mark, SELECT * FROM csrAllValues WHERE iValue NOT in (Select iValue FROM csrValues) ORDER BY 1 INTO CURSOR csrMissingValues So, basically, create a cursor for "all values" (csrAllValues), then check against csrValues. Nice! Thanks you sir! Will compare the LOOP / LOCATE algo against this...

Hi Guys, Me again. I need to show the user which invoice numbers are missing given a number range. Suppose the following: Actual Invoice Numbers: 1,2,3,4,5,8,9,11,12,13,15 (each of these numbers are in their respective invoice records) Number Range: 1 to 15...

What ill effect will it have if one just RELEASEs it without setting it to NULL first?

Hi Experts, It's me once again. I have a business object that opens certain cursoradapter (CA) objects. For example, boCustomer will open the Customer CA object and the Salesman CA object. oCustomer = NEWOBJECT( "boCustomer" ) && the Init does the creating of cursoradapters Customer and...

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.