Chriss,
I had an OLD form class used for generating reports wherein I use as part of my Validation routine the 'direct addressing' of a form control that has an invalid value.
The Validate routine will go through all controls (textboxes usually). If the Value is invalid, I passed the offending...
Hi Guys,
Is there some VFP function or Property that will return the "complete address" of a form control?
This is what I mean:
Suppose I have a textbox named txtFirstname, which is inside Page1 of pgfMain found in a form. How can I get its complete address...
Well, for MariaDB, from hereon out, I will use "ORDER BY id" then.
Again, kinda weird, coz MySQL has always shown the resulting rows already arranged.
Thanks!
Well, for MariaDB, from hereon out, I will use "ORDER BY id" then.
Again, kinda weird, coz MySQL has always shown the resulting rows already arranged.
Thanks!
The reason I used sequential GUIDs is just to make sure they are ordered in the "natural order" of entry of the invoice details (child) rows.
This has worked for me ever since I used MySQL, as a "workaround" to our VFP table record number.
This is really strange. Ever since I have used MySQL, I have never used "ORDER BY id" to make sure they are in the 'natural' sequential order.
No worries though. I will explicitly put "ORDER BY id" from hereon out since I am now with MariaDB.
Thanks.
Kindly check my reply to mJindrova.
I have been using MySQL and it always shows the records sequentially - by the sequential GUID - without the need to put "ORDER BY id". It is only when I migrated to MariaDB recently that I noticed this behavior. If this really is the default behavior, then no...
Hi,
If you execute the same using MySQL, it orders it sequentially with out adding an "ORDER BY id".
Strangely though, if you:
select * from SODTL
without any WHERE clause, it will arrange it "correctly" - sequentially.
Only when you place a WHERE clause will it show the rows in reverse order.
Hi Guys,
I use sequential GUIDs for both my Invoice header and detail tables. Ever since I moved to MariaDb, it was only now that I noticed that if I do a select of the invoice detail rows of a particular header row, MariaDB shows the rows in REVERSE order! I have to explicitly add a "ORDER BY...
Bill,
Hi. I am the same guy who asked you about whether you have Youtube video tutorials on your creation on Facebook or not.
Perhaps you can guide me and maybe I can create them Youtube videos to help propagate your creation sir?
Cheers!
Hi EinTerraner,
SET PRINTER TO <PDfCreator>
REPORT FORM <YourOutputName> TO PRINTER
<YourOutputName> is the name of the .FRX (report form), right?
Suppose I need for the name of generated PDF to be "Customer 0009 - Receipt.pdf", where shall specify this in order for the PDF to be created with...
Hi Joe,
I do use FoxyPreviewer, albeit the free version. I didn't know that it can output to a PDF. I thought it was a better REPORT FORM PREVIEW interface.
Perhaps you can provide me a few snippets to start off?
Thanks!
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.