andydempsey
07-23-2003, 05:24 PM
Is there any database program for the PPC that supports SUM() and GROUP BY in SQL statements?
I'm trying to build a couple of small apps for my own use and each DB package I look at fails at the ability to to what essentiall amounts to a percent to total for each database record (or set of records). Is this a pocket access limitation?
THe closest I have found so far is Sprint DB, but the sum function is done in a MACRO and not SQL, so too much programming is required on a case by bcase basis. Otherwise, am I forced to try something like NSBasic (but I'm not a programmer!)
I'm trying to build a couple of small apps for my own use and each DB package I look at fails at the ability to to what essentiall amounts to a percent to total for each database record (or set of records). Is this a pocket access limitation?
THe closest I have found so far is Sprint DB, but the sum function is done in a MACRO and not SQL, so too much programming is required on a case by bcase basis. Otherwise, am I forced to try something like NSBasic (but I'm not a programmer!)