I find (with slight modification to Pwise's solution) that both work, but Pwise's solution gives me more than one result per apartment if there is more than one transaction on the latest date (which there sometimes is).
Anyway, thanks to both of you - I imagine this is "child's play" to both of...
I have a table as such:
id, apartment, date, description, amount
I'd like to query it as follows:
select apartment, sum(amount) as balance, max(date), last(description)
from mytable
group by apartment
Of course there is no "last" function. I'm after a list of current balances by apartment...
? set("path") is returning "C:\TEMP\TEST\"
? set("default") is returning "C:"
Neither of these is consistent with what is in the registry.
If I start VFP9 with the "-C" option, then "path" and "default" respects the registry setting.
Again, I have searched through all files - there is no...
Using VFP9 SP2 with Vista. Have tried everything to change the "search path", but when I reload VFP9, it keeps getting set back to "c:\temp\test (that directory does not even exist). I've searched every file on my computer and through the registry and nowhere do I find "c:\temp\test". Seems...
Thanks, I will try both of those suggestions. My new drive is on order along with a drive caddy.
So I'm taking it that there is no one "ultimate" bootable harddrive utility out there that makes this kind of thing a breeze?
I am replacing a harddrive on my laptop (a Dell). I recently had to restore the original operating system as shipped, but it still works for now. However, I was not ever able to do a full chkdsk on it, so I know it has problems.
I have ordered a replacement, but would like some suggestions on...
Doing a .net ExecuteScalar against a VFP table with all deleted records. It returns a null value. If you "undelete" one record, it then returns the proper count. Using the latest VFPOLEDB (8.0a) provider.
Has anyone experienced this? Am I wrong in thinking this should work against an "all...
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.