Posts by LucasMotta • 1,026 points
23 posts
-
2
votes1
answer480
viewsQ: Difference between Dictionaries and Lists/Arrays?
I am trying to understand the concept of each and its differences. I want to understand in which situations to use one or the other.
-
1
votes1
answer1011
viewsQ: Problem importing text file via VBA
I am trying to import a text file to excel through the following macro: Sub Teste() Dim intervalo As String intervalo = "intervalo" Workbooks.Add ActiveWorkbook.Sheets("Plan1").Select With…
-
2
votes1
answer258
viewsQ: Set the field return size
I have an sql: Select a.nome From tabela a I want to return the name, but imagine my name field is size Varchar(100), but I want to return the first 50 characters. Edit: It’s for IBM’s Informix…
-
2
votes1
answer450
viewsA: Hide tab - Java
I managed to solve my problem using the following command: Suffice it to say the tab, of 0 a N (number of tabs of the project) and if you want it enabled = true, or disabled = false private void…
-
2
votes1
answer450
viewsQ: Hide tab - Java
I have a program with several tabs, so I will be if the user is ADMIN, based on this I would like to hide/disable some tabs, I have already tested these commands and do not disable the window:…
-
3
votes1
answer2019
viewsQ: Could you add a UNIQUE field that accepts nulls?
I can create a field that accepts nulls and say it is unique? This table of mine, the CRM indicates that he is a doctor and not a normal person, he has to be unique, but has to allow nulls. This…
-
4
votes1
answer2185
viewsQ: Insert cities into database
Hello, I am creating a database, and in it I will have information of Brazilian municipalities, I imagine that I am certainly not the first to need this information, however I do not know if there…
-
4
votes1
answer1246
viewsQ: In Postgresql, which field to use for percentage?
In the table that I am creating, I will have a column that will indicate the discount percentage, for example, "for a given agreement I will have 20% discount, for another agreement I will have 50%…
-
20
votes2
answers40655
viewsQ: Difference between datetime x timestamp?
I am building a diagram in Mysql Workbench and I came up with this question, what is the difference between the two? I will work with this base in Java, java has problem with some of them?…
mysqlasked LucasMotta 1,026 -
3
votes1
answer935
viewsQ: Database query for a C#List
I need to make a query at the bank, I made this code for connection, but I do not know how to proceed to put this information in a list<String> SqlConnection conexao = new…
-
0
votes1
answer588
viewsA: How to calculate the sum of a group in MDX
Now after reading the book SQL Server 2008 MDX Step by Step I was able to put together a calculation that is returning what I needed, it is performing well in SQL Server Management Studio and Visual…
-
2
votes1
answer1670
viewsQ: Passing parameters to the postgresSQL
I will create a Rigger in postgresql to copy the information from one table to another, the tables will always have the same structure, so I intend to pass the table names, make a WHILE and copy the…
-
0
votes1
answer588
viewsQ: How to calculate the sum of a group in MDX
I need to create a Calculation in SQL Server Data Tools. Imagine that in my structure OLAP I have the City and Dealer Dimensions, and a Sales Fact. In the City dimension I have City, State and…
-
6
votes1
answer1189
viewsQ: Comparing Ides to java
Next semester I will have to choose between two Ides: Netbeans and Eclipse. I will need to develop desktop apps, and I’m having doubts about: Tools for graphical user interface Hardware Requirements…
-
2
votes1
answer1271
viewsA: Close only one Window
You can do it this way if (e.Key == Key.Escape && this.IsActive) this.Close();
-
2
votes1
answer537
viewsA: How to return more than one column from the same table?
I didn’t really understand what you wanted to return, but here are two examples: SELECT tbl_produtos.*, tbl_categorias.*, tbl_variacoes.valor || tbl_variacoes.dimensao || tbl_variacoes.quantidade AS…
-
2
votes3
answers98
viewsA: How to consult and return all product information?
Good morning, I didn’t understand if you just want a consultation or something more complicated, I made this consultation here: SELECT nome_prod, nome_cat, cor_prod FROM tbl_produto INNER JOIN…
-
7
votes3
answers1890
viewsA: Query two tables in Mysql
Try that, see if it works. (SELECT unid, info FROM TabelaUM WHERE unid NOT EXISTS ( SELECT Unid FROM TabelaDOIS)) UNION (SELECT unid, info FROM TabelaDOIS) Editing to fit your need SELECT cgc,…
-
2
votes1
answer71
viewsA: Error restricting dates in SQL Server
Test that YEAR(Data) IN '2014'
-
2
votes1
answer16582
viewsA: Merge duplicate names into one line
Like the gmsantos commented, you can put in Dynamic Table, to facilitate: Selects the entire table, including headers; Format as table, check "My table has headers"; Inserts a dynamic table and in…
-
2
votes1
answer59
viewsA: How to delete a record without affecting the query?
Hello, Whenever you want to return values that are present in both tables, use INNER JOIN. From tbesquerda inner join tbdireita on tbesquerda.codigo = tbdireita.codigo ------------------- |A.NOME |…
-
3
votes3
answers527
viewsA: Structure/Nomenclature of Tables
SystemInheritedPermissions and GroupInheritedPermissions do not believe it is a strange name, or put in Portuguese.
-
4
votes1
answer228
viewsA: Calculation with Excel hours are not very accurate
Dude, excel works excellently with hours, you might be working wrongly with excel. Try formatting the fields as time, and fill in the field in the following HH:MM:SS format (11:56:32). Then just…
excelanswered LucasMotta 1,026