object ReportTabelaDeVenda: TppReport AutoStop = False DataPipeline = daIBXQueryDataView3.PrecosAlterados PassSetting = psTwoPass PrinterSetup.BinName = 'Default' PrinterSetup.DocumentName = 'Tabela de Pre'#231'os de Venda' PrinterSetup.PaperName = 'A4' PrinterSetup.PrinterName = 'Default' PrinterSetup.SaveDeviceSettings = False PrinterSetup.mmMarginBottom = 6350 PrinterSetup.mmMarginLeft = 6350 PrinterSetup.mmMarginRight = 6350 PrinterSetup.mmMarginTop = 6350 PrinterSetup.mmPaperHeight = 297000 PrinterSetup.mmPaperWidth = 210000 PrinterSetup.PaperSize = 9 Template.DatabaseSettings.DataPipeline = DZ.ppRelatorios Template.DatabaseSettings.Name = 'TabelaVenda' Template.DatabaseSettings.NameField = 'NomeDoRelatorio' Template.DatabaseSettings.TemplateField = 'Relatorio' Template.FileName = 'C:\Users\Administrador\Desktop\TabelaVenda.rtm' Template.Format = ftASCII Units = utMillimeters AllowPrintToFile = True ArchiveFileName = 'Tabela.PDF' DeviceType = 'Screen' EmailSettings.ReportFormat = 'PDF' EmailSettings.Enabled = True LanguageID = 'Default' OutlineSettings.CreateNode = True OutlineSettings.CreatePageNodes = True OutlineSettings.Enabled = True OutlineSettings.Visible = True PDFSettings.EmbedFontOptions = [efUseSubset] PDFSettings.EncryptSettings.AllowCopy = True PDFSettings.EncryptSettings.AllowInteract = True PDFSettings.EncryptSettings.AllowModify = True PDFSettings.EncryptSettings.AllowPrint = True PDFSettings.EncryptSettings.Enabled = False PDFSettings.FontEncoding = feAnsi PDFSettings.OpenPDFFile = True PreviewFormSettings.WindowState = wsMaximized PreviewFormSettings.ZoomSetting = zsPageWidth RTFSettings.DefaultFont.Charset = DEFAULT_CHARSET RTFSettings.DefaultFont.Color = clWindowText RTFSettings.DefaultFont.Height = -13 RTFSettings.DefaultFont.Name = 'Arial' RTFSettings.DefaultFont.Style = [] TextFileName = 'Tabela.PDF' TextSearchSettings.DefaultString = '' TextSearchSettings.Enabled = True Left = 24 Top = 440 Version = '12.01' mmColumnWidth = 0 DataPipelineName = 'PrecosAlterados' object ppTitleBand2: TppTitleBand BeforePrint = ppTitleBand2BeforePrint mmBottomOffset = 0 mmHeight = 32808 mmPrintPosition = 0 object ppLabel10: TppLabel UserName = 'Label10' HyperlinkColor = clBlue AutoSize = False Border.BorderPositions = [] Border.Color = clBlack Border.Style = psSolid Border.Visible = False Border.Weight = 1.000000000000000000 Caption = 'Produtos Alterados por Data' Ellipsis = False Font.Charset = DEFAULT_CHARSET Font.Color = clNavy Font.Name = 'TIMES NEW ROMAN' Font.Size = 20 Font.Style = [fsBold, fsItalic] TextAlignment = taCentered Transparent = True mmHeight = 8467 mmLeft = 2117 mmTop = 23283 mmWidth = 192882 BandType = 1 end object ppShape1: TppShape UserName = 'Shape1' Gradient.EndColor = clWhite Gradient.StartColor = clWhite Gradient.Style = gsNone mmHeight = 21960 mmLeft = 0 mmTop = 0 mmWidth = 197115 BandType = 1 end object ppDBImage1: TppDBImage UserName = 'DBImage1' AlignHorizontal = ahCenter AlignVertical = avCenter MaintainAspectRatio = False Stretch = True Border.BorderPositions = [] Border.Color = clBlack Border.Style = psSolid Border.Visible = False Border.Weight = 1.000000000000000000 DataField = 'LOGO' DataPipeline = DZ.ppEmpresa GraphicType = 'AutoDetect' ParentDataPipeline = False DataPipelineName = 'ppEmpresa' mmHeight = 21431 mmLeft = 265 mmTop = 265 mmWidth = 74083 BandType = 1 end object ppDBText1: TppDBText UserName = 'DBText1' HyperlinkColor = clBlue Border.BorderPositions = [] Border.Color = clBlack Border.Style = psSolid Border.Visible = False Border.Weight = 1.000000000000000000 DataField = 'NOME' DataPipeline = DZ.ppEmpresa Ellipsis = False Font.Charset = DEFAULT_CHARSET Font.Color = clWindowText Font.Name = 'Arial' Font.Size = 10 Font.Style = [fsBold] ParentDataPipeline = False Transparent = True DataPipelineName = 'ppEmpresa' mmHeight = 4191 mmLeft = 75671 mmTop = 1600 mmWidth = 119327 BandType = 1 end object ppDBText2: TppDBText UserName = 'DBText2' HyperlinkColor = clBlue Border.BorderPositions = [] Border.Color = clBlack Border.Style = psSolid Border.Visible = False Border.Weight = 1.000000000000000000 DataField = 'ATIVIDADE' DataPipeline = DZ.ppEmpresa Ellipsis = False Font.Charset = DEFAULT_CHARSET Font.Color = clWindowText Font.Name = 'Arial' Font.Size = 9 Font.Style = [] ParentDataPipeline = False Transparent = True DataPipelineName = 'ppEmpresa' mmHeight = 3969 mmLeft = 75671 mmTop = 6600 mmWidth = 119327 BandType = 1 end object ppDBText5: TppDBText UserName = 'DBText5' HyperlinkColor = clBlue Border.BorderPositions = [] Border.Color = clBlack Border.Style = psSolid Border.Visible = False Border.Weight = 1.000000000000000000 DataField = 'CGC' DataPipeline = DZ.ppEmpresa DisplayFormat = '!99\.999\.999\/9999\-99;0;' Ellipsis = False Font.Charset = DEFAULT_CHARSET Font.Color = clWindowText Font.Name = 'Arial' Font.Size = 9 Font.Style = [] ParentDataPipeline = False Transparent = True DataPipelineName = 'ppEmpresa' mmHeight = 3969 mmLeft = 85990 mmTop = 11600 mmWidth = 37042 BandType = 1 end object ppLabel3: TppLabel UserName = 'Label1' HyperlinkColor = clBlue Border.BorderPositions = [] Border.Color = clBlack Border.Style = psSolid Border.Visible = False Border.Weight = 1.000000000000000000 Caption = 'CNPJ:' Ellipsis = False Font.Charset = DEFAULT_CHARSET Font.Color = clWindowText Font.Name = 'Arial' Font.Size = 9 Font.Style = [] Transparent = True mmHeight = 3969 mmLeft = 75671 mmTop = 11600 mmWidth = 9260 BandType = 1 end object ppLabel4: TppLabel UserName = 'Label4' HyperlinkColor = clBlue Border.BorderPositions = [] Border.Color = clBlack Border.Style = psSolid Border.Visible = False Border.Weight = 1.000000000000000000 Caption = 'I.E.:' Ellipsis = False Font.Charset = DEFAULT_CHARSET Font.Color = clWindowText Font.Name = 'Arial' Font.Size = 9 Font.Style = [] Transparent = True mmHeight = 3969 mmLeft = 161396 mmTop = 11600 mmWidth = 5292 BandType = 1 end object ppDBText6: TppDBText UserName = 'DBText6' HyperlinkColor = clBlue Border.BorderPositions = [] Border.Color = clBlack Border.Style = psSolid Border.Visible = False Border.Weight = 1.000000000000000000 DataField = 'INSC' DataPipeline = DZ.ppEmpresa DisplayFormat = '!99\.999\.999\/999\-99;0;' Ellipsis = False Font.Charset = DEFAULT_CHARSET Font.Color = clWindowText Font.Name = 'Arial' Font.Size = 9 Font.Style = [] ParentDataPipeline = False TextAlignment = taRightJustified Transparent = True DataPipelineName = 'ppEmpresa' mmHeight = 3969 mmLeft = 165100 mmTop = 11600 mmWidth = 29898 BandType = 1 end object lblRBFone: TppLabel UserName = 'Fone' HyperlinkColor = clBlue Border.BorderPositions = [] Border.Color = clBlack Border.Style = psSolid Border.Visible = False Border.Weight = 1.000000000000000000 Caption = 'Tel.: 0000-0000' Ellipsis = False Font.Charset = DEFAULT_CHARSET Font.Color = clWindowText Font.Name = 'Arial' Font.Size = 9 Font.Style = [fsBold] TextAlignment = taRightJustified Transparent = True mmHeight = 3810 mmLeft = 172308 mmTop = 1588 mmWidth = 22691 BandType = 1 end object lblRBEndereco: TppLabel UserName = 'Endereco' HyperlinkColor = clBlue Border.BorderPositions = [] Border.Color = clBlack Border.Style = psSolid Border.Visible = False Border.Weight = 1.000000000000000000 Caption = 'Endere'#231'o da empresa' Ellipsis = False Font.Charset = DEFAULT_CHARSET Font.Color = clWindowText Font.Name = 'Arial' Font.Size = 9 Font.Style = [] Transparent = True mmHeight = 3704 mmLeft = 75671 mmTop = 16669 mmWidth = 96044 BandType = 1 end end object ppHeaderBand2: TppHeaderBand mmBottomOffset = 0 mmHeight = 0 mmPrintPosition = 0 end object ppDetailBand2: TppDetailBand Background1.Brush.Style = bsClear Background1.Gradient.EndColor = clWhite Background1.Gradient.StartColor = clWhite Background1.Gradient.Style = gsNone Background2.Brush.Style = bsClear Background2.Gradient.EndColor = clWhite Background2.Gradient.StartColor = clWhite Background2.Gradient.Style = gsNone PrintHeight = phDynamic mmBottomOffset = 0 mmHeight = 5027 mmPrintPosition = 0 object ppDBText4: TppDBText UserName = 'DBText4' HyperlinkColor = clBlue Border.BorderPositions = [] Border.Color = clBlack Border.Style = psSolid Border.Visible = False Border.Weight = 1.000000000000000000 DataField = 'PVEND' DataPipeline = daIBXQueryDataView3.PrecosAlterados DisplayFormat = '#,0.00;-#,0.00' Ellipsis = False Font.Charset = DEFAULT_CHARSET Font.Color = clWindowText Font.Name = 'Arial' Font.Size = 10 Font.Style = [] ParentDataPipeline = False TextAlignment = taRightJustified Transparent = True DataPipelineName = 'PrecosAlterados' mmHeight = 4763 mmLeft = 152665 mmTop = 265 mmWidth = 41275 BandType = 4 end object ppDBText7: TppDBText UserName = 'DBText7' HyperlinkColor = clBlue Border.BorderPositions = [] Border.Color = clBlack Border.Style = psSolid Border.Visible = False Border.Weight = 1.000000000000000000 DataField = 'PRODUTO' DataPipeline = daIBXQueryDataView3.PrecosAlterados Ellipsis = False Font.Charset = DEFAULT_CHARSET Font.Color = clWindowText Font.Name = 'Arial' Font.Size = 10 Font.Style = [] ParentDataPipeline = False Transparent = True DataPipelineName = 'PrecosAlterados' mmHeight = 4763 mmLeft = 3175 mmTop = 264 mmWidth = 98690 BandType = 4 end object ppLine11: TppLine UserName = 'Line11' Border.BorderPositions = [] Border.Color = clBlack Border.Style = psSolid Border.Visible = False Border.Weight = 1.000000000000000000 Position = lpBottom Weight = 0.750000000000000000 mmHeight = 794 mmLeft = 2117 mmTop = 4233 mmWidth = 192882 BandType = 4 end object ppLine12: TppLine UserName = 'Line12' Border.BorderPositions = [] Border.Color = clBlack Border.Style = psSolid Border.Visible = False Border.Weight = 1.000000000000000000 Position = lpLeft Weight = 0.750000000000000000 mmHeight = 4763 mmLeft = 2117 mmTop = 0 mmWidth = 1058 BandType = 4 end object ppLine13: TppLine UserName = 'Line13' Border.BorderPositions = [] Border.Color = clBlack Border.Style = psSolid Border.Visible = False Border.Weight = 1.000000000000000000 Position = lpLeft Weight = 0.750000000000000000 mmHeight = 4763 mmLeft = 101600 mmTop = 0 mmWidth = 1058 BandType = 4 end object ppLine14: TppLine UserName = 'Line14' Border.BorderPositions = [] Border.Color = clBlack Border.Style = psSolid Border.Visible = False Border.Weight = 1.000000000000000000 Position = lpLeft Weight = 0.750000000000000000 mmHeight = 4763 mmLeft = 194734 mmTop = 0 mmWidth = 1058 BandType = 4 end object ppLine16: TppLine UserName = 'Line101' Border.BorderPositions = [] Border.Color = clBlack Border.Style = psSolid Border.Visible = False Border.Weight = 1.000000000000000000 Position = lpLeft Weight = 0.750000000000000000 mmHeight = 4763 mmLeft = 152665 mmTop = 0 mmWidth = 1058 BandType = 4 end object ppDBText8: TppDBText UserName = 'DBText8' HyperlinkColor = clBlue Border.BorderPositions = [] Border.Color = clBlack Border.Style = psSolid Border.Visible = False Border.Weight = 1.000000000000000000 DataField = 'DATAULTIMAALTERACAO' DataPipeline = daIBXQueryDataView3.PrecosAlterados Ellipsis = False Font.Charset = DEFAULT_CHARSET Font.Color = clWindowText Font.Name = 'Arial' Font.Size = 10 Font.Style = [] ParentDataPipeline = False TextAlignment = taCentered Transparent = True DataPipelineName = 'PrecosAlterados' mmHeight = 4763 mmLeft = 101600 mmTop = 265 mmWidth = 50800 BandType = 4 end end object ppFooterBand2: TppFooterBand mmBottomOffset = 0 mmHeight = 6350 mmPrintPosition = 0 object ppLine4: TppLine UserName = 'Line4' Border.BorderPositions = [] Border.Color = clBlack Border.Style = psSolid Border.Visible = False Border.Weight = 1.000000000000000000 Pen.Color = clGray Pen.Width = 2 Weight = 1.500000000000000000 mmHeight = 3969 mmLeft = 1323 mmTop = 5027 mmWidth = 194734 BandType = 8 end object ppSystemVariable4: TppSystemVariable UserName = 'SystemVariable4' HyperlinkColor = clBlue Border.BorderPositions = [] Border.Color = clBlack Border.Style = psSolid Border.Visible = False Border.Weight = 1.000000000000000000 VarType = vtPageSetDesc Font.Charset = DEFAULT_CHARSET Font.Color = clNavy Font.Name = 'TIMES NEW ROMAN' Font.Size = 9 Font.Style = [] TextAlignment = taRightJustified Transparent = True mmHeight = 3725 mmLeft = 178721 mmTop = 1323 mmWidth = 17314 BandType = 8 end object lblRBDataEUsuario: TppLabel UserName = 'Data' HyperlinkColor = clBlue Border.BorderPositions = [] Border.Color = clBlack Border.Style = psSolid Border.Visible = False Border.Weight = 1.000000000000000000 Caption = 'Data' Ellipsis = False Font.Charset = DEFAULT_CHARSET Font.Color = clNavy Font.Name = 'TIMES NEW ROMAN' Font.Size = 9 Font.Style = [] Transparent = True mmHeight = 3725 mmLeft = 1323 mmTop = 1320 mmWidth = 5969 BandType = 8 end object lblRBSistemaEVersao: TppLabel UserName = 'Sistema' HyperlinkColor = clBlue Border.BorderPositions = [] Border.Color = clBlack Border.Style = psSolid Border.Visible = False Border.Weight = 1.000000000000000000 Caption = 'SAT - Sistema de Automa'#231#227'o Total' Ellipsis = False Font.Charset = DEFAULT_CHARSET Font.Color = clNavy Font.Name = 'TIMES NEW ROMAN' Font.Size = 9 Font.Style = [] TextAlignment = taCentered Transparent = True mmHeight = 3725 mmLeft = 86117 mmTop = 1320 mmWidth = 45254 BandType = 8 end object ppLine1: TppLine UserName = 'Line1' Border.BorderPositions = [] Border.Color = clBlack Border.Style = psSolid Border.Visible = False Border.Weight = 1.000000000000000000 Pen.Color = clGray Pen.Width = 2 Weight = 1.500000000000000000 mmHeight = 529 mmLeft = 1323 mmTop = 794 mmWidth = 194734 BandType = 8 end end object ppGroup1: TppGroup BreakName = 'CLASD' DataPipeline = daIBXQueryDataView3.PrecosAlterados GroupFileSettings.NewFile = False GroupFileSettings.EmailFile = False OutlineSettings.CreateNode = True StartOnOddPage = False UserName = 'Group1' mmNewColumnThreshold = 0 mmNewPageThreshold = 0 DataPipelineName = 'PrecosAlterados' NewFile = False object ppGroupHeaderBand1: TppGroupHeaderBand mmBottomOffset = 0 mmHeight = 5292 mmPrintPosition = 0 object ppLine2: TppLine UserName = 'Line2' Border.BorderPositions = [] Border.Color = clBlack Border.Style = psSolid Border.Visible = False Border.Weight = 1.000000000000000000 Pen.Color = clNavy Pen.Width = 2 Weight = 1.500000000000000000 mmHeight = 794 mmLeft = 2117 mmTop = 0 mmWidth = 192882 BandType = 3 GroupNo = 0 end object ppLine5: TppLine UserName = 'Line5' Border.BorderPositions = [] Border.Color = clBlack Border.Style = psSolid Border.Visible = False Border.Weight = 1.000000000000000000 Pen.Color = clNavy Pen.Width = 2 Position = lpBottom Weight = 1.500000000000000000 mmHeight = 794 mmLeft = 2117 mmTop = 4498 mmWidth = 192882 BandType = 3 GroupNo = 0 end object ppLine6: TppLine UserName = 'Line6' Border.BorderPositions = [] Border.Color = clBlack Border.Style = psSolid Border.Visible = False Border.Weight = 1.000000000000000000 Pen.Color = clNavy Pen.Width = 2 Position = lpLeft Weight = 1.500000000000000000 mmHeight = 4498 mmLeft = 2117 mmTop = 529 mmWidth = 1058 BandType = 3 GroupNo = 0 end object ppLine7: TppLine UserName = 'Line7' Border.BorderPositions = [] Border.Color = clBlack Border.Style = psSolid Border.Visible = False Border.Weight = 1.000000000000000000 Pen.Color = clNavy Pen.Width = 2 Position = lpLeft Weight = 1.500000000000000000 mmHeight = 4498 mmLeft = 101600 mmTop = 265 mmWidth = 1058 BandType = 3 GroupNo = 0 end object ppLabel13: TppLabel UserName = 'Label13' HyperlinkColor = clBlue AutoSize = False Border.BorderPositions = [] Border.Color = clBlack Border.Style = psSolid Border.Visible = False Border.Weight = 1.000000000000000000 Caption = 'Data Hora Altera'#231#227'o' Ellipsis = False Font.Charset = DEFAULT_CHARSET Font.Color = clNavy Font.Name = 'TIMES NEW ROMAN' Font.Size = 11 Font.Style = [fsBold, fsItalic] TextAlignment = taCentered Transparent = True mmHeight = 4498 mmLeft = 102394 mmTop = 265 mmWidth = 50006 BandType = 3 GroupNo = 0 end object ppLine8: TppLine UserName = 'Line8' Border.BorderPositions = [] Border.Color = clBlack Border.Style = psSolid Border.Visible = False Border.Weight = 1.000000000000000000 Pen.Color = clNavy Pen.Width = 2 Position = lpLeft Weight = 1.500000000000000000 mmHeight = 4498 mmLeft = 194469 mmTop = 265 mmWidth = 1058 BandType = 3 GroupNo = 0 end object ppLine10: TppLine UserName = 'Line10' Border.BorderPositions = [] Border.Color = clBlack Border.Style = psSolid Border.Visible = False Border.Weight = 1.000000000000000000 Pen.Color = clNavy Pen.Width = 2 Position = lpLeft Weight = 1.500000000000000000 mmHeight = 4498 mmLeft = 152400 mmTop = 529 mmWidth = 1058 BandType = 3 GroupNo = 0 end object ppLabel2: TppLabel UserName = 'Label3' HyperlinkColor = clBlue AutoSize = False Border.BorderPositions = [] Border.Color = clBlack Border.Style = psSolid Border.Visible = False Border.Weight = 1.000000000000000000 Caption = 'Novo Pre'#231'o de Venda' Ellipsis = False Font.Charset = DEFAULT_CHARSET Font.Color = clNavy Font.Name = 'TIMES NEW ROMAN' Font.Size = 11 Font.Style = [fsBold, fsItalic] TextAlignment = taCentered Transparent = True mmHeight = 4498 mmLeft = 152665 mmTop = 265 mmWidth = 42069 BandType = 3 GroupNo = 0 end object ppLabel1: TppLabel UserName = 'Label2' HyperlinkColor = clBlue AutoSize = False Border.BorderPositions = [] Border.Color = clBlack Border.Style = psSolid Border.Visible = False Border.Weight = 1.000000000000000000 Caption = 'Produto' Ellipsis = False Font.Charset = DEFAULT_CHARSET Font.Color = clNavy Font.Name = 'TIMES NEW ROMAN' Font.Size = 11 Font.Style = [fsBold, fsItalic] TextAlignment = taCentered Transparent = True mmHeight = 4498 mmLeft = 2117 mmTop = 529 mmWidth = 98425 BandType = 3 GroupNo = 0 end end object ppGroupFooterBand1: TppGroupFooterBand HideWhenOneDetail = False mmBottomOffset = 0 mmHeight = 0 mmPrintPosition = 0 end end object daDataModule1: TdaDataModule object daBDEQueryDataView5: TdaIBXQueryDataView UserName = 'Query_PROD' Height = 245 Left = 10 NameColumnWidth = 105 SizeColumnWidth = 35 SortMode = 0 Top = 10 TypeColumnWidth = 52 Width = 224 AutoSearchTabOrder = 0 object PROD: TppChildDBPipeline AutoCreateFields = False UserName = 'PROD' object ppField1: TppField FieldAlias = 'CLASD' FieldName = 'CLASD' FieldLength = 20 IsDetail = True DisplayWidth = 20 Position = 0 TableName = 'CLAS_1' end object ppField2: TppField FieldAlias = 'COD' FieldName = 'COD' FieldLength = 0 DataType = dtInteger DisplayWidth = 10 Position = 1 TableName = 'PROD_1' end object ppField3: TppField FieldAlias = 'PRODUTO' FieldName = 'PRODUTO' FieldLength = 50 DisplayWidth = 50 Position = 2 TableName = 'PROD_1' end object ppField4: TppField FieldAlias = 'MARCA' FieldName = 'MARCA' FieldLength = 20 IsDetail = True DisplayWidth = 20 Position = 3 TableName = 'MARCAS_1' end object ppField5: TppField FieldAlias = 'GARANTIA' FieldName = 'GARANTIA' FieldLength = 10 IsDetail = True DisplayWidth = 10 Position = 4 TableName = 'CLAS_1' end object ppField6: TppField FieldAlias = 'PVEND' FieldName = 'PVEND' FieldLength = 0 DataType = dtDouble DisplayWidth = 10 Position = 5 TableName = 'PROD_1' end object ppField7: TppField FieldAlias = 'PVEND2' FieldName = 'PVEND2' FieldLength = 0 DataType = dtDouble DisplayWidth = 10 Position = 6 TableName = 'PROD_1' end object ppField8: TppField FieldAlias = 'PVEND3' FieldName = 'PVEND3' FieldLength = 0 DataType = dtDouble DisplayWidth = 10 Position = 7 TableName = 'PROD_1' end object ppField9: TppField FieldAlias = 'PVEND4' FieldName = 'PVEND4' FieldLength = 0 DataType = dtDouble DisplayWidth = 10 Position = 8 TableName = 'PROD_1' end end object daSQL2: TdaSQL CollationType = ctASCII DatabaseName = 'SAT' DatabaseType = dtInterBase DataPipelineName = 'PROD' Distinct = True LinkColor = clNavy LinkType = ltMagicSQL MaxSQLFieldAliasLength = 25 SQLText.Strings = ( 'SELECT DISTINCT CLAS_1.CLASD, PROD_1.COD, ' ' PROD_1.PRODUTO, MARCAS_1.MARCA, ' ' CLAS_1.GARANTIA, PROD_1.PVEND, ' ' PROD_1.PVEND2, PROD_1.PVEND3, ' ' PROD_1.PVEND4' 'FROM PROD PROD_1 INNER JOIN PRO PRO_1 ON ' ' (PRO_1.COD = PROD_1.COD)' ' INNER JOIN MARCAS MARCAS_1 ON ' ' (MARCAS_1.COD = PROD_1.MARCA)' ' INNER JOIN CLAS CLAS_1 ON ' ' (CLAS_1.CLAS = PROD_1.CLAS)' 'WHERE ( PROD_1.SEL = '#39'T'#39' ) OR (( PRO_1.LOJA = 1 )' ' AND ( PRO_1.QUANT > 0 ))' 'ORDER BY CLAS_1.CLASD, PROD_1.PRODUTO') SQLType = sqSQL2 object daCriteria1: TdaCriteria ChildType = 7 Level = 0 Value = 'T' object TdaField Alias = 'SEL' DisplayWidth = 1 FieldAlias = 'SEL' FieldLength = 1 FieldName = 'SEL' SQLFieldName = 'SEL' TableAlias = 'PROD' TableName = 'PROD' TableSQLAlias = 'PROD_1' end end object daCriteria2: TdaCriteria ChildType = 7 CriteriaType = dacrOR Level = 0 end object daCriteria3: TdaCriteria ChildType = 7 CriteriaType = dacrBegin Level = 0 end object daCriteria4: TdaCriteria ChildType = 7 Level = 0 Value = '1' object TdaField Alias = 'LOJA' DataType = dtInteger DisplayWidth = 10 FieldAlias = 'LOJA' FieldLength = 0 FieldName = 'LOJA' SQLFieldName = 'LOJA' TableAlias = 'PRO' TableName = 'PRO' TableSQLAlias = 'PRO_1' end object TdaNumericValue Value = 1.000000000000000000 end end object daCriteria5: TdaCriteria ChildType = 7 Level = 0 Operator = dacoGreaterThan Value = '0' object TdaField Alias = 'QUANT' DataType = dtDouble DisplayWidth = 10 FieldAlias = 'QUANT' FieldLength = 0 FieldName = 'QUANT' SQLFieldName = 'QUANT' TableAlias = 'PRO' TableName = 'PRO' TableSQLAlias = 'PRO_1' end object TdaNumericValue end end object daCriteria6: TdaCriteria ChildType = 7 CriteriaType = dacrEnd Level = 0 end object daField1: TdaField Alias = 'CLASD' DisplayWidth = 20 FieldAlias = 'CLASD' FieldLength = 20 FieldName = 'CLASD' IsDetail = True SQLFieldName = 'CLASD' TableAlias = 'CLAS' TableName = 'CLAS' TableSQLAlias = 'CLAS_1' end object daField2: TdaField Alias = 'COD' DataType = dtInteger DisplayWidth = 10 FieldAlias = 'COD' FieldLength = 0 FieldName = 'COD' SQLFieldName = 'COD' TableAlias = 'PROD' TableName = 'PROD' TableSQLAlias = 'PROD_1' end object daField3: TdaField Alias = 'PRODUTO' DisplayWidth = 50 FieldAlias = 'PRODUTO' FieldLength = 50 FieldName = 'PRODUTO' SQLFieldName = 'PRODUTO' TableAlias = 'PROD' TableName = 'PROD' TableSQLAlias = 'PROD_1' end object daField4: TdaField Alias = 'MARCA' DisplayWidth = 20 FieldAlias = 'MARCA' FieldLength = 20 FieldName = 'MARCA' IsDetail = True SQLFieldName = 'MARCA' TableAlias = 'MARCAS' TableName = 'MARCAS' TableSQLAlias = 'MARCAS_1' end object daField5: TdaField Alias = 'GARANTIA' DisplayWidth = 10 FieldAlias = 'GARANTIA' FieldLength = 10 FieldName = 'GARANTIA' IsDetail = True SQLFieldName = 'GARANTIA' TableAlias = 'CLAS' TableName = 'CLAS' TableSQLAlias = 'CLAS_1' end object daField6: TdaField Alias = 'PVEND' DataType = dtDouble DisplayWidth = 10 FieldAlias = 'PVEND' FieldLength = 0 FieldName = 'PVEND' SQLFieldName = 'PVEND' TableAlias = 'PROD' TableName = 'PROD' TableSQLAlias = 'PROD_1' end object daField7: TdaField Alias = 'PVEND2' DataType = dtDouble DisplayWidth = 10 FieldAlias = 'PVEND2' FieldLength = 0 FieldName = 'PVEND2' SQLFieldName = 'PVEND2' TableAlias = 'PROD' TableName = 'PROD' TableSQLAlias = 'PROD_1' end object daField8: TdaField Alias = 'PVEND3' DataType = dtDouble DisplayWidth = 10 FieldAlias = 'PVEND3' FieldLength = 0 FieldName = 'PVEND3' SQLFieldName = 'PVEND3' TableAlias = 'PROD' TableName = 'PROD' TableSQLAlias = 'PROD_1' end object daField9: TdaField Alias = 'PVEND4' DataType = dtDouble DisplayWidth = 10 FieldAlias = 'PVEND4' FieldLength = 0 FieldName = 'PVEND4' SQLFieldName = 'PVEND4' TableAlias = 'PROD' TableName = 'PROD' TableSQLAlias = 'PROD_1' end object daField10: TdaField ChildType = 2 Alias = 'CLASD' DisplayWidth = 20 FieldAlias = 'CLASD' FieldLength = 20 FieldName = 'CLASD' SQLFieldName = 'CLASD' TableAlias = 'CLAS' TableName = 'CLAS' TableSQLAlias = 'CLAS_1' end object daField11: TdaField ChildType = 2 Alias = 'PRODUTO' DisplayWidth = 50 FieldAlias = 'PRODUTO' FieldLength = 50 FieldName = 'PRODUTO' SQLFieldName = 'PRODUTO' TableAlias = 'PROD' TableName = 'PROD' TableSQLAlias = 'PROD_1' end object daTable1: TdaTable ChildType = 5 Alias = 'PROD' JoinType = dajtNone SQLAlias = 'PROD_1' TableAlias = 'PROD' TableName = 'PROD' end object daTable2: TdaTable ChildType = 5 Alias = 'PRO' SQLAlias = 'PRO_1' TableAlias = 'PRO' TableName = 'PRO' object daTableJoin1: TdaTableJoin ChildType = 6 object daField13: TdaField ChildType = 3 Alias = 'COD' DataType = dtInteger DisplayWidth = 10 FieldAlias = 'COD' FieldLength = 0 FieldName = 'COD' SQLFieldName = 'COD' TableAlias = 'PRO' TableName = 'PRO' TableSQLAlias = 'PRO_1' end object daField12: TdaField ChildType = 4 Alias = 'COD' DataType = dtInteger DisplayWidth = 10 FieldAlias = 'COD' FieldLength = 0 FieldName = 'COD' SQLFieldName = 'COD' TableAlias = 'PROD' TableName = 'PROD' TableSQLAlias = 'PROD_1' end end end object daTable3: TdaTable ChildType = 5 Alias = 'MARCAS' SQLAlias = 'MARCAS_1' TableAlias = 'MARCAS' TableName = 'MARCAS' object daTableJoin2: TdaTableJoin ChildType = 6 object daField15: TdaField ChildType = 3 Alias = 'COD' DataType = dtInteger DisplayWidth = 10 FieldAlias = 'COD' FieldLength = 0 FieldName = 'COD' SQLFieldName = 'COD' TableAlias = 'MARCAS' TableName = 'MARCAS' TableSQLAlias = 'MARCAS_1' end object daField14: TdaField ChildType = 4 Alias = 'MARCA' DataType = dtInteger DisplayWidth = 10 FieldAlias = 'MARCA' FieldLength = 0 FieldName = 'MARCA' SQLFieldName = 'MARCA' TableAlias = 'PROD' TableName = 'PROD' TableSQLAlias = 'PROD_1' end end end object daTable4: TdaTable ChildType = 5 Alias = 'CLAS' SQLAlias = 'CLAS_1' TableAlias = 'CLAS' TableName = 'CLAS' object daTableJoin3: TdaTableJoin ChildType = 6 object daField17: TdaField ChildType = 3 Alias = 'CLAS' DataType = dtInteger DisplayWidth = 10 FieldAlias = 'CLAS' FieldLength = 0 FieldName = 'CLAS' SQLFieldName = 'CLAS' TableAlias = 'CLAS' TableName = 'CLAS' TableSQLAlias = 'CLAS_1' end object daField16: TdaField ChildType = 4 Alias = 'CLAS' DataType = dtInteger DisplayWidth = 10 FieldAlias = 'CLAS' FieldLength = 0 FieldName = 'CLAS' SQLFieldName = 'CLAS' TableAlias = 'PROD' TableName = 'PROD' TableSQLAlias = 'PROD_1' end end end end end object daIBXQueryDataView3: TdaIBXQueryDataView UserName = 'Query_PrecosAlterados' Height = 255 Left = 284 NameColumnWidth = 105 SizeColumnWidth = 35 SortMode = 0 Top = 10 TypeColumnWidth = 52 Width = 338 AutoSearchTabOrder = 0 object PrecosAlterados: TppChildDBPipeline AutoCreateFields = False UserName = 'PrecosAlterados' object ppField1: TppField FieldAlias = 'PRODUTO' FieldName = 'PRODUTO' FieldLength = 50 DisplayWidth = 50 Position = 0 TableName = 'PROD_1' end object ppField2: TppField FieldAlias = 'DATAULTIMAALTERACAO' FieldName = 'DATAULTIMAALTERACAO' FieldLength = 0 DataType = dtDateTime DisplayWidth = 18 Position = 1 TableName = 'PROD_1' end object ppField3: TppField FieldAlias = 'PVEND' FieldName = 'PVEND' FieldLength = 0 DataType = dtDouble DisplayWidth = 10 Position = 2 TableName = 'PROD_1' end end object daSQL1: TdaSQL CollationType = ctASCII DatabaseName = 'SAT' DatabaseType = dtInterBase DataPipelineName = 'PrecosAlterados' IsCaseSensitive = True LinkColor = clMaroon LinkType = ltMagicSQL MaxSQLFieldAliasLength = 25 SQLText.Strings = ( 'SELECT PROD_1.PRODUTO, ' ' PROD_1.DATAULTIMAALTERACAO, PROD_1.PVEND' 'FROM PROD PROD_1' 'WHERE ('#39'c'#39' <> '#39'c'#39' ) AND (' ' ( PROD_1.DATAULTIMAALTERACAO >= '#39'10/30/2013 00:00:00'#39' )' ' )') SQLType = sqSQL1 object daCriteria1: TdaCriteria ChildType = 7 Level = 0 Operator = dacoGreaterThanOrEqualTo ParamName = 'DataAlteracao' Value = '30/10/13' object TdaField Alias = 'DATAULTIMAALTERACAO' DataType = dtDateTime DisplayWidth = 18 FieldAlias = 'DATAULTIMAALTERACAO' FieldLength = 0 FieldName = 'DATAULTIMAALTERACAO' Mandatory = True SQLFieldName = 'DATAULTIMAALTERACAO' TableAlias = 'PROD' TableName = 'PROD' TableSQLAlias = 'PROD_1' end object TdaNumericValue Value = 41577.000000000000000000 end end object daField1: TdaField Alias = 'PRODUTO' DisplayWidth = 50 FieldAlias = 'PRODUTO' FieldLength = 50 FieldName = 'PRODUTO' SQLFieldName = 'PRODUTO' TableAlias = 'PROD' TableName = 'PROD' TableSQLAlias = 'PROD_1' end object daField2: TdaField Alias = 'DATAULTIMAALTERACAO' DataType = dtDateTime DisplayWidth = 18 FieldAlias = 'DATAULTIMAALTERACAO' FieldLength = 0 FieldName = 'DATAULTIMAALTERACAO' SQLFieldName = 'DATAULTIMAALTERACAO' TableAlias = 'PROD' TableName = 'PROD' TableSQLAlias = 'PROD_1' end object daField3: TdaField Alias = 'PVEND' DataType = dtDouble DisplayWidth = 10 FieldAlias = 'PVEND' FieldLength = 0 FieldName = 'PVEND' SQLFieldName = 'PVEND' TableAlias = 'PROD' TableName = 'PROD' TableSQLAlias = 'PROD_1' end object daField4: TdaField ChildType = 2 Alias = 'DATAULTIMAALTERACAO' DataType = dtDateTime DisplayWidth = 18 FieldAlias = 'DATAULTIMAALTERACAO' FieldLength = 0 FieldName = 'DATAULTIMAALTERACAO' SQLFieldName = 'DATAULTIMAALTERACAO' TableAlias = 'PROD' TableName = 'PROD' TableSQLAlias = 'PROD_1' end object daTable1: TdaTable ChildType = 5 Alias = 'PROD' JoinType = dajtNone SQLAlias = 'PROD_1' TableAlias = 'PROD' TableName = 'PROD' end end end end object ppParameterList1: TppParameterList object ppParameter1: TppParameter AutoSearchSettings.Enabled = True AutoSearchSettings.FieldAlias = 'DATAULTIMAALTERACAO' AutoSearchSettings.LogicalPrefix = [] AutoSearchSettings.Mandatory = True AutoSearchSettings.SearchExpression = '41577' AutoSearchSettings.SearchOperator = soGreaterThanOrEqualTo DataType = dtDate LookupSettings.DisplayType = dtNameOnly LookupSettings.SortOrder = soName Value = 41577d UserName = 'DataAlteracao' end end end