How to make operation

  • Thread starter Federico Moschini [328594]
  • Start date
F

Federico Moschini [328594]

I have to make difference between2 data from a table in SQL.

The page is made with Frontpage, and it extracts QtaGiaCons and Quantita
from table "oclrighe".

I have to make Quantita - QtaGiaCons to obtain QtaInev
(quantity that I have to ship because I have partially shipped)

I wait for your suggestion. Thank you.

Federico

**************************


<html>

<head>
<% ' FP_ASP -- ASP Automatically generated by a Frontpage Component. Do not
Edit.
FP_LCID = 1040 %>
<meta http-equiv="Content-Language" content="it">
<% ' FP_ASP -- ASP Automatically generated by a Frontpage Component. Do not
Edit.
FP_CharSet = "windows-1252"
FP_CodePage = 1252 %>
<meta http-equiv="Content-Type" content="text/html; charset=windows-1252">
<title>DETTAGLIO RESIDUO D'ORDINE</title>
</head>

<body>

<p style="margin-top: 0; margin-bottom: 0"><b>METRO INTERNATIONAL
S.p.A.</b></p>
<p style="margin-top: 0; margin-bottom: 0"><font size="2">VIA MODICA 16 -
20143
MILANO MI</font></p>
<p style="margin-top: 0; margin-bottom: 0"><font size="2">TEL. 02817941 -
FAX.
028131113</font></p>
<p style="margin-top: 0; margin-bottom: 0"><font size="2">E-MAIL:
(e-mail address removed)
- SITO INTERNET: http://www.metroint.it</font></p>
<div style="border-top-style: solid; border-top-width: 1; padding-top: 1">
<p style="margin-top: 0; margin-bottom: 0">&nbsp;</p>
</div>

<p style="margin-top: 0; margin-bottom: 0">&nbsp;</p>
<table width="100%" border="0">
<thead>
</thead>
<tbody>
<!--webbot bot="DatabaseRegionStart"
s-columnnames="NrOrClInt,NrOrClEst,DtaOrdCli,DtaPrevCon,DtaConConf,Cliente,L
ingua,NsRif,VsRif,CondPag,PagNonStd,Listino,BancaCli,BancaDitta,SedeDoc,Sede
Eff,NettoIVA,Divisa,DtaFixing,FixingManuale,Fixing,Area,Agente,CalcProvv,Mat
uraz,PrcMatADF,CapoArea,Nota,ModCon,RegIVA,CauMov,Bollett,DepoFase1,SpecFase
1,DepoFase2,SpecFase2,GiaConsegn,GiaFatt,Stampato,UsaAnnoC,OrdAnn,IdOrdCli,C
ommessa,Centro,ListinoDaDtaCons,DataValList,ConsegnaUnica,CCDitta,Presentaz,
DtaConTass,LastSubId,CodCliFatturazione,Priorita,SedeMerce,CodAutBancaria,Se
gueFattura,ClcRateDa,ImportoProvvigioneAgenteTot,ImportoProvvigioneCapoareaT
ot,ImportoBaseAgente,ImportoBaseCapoArea,PercProvvAgente,PercProvvCapoArea,I
mportoProvvAgenteAuto,ImportoProvvCapoAreaAuto,CalcoloProvvCapoArea,PercProv
vAgenteAuto,PercProvvCapoAreaAuto,TipoCliFor,TipoSpecificatoreFase1,TipoSpec
ificatoreFase2,CodicePoliticaAgente,CodicePoliticaCapoArea"
s-columntypes="200,200,135,135,135,200,200,200,200,200,200,200,200,200,200,2
00,200,200,135,200,5,200,200,3,3,5,200,200,200,200,200,200,200,200,200,200,2
00,200,200,200,200,3,200,200,200,135,200,200,3,135,3,200,2,200,200,200,135,5
,5,5,5,5,5,200,200,3,200,200,3,3,3,200,200" s-dataconnection="Ordini"
b-tableformat="TRUE" b-menuformat="FALSE" s-menuchoice s-menuvalue
b-tableborder="TRUE" b-tableexpand="TRUE" b-tableheader="TRUE"
b-listlabels="TRUE" b-listseparator="TRUE" i-listformat="0"
b-makeform="FALSE" s-recordsource="OClTesta" s-displaycolumns="NrOrClInt"
s-criteria="{IdOrdCli} EQ {IdOrdCli} +" s-order s-sql="SELECT * FROM
OClTesta WHERE (IdOrdCli = ::IdOrdCli::)" b-procedure="FALSE" clientside
suggestedext="asp" s-defaultfields="IdOrdCli=" s-norecordsfound="No records
returned." i-maxrecords="256" i-groupsize="0" botid="1"
u-dblib="_fpclass/fpdblib.inc" u-dbrgn1="_fpclass/fpdbrgn1.inc"
u-dbrgn2="_fpclass/fpdbrgn2.inc" tag="TBODY" preview="&lt;tr&gt;&lt;td
colspan=64 bgcolor=&quot;#FFFF00&quot; width=&quot;100%&quot;&gt;&lt;font
color=&quot;#000000&quot;&gt;This is the start of a Database Results
region.&lt;/font&gt;&lt;/td&gt;&lt;/tr&gt;" startspan --><!--#include
file="_fpclass/fpdblib.inc"-->
<% if 0 then %>
<SCRIPT Language="JavaScript">
document.write("<div style='background: yellow; color: black;'>The Database
Results component on this page is unable to display database content. The
page must have a filename ending in '.asp', and the web must be hosted on a
server that supports Active Server Pages.</div>");
</SCRIPT>
<% end if %>
<%
fp_sQry="SELECT * FROM OClTesta WHERE (IdOrdCli = ::IdOrdCli::)"
fp_sDefault="IdOrdCli="
fp_sNoRecords="<tr><td colspan=1 align=""LEFT"" width=""100%"">No records
returned.</td></tr>"
fp_sDataConn="Ordini"
fp_iMaxRecords=256
fp_iCommandType=1
fp_iPageSize=0
fp_fTableFormat=True
fp_fMenuFormat=False
fp_sMenuChoice=""
fp_sMenuValue=""
fp_sColTypes="&NrOrClInt=200&NrOrClEst=200&DtaOrdCli=135&DtaPrevCon=135&DtaC
onConf=135&Cliente=200&Lingua=200&NsRif=200&VsRif=200&CondPag=200&PagNonStd=
200&Listino=200&BancaCli=200&BancaDitta=200&SedeDoc=200&SedeEff=200&NettoIVA
=200&Divisa=200&DtaFixing=135&FixingManuale=200&Fixing=5&Area=200&Agente=200
&CalcProvv=3&Maturaz=3&PrcMatADF=5&CapoArea=200&Nota=200&ModCon=200&RegIVA=2
00&CauMov=200&Bollett=200&DepoFase1=200&SpecFase1=200&DepoFase2=200&SpecFase
2=200&GiaConsegn=200&GiaFatt=200&Stampato=200&UsaAnnoC=200&OrdAnn=200&IdOrdC
li=3&Commessa=200&Centro=200&ListinoDaDtaCons=200&DataValList=135&ConsegnaUn
ica=200&CCDitta=200&Presentaz=3&DtaConTass=135&LastSubId=3&CodCliFatturazion
e=200&Priorita=2&SedeMerce=200&CodAutBancaria=200&SegueFattura=200&ClcRateDa
=135&ImportoProvvigioneAgenteTot=5&ImportoProvvigioneCapoareaTot=5&ImportoBa
seAgente=5&ImportoBaseCapoArea=5&PercProvvAgente=5&PercProvvCapoArea=5&Impor
toProvvAgenteAuto=200&ImportoProvvCapoAreaAuto=200&CalcoloProvvCapoArea=3&Pe
rcProvvAgenteAuto=200&PercProvvCapoAreaAuto=200&TipoCliFor=3&TipoSpecificato
reFase1=3&TipoSpecificatoreFase2=3&CodicePoliticaAgente=200&CodicePoliticaCa
poArea=200&"
fp_iDisplayCols=1
fp_fCustomQuery=False
BOTID=1
fp_iRegion=BOTID
%>
<!--#include file="_fpclass/fpdbrgn1.inc"-->
<!--webbot bot="DatabaseRegionStart" endspan i-checksum="30455" --><tr>
<td><b>RESIDUO D'ORDINE N°
<!--webbot bot="DatabaseResultColumn"
s-columnnames="NrOrClInt,NrOrClEst,DtaOrdCli,DtaPrevCon,DtaConConf,Cliente,L
ingua,NsRif,VsRif,CondPag,PagNonStd,Listino,BancaCli,BancaDitta,SedeDoc,Sede
Eff,NettoIVA,Divisa,DtaFixing,FixingManuale,Fixing,Area,Agente,CalcProvv,Mat
uraz,PrcMatADF,CapoArea,Nota,ModCon,RegIVA,CauMov,Bollett,DepoFase1,SpecFase
1,DepoFase2,SpecFase2,GiaConsegn,GiaFatt,Stampato,UsaAnnoC,OrdAnn,IdOrdCli,C
ommessa,Centro,ListinoDaDtaCons,DataValList,ConsegnaUnica,CCDitta,Presentaz,
DtaConTass,LastSubId,CodCliFatturazione,Priorita,SedeMerce,CodAutBancaria,Se
gueFattura,ClcRateDa,ImportoProvvigioneAgenteTot,ImportoProvvigioneCapoareaT
ot,ImportoBaseAgente,ImportoBaseCapoArea,PercProvvAgente,PercProvvCapoArea,I
mportoProvvAgenteAuto,ImportoProvvCapoAreaAuto,CalcoloProvvCapoArea,PercProv
vAgenteAuto,PercProvvCapoAreaAuto,TipoCliFor,TipoSpecificatoreFase1,TipoSpec
ificatoreFase2,CodicePoliticaAgente,CodicePoliticaCapoArea"
s-column="NrOrClInt" b-tableformat="TRUE" b-hashtml="FALSE"
b-makelink="FALSE" clientside b-MenuFormat preview="&lt;font
size=&quot;-1&quot;&gt;&amp;lt;&amp;lt;&lt;/font&gt;NrOrClInt&lt;font
size=&quot;-1&quot;&gt;&amp;gt;&amp;gt;&lt;/font&gt;"
startspan --><%=FP_FieldVal(fp_rs,"NrOrClInt")%><!--webbot
bot="DatabaseResultColumn" endspan i-checksum="20991" --></b></td>
</tr>
<!--webbot bot="DatabaseRegionEnd" b-tableformat="TRUE"
b-menuformat="FALSE" u-dbrgn2="_fpclass/fpdbrgn2.inc" i-groupsize="0"
clientside tag="TBODY" preview="&lt;tr&gt;&lt;td colspan=64
bgcolor=&quot;#FFFF00&quot; width=&quot;100%&quot;&gt;&lt;font
color=&quot;#000000&quot;&gt;This is the end of a Database Results
region.&lt;/font&gt;&lt;/td&gt;&lt;/tr&gt;" startspan --><!--#include
file="_fpclass/fpdbrgn2.inc"-->
<!--webbot bot="DatabaseRegionEnd" endspan i-checksum="62730" --></tbody>
</table>

<table width="97%" border="0" cellspacing="0">
<thead>
<tr>
<th ALIGN="LEFT" bgcolor="#CCCCCC" style="border-bottom: 1px solid
#000000; padding-left: 4px; padding-right: 4px" width="15%">
<b>Articolo</b></th>
<th ALIGN="LEFT" bgcolor="#CCCCCC" style="border-bottom: 1px solid
#000000; padding-left: 4px; padding-right: 4px" width="41%">
<b>Descrizione</b></th>
<th ALIGN="LEFT" bgcolor="#CCCCCC" style="border-bottom: 1px solid
#000000; padding-left: 4px; padding-right: 4px" width="12%">
<p align="right">
<b>Quantità</b></th>
<th bgcolor="#CCCCCC" style="border-bottom: 1px solid #000000;
padding-left: 4px; padding-right: 4px" width="21%">
<p align="right">Q.tà consegnata</th>
<th ALIGN="LEFT" bgcolor="#CCCCCC" style="border-bottom: 1px solid
#000000; padding-left: 4px; padding-right: 4px">
&nbsp;</th>
</tr>
</thead>
<tbody>
<!--webbot bot="DatabaseRegionStart"
s-columnnames="Riga,Posiz,TipoRiga,Descri,NoRipStam,NoRipBolla,NoRipFatt,Art
icolo,Variante,Cliente,DtaOrdCli,Reparto,UnMis,Quantita,QtaAcc1,QtaAcc2,QtaA
cc3,QtaAcc,ValUnit,Imponibile,CodIVA,Totale,Sconto1,Sconto2,ScontoFormula,Im
pSconto,DtaPrevCon,DtaConConf,QtaGiaCons,QtaGiaFatt,TipoVend,NrColli,UnMisCo
lli,PesoLordo,PesoNetto,Cubaggio,GiaConsegn,GiaFatt,RigaAnn,IdOrdCli,NrKitDo
c,QtaKit,Commessa,Centro,PercProvv,ProvCapoarea,ScontoAge,CatProvv,IDSchema,
NrSchema,RigaSchema,Cntprt,QtaPrenotata,ImpProvAge,SubID,ArticoloDistinta,De
poFase1,DepoFase2,SpecFase1,SpecFase2,RifRigaEst,NrLottoCli,RifIDDocEsterno,
RifNrDocEsterno,RifIDOfferta,RifSubIDOfferta,RifOfferta,Nota,ImportoBaseAgen
te,ImportoBaseCapoArea,ImportoProvCapo,CatProvvCapoArea,PercentualeProvvigio
neAuto,PercentualeProvCapoareaAuto,ImportoProvAgeAuto,ImportoProvCapoAuto,Ca
tProvvAgeAuto,CatProvvCapoAuto"
s-columntypes="2,2,3,200,200,200,200,200,200,200,135,200,200,5,5,5,5,5,5,5,2
00,5,5,5,200,5,135,135,5,5,3,2,200,5,5,5,200,200,200,3,2,5,200,200,5,5,5,200
,3,200,2,200,5,5,3,200,200,200,200,200,2,200,3,200,3,3,200,200,5,5,5,200,200
,200,200,200,200,200" s-dataconnection="Ordini" b-tableformat="TRUE"
b-menuformat="FALSE" s-menuchoice="Articolo" s-menuvalue="Articolo"
b-tableborder="TRUE" b-tableexpand="TRUE" b-tableheader="TRUE"
b-listlabels="TRUE" b-listseparator="TRUE" i-listformat="0"
b-makeform="FALSE" s-recordsource="OClRighe"
s-displaycolumns="Articolo,Descri,Quantita,QtaGiaCons"
s-criteria="{IdOrdCli} EQ {IdOrdCli} + {TipoRiga} EQ {TipoRiga} +
[GiaConsegn] EQ {GiaConsegn} + [GiaFatt] EQ {GiaFatt} + [RigaAnn] EQ
{RigaAnn} +" s-order="[Riga] +" s-sql="SELECT * FROM OClRighe WHERE
(IdOrdCli = ::IdOrdCli:: AND TipoRiga = ::TipoRiga:: AND GiaConsegn =
'::GiaConsegn::' AND GiaFatt = '::GiaFatt::' AND RigaAnn = '::RigaAnn::')
ORDER BY Riga ASC" b-procedure="FALSE" clientside suggestedext="asp"
s-defaultfields="IdOrdCli=&amp;amp;TipoRiga=3538947&amp;amp;GiaConsegn=0&amp
;amp;GiaFatt=0&amp;amp;RigaAnn=0" s-norecordsfound="No records returned."
i-maxrecords="256" i-groupsize="0" botid="2" u-dblib="_fpclass/fpdblib.inc"
u-dbrgn1="_fpclass/fpdbrgn1.inc" u-dbrgn2="_fpclass/fpdbrgn2.inc"
tag="TBODY" preview="&lt;tr&gt;&lt;td colspan=64 bgcolor=&quot;#FFFF00&quot;
width=&quot;100%&quot;&gt;&lt;font color=&quot;#000000&quot;&gt;This is the
start of a Database Results region.&lt;/font&gt;&lt;/td&gt;&lt;/tr&gt;"
startspan b-UseDotNET="FALSE" CurrentExt sa-InputTypes="3,3,200,200,200"
b-DataGridFormat="FALSE" b-DGridAlternate="TRUE"
sa-CritTypes="3,3,200,200,200" b-WasTableFormat="TRUE" --><!--#include
file="_fpclass/fpdblib.inc"-->
<% if 0 then %>
<SCRIPT Language="JavaScript">
document.write("<div style='background: yellow; color: black;'>The Database
Results component on this page is unable to display database content. The
page must have a filename ending in '.asp', and the web must be hosted on a
server that supports Active Server Pages.</div>");
</SCRIPT>
<% end if %>
<%
fp_sQry="SELECT * FROM OClRighe WHERE (IdOrdCli = ::IdOrdCli:: AND TipoRiga
= ::TipoRiga:: AND GiaConsegn = '::GiaConsegn::' AND GiaFatt =
'::GiaFatt::' AND RigaAnn = '::RigaAnn::') ORDER BY Riga ASC"
fp_sDefault="IdOrdCli=&TipoRiga=3538947&GiaConsegn=0&GiaFatt=0&RigaAnn=0"
fp_sNoRecords="<tr><td colspan=4 align=""LEFT"" width=""100%"">No records
returned.</td></tr>"
fp_sDataConn="Ordini"
fp_iMaxRecords=256
fp_iCommandType=1
fp_iPageSize=0
fp_fTableFormat=True
fp_fMenuFormat=False
fp_sMenuChoice="Articolo"
fp_sMenuValue="Articolo"
fp_sColTypes="&Riga=2&Posiz=2&TipoRiga=3&Descri=200&NoRipStam=200&NoRipBolla
=200&NoRipFatt=200&Articolo=200&Variante=200&Cliente=200&DtaOrdCli=135&Repar
to=200&UnMis=200&Quantita=5&QtaAcc1=5&QtaAcc2=5&QtaAcc3=5&QtaAcc=5&ValUnit=5
&Imponibile=5&CodIVA=200&Totale=5&Sconto1=5&Sconto2=5&ScontoFormula=200&ImpS
conto=5&DtaPrevCon=135&DtaConConf=135&QtaGiaCons=5&QtaGiaFatt=5&TipoVend=3&N
rColli=2&UnMisColli=200&PesoLordo=5&PesoNetto=5&Cubaggio=5&GiaConsegn=200&Gi
aFatt=200&RigaAnn=200&IdOrdCli=3&NrKitDoc=2&QtaKit=5&Commessa=200&Centro=200
&PercProvv=5&ProvCapoarea=5&ScontoAge=5&CatProvv=200&IDSchema=3&NrSchema=200
&RigaSchema=2&Cntprt=200&QtaPrenotata=5&ImpProvAge=5&SubID=3&ArticoloDistint
a=200&DepoFase1=200&DepoFase2=200&SpecFase1=200&SpecFase2=200&RifRigaEst=2&N
rLottoCli=200&RifIDDocEsterno=3&RifNrDocEsterno=200&RifIDOfferta=3&RifSubIDO
fferta=3&RifOfferta=200&Nota=200&ImportoBaseAgente=5&ImportoBaseCapoArea=5&I
mportoProvCapo=5&CatProvvCapoArea=200&PercentualeProvvigioneAuto=200&Percent
ualeProvCapoareaAuto=200&ImportoProvAgeAuto=200&ImportoProvCapoAuto=200&CatP
rovvAgeAuto=200&CatProvvCapoAuto=200&"
fp_iDisplayCols=4
fp_fCustomQuery=False
BOTID=2
fp_iRegion=BOTID
%>
<!--#include file="_fpclass/fpdbrgn1.inc"-->
<!--webbot bot="DatabaseRegionStart" endspan i-checksum="22767" --><tr>
<td style="border-bottom: 1px solid #000000; padding-left: 4px;
padding-right: 4px" width="15%">
<a title="VERIFICA DISPONIBILITA'"
href="magazzino.asp?Articolo=<%=FP_FieldURL(fp_rs,"Articolo")%>">
<img border="0" src="info.gif" width="16" height="16"></a>
<!--webbot bot="DatabaseResultColumn"
s-columnnames="Riga,Posiz,TipoRiga,Descri,NoRipStam,NoRipBolla,NoRipFatt,Art
icolo,Variante,Cliente,DtaOrdCli,Reparto,UnMis,Quantita,QtaAcc1,QtaAcc2,QtaA
cc3,QtaAcc,ValUnit,Imponibile,CodIVA,Totale,Sconto1,Sconto2,ScontoFormula,Im
pSconto,DtaPrevCon,DtaConConf,QtaGiaCons,QtaGiaFatt,TipoVend,NrColli,UnMisCo
lli,PesoLordo,PesoNetto,Cubaggio,GiaConsegn,GiaFatt,RigaAnn,IdOrdCli,NrKitDo
c,QtaKit,Commessa,Centro,PercProvv,ProvCapoarea,ScontoAge,CatProvv,IDSchema,
NrSchema,RigaSchema,Cntprt,QtaPrenotata,ImpProvAge,SubID,ArticoloDistinta,De
poFase1,DepoFase2,SpecFase1,SpecFase2,RifRigaEst,NrLottoCli,RifIDDocEsterno,
RifNrDocEsterno,RifIDOfferta,RifSubIDOfferta,RifOfferta,Nota,ImportoBaseAgen
te,ImportoBaseCapoArea,ImportoProvCapo,CatProvvCapoArea,PercentualeProvvigio
neAuto,PercentualeProvCapoareaAuto,ImportoProvAgeAuto,ImportoProvCapoAuto,Ca
tProvvAgeAuto,CatProvvCapoAuto" s-column="Articolo" b-tableformat="TRUE"
b-hashtml="FALSE" b-makelink="FALSE" clientside b-MenuFormat
preview="&lt;font
size=&quot;-1&quot;&gt;&amp;lt;&amp;lt;&lt;/font&gt;Articolo&lt;font
size=&quot;-1&quot;&gt;&amp;gt;&amp;gt;&lt;/font&gt;"
startspan --><%=FP_FieldVal(fp_rs,"Articolo")%><!--webbot
bot="DatabaseResultColumn" endspan i-checksum="16368" --> </td>
<td style="border-bottom: 1px solid #000000; padding-left: 4px;
padding-right: 4px" width="41%">
<!--webbot bot="DatabaseResultColumn"
s-columnnames="Riga,Posiz,TipoRiga,Descri,NoRipStam,NoRipBolla,NoRipFatt,Art
icolo,Variante,Cliente,DtaOrdCli,Reparto,UnMis,Quantita,QtaAcc1,QtaAcc2,QtaA
cc3,QtaAcc,ValUnit,Imponibile,CodIVA,Totale,Sconto1,Sconto2,ScontoFormula,Im
pSconto,DtaPrevCon,DtaConConf,QtaGiaCons,QtaGiaFatt,TipoVend,NrColli,UnMisCo
lli,PesoLordo,PesoNetto,Cubaggio,GiaConsegn,GiaFatt,RigaAnn,IdOrdCli,NrKitDo
c,QtaKit,Commessa,Centro,PercProvv,ProvCapoarea,ScontoAge,CatProvv,IDSchema,
NrSchema,RigaSchema,Cntprt,QtaPrenotata,ImpProvAge,SubID,ArticoloDistinta,De
poFase1,DepoFase2,SpecFase1,SpecFase2,RifRigaEst,NrLottoCli,RifIDDocEsterno,
RifNrDocEsterno,RifIDOfferta,RifSubIDOfferta,RifOfferta,Nota,ImportoBaseAgen
te,ImportoBaseCapoArea,ImportoProvCapo,CatProvvCapoArea,PercentualeProvvigio
neAuto,PercentualeProvCapoareaAuto,ImportoProvAgeAuto,ImportoProvCapoAuto,Ca
tProvvAgeAuto,CatProvvCapoAuto" s-column="Descri" b-tableformat="TRUE"
b-hashtml="FALSE" b-makelink="FALSE" clientside b-MenuFormat
preview="&lt;font
size=&quot;-1&quot;&gt;&amp;lt;&amp;lt;&lt;/font&gt;Descri&lt;font
size=&quot;-1&quot;&gt;&amp;gt;&amp;gt;&lt;/font&gt;"
startspan --><%=FP_FieldVal(fp_rs,"Descri")%><!--webbot
bot="DatabaseResultColumn" endspan i-checksum="14190" --></td>
<td style="border-bottom: 1px solid #000000; padding-left: 4px;
padding-right: 4px" width="12%">
<p align="right">
<!--webbot bot="DatabaseResultColumn"
s-columnnames="Riga,Posiz,TipoRiga,Descri,NoRipStam,NoRipBolla,NoRipFatt,Art
icolo,Variante,Cliente,DtaOrdCli,Reparto,UnMis,Quantita,QtaAcc1,QtaAcc2,QtaA
cc3,QtaAcc,ValUnit,Imponibile,CodIVA,Totale,Sconto1,Sconto2,ScontoFormula,Im
pSconto,DtaPrevCon,DtaConConf,QtaGiaCons,QtaGiaFatt,TipoVend,NrColli,UnMisCo
lli,PesoLordo,PesoNetto,Cubaggio,GiaConsegn,GiaFatt,RigaAnn,IdOrdCli,NrKitDo
c,QtaKit,Commessa,Centro,PercProvv,ProvCapoarea,ScontoAge,CatProvv,IDSchema,
NrSchema,RigaSchema,Cntprt,QtaPrenotata,ImpProvAge,SubID,ArticoloDistinta,De
poFase1,DepoFase2,SpecFase1,SpecFase2,RifRigaEst,NrLottoCli,RifIDDocEsterno,
RifNrDocEsterno,RifIDOfferta,RifSubIDOfferta,RifOfferta,Nota,ImportoBaseAgen
te,ImportoBaseCapoArea,ImportoProvCapo,CatProvvCapoArea,PercentualeProvvigio
neAuto,PercentualeProvCapoareaAuto,ImportoProvAgeAuto,ImportoProvCapoAuto,Ca
tProvvAgeAuto,CatProvvCapoAuto" s-column="Quantita" b-tableformat="TRUE"
b-hashtml="FALSE" b-makelink="FALSE" clientside b-MenuFormat
preview="&lt;font
size=&quot;-1&quot;&gt;&amp;lt;&amp;lt;&lt;/font&gt;Quantita&lt;font
size=&quot;-1&quot;&gt;&amp;gt;&amp;gt;&lt;/font&gt;"
startspan --><%=FP_FieldVal(fp_rs,"Quantita")%><!--webbot
bot="DatabaseResultColumn" endspan i-checksum="17467" --></td>
<td style="border-bottom: 1px solid #000000; padding-left: 4px;
padding-right: 4px" width="21%">
<p align="right">
<!--webbot bot="DatabaseResultColumn"
s-columnnames="Riga,Posiz,TipoRiga,Descri,NoRipStam,NoRipBolla,NoRipFatt,Art
icolo,Variante,Cliente,DtaOrdCli,Reparto,UnMis,Quantita,QtaAcc1,QtaAcc2,QtaA
cc3,QtaAcc,ValUnit,Imponibile,CodIVA,Totale,Sconto1,Sconto2,ScontoFormula,Im
pSconto,DtaPrevCon,DtaConConf,QtaGiaCons,QtaGiaFatt,TipoVend,NrColli,UnMisCo
lli,PesoLordo,PesoNetto,Cubaggio,GiaConsegn,GiaFatt,RigaAnn,IdOrdCli,NrKitDo
c,QtaKit,Commessa,Centro,PercProvv,ProvCapoarea,ScontoAge,CatProvv,IDSchema,
NrSchema,RigaSchema,Cntprt,QtaPrenotata,ImpProvAge,SubID,ArticoloDistinta,De
poFase1,DepoFase2,SpecFase1,SpecFase2,RifRigaEst,NrLottoCli,RifIDDocEsterno,
RifNrDocEsterno,RifIDOfferta,RifSubIDOfferta,RifOfferta,Nota,ImportoBaseAgen
te,ImportoBaseCapoArea,ImportoProvCapo,CatProvvCapoArea,PercentualeProvvigio
neAuto,PercentualeProvCapoareaAuto,ImportoProvAgeAuto,ImportoProvCapoAuto,Ca
tProvvAgeAuto,CatProvvCapoAuto" s-column="QtaGiaCons" b-tableformat="TRUE"
b-hashtml="FALSE" b-makelink="FALSE" clientside b-MenuFormat
preview="&lt;font
size=&quot;-1&quot;&gt;&amp;lt;&amp;lt;&lt;/font&gt;QtaGiaCons&lt;font
size=&quot;-1&quot;&gt;&amp;gt;&amp;gt;&lt;/font&gt;"
startspan --><%=FP_FieldVal(fp_rs,"QtaGiaCons")%><!--webbot
bot="DatabaseResultColumn" endspan i-checksum="31752" --></td>
<td style="border-bottom: 1px solid #000000; padding-left: 4px;
padding-right: 4px">
&nbsp;
</td>
</tr>
<!--webbot bot="DatabaseRegionEnd" b-tableformat="TRUE"
b-menuformat="FALSE" u-dbrgn2="_fpclass/fpdbrgn2.inc" i-groupsize="0"
clientside tag="TBODY" preview="&lt;tr&gt;&lt;td colspan=64
bgcolor=&quot;#FFFF00&quot; width=&quot;100%&quot;&gt;&lt;font
color=&quot;#000000&quot;&gt;This is the end of a Database Results
region.&lt;/font&gt;&lt;/td&gt;&lt;/tr&gt;" startspan --><!--#include
file="_fpclass/fpdbrgn2.inc"-->
<!--webbot bot="DatabaseRegionEnd" endspan i-checksum="62730" --></tbody>
</table>

</body>

</html>
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Members online

No members online now.

Forum statistics

Threads
473,982
Messages
2,570,185
Members
46,736
Latest member
AdolphBig6

Latest Threads

Top