By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
425,543 Members | 1,887 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 425,543 IT Pros & Developers. It's quick & easy.

How to make operation

P: n/a
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:
in**@metroint.it
- 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,DtaPrev Con,DtaConConf,Cliente,L
ingua,NsRif,VsRif,CondPag,PagNonStd,Listino,BancaC li,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,Conseg naUnica,CCDitta,Presentaz,
DtaConTass,LastSubId,CodCliFatturazione,Priorita,S edeMerce,CodAutBancaria,Se
gueFattura,ClcRateDa,ImportoProvvigioneAgenteTot,I mportoProvvigioneCapoareaT
ot,ImportoBaseAgente,ImportoBaseCapoArea,PercProvv Agente,PercProvvCapoArea,I
mportoProvvAgenteAuto,ImportoProvvCapoAreaAuto,Cal coloProvvCapoArea,PercProv
vAgenteAuto,PercProvvCapoAreaAuto,TipoCliFor,TipoS pecificatoreFase1,TipoSpec
ificatoreFase2,CodicePoliticaAgente,CodicePolitica CapoArea"
s-columntypes="200,200,135,135,135,200,200,200,200,2 00,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&DtaOrdC li=135&DtaPrevCon=135&DtaC
onConf=135&Cliente=200&Lingua=200&NsRif=200&VsRif= 200&CondPag=200&PagNonStd=
200&Listino=200&BancaCli=200&BancaDitta=200&SedeDo c=200&SedeEff=200&NettoIVA
=200&Divisa=200&DtaFixing=135&FixingManuale=200&Fi xing=5&Area=200&Agente=200
&CalcProvv=3&Maturaz=3&PrcMatADF=5&CapoArea=200&No ta=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&UsaA nnoC=200&OrdAnn=200&IdOrdC
li=3&Commessa=200&Centro=200&ListinoDaDtaCons=200& DataValList=135&ConsegnaUn
ica=200&CCDitta=200&Presentaz=3&DtaConTass=135&Las tSubId=3&CodCliFatturazion
e=200&Priorita=2&SedeMerce=200&CodAutBancaria=200& SegueFattura=200&ClcRateDa
=135&ImportoProvvigioneAgenteTot=5&ImportoProvvigi oneCapoareaTot=5&ImportoBa
seAgente=5&ImportoBaseCapoArea=5&PercProvvAgente=5 &PercProvvCapoArea=5&Impor
toProvvAgenteAuto=200&ImportoProvvCapoAreaAuto=200 &CalcoloProvvCapoArea=3&Pe
rcProvvAgenteAuto=200&PercProvvCapoAreaAuto=200&Ti poCliFor=3&TipoSpecificato
reFase1=3&TipoSpecificatoreFase2=3&CodicePoliticaA gente=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,DtaPrev Con,DtaConConf,Cliente,L
ingua,NsRif,VsRif,CondPag,PagNonStd,Listino,BancaC li,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,Conseg naUnica,CCDitta,Presentaz,
DtaConTass,LastSubId,CodCliFatturazione,Priorita,S edeMerce,CodAutBancaria,Se
gueFattura,ClcRateDa,ImportoProvvigioneAgenteTot,I mportoProvvigioneCapoareaT
ot,ImportoBaseAgente,ImportoBaseCapoArea,PercProvv Agente,PercProvvCapoArea,I
mportoProvvAgenteAuto,ImportoProvvCapoAreaAuto,Cal coloProvvCapoArea,PercProv
vAgenteAuto,PercProvvCapoAreaAuto,TipoCliFor,TipoS pecificatoreFase1,TipoSpec
ificatoreFase2,CodicePoliticaAgente,CodicePolitica CapoArea"
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,Qua ntita,QtaAcc1,QtaAcc2,QtaA
cc3,QtaAcc,ValUnit,Imponibile,CodIVA,Totale,Sconto 1,Sconto2,ScontoFormula,Im
pSconto,DtaPrevCon,DtaConConf,QtaGiaCons,QtaGiaFat t,TipoVend,NrColli,UnMisCo
lli,PesoLordo,PesoNetto,Cubaggio,GiaConsegn,GiaFat t,RigaAnn,IdOrdCli,NrKitDo
c,QtaKit,Commessa,Centro,PercProvv,ProvCapoarea,Sc ontoAge,CatProvv,IDSchema,
NrSchema,RigaSchema,Cntprt,QtaPrenotata,ImpProvAge ,SubID,ArticoloDistinta,De
poFase1,DepoFase2,SpecFase1,SpecFase2,RifRigaEst,N rLottoCli,RifIDDocEsterno,
RifNrDocEsterno,RifIDOfferta,RifSubIDOfferta,RifOf ferta,Nota,ImportoBaseAgen
te,ImportoBaseCapoArea,ImportoProvCapo,CatProvvCap oArea,PercentualeProvvigio
neAuto,PercentualeProvCapoareaAuto,ImportoProvAgeA uto,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,2 00,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,QtaGiaCon s"
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=20 0&NoRipStam=200&NoRipBolla
=200&NoRipFatt=200&Articolo=200&Variante=200&Clien te=200&DtaOrdCli=135&Repar
to=200&UnMis=200&Quantita=5&QtaAcc1=5&QtaAcc2=5&Qt aAcc3=5&QtaAcc=5&ValUnit=5
&Imponibile=5&CodIVA=200&Totale=5&Sconto1=5&Sconto 2=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&Cu baggio=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=2 00&IDSchema=3&NrSchema=200
&RigaSchema=2&Cntprt=200&QtaPrenotata=5&ImpProvAge =5&SubID=3&ArticoloDistint
a=200&DepoFase1=200&DepoFase2=200&SpecFase1=200&Sp ecFase2=200&RifRigaEst=2&N
rLottoCli=200&RifIDDocEsterno=3&RifNrDocEsterno=20 0&RifIDOfferta=3&RifSubIDO
fferta=3&RifOfferta=200&Nota=200&ImportoBaseAgente =5&ImportoBaseCapoArea=5&I
mportoProvCapo=5&CatProvvCapoArea=200&PercentualeP rovvigioneAuto=200&Percent
ualeProvCapoareaAuto=200&ImportoProvAgeAuto=200&Im portoProvCapoAuto=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,Qua ntita,QtaAcc1,QtaAcc2,QtaA
cc3,QtaAcc,ValUnit,Imponibile,CodIVA,Totale,Sconto 1,Sconto2,ScontoFormula,Im
pSconto,DtaPrevCon,DtaConConf,QtaGiaCons,QtaGiaFat t,TipoVend,NrColli,UnMisCo
lli,PesoLordo,PesoNetto,Cubaggio,GiaConsegn,GiaFat t,RigaAnn,IdOrdCli,NrKitDo
c,QtaKit,Commessa,Centro,PercProvv,ProvCapoarea,Sc ontoAge,CatProvv,IDSchema,
NrSchema,RigaSchema,Cntprt,QtaPrenotata,ImpProvAge ,SubID,ArticoloDistinta,De
poFase1,DepoFase2,SpecFase1,SpecFase2,RifRigaEst,N rLottoCli,RifIDDocEsterno,
RifNrDocEsterno,RifIDOfferta,RifSubIDOfferta,RifOf ferta,Nota,ImportoBaseAgen
te,ImportoBaseCapoArea,ImportoProvCapo,CatProvvCap oArea,PercentualeProvvigio
neAuto,PercentualeProvCapoareaAuto,ImportoProvAgeA uto,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,Qua ntita,QtaAcc1,QtaAcc2,QtaA
cc3,QtaAcc,ValUnit,Imponibile,CodIVA,Totale,Sconto 1,Sconto2,ScontoFormula,Im
pSconto,DtaPrevCon,DtaConConf,QtaGiaCons,QtaGiaFat t,TipoVend,NrColli,UnMisCo
lli,PesoLordo,PesoNetto,Cubaggio,GiaConsegn,GiaFat t,RigaAnn,IdOrdCli,NrKitDo
c,QtaKit,Commessa,Centro,PercProvv,ProvCapoarea,Sc ontoAge,CatProvv,IDSchema,
NrSchema,RigaSchema,Cntprt,QtaPrenotata,ImpProvAge ,SubID,ArticoloDistinta,De
poFase1,DepoFase2,SpecFase1,SpecFase2,RifRigaEst,N rLottoCli,RifIDDocEsterno,
RifNrDocEsterno,RifIDOfferta,RifSubIDOfferta,RifOf ferta,Nota,ImportoBaseAgen
te,ImportoBaseCapoArea,ImportoProvCapo,CatProvvCap oArea,PercentualeProvvigio
neAuto,PercentualeProvCapoareaAuto,ImportoProvAgeA uto,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,Qua ntita,QtaAcc1,QtaAcc2,QtaA
cc3,QtaAcc,ValUnit,Imponibile,CodIVA,Totale,Sconto 1,Sconto2,ScontoFormula,Im
pSconto,DtaPrevCon,DtaConConf,QtaGiaCons,QtaGiaFat t,TipoVend,NrColli,UnMisCo
lli,PesoLordo,PesoNetto,Cubaggio,GiaConsegn,GiaFat t,RigaAnn,IdOrdCli,NrKitDo
c,QtaKit,Commessa,Centro,PercProvv,ProvCapoarea,Sc ontoAge,CatProvv,IDSchema,
NrSchema,RigaSchema,Cntprt,QtaPrenotata,ImpProvAge ,SubID,ArticoloDistinta,De
poFase1,DepoFase2,SpecFase1,SpecFase2,RifRigaEst,N rLottoCli,RifIDDocEsterno,
RifNrDocEsterno,RifIDOfferta,RifSubIDOfferta,RifOf ferta,Nota,ImportoBaseAgen
te,ImportoBaseCapoArea,ImportoProvCapo,CatProvvCap oArea,PercentualeProvvigio
neAuto,PercentualeProvCapoareaAuto,ImportoProvAgeA uto,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,Qua ntita,QtaAcc1,QtaAcc2,QtaA
cc3,QtaAcc,ValUnit,Imponibile,CodIVA,Totale,Sconto 1,Sconto2,ScontoFormula,Im
pSconto,DtaPrevCon,DtaConConf,QtaGiaCons,QtaGiaFat t,TipoVend,NrColli,UnMisCo
lli,PesoLordo,PesoNetto,Cubaggio,GiaConsegn,GiaFat t,RigaAnn,IdOrdCli,NrKitDo
c,QtaKit,Commessa,Centro,PercProvv,ProvCapoarea,Sc ontoAge,CatProvv,IDSchema,
NrSchema,RigaSchema,Cntprt,QtaPrenotata,ImpProvAge ,SubID,ArticoloDistinta,De
poFase1,DepoFase2,SpecFase1,SpecFase2,RifRigaEst,N rLottoCli,RifIDDocEsterno,
RifNrDocEsterno,RifIDOfferta,RifSubIDOfferta,RifOf ferta,Nota,ImportoBaseAgen
te,ImportoBaseCapoArea,ImportoProvCapo,CatProvvCap oArea,PercentualeProvvigio
neAuto,PercentualeProvCapoareaAuto,ImportoProvAgeA uto,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>
Jul 19 '05 #1
Share this question for a faster answer!
Share on Google+

This discussion thread is closed

Replies have been disabled for this discussion.