Posts by Marcos Marques • 123 points
14 posts
-
1
votes1
answer32
viewsA: Overwriting data in Rstudio
An example to be clearer. p <- rnorm(10000) p[p<0] <- 0 A function: trocaNegativo <- function(x) { x[x<0] <- 0; x } trocaNegativo(p) In your Cup, you can put a clause and filter…
databaseanswered Marcos Marques 123 -
0
votes1
answer54
viewsA: I am unable to gather data - must be lack of INNER JOIN
Taking into account that the prefix is unique enters the tables. And that the tables are created with the fields you reported, basically this would already solve your problem. insert into…
-
0
votes2
answers176
viewsA: How to create a View to insert multiple entities
Well, I would create a new model obterFornecedoresModel With the definitions of other models. Type public IEnumerable<Fornecedor> Fornecedores{ get; set; } And so on with the other entities.…
-
1
votes2
answers621
viewsA: Group [group by] SQL Firebird
It does, but only if you use aggregated functions in those values you want to return, like sum(),Count(),max() and etcs.
-
1
votes1
answer860
viewsA: Use 3D Blender to create games for Android
Yes, you create your models and import them for Android Studio. Look at some examples: http://download.blender.org/demo/android/…
-
1
votes3
answers55
viewsA: I tried a Union consultation but did not get the expected result
SELECT RE.cd_flremequ AS RemessaID , DE.cd_flremequ AS DevID , CONVERT(VARCHAR(10), R.dt_saida,111)AS dt_saida , CONVERT(VARCHAR(10), MAX(D.dt_cobranca),111) AS dt_devolucao , F.numero AS ficha ,…
-
0
votes1
answer389
viewsA: Change Button label with typed value
@IBAction func userInput(sender: UITextField) { MeuBotao.setTitle(sender.text,for: .normal) }
-
1
votes3
answers1640
viewsA: Datetime function C#
DateTime.Parse Here it is transforming your user data entry which is in text(string) format to the date and time formed. Then it returns the Date format for text, already using the format:…
-
1
votes1
answer60
viewsA: Not bringing the records - Query SQL
If your two sub-queries already do everything you want, no need to join in the two. Besides you are doing the Join of the two with the columns of quantity Blocked and Active, which in my point of…
-
0
votes1
answer71
viewsA: Popular Gridview with Access Data
I hope it helps. string strProvider = "@"Provider=Microsoft.ACE.OLEDB.12.0;Data Source=C:\ArquivoAcess.accdb"; string strSql = "Select * from [Nome_Tabela]"; OleDbConnection con = new…
-
0
votes2
answers324
viewsA: Insert ID into Table with 13,346 lines with LOOP
Rafael’s answer already solves your problem. But if you just want to update the data without having to change it column type, follow an example: declare @i int set @i =0 while @i < 13346 begin…
-
2
votes2
answers347
viewsA: How do I make my Dropdownlistfor equal to Select
@Html.DropDownListFor(s => s.MeetingFrequency, new SelectList(new List<Object> { new { value = "0", text ="Selecionar",disabled = "disabled"}, new { value = "SEMANAL", text = "Semanal" },…
-
0
votes2
answers2012
viewsA: System.Outofmemoryexception error
Dude, probably the size you’re passing to the.write file.. It’s small. I’m not sure what size you’re getting back with the _pdf.length. But it’s little for what you need.
-
1
votes1
answer47
viewsA: VB - Too Many Arguments
You’re calling the function by passing idCliente Lerclients1(idCliente) But its function has no parameters. Friend Sub Lerclientes1() You can change to: Friend Sub LerClientes1(int IdCLiente) and…
vb.netanswered Marcos Marques 123