Posts by Tiago Casanova • 778 points
83 posts
-
-3
votes0
answers15
viewsQ: Embroider round on Trldraw component
In Strong Report I have the Trldraw component in it I can set in the property Drawkind = dkRectangle, where a rectangle is drawn, I would like the corners to be rounded, someone knows which property…
-
0
votes0
answers14
viewsQ: Strong Report running Trlband more than once
I have a Fort Report, inside it I have a Trlband with bandType = btDetail, in the Beforeprint I have the following code: procedure TFRel_QualidadeFomento.RLBand2BeforePrint(Sender: TObject; var…
-
0
votes0
answers93
viewsQ: OLE Error Windows Xp
I have an application developed in Delphi, while running only on Windows XP computers I am having the following error: OLE error 80131513, ClassID: {3A8B6B96-4F23-4EB5-B4B1-243BFBC41A39} Follows my…
-
0
votes1
answer211
viewsA: Group records and create column in SQL Firebird
I decided as follows: select MAQUINA,LOTECA,DTPOST, SUM(case when SEXOCARR = 'Fêmeas' then QTDEPINT else 0 end) as FEMEAS, SUM(case when SEXOCARR = 'Machos' then QTDEPINT else 0 end) as MACHOS FROM…
-
0
votes1
answer211
viewsQ: Group records and create column in SQL Firebird
I have the following records: |MAQUINA|LOTECA| DTPOST |SEXOCAR|QTDEPIN| |17 MAQ |602121|02/04/20|Fêmeas | 9300 | |17 MAQ |602121|02/04/20|Machos | 9600 | |17 MAQ |602121|02/04/20|Fêmeas | 100 | |18…
-
0
votes1
answer52
viewsQ: Httpwebresponde format return
I have the following Code: try { public string ProcessAttachment(string fileInput) { HttpWebRequest req =…
c#asked Tiago Casanova 778 -
0
votes0
answers81
viewsQ: Httpwebrequest Proxy-Connection Set
I’m trying to accomplish the WCF sending via SOAP. Can send via SOAPUI, as picture there is the parameter "Proxy-Connection": In C# there is no such parameter "Proxy-Connection": HttpWebRequest req…
c#asked Tiago Casanova 778 -
1
votes2
answers340
viewsQ: How to communicate with SOAP webservice
I am trying to communicate with a SOAP Webservice. I was able to communicate using SOAPUI as image: I am developing this communication in c# as follows: try { var service = new…
-
0
votes1
answer154
viewsQ: C# take a part of a String
I have a string that in case you have "-" I want to only take what is before the "-" var value = "12345-485" or "7896" I tried using: value. Substring(0,value. Index("-")); If the value has "-"…
c#asked Tiago Casanova 778 -
1
votes1
answer44
viewsQ: C# convert Object to Object[]
I have the following code: var pagamento = new PefService.Pagamento(); pagamento.IdPagamentoCliente = "teste"; ...... //resquest.Pagamentos é PefService.Pagamento[] request.Pagamentos = pagamento;…
c#asked Tiago Casanova 778 -
2
votes1
answer33
viewsQ: Returning Internalservererror a Tuple list
I have the following code: public async Task<IHttpActionResult> Gravar() { List<Tuple<string, string>> statusRetorno = new List<Tuple<string, string>>();…
-
0
votes2
answers42
viewsQ: SQL formatting field
I have the following structure: |VALOR| | 1 | | 23 | | 5 | | 41 | I have a need to transform: | VALOR | | 0001 | | 0023 | | 0005 | | 0041 | Is there any function I can do that?…
-
0
votes2
answers44
viewsQ: Changing positions of an integer
Citation I am building an sql where I have the following information yyyymmdd 20190327 is in the database as integer, I need to convert into ddmmyyyy 27032019 continuing to be an integer in select.…
-
1
votes0
answers341
viewsQ: SQL using Join with subquery
I have the following code: select FACAV_CDMATCOOP,CCCCO_NOCOOPERAD,FACLA_ORIDAVIAR FACLA_QTPESOLOTE, FACLA_QTENTREG1, FACAV_ORCDAVIAR, FACLA_NRLOTE, FACLA_DTYALOJA, FATCR_QTPESOMED from FACAV F…
-
1
votes1
answer501
viewsQ: Use in select percentage in Firebird
I have the following instruction in Excel: (100%-2%)*2135,68 I want to make an sql: Select (100%-2%)*T.valor as TOTAL from tb_teste T In Firebird I can’t work with %. How can I get around this?…
-
0
votes1
answer185
viewsQ: Using Count with select all
I am wanting to make an sql counting the records with duplicity: select produto,matricula,data,fornecedor, count(*) from tb_teste group by produto,matricula order by fornecedor This way of the…
-
0
votes1
answer619
viewsA: Using in SQL coalesce with Date
Resolved as follows: ...and cast(coalesce(tb_cadastro.dt_pallet,'')as date) = coalesce(:DT_PALLET, cast(coalesce(tb_cadastro.dt_pallet,'') as date))
-
2
votes1
answer619
viewsQ: Using in SQL coalesce with Date
I have the following question. In SQL your doing so works. ...and coalesce(tb_cadastro.cod_produto,'') = coalesce(:COD_PRODUTO, coalesce(tb_cadastro.cod_produto,'')) and ... Where the COD_PRODUTO is…
-
-1
votes5
answers1444
viewsQ: Query pass null parameter
I can pass the value is null or is not null through a Query? Example in SQL: select * from tb_teste where tb_teste.data_hora :PARAMETRO; At Delphi: Query.ParamByName('PARAMETRO').value = 'is not…
-
3
votes3
answers97
viewsQ: Relationship between the tables
I have the following tables: TB_ESTOQUE |COD_PRODUTO|QT_DISPONIVEL|COD_FILIAL| | 0856322 | 5 | 41 | | 0856351 | 2 | 41 | | 0856322 | 9 | 114 | | 0856720 | 3 | 20 | | 0856322 | 8 | 128 | | 0856322 |…
-
1
votes1
answer45
viewsQ: Sql using left Join
I have the following tables: TB_ESTOQUE |PRODUTO|QT_DISPONIVEL|COD_FILIAL| |0856322| 5 | 41 | |0856351| 2 | 41 | |0856322| 9 | 114 | |0856720| 3 | 20 | TB_FILIAL |COD_FILIAL|COD_LOCALADM| | 41 | 114…
-
1
votes3
answers488
viewsQ: Using Datetimepicker with Time
I’m using the Tdatetimepicker component. I put in the FORMAT property the following value: dd/MM/yyyy HH:mm:ss Running in form if not "click" on component and change values, example 21/09/2018…
-
3
votes2
answers385
viewsQ: SQL using sum
I have the following structure: | Data |Quantidade|QTCxVer|QTCxBra| |04.09.18| 10 | 1 | | |04.09.18| 30 | | 3 | |04.09.18| 40 | | 4 | |04.09.18| 50 | 5 | | |05.09.18| 20 | 2 | | |05.09.18| 10 | | 1…
-
0
votes1
answer114
viewsQ: Wcf access via https
I have the following error accessing a https url: O esquema de URI do provedor 'https' é inválido; esperado 'http'.\r\nNome do parâmetro: via My file to <?xml version="1.0" encoding="utf-8" ?>…
-
2
votes1
answer483
viewsQ: Taking the name of the Standard Printer
I can get the default printer name declared Printers in the uses section: Printer.Printers[Printer.PrinterIndex] If by chance, while running the program the user changes the default printer. How do…
-
3
votes2
answers490
viewsQ: Using case in null field
I have the following structure tb_boletim: |Cod|boletim|dt_enviado| | 1 | N | NULL | | 2 | S |24/08/2018| | 3 | S | NULL | | 4 | S |23/08/2018| | 5 | S |23/08/2018| | 6 | S | NULL | | 7 | N | NULL |…
-
18
votes1
answer285
viewsQ: Webservice Registering dll
I have the following code: CoInitialize(nil); try DM_Principal.pLarWS := CreateComObject(LarWS_TLB.CLASS_WS) as IWS; except WinExec( 'regasm LarWS.dll /tlb:LarWS.tlb',SW_HIDE); Screen.Cursor :=…
-
3
votes1
answer774
viewsQ: Print coil style on Rlreport
I developed a coupon-style report, where I have the header and items of my note. RLReport - PageSetup: Orientation : poPortrait PaperHeight : 220 PaperSize : fpCustom PaperWidht : 80 In my Rlreport…
-
2
votes1
answer46
viewsQ: Signaling the last SQL record
I have the following SQL: select cod_nota, cod_local, cod_produto, valor from pedido order by cod_nota,cod_local,cod_produto With the result: |cod_nota|cod_local|cod_produto| Valor | | 501 | 01 |…
-
2
votes0
answers266
viewsQ: Delphi sql using coalesce
In Delphi I have Tibquery: select * from TB_PRECO where coalesce(DT_CAMPANHA,'') = coalesce(:DT_CAMPANHA,coalesce(DT_CAMPANHA,'')) and coalesce(DT_VECTOPRECO,'') >= coalesce(:DT_ATUAL,…
-
1
votes2
answers838
viewsQ: Delphi herring values
I have the following problem: | Result | 10 / 0,9280 = | 10,77 | 10 / 0,8740 = | 11,44 | 214,35 / 0,9280 = | 230,98 | Note: This information is recorded on the rounded server, like the example. Now…
-
0
votes1
answer520
viewsQ: query receive value from another query
There is a way for a Tibquery to receive the other Tibquery. For example: Query1.Close; Query1.Open; Query2 := Query1; if Query2Valor1.... // segue a lógica
-
0
votes2
answers347
viewsQ: Lazarus Debugando
In Delphi in debug mode I can check the value of a field, for example: if Edit.text = '' then If you hover over Edit I will be able to visualize the value of the field. How do I do this in Lazarus?…
-
0
votes1
answer50
viewsQ: SQL grouping information
I have the following sql statement: SELECT * FROM TB_CADPRECO WHERE MAT_GESTOR = 123 AND UF_PRODUTO LIKE 'PR' AND TIPO_CAMPANHA = 5 AND DT_CAMPANHA = '01.08.2018' UNION SELECT * FROM TB_CADPRECO…
-
2
votes1
answer248
viewsQ: Fetch ip via sql
Does anyone know if there is a way for me to search via sql (Firebird) all ips that are using a Table or Views? I am trying to update a view, but am trying the following error: This operation is not…
-
2
votes3
answers1806
viewsQ: SQL searching records from a Date and Time
I have the following SQL: select * from tb_valores where DATA >= '14/12/17' and HORA >= '16:34:00') I would like to bring all records from that date and time. The problem is that if I have…
-
2
votes1
answer247
viewsQ: Error Char to String conversion
I have the following code: procedure TDM_Maquinas.IBQCons_MaquinasCOD_LINHAGetText(Sender: TField; var Text: string; DisplayText: Boolean); begin Text := Sender.AsString; if Text <> '' then…
-
6
votes2
answers155
viewsQ: Incompatible data types when calling Procedure
I’m having trouble calling the next trial in my form: procedure TDM_Maquinas.IBDSMaquinasCOD_LINHASetText(Sender: TField; const Text: string); begin if Text <> '' then begin if Text = 'Linha…
-
1
votes1
answer517
viewsQ: Auto complete Dblookupcombobox
I have a Dblookupcombobox2 with the following information: 42-batata 45-cebola 78-caneca 49-faca 79-livro If the number is entered the search is done, but with letters does not work. For example I…
-
3
votes1
answer2406
viewsQ: Using the Firebird SQL case statement
I’m trying to make the following sql in Firebird. select distinct tb_proostarefas.*, (case WHEN (tb_proostarefas.dt_prev is null and tb_proostarefas.dt_vencimento < date) then 1 When…
-
0
votes1
answer483
viewsQ: Using Tdbcombobox compounding
I have the following problem, when I select an item in Tdbcombobox when leaving the component it automatically selects the last record. DM_BancoInsumos.IBQCons_ForneInsumos.Close;…
-
2
votes1
answer142
viewsQ: GS1 tags Code128 subset C
Has anyone implemented the standard GS1 barcode? In the pattern there is a barcode Code128. I’m trying to implement using Code 128 subjet C, my number of digits will be odd. How it has to be:…
-
2
votes0
answers122
viewsQ: Delphi Rlanglelabel lose quality
Does anyone use Fortesreport’s Rlanglelabel? This component loses quality in the printing, what is circulating is using the Rlanglelabel, as we can notice it loses quality. Does anyone know if there…
-
0
votes2
answers162
viewsQ: Lazarus Comparing Dates
In the data collector I can configure the format of Data, but I want to make this configuration within my application, I am trying to do as follows: FormatSettings.ShortDateFormat := 'dd-mm-yy';…
-
0
votes0
answers41
viewsQ: Data Collector MX7
Does anyone know how I put an automatic ENTER after reading the barcode on the Honeywell Model MX7 collector, searched the manual but found nothing that could help me.
lazarusasked Tiago Casanova 778 -
0
votes1
answer736
viewsQ: Radiogroup select item through a string
I have a radioGroup with the items: 0 : bola 1 : futebol 2 : gol 3 : chuteira 4: jogador How to select the Index by the value recorded in the bank which is "ball, football...".…
delphiasked Tiago Casanova 778 -
0
votes0
answers150
viewsQ: Dbgrid with following error out of memory
I have the following Dbgrid error. out of memory - dbgrid This error is giving only on Windows XP.
-
1
votes3
answers50
viewsQ: Returning information recorded in the bank
I have a system that is installed on an unstable network, my doubt is the following, if at some point in my recording I lose the connection to the database, how do I undo what was done in the…
-
0
votes1
answer348
viewsQ: Using Case in Order By with Union
I’m having trouble using Order by com Case on Union, so it works: select tb_a.nr_rua, tb_a.cod_altura, tb_a.cod_posicao, tb_a.cod_lado where ...... union all select tb_b.nr_rua, tb_b.cod_altura,…
-
0
votes0
answers42
viewsQ: Lazarus before searching has to commit
Have you been there? If I have a query, and the result may change from third party programs Lazarus does not see that change unless before the search the commit is made and then the search. The…
lazarusasked Tiago Casanova 778