Posts by David • 4,330 points
170 posts
-
2
votes4
answers7473
viewsA: How do I display the same phone number from the OLX site?
I know it’s in javascript, but I decided to do it in css :) .telefone { width :90px; } .overflow { white-space: nowrap; width: 100%; overflow: hidden; text-overflow: ellipsis; } .overflow:active {…
-
0
votes2
answers162
viewsA: I cannot enter data in Sqlite Table
Notice I edited your question, formatting the SQL, 'cause it makes it easier to understand. And I realized that the codbarras and embalagem_vol sane NUM, and you’re passing a text on insert, try to…
-
2
votes1
answer1292
viewsQ: How to create a windows environment variable
I need to create an environment variable in windows, through a batch. I can create a local variable with set variavel=valor But I need to access this value through other batch. how do I create a…
-
1
votes1
answer57
viewsA: How to count Planilhagoogle
To make it simpler, first let’s take the "x" of the number, so I converted the values to the column B, house line, of B1 to B5, using the formula: =LEFT($A1;LEN($A1)-1)*1 Then we have to 4.75x has 5…
google-drive-apianswered David 4,330 -
1
votes3
answers124
viewsA: Return only the time in Select
Elaine, I don’t think you need to create the horalocacao and horadevolucao, can do as follows: Based on the data you passed, the table creation would look like this: CREATE TABLE LOCACAO (loc_codigo…
-
3
votes1
answer531
viewsA: Best Mysql performance (one table or multiple tables)
TL;DR: A table. If you hadn’t put it in context, answer would be that there would be no difference, because if you forget the business rule to be applied, and understand only data storage, the two…
-
0
votes3
answers212
viewsA: Capture the WHERE clause of an SQL query
I don’t know Python, I don’t know how you do right to assign a select for a variable because of the quotes, but here is an example I found in the documentation applied to your case. According to…
-
5
votes1
answer140
viewsA: Set a group in regex
Usually in regular expressions the Hyphen - is a sequence indicator, for example, rather than writing [abcdefgh], we write, [a-h]. Or capitalize and minuscule with, [a-hA-H]. This way the Hyphen is…
-
31
votes4
answers6983
views -
2
votes1
answer110
viewsQ: SQL query using several times the same function
I have a function that converts the identification of a version to number, example, of 1.0.0 for 10000, because I can filter the results. Function: CREATE OR REPLACE FUNCTION…
-
3
votes2
answers681
viewsA: Download during installation by Inno Setup
You can use the plugin Inno Download Plugin. Example of use: #include <idp.iss> [Files] Source: "{tmp}\file1.xyz"; DestDir: "{app}"; Flags: external; ExternalSize: 1048576 Source:…
-
3
votes2
answers2704
viewsA: Bootstrap 3 - Input spacing
In the div which determines the size when adding the form-control, has the expected result, has also been removed the <br /> to stay the same distance: <link…
-
2
votes1
answer1934
viewsA: Difference between acceptance test and system test
Validation Test The software is mounted as a package and the validation of it is performed through a series of tests black box purpose: demonstrate compliance with functional and performance…
-
0
votes2
answers169
viewsA: How to make the variable appear on the screen before it is modified?
Arthur, you have 3 variables defined S,S2 and N1, right? So let’s use the S and S2. As done, and this correct, keep the value in S of multiplication: S <- N1 * 2 Now let’s use the value that is…
-
-1
votes1
answer410
viewsA: Call the USSD IONIC number
To make it functional you need to provide access in config.xml, add: <access origin="tel:*" launch-external="yes"/> Source: it1me.with…
-
1
votes2
answers643
viewsA: Smooth serration in the gradient
The way the saw will exist 50%/50% the gradient is not applied because there is no transition, but if the difference is 0.05%, already improves the result, because a little gradient will be applied.…
-
0
votes1
answer35
viewsA: Problems when creating an event
As documentation on Create Event, I changed your scripts by adding the command Delimiter, because this way Mysql ignores the ;, to execute the command in a block, something like that. More details…
-
2
votes1
answer1693
viewsA: The Provider is not compatible with the version of Oracle client
Cesar, I’m not sure, but I think I have to install Oracle Developer Tools for Visual Studio 2015, within the facility has the Prior, which is complaining of the compatibility. Data Access Components…
-
0
votes2
answers249
viewsA: Translation SQL Script for Oracle
Try it that way: SELECT (TO_DATE('20161008', 'YYYYMMDD') - MAX(DatBase)) AS diasdiferenca ,MAX(DatBase) AS datalimite ,COUNT(1) AS qtde_registros FROM DELQMST WHERE datbase <= TO_DATE('20101205',…
-
7
votes2
answers12161
viewsQ: Difference between RIGHT JOIN and LEFT JOIN
I have a little knowledge in relationship tables, read the answers to the question about What is the difference between INNER JOIN and OUTER JOIN?, and understood, theoretically. LEFT JOIN Returns…
-
0
votes1
answer97
views -
1
votes2
answers6054
viewsA: Windows CMD - Setar String with Accentuation
As @Bacco said, it could be a problem with encoding. A while ago I had this problem, which still generated new .bat from another .bat, to settle I switched to Windows-1252, adding the command below…
-
0
votes2
answers3542
viewsA: Compare with earlier date in oracle
And if you do it simply: SELECT * FROM carros car WHERE TO_DATE(car.datacompra,'YYYY-MM-DD') = TRUNC(SYSDATE-7)
-
2
votes1
answer393
viewsA: Save a field log only if it is Insert (Trigger SQL Server)
Jeterson, I have more knowledge in Oracle, but searching a little with key terms, I believe it will solve your problem. SQL_STATEMENT It is the conditions and actions of the trigger. The trigger…
-
0
votes1
answer97
views -
0
votes1
answer42
viewsA: Error reading Like with Timestampdiff
You can only use column nicknames on GROUP BY, ORDER BY or HAVING. The SQL standard does not allow you to refer to a column alias in a clause WHERE. This restriction is imposed because when the code…
-
1
votes2
answers1243
viewsA: How does the App Store App versioning control work?
The format you are using, 1.0.1.10, the 10 would be the build nomenclature you are making, right? Searching and as per Apple versioning documentation, the standard is required for 1.2.3, that it…
-
3
votes1
answer395
viewsA: How to get the size of an external window
I’ll pass the basics for you to implement, first we need to find out what the Handle of the application: var hWindow : THandle; begin hWindow := FindWindow(nil, 'Calculadora'); end; With this we can…
-
1
votes1
answer364
viewsA: Create Radiogroup based on Combobox selection using INI, dynamically in Delphi
To solve the problem, there should be a way to load the TComboBox based on the . ini already created: [CATEGORIA] 0=CATEGORIA1 1=CATEGORIA2 2=CATEGORIA3 A for would solve, but for each category…
-
1
votes1
answer1031
viewsA: How to set a maximum size for a BLOB field?
To solve your problem, we can put a constraint check, and enforce domain integrity by limiting the values that are accepted by a column. They are similar to FOREIGN KEY as they control the values…
-
1
votes1
answer206
viewsA: How to use indentation lines in Delphi XE7?
For error have given by missing dll DelForEx21.dll, then regarding the name we have the Delforexp component, which has been integrated the Gexperts code base in an experimental version of Gexperts,…
-
0
votes3
answers32392
viewsA: Changing window.location.href does not redirect to the new page
The window.location.href property returns the URL of the current page, for example, if I open put in the console the command below on the page of this question, we will return the URL of this page:…
javascriptanswered David 4,330 -
2
votes1
answer748
viewsA: batch script - move parent directory and subdirectory
As I’m not sure I understand correctly, then we have 2 ways to solve your problem. The form below will copy all files with the extension and subfolders to the destination and create the same folders…
-
0
votes3
answers3855
viewsA: Differences between Git and Mercurial
Git has many good services and the best solutions for continuous integration, loses on the interface part, ok has Sourcetree and Magit, but nothing compared to Tortoisehg, HG’s performance is much…
-
1
votes1
answer102
viewsA: Send multiple "select" text to the same "input text"?
When using the input.value = option.innerHTML;, every time you click on a new word from select, your input will receive a new value, but what we want is to concatenate the values to form a sentence,…
javascriptanswered David 4,330 -
3
votes1
answer3054
viewsQ: Book query by ISBN and save result in txt via console.log
Context: I have a list of ISBN (International Standard Book Number) with about 100 records, all Brazilian books, and wanted to get the information about the book in a faster way, but it doesn’t have…
javascriptasked David 4,330 -
1
votes1
answer364
viewsQ: Create Radiogroup based on Combobox selection using INI, dynamically in Delphi
Context: With the use of a personal app made on Delphi-7, I have been adding new actions as needed in a TRadioGroup, but now contains many items (16), harming the usability of the application. What…
-
0
votes1
answer679
viewsA: Conversion of Oracle to Sqlserver
I found a solution that solves my problem, the Sqlines SQL Converter, does conversions of various types of banks: Sqlies SQL Converter is an open source tool (Apache License 2.0) that allows…
-
1
votes1
answer267
viewsA: Git Pull removing files
In the changes above your revision, these files have been removed? Review the above revisions, and see if any commit exists with these removals. If it exists, logically these files will be removed…
-
2
votes2
answers2921
viewsA: How to use ternary IF
In programming languages, the expression :?, is known to be a Ternary Operator, several languages adopt it, but even in its latest Seattle 10 version, Delphi nay adopts. But from Delphi7, there is…
-
8
votes3
answers1106
viewsA: Button diagonally only the left side
Below is an option on how to do: .forma { border-top: 60px solid #DB005C; border-left: 20px solid transparent; border-right: transparent; border-bottom: transparent; width: 250px; color: #FFF;…
-
2
votes2
answers2566
viewsA: Netbeans Xdebug Does Not Work
Andraw, I’m a beginner in php and went through the same problem, researched, researched, and gave! To check the correct path to place the dll of Xdebug, use the Xdebug website itself, where you have…
-
2
votes4
answers344
viewsQ: Convert a Select with 2 option HTML to 2 Buttons
Context: Daily access a site several times during the day, of which before effectively entering, besides informing user and password, I have to select the type of access between the 2 existing, I…
-
0
votes2
answers84
viewsA: Running the Procedure with date type argument on a dblink
You’d have to know the structure of your Procedure, and the table, but try to add the command to_date, for thus you convert your string in date: corporativo..UP_COP025_ASS_DMANDA_JURID_I 17444968,…
-
3
votes1
answer924
viewsA: Delete all objects from a schema
Below is a script to delete all objects of an Owner, have control of what is deleting and generate a log of each object to be deleted. set verify off set heading off set feedback off accept vo…
-
1
votes1
answer91
viewsA: How to leave search field prepared to search for any term
If you use the command LIKE from which you search any part of the text? SELECT * FROM cor_textura WHERE codigo like '%6651%' AND cor_textura.status = 1 I made a example in Sqlfindle, using Mysql,…
-
3
votes1
answer1070
viewsA: How to count NULL type values in Mysql
To solve this problem, we can use the function IFNULL which returns a numeric value or string, depending on the context in which it is used: mysql> SELECT IFNULL(1,0); -> 1 mysql> SELECT…
-
1
votes1
answer679
viewsQ: Conversion of Oracle to Sqlserver
Context: Currently I work in a system that uses the database oracle, but now I’m going to need the system to use sqlserver. My goal is to convert DDL and DML for sqlserver, I see there are some…
-
3
votes1
answer3292
viewsA: Move text in pl/sql to uppercase
Has as yes, Via PL/SQL accessing Meno Tools > Preferences, in the group User Interface there is the option PL/SQL Beautifier. Configuring the Rules File, click on Edit..: So automatically this…
-
2
votes1
answer7165
viewsA: Conversion and Grouping of Rows into columns dynamically in Oracle
As commented by Fernando A.W on an answer in the [so] of the question Dynamic pivot in oracle sql of User. Help in parts, let’s explain. Conforms select below, runs to generate the columns needed…