Posts by Tiago Casanova • 778 points
83 posts
-
1
votes2
answers2102
viewsQ: Case no order by
I am trying to make an order by as the result of sql: sql.... order by cod_rua, case cod_lado when 'M' then cod_lado desc else cod_lado ASC end, cod_altura Only you’re making a mistake on the way…
-
0
votes1
answer113
viewsQ: Securing a Transaction
I have a table of Tags with sequential ID incremented in hand, because it Zera every day. I have a Tag registration screen where I pass the amount of tags to be generated: Vrg := Select MAX onde eu…
-
1
votes3
answers2481
viewsQ: Find a component by name
I have a string: var vMinhastring : string; begin vMinhastring := 'Edit1'; In my form I have a Tedit Compomente with the name Edit1. How I pass some value to my Edit1, using vMinhastring as the…
-
0
votes1
answer843
viewsQ: Delphi picking value from the field created at runtime
Create at runtime various Tradiogroup: Rdb1:= TRadioGroup.Create(Painel); But with the same name "Rdb1". My doubt is how I get the value of the field that was selected. I tried to do so: Rdb1.OnExit…
-
2
votes2
answers790
viewsQ: Inputbox lock CTRL+V
I have the following code: vResultado := InputBox(Application.Title, 'Leia o cartão de Segurança:', ''); There is a way to block copy and paste in Inputbox?
-
0
votes2
answers2456
viewsQ: Download events Onkeydown and Onexit
I have the following code at the events: Onexit: procedure TFEqt_Pallet.EdNr_PalletExit(Sender: TObject); var MeuKey: word; begin MeuKey := 13; EdNr_PalletKeyDown(EdNr_Pallet,MeuKey,[]); end;…
-
5
votes1
answer145
viewsQ: Development windows CE Cortex-A9
I have a Processor Collector: Ti Cortex-A9 OMAP4430, I have developed a clamp using Lazarus 1.6.2, I am trying to compile, I am getting the following message: Error: Illegal Parameter: -Cpcortexm3…
-
1
votes2
answers431
viewsQ: Create Login screen at runtime
How to create within a ShowMessage or ShowModal a message where the user would have to enter the code and password, when leaving this ShowMessage I can get this information (code and password) to…
-
1
votes2
answers943
viewsQ: Adding Hours greater 24 h
The sql statement returns me the time type hours: | Horas | |20:52:00| |12:42:00| |09:00:00| |07:45:00| I would like to add the total hours, but that way he is "zeroing" when it reaches 24 hours.…
-
1
votes2
answers584
viewsQ: Make a General Sum with all fields
I have the following tables: tb_product, tb_movement COD_PROD | DESCRICAO | TIPO | |01 | CEBOLA | ALIMENTO | |02 | ARROZ | ALIMENTO | |03 | CARNE | ALIMENTO | |04 | COCA-COLA | BEBIDA | |05 | PINGA…
-
5
votes1
answer95
viewsQ: Concatenate two sql
I have the records: |DT_OBS | DESC_OBS | COD_TURNO | COD_PERIODO| |01.10.16| TESTE 01| 1 | 1 | |01.10.16| TESTE 02| 2 | 1 | |01.10.16| TESTE 03| 1 | 2 | |02.10.16| TESTE 04| 1 | 1 | |02.10.16| TESTE…
-
0
votes0
answers143
viewsQ: Delphi Datamatrix Static size
I am working with Data Matrix I am using the Unit Datamatrixbarcode, dmtx. var options:DatamatrixEncodeOptions; options := InitializeDatamatrixEncodeOptions; options.moduleSize := 4;…
-
4
votes1
answer75
viewsQ: Sql group records
I have the following appointment: select T1.dt_producao, T1.cod_turno, T1.cod_periodo, CASE WHEN T2.TP_PALLET = 'DZ' THEN sum(T1.QT_PROD* T2.QT_EMBALAGEM*12) ELSE sum(T1.QT_PROD* T2.QT_EMBALAGEM)…
-
2
votes1
answer793
viewsQ: Delphi Decimal Converter for Hours
I have the following decimal 0,0159722222222222 I want to turn into hours in the following format 00:23:00.
-
0
votes0
answers63
viewsQ: Delphi trlReport with Group does not load the first record
I have the sql return: |dt_producao| |20/09/2016 | |20/09/2016 | |20/09/2016 | |21/09/2016 | |21/09/2016 | |22/09/2016 | |24/09/2016 | I’m trying to create a report that makes me join: |dt_producao|…
-
1
votes1
answer46
viewsQ: SQL query using order by filtering by log
I have the table: | cod | hora | produto | Amostra | Min | Max | |-----|-------|---------|---------|-----|-----| | 1 | 08:00 | 96722 | 1 | 100 | 200 | | 2 | 08:23 | 96721 | 1 | 90 | 90 | | 3 | 08:50…
-
0
votes1
answer2205
viewsQ: Select using Join with Distinct
I have two tables: tb_movement | cod | dt_producao | qt_prod | |-----|--------------|---------| | 1 | '04.08.2016' | 10 | | 2 | '04.08.2016' | 5 | | 3 | '09.08.2016' | 12 | | 4 | '10.08.2016' | 3 |…
-
2
votes2
answers363
viewsQ: Error '15.0' is not a Valid floating point value when saving . xls
While trying to save a file. xls I am having the following error: '15.0' is not a Valid floating point value I’m trying to save like this: var HCalc : THojaCalc; vArquivo : String; vArquivo :=…
-
0
votes1
answer271
viewsQ: Lazarus depurador invalido
I installed: Lazarus 1.4.0/FPC 2.6.4 Lazarus Wince Cross Compile within folder C: Lazarus At Lazarus I made the following configuration: 1 -…
-
1
votes1
answer78
viewsQ: Tbquery back N records
No Lphi if I give one TbQuery.prior It returns a record. But if I want to go back N records, for example, I want to go back 5 records. Does anyone know if there are any methods in Delphi that do…
-
0
votes3
answers710
viewsQ: Sorting using Dbgrid with Clientdataset
I’m using a Dbgrid along with a Datasource. And I’m willing to do the ordering as the client clicks on the title. I made the following settings: On my Dbgrid on the Datasource property I inked my…
-
1
votes1
answer1191
viewsQ: Unsupported on-disk Structure
I was developing in Delphi using Firebird 2.5. And it started to give an error when trying to connect to the local database. When trying to connect it from the following message: Error: unsupported…
-
3
votes2
answers105
viewsQ: Query bringing all records, and filter the repeated
Have table mov_pallet(some records): movpallet rua altura posicao hora produto data pallet 1.424.959 1 C 4 09:30:07 18.342 02.05.2016 456.074 1.424.960 1 C 4 09:27:07 18.399 05.05.2016 456.182…
-
1
votes2
answers346
viewsQ: Show streets and images in Type Satellite by default
I am wanting to show the names of the streets and establishments by default. What would be the option? I am doing so: var myOptions = { scrollwheel: false, center: new google.maps.LatLng(lat,…
-
9
votes2
answers879
viewsQ: Recover Error messages via json in Angular
I’m trying to register using Angularjs, but I want to get the validations that are in my model in Rails. But I’m having difficulties: Covenat(model) Rails validates :name, presence: true controller…
-
4
votes1
answer136
viewsQ: synchronize two screens
I am starting to develop a scheduling system in Rails and I have the following problem: Let’s say I have two open screens in my book: 1.1 - First screen opens on doctor’s computer. 1.2 - Second…
-
1
votes3
answers54
viewsQ: Adding Current class to the menu
I’m having the problem in my JS it’s adding the Current class to all the #li. html <ul id="navlist"> <li id="home"><a href="/">Home</a></li> <li id="sobre"><a…
-
5
votes3
answers18417
viewsQ: How to catch the child element
I’m trying to get the value of the plan by clicking the button. html <div class="price-button"> <input type='hidden' name='plano' value='Plano Padrão' /> <button type="button"…
-
1
votes1
answer85
viewsQ: Using Jekyll to create a news for
I’m having the following doubt as I create a news for? I have to add something inside the config.yml file? Inside the _post folder I have the file 2015-03-03-Welcome-Jekyll.markdown --- layout: post…
-
0
votes1
answer53
viewsQ: How to use text_field via ajax
I am trying to call via ajax a function in a text_field field, I tried it in two ways: 1 - From Undefined method remote_function error. <%= f.text_field(:data, class: "form-control", :remote…
-
2
votes1
answer78
viewsQ: Render a layout across multiple sites
I have the following situation, I have several sites with different layouts and databases, but I wanted them to use the same administrative area, the same Gems, because if I need to fix a bug in the…
-
1
votes1
answer105
viewsQ: Search using Solr in Rails
If I search for a piece of a word other than the first characters of the word he doesn’t think. Like if I search for "Car" it searches correctly, but now if I search for "los" or "arlos" returns me…
-
0
votes1
answer108
viewsQ: Rails 4 select Uniq
I have the table Items: id enrollment_id turma_id 11 2 2 12 2 3 13 2 2 14 2 2 15 2 3 I want my result to be this: id enrollment_id turma_id 11 2 2 12 2 3 That is I want all the items, but that does…