Posts by Roberto Valentim • 420 points
20 posts
-
0
votes1
answer84
viewsA: Show registration without updating page
Not if it will suit you, but here in the company we also use TV Panels that display information that is captured directly from the Database in real time, and to be able to perform this type of…
-
1
votes1
answer109
viewsA: Change configuration file by configparser remove_section
I continued with the tests here and ended up mixing some examples I found on the internet, so I managed to solve the problem, I do not know if it was the best way to solve the problem. import…
-
2
votes1
answer109
viewsQ: Change configuration file by configparser remove_section
How to save the configuration file (.ini) after deleting an option or section? I’m doing it this way: test ini. [LOCAL] url = 'http://localhost:8080/' username = 'usuario' password = 'SECRET'…
-
0
votes2
answers325
viewsQ: How to insert data into another database with Linked Server
Good afternoon! How do I create a trigger that uses a Linked Server to insert the INSERTED data in another table that is in another database, this in another server? Trying to Exemplify: CREATE…
-
3
votes1
answer283
viewsQ: Select Electronic Point Record (SQL)
How can I gather only the first and last appointment, where a staff member can have X Appointments and even appointments the next day? As the example below +------+--------+-------+-------+ | FUNC |…
-
3
votes1
answer268
viewsQ: Select of Product Structure
Good morning! there is some way to create a query that brings the "product" and all the "Components and Subcomponents" of the structure of this product? Let me try to explain better Structure…
-
1
votes1
answer499
viewsQ: List Missing Period Days in SQL Server
How would it be possible to do with what in SQL Server when confronting a table that stores the status records of a given code with a virtual table of the period (Calendar of days) it brings me all…
-
1
votes3
answers1724
viewsA: how to close Word opened by VBA
I found a solution, which at least Opens only 1 instance of WINWORD in the task manager or Uses the one that is already open, since it is not closing with the QUIT command due to the use of…
-
2
votes3
answers1724
viewsQ: how to close Word opened by VBA
For each Execution of the Deletesel function, a "WINWORD" is open in memory, even with the Close and/or Quit command it does not close. Sub DeleteSel(msg As Outlook.MailItem) Dim objDoc As Object…
-
0
votes1
answer592
viewsQ: How to Connect to Database by Reading INI File (Function and Class)
How can I connect to the database (PHP in 3 Layers [Facade / Repository / Database]) by reading the information from a file. ini and assigning these values in a function within a class ? Banco.php…
-
0
votes3
answers2051
viewsQ: Difference between dates on multiple lines
Is there any way to make a DATEDIFF/LEAD/LAG in SQL Server to calculate the difference between dates taking into account the date of the previous/next record. SELECT SELECT NUM, CLIENTE, EMISSAO…
-
3
votes1
answer6731
viewsQ: Compare Current Line to Previous
I want in a "Test" column to define the value "S" for only in the first row of a given "code" and all the others to define the value "N" and so successively for all other codes in a SELECT, I am…
-
2
votes0
answers39
viewsQ: PHP source encryption (System)
I need to deploy a system I created in PHP, but I would like to protect my system somehow. It is possible to encrypt my system (PHP) so that more users do not have access to the source code and end…
-
-2
votes2
answers142
viewsQ: Error reading position (3) of Two-dimensional array: Invalid argument supplied for foreach
How can I read the contents of array $detail[3] after using the explode(implode) ? I’m doing it this way: $aArray = array( "Titulo" => array( "Class|SubTitulo" => Array( "Detalhe01",…
-
3
votes2
answers477
viewsQ: List every month in Query or PHP?
I need to list every month within a period, including those that have not moved, example below: My Query: SELECT LEFT(B8.B8_DTVALID, 06) AS VALIDADE, SUM(B8.B8_SALDO) AS VENCIDO, 0 AS VENCENDO, 0 AS…
-
1
votes1
answer276
viewsA: How to assemble a table with Current Week Number plus the next 15 Weeks
I’ve already solved my own doubt, thank you all for your attention. Code used as a basis for solving doubts. // volta para segunda $date = new DateTime('first monday this week'); // numero de…
-
-2
votes1
answer276
viewsQ: How to assemble a table with Current Week Number plus the next 15 Weeks
How can I build a table (HTML + PHP) using the current week number and the next 15 weeks, for example: Semana Atual é 29 então teremos 29+15 = 44 The table will display the information obtained from…
-
0
votes3
answers141
viewsA: Query problem - Accentuation
You can try to make these changes and check if they will work. Add at the beginning of the PHP header page('Content-type: text/html; charset=UTF-8'); Place after connection to Mysql the command…
-
2
votes1
answer1164
viewsQ: Reading XML with Equal Tag (Nodes)
how can I read an XML file via Vbscript where the file has 2 main tags (Nodes) equal as the example below: XML file: <?xml version="1.0" encoding="utf-8"?> <!-- Primeiro details -->…
-
1
votes2
answers505
viewsQ: Field validation when submitting form
How can I validate multiple fields in the form where these fields are created dynamically? Example: <tr align="right"> <td style="font-size: 11px;"><b>Item 1 -…