All Questions

2
answers

Search performance involving multiple disks

Assuming a query that uses JOIN between two or more tables, such as: SELECT * FROM foo INNER JOIN bar ON foo.id = bar.id Is there performance gain if the data in the tables are in different HD's (due to having more heads reading a...
asked on 22.10.2014 / 22:49
1
answer

What is the equivalent function of window.location.href of JavaScript in PHP? [duplicate]

I want to redirect the visitor to another page so I wanted the equivalent of window.location.href in PHP     
asked on 02.10.2015 / 16:15
2
answers

Firebird SQL auto-increment

I'm doing a SQL / Modeling course in mysql the creation of a composite table would look like this: USE banco; CREATE TABLE clientes( cli_id integer not null auto_increment, cli_nome varchar(20) not null, cli_email varchar(30) not null...
asked on 21.11.2014 / 16:54
2
answers

Create Static SelectList and pass a selected item to View

I have a question about how to send my selectList "status" to my View EditarUsuario . I've created my list with the following items: var list = new SelectList(new[] { new{ID="2",Name="Selecione"}, new{ID="1",Name="A...
asked on 02.10.2015 / 22:42
2
answers

How to receive the various fields of a view in the controller

I need to create an Insert from multiple fields at the same time! My system has multiple table and relationships and I am having difficulties at that point. I have this registration screen: Withthiscode:@using(Html.BeginForm()){<divstyle="wi...
asked on 15.10.2015 / 00:10
2
answers

Doubt about using the inner join

I have 4 tables in my database Tabela Cadastro - idCadastro(PK) - IP Tabela Porta - idPorta(PK) - numero porta - idSwitch(FK) Tabela Porta_has_Cadastro - idCadastro(FK) - idPorta(PK) //Observação: Relaçao...
asked on 23.10.2015 / 13:51
3
answers

Increasing the size of a TextView, according to the amount of data inserted in it

I'm developing an app, for technical course work, and I have the following situation: I'm displaying data within a TextView . But there comes a time when size is not enough. Look at the pictures. App Home Photo: PhotoActivityReport,wh...
asked on 22.09.2015 / 03:17
1
answer

Add an if with 2 conditions [closed]

I have the following declared variables: n_var:= strtoint (En_var.Text); n_raster := strtoint (En_raster.Text); And I would like you to make a condition by comparing their values for example: if (En_var.Text = (inttostr(3)) and (En_raster...
asked on 30.09.2015 / 16:25
1
answer

How to modify VBA function to write extensively a number greater than 1 trillion in EXCEL cell?

In 2013 a user submitted a question about how to spell out a number stored in an EXCEL cell. One of the answers contained a VBA function that had already been published by UOL for some time. I consider one of the best functions already developed...
asked on 19.10.2015 / 12:11
1
answer

Select brings different results

I'm having a problem with a SELECT: SELECT * FROM documento WHERE idAdministrador = '1' AND modulo = 'funcionario' OR modulo = 'atestado' I need to know if the module is an OR certificate, which does the correct search ... However, it does...
asked on 24.09.2015 / 14:06