Thanks guys, but I can't change my database system because all of the rest is working perfectly. I can't use MIN() or MAX() because "ObsSol" is a text column. However, how can I use DISTINCT? Can You give a example PHV?
Hello guys! I would like to include a field in a select but don't use it with group by (forgive my english...). This is my select:
"SELECT NumSol,NumCot,NumPed,ObsSol FROM E405Sol WHERE CODEMP = nCodEmp AND NUMCOT = nNumCot AND CODPRO = aCodPro AND CODDER = aCodDer GROUP BY...
Hello! I'm from Brazil so, forgive my english. I have a problem: I installed WMI in Windows 98 to get some informations, and one of this is the name of workgroup. I get the computer name, but when my function (thanks mgagnon!!!) trys to get the workgroup name I get this error message: "OLE error...
THANKS A LOT MIKE!!!! It was so helpfull!! Sorry, I have more one doubt: I run it on Windows XP but in Windows 98 it didn't work. Would you tell me how can I adapt it to Win98 (with VFP9)? One more time, thanks a lot!!!
Hello! I want to use the function ANETRESOURCES() to get the name of computers in a workgroup. But ANERRESOURCES() needs to specify the name of workgroup. Searching for a function to do it, I found a API named NetGetJoinInformation. Is it the better function to get the name of workgroup? How can...
Hello! I want to use the function ANETRESOURCES() to get the name of computers in a workgroup. But ANERRESOURCES() needs to specify the name of workgroup. Searching for a function to do it, I found a API named NetGetJoinInformation. Is it the better function to get the name of workgroup? How can...
Hello! My name is Pablo and I'm from Brazil. Because it, I request for you to forgive my english. My problem is: I created a form to receive errors codes e show it. In the main program (prg) I put this code:
ON ERROR do forms c:\foxpro\myprogram\forms\alert with program(),lineno()
In the...
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.