Posts by Andrew Paes • 268 points
8 posts
-
4
votes2
answers1435
viewsA: SQL query taking too long and returning a Time Out error
At the beginning of the code you are opening a connection and a transaction: conexao.OpenConnection(); transaction = conexao.transaction(); Then you are opening a new connection, without having…
-
0
votes2
answers267
viewsA: Store Procedure not working properly
From what I could see, you are doing a DELETE before, and then an INSERT, so depending on how the data is, it makes the turn of an UPDATE. However, the INSERT is being done with a fixed NUMNF of…
-
0
votes1
answer1537
viewsA: Media calculation between SQL Selects
industria dtt_data_captura flt_base vch_empresa_editada IND 12/1/2016 1022.15 G3 IND 12/1/2016 1093.4 G3 IND 12/1/2016 950.9 G3 IND 12/1/2016 950.9 G3 IND 12/1/2016 670 JJ IND 12/1/2016 1733.9 G3…
-
1
votes1
answer45
viewsA: Doubts of systems architecture
If you don’t want to make multiple requests to the database, which I honestly don’t think is a problem when the methods are well implemented, and the return of queries doesn’t have a lot of data,…
-
1
votes3
answers1432
viewsA: Perform UPDATE with values from another table, in columns with the same name
You can make a script to generate the update and then run it dynamically. Creating the structure of the base: CREATE TABLE Table1 ([Id] int, [name] varchar(50)); CREATE TABLE Table2 ([Id] int,…
sql-serveranswered Andrew Paes 268 -
-1
votes1
answer640
viewsA: How to use C# Windows Forms with Firebird and Object Orientation?
Legal your interest in programming. But my tip is, try to do things one step at a time. Learn how to connect through C#, then learn how to use Windows Forms, then try connecting to Firebird. I…
-
2
votes1
answer45
viewsA: Code abstraction with multiple Replaces
Well, I would try something that is not so much simpler, but is much cleaner and more effective, because your file may have other tags or "junk" inside the tags. I’ve seen your other questions about…
-
2
votes1
answer74
viewsA: Assemble link only when there is data
If you only want the link to be viewed or not, then use the Style Tag together with the Display property. <strong> <a class="linkUpload" <%# Eval("SEQ_CHA") != null &&…