Logo_DetaylıbilgiSQL
<blockquote> <p><span style="font-size:12pt"><span style="font-family:"Times New Roman","serif""><span style="font-size:10.5pt"><span style="font-family:"Verdana","sans-serif""><span style="color:#172b4d">_SQLINFO("REPLACE(SUBSTRING(CAST(CAST(LDATA AS VARBINARY(500)) AS VARCHAR(500)),2,100),' ',' ')",[TABLO],[WHR])</span></span></span></span></span></p> <p> </p> <p><span style="font-size:12pt"><span style="font-family:"Times New Roman","serif""><span style="font-size:10.5pt"><span style="font-family:"Verdana","sans-serif""><span style="color:#172b4d">WHR : "INFOTYP=7 AND P.INFOREF=S.INVOICEREF AND S.INVOICEREF='"+STR(R10.invoiceRef)+"'"</span></span></span></span></span></p> <p><span style="font-size:12pt"><span style="font-family:"Times New Roman","serif""><span style="font-size:10.5pt"><span style="font-family:"Verdana","sans-serif""><span style="color:#172b4d">TABLO : "LG_001_02_PERDOC P,LG_001_02_STLINE S"</span></span></span></span></span></p> </blockquote> <p> </p> <blockquote> <p><span style="font-size:12pt"><span style="font-family:"Times New Roman","serif""><span style="font-size:10.5pt"><span style="font-family:"Verdana","sans-serif""><span style="color:#172b4d">SELECT<br /> REPLACE(SUBSTRING(CAST(CAST(LDATA AS VARBINARY(500)) AS VARCHAR(500)),2,100),' ',' '),<br /> * FROM LG_003_03_PERDOC<br /> where INFOTYP=7 </span></span></span></span></span></p> </blockquote> <p> </p> <p>_SQLINFO("cast(cast(LDATA As varbinary(500)) as varchar(500))",lg_001_Perdoc,"INFOTYP=5 AND INFOREF='"+STR(R21.ordFicheRef)+"'") select cast(cast(ldata as varbinary(500)) as varchar(500)),* from LG_001_02_PERDOC WHERE INFOTYP=36 AND INFOREF=18</p> <p> </p>
0 Yorum