Logo_DetaylıbilgiSQL
_SQLINFO("REPLACE(SUBSTRING(CAST(CAST(LDATA AS VARBINARY(500)) AS VARCHAR(500)),2,100),' ',' ')",[TABLO],[WHR])
WHR : "INFOTYP=7 AND P.INFOREF=S.INVOICEREF AND S.INVOICEREF='"+STR(R10.invoiceRef)+"'"
TABLO : "LG_001_02_PERDOC P,LG_001_02_STLINE S"
SELECT
REPLACE(SUBSTRING(CAST(CAST(LDATA AS VARBINARY(500)) AS VARCHAR(500)),2,100),' ',' '),
* FROM LG_003_03_PERDOC
where INFOTYP=7
_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