Posts by Washington da costa • 1,029 points
35 posts
-
2
votes1
answer298
viewsQ: Error trying to insert Datetime.Minvalue into database
I have an object that has a property Datetime and, start with the value of the property Datetime.Minvalue The problem is that, when passing this value to register in the SQL Server database gives an…
-
1
votes3
answers2405
viewsQ: Export query output as Insert scripts
I would like to export the result of a query in SQL Server as an Insert script to insert the data in another database. I know there is the option to export the whole table through the "Tasks ->…
sql-serverasked Washington da costa 1,029 -
2
votes1
answer923
viewsA: SQL query to return only if capitalized
By default the collation of the tables is case insensitive, to learn more about collation click here, so you have two alternatives: or change the collation of your table column alter table Foo alter…
-
2
votes2
answers541
viewsA: How to reduce space between Bullet and text in a centralized <ul>?
Another solution would be to wrap the contents of the Lis in a tag and position it to the left. li span { position: relative; left: -30px; } <ul style="text-align: center; list-style-position:…
-
1
votes2
answers73
viewsA: With editing Tabcontrol in c#?
The easiest way, and that can be done by the control properties is as follows: tabControl1.Appearance = TabAppearance.FlatButtons; tabControl1.ItemSize = new Size(0, 1); tabControl1.SizeMode =…
c#answered Washington da costa 1,029 -
0
votes3
answers5094
viewsA: How to download a file from a URL using C#
creates a form, inserts a text box to type in the url(txtUrl), a button to start the download(button1), a label to show how much was downloaded (label) and a progressibar(progressBar1) to see the…
-
0
votes2
answers306
viewsA: Split String Html
this code does the magic using regular expressions var texto = "<div class='page'>...Conteúdo1</div>"; texto += "<div class='page'>...Conteúdo2</div>"; texto += "<div…
-
1
votes2
answers160
viewsA: tool or technology to assist in controlling database data
There is no automatic solution for this, you have to create the versioning engine manually. you can for example insert a field called VERSAO in the table and not allow update in the records, to…
-
3
votes1
answer1101
viewsQ: incremental vs differential backup in SQL Server
Whenever I need to set up the backup routine of an SQL Server database I confuse these two types of backup. Therefore I would like to know: What each one does? Whereas I do a full backup on Sunday,…
-
1
votes4
answers7295
viewsA: How to generate a spreadsheet from another using VBA
tested here and it worked, insert a button in the spreadsheet with the macro below. It will generate another spreadsheet in the same file. Sub geraPlanilha() Dim contador As Integer Dim…
-
2
votes3
answers879
viewsA: Store in the database or in sessions
I know you expect a definitive answer but have no definitive answer to this question, everything will depend on the architecture of your application. If you are going to host the system on a…
phpanswered Washington da costa 1,029 -
2
votes1
answer888
viewsA: Real time with javascript or jquery?
use the setInterval function, documentation here for example to perform its function every 3 seconds <script type="text/javascript"> <!-- window.onload = function() { function funcaoAjax(){…
-
4
votes1
answer1183
viewsA: What is a collation?
The collation ollation defines the set of rules that the server will use for sorting and comparing texts, that is, how the operators =, >, <, order by, etc. For example, depending on the…
-
22
votes2
answers2693
viewsA: What is the difference between charset and collation in a database?
Charset The Charset defines the character set that you will use to store data in text form, where each character receives a number. A very common example is the 256-character ASCII table. If you…
-
1
votes2
answers122
viewsA: listbox with database records
first you have to exchange the IF for WHILE to go through all the records, and not to enter repeated records your query should bring only non-repeated records, using the DISTINCT keyword. using…
-
0
votes1
answer703
viewsA: Search last record of a distinct group
I made a solution however, I only have to test in SQL Server. I used the concept of Subqueries, where the internal query selects the last date of each group and the external query does Join with the…
-
1
votes1
answer3118
viewsA: Medical Practice Class Diagram Conference
These are my considerations, highlighted in bold. In the relationship Convênio X Patient: • 1 agreement has 0 or more related clients(patients). (technically says 0 or N customers) • 1 patient has…
-
1
votes1
answer273
viewsA: Improve Writing Resolution with HTML5 Canvas
There is no command to increase the resolution of the canvas, one trick you can use is to draw the circle on a canvas twice the size needed and decrease using CSS, so the resolution increases. See…
-
1
votes1
answer254
viewsA: Genexus is not generating the files for compilation
I finally figured out the problem. It may seem obvious to the more experienced, but I was inserting the attributes of the second level of the transaction on the screen as textboxes, as I used to do…
genexusanswered Washington da costa 1,029 -
1
votes1
answer181
viewsA: How to make a filter before performing action?
You can use Action Filters to do this. An Action Filter is an attribute that you put on top of each action (or in the controller, to apply to all actions) indicating to the framework that, before…
asp.net-mvc-5answered Washington da costa 1,029 -
1
votes1
answer1375
viewsA: How to convert a project from VB6 (.vbp) to VB.NET (.vbproj)?
This article shows what you can do to migrate from VB6 to . NET: Case Study: Migrating a large VB6 app to . NET The author cites some tools, so I won’t repeat here. This tool from Microsoft…
-
2
votes3
answers796
viewsA: Error calling 2 javascript functions at the same time
I suggest using the Domcontentloaded event, which runs after all content is loaded. See an example: <script type="text/javascript"> function a() { alert('a'); if ('a' == 'a') {…
javascriptanswered Washington da costa 1,029 -
0
votes1
answer466
viewsA: Subtract Saturdays, Sundays and specific dates from another table
I took the liberty of not reading the table to check Saturdays and Sundays as there is a function in sql server for this. see if it solves your problem. DECLARE @data DATE = '2017-01-26' DECLARE…
sql-serveranswered Washington da costa 1,029 -
2
votes1
answer156
viewsA: How to show 5 in 5 hidden elements?
I suggest a small change in the "database" that will greatly facilitate the understanding of the code. If possible, group the links in Divs as below: var totalGrupos = 5; var grupo = 1; function…
-
3
votes3
answers8159
viewsA: When to use Entity Framework with Repository Pattern?
There is no definitive answer to that. Some argue that the Entityframework is the repository itself, (as in the answer that was marked as correct) others say that the Entity Framework does not…
-
1
votes1
answer1098
viewsA: How to configure Web Api route to accept named parameter(query string)?
define the route without the "?" query string will be automatically mapped to the parameter of the same name. [HttpGet] [Route("api/documento/doc/list")] public string Listar(string cpf) { return…
-
3
votes2
answers384
viewsA: Is there a standard for structuring an HTML site?
The recommended structure for an HTML5 page in your case could be like this: <!DOCTYPE html> <html> <head> <title>título da página</title> </head> <body>…
-
-1
votes4
answers7473
viewsA: How do I display the same phone number from the OLX site?
This is done by displaying or hiding a div via javascript. In the case of that site you passed just take a look at the code you find the following code: $("#show_phone").click(function(){…
-
1
votes2
answers970
viewsA: How to make a Datagrid in HTML5?
There is no datagrid component in HTML, you have to create using a table, in the language you are developing. Here you can find some in javascript: 15 Javascript Data Grids to Enhance your HTML…
-
0
votes2
answers260
viewsA: Implement Progressbar
Insert this code snippet below the line aCommand.Executenonquery(); ... //Calcula a porcentagem que i representa do total int percent = (int)(100 * (i+1)/vGrade.Rows.Count); // atualiza a…
c#answered Washington da costa 1,029 -
1
votes2
answers306
viewsA: Any ASP.NET MVC solution for SQL injection?
Use Sqlcommands to enter the data, it already does this cleaning for you. Cleaning up the way you were suggesting would remove the words from any text, even if it wasn’t an attempt at SQL Injection.…
-
6
votes2
answers327
viewsA: When to use underlining in web hyperlinks?
The pattern has always been blue and underlined links, that’s what users expect. But with the evolution in the design of the pages he got used to customizing the links. Nothing prevents you from…
-
-1
votes5
answers2766
viewsA: What HTTP code should I use when I can’t authenticate to third-party services with login and password provided by the client earlier?
It doesn’t really seem to have a code that meets this situation, since in your case the request will be processed correctly. I believe code 200 is the most appropriate, with a custom error message.…
-
-1
votes1
answer315
viewsQ: How to create graphics in Genexus X?
I am migrating from Gx 9 to Gx Evolution 3 and facing some difficulties. One of them refers to the command Gxmakegraph that is no longer supported, but I can not find an explanation of how to…
genexusasked Washington da costa 1,029 -
0
votes1
answer254
viewsQ: Genexus is not generating the files for compilation
I’m migrating a system of Gx 9 with generator VB for Gx Evo3, with generator C#. It is my first contact with the new version and I am going through the following problem: In some Transactions (not…
genexusasked Washington da costa 1,029