On Oct 31, 2007, at 2:55 AM, Thorsten Hohage wrote:
> depending on the used Valentina version I'm not sure if you're able
> to use aggregate function in an order by clause. If this will make
> any difficults, define a table method for the calculation.
Here's where I came up with:
SELECT departmentName as 'myDepartmentName',sum
(itemsales.itemsalesamount) as 'itemsalesAMT'
FROM departments,itemsales where departments._rowID =
itemsales.itemsalesdepartmentID
group by departmentName
order by itemsalesAMT Desc
I have never tried binary links. Does this look like a good canidate
to use a binary link?
> Changing from one DB-vendor to another will never be straight
> forward and I even remember a lot of situations where even a
> product upgrade or product switch from one vendor will cause issues.
>
> For the migration process itself I dump the structure to sql first,
> use BBEdit and some find-replace to change everthing, that it will
> not only fit in Valentina, but uses some advantages of Valentina.
> Then I define the db and in a second step I dump the data (complete
> inserts, no hex) and import it.
>
> Average time of DB migration for rather complex systems (50+
> tables) is for me < 1 day - for "known" solutaions (because some
> clients use the same structure) and not to much data I'm below an
> hour now.
I am not a programmer by trade(I am a bit of a weekend warrior.)
Everything I program is done in my free time away from my day job so
my time
is very limited and scattered. I find it hard to get a solid block of
time to dedicate to this.
Maybe thats why I have so much difficulty.
Joseph
_______________________________________________
Valentina mailing list
Valentina .at. lists .D.OT macserve.net
http://lists.macserve.net/mailman/listinfo/valentina
©2007 Joseph Morgan |
