2. PHPRunner General questions
  3. no addtion
This topic is locked

no addtion

 		6/21/2007 12:06:31 AM
PHPRunner General questions
M
 mollyman01 author

Hello
i have some problems
i have this query

select

ID_Points,

NameP,

Inf,

Scharfts,

Garde,

Mat,

See,

Inf+Scharfts+Garde+Mat+See as Soldaten,

Pinassen,

Schaluppen,

Brigg,

Barke,

Fleute,

Fregatte,

Linenschiff,

Galeone,

Aktionskrieg,

Postdatum,

StufeKTFest,

Soldaten*0.01 as PointsSol,

Pinassen*10 as PointsPin,

Schaluppen*10 as PointScha,

Brigg*30 as PointsBrig,

Barke*30 as PointsBar,

Fleute*30 as PointsFleu,

Fregatte*50 as PointsFreg,

Linenschiff*100 as PointsLin,

Galeone*120 as PointsLeo,

PointsSol+PointsPin+PointScha+PointsBrig+PointsBrig+PointsBar+PointsFleu+PointsF

reg+PointsLin+PointsLeo as PointsTot

from _Punkte


but this do not the addition

can someone help me ?
Alexey admin 6/21/2007

Martin,
please clarify what kind of problem do you have.

Any error messages ?
If you have calculated fields (Soldaten, PointsSol etc) field on Add page proceed to Choose fields tab in PHPRunner and remove these fields from Add page.
M
 		mollyman01 author 6/22/2007

i think the best is when is say what i will do
i have one tabel in this is at example the column Pinassen .

I need that the number in Pinassen multiplikated with 10 the summary must write in PointsPin and so on

then must PointsPin + PointsSol and so an write the summary in Pointstot all in the same row
my problem is that the summary are dont write
sorry for my bad englisch
Greets Martin
Sergey Kornilov admin 6/22/2007

Martin,
you don't need to write anything to PointsTot field.
This field is calculated on the fly.
Remove PointsTot from the Add page and you'll be fine.