Search results for query: *

Hi, I tested SYS(2015) with 1'000'000 records created in 540 milliseconds ( ~ 1850 values per millisecond) and NO duplicates were found (see code below). According to the Help file, records created during the same millisecond would be identical. Hence my question: is SYS(2015) generating unique...

Hi, When compiling a project I get the following error How can I determine which CLASS(es) make(s) the calls to these forms? TIA MarK

Hi, Have you ever wondered in how may years aunt Tilly (well known person in Hacker's Guide) will celebrate her 90th birthday? Or how many days you'll still have to work till your retirement? Or how many WEs you already have gone through? Comes in this little program (code below). Enjoy MarK...

Hi, This code executed from a page's click event works fine and the results are correct Select Stagiaires.cName, ; Stagiaires.cGender, ; Stagiaires.dBirth, ; Stagiaires.cEmail, ; NVL(COUNT(Students.dEntry), 0), ; NVL(MIN(Students.dEntry), {}), ; NVL(MAX(Students.dExit), {}), ...

Hi, I have several PCs (W7 pro - 32 bit, W8 - 64 bit, W10 - 64bit). VFP9 with all the SPs and hotfixes is installed on the W7-PC. The run time files are installed on the other PCs. The data reside in a shared folder of a NAS, mapped as S:\. All the PCs access the date on S:\ through a GB...

Hi Strange behavior of SELECT ... GROUP BY ... HAVING ... SELECT cName from stagiaires GROUP BY cName HAVING COUNT(cName) > 1 &&& works SELECT SUBSTR(cName,1,15) as cTrunkName from stagiaires GROUP BY cTrunkName HAVING COUNT(cTrunkName) > 1 &&& yields an error SELECT SUBSTR(cName,1,15) as...

Hi, Would anybody be as kind as to translate this code into VFP. I'm absolutely clueless and would appreciate a lot. Many thanks. MarK /** * Apply Luhn algorithm to compute check digit * This algorithm is used to compute the first check digit * during extended unique id generation...

Hi, This is a students home booking app and I try to find the non booked periods. The data looks like this SELECT cHCode, dEntry, dExit, cName .... into ... vFreeRooms. The result is ordered by cHCode, dExit 1107.05 1/12/2013 15/12/2013 xxxxx 1107.05 1/1/2014 31/1/2014 xxxxx 1107.05...

Hi, I'm confused with a strange behaviour of views. I'm working with one test dataset and one real dataset. I switch from one set to the other with this code in the BEFOREOPENTABLES event of the form's dataenvironment. Local cObjClass, cObjName, cOldDatabase, cNewDatabase, oReference Local...

Hi all, I have an application (EXE) that runs fine on my machine where VFP9 IS installed. But when I port it to my laptop, where VFP9 is NOT installed - but the runtime files ARE - if I want to save a record the error message TIGGER FAILED shows up and the app crashes. Any hints Thansk Mark

Hi, I HAVE to install vfp6 sp5 on a new W7 PC. Unfortunately I don't seem to be able to do it. vfp6 ist installed in C:\VFP6\VFP98... sp5 is installed in C:\VFP6\VFP98\SP5 Tried to run it AS ADMINISTRATOR, in XPMODE, in RUN and even at DOT PROMPT - to no avail. Any hint would be appreciated...