Posts by Rodrigo Tognin • 1,057 points
62 posts
-
0
votes3
answers974
viewsQ: Service done in Delphi "kill yourself" or give Stop
I would like to know which command to use for a Windows service "kill yourself". Because it’s a service I don’t have the option Application.Terminate. I need to check a certain date, and if it’s…
delphiasked Rodrigo Tognin 1,057 -
1
votes2
answers199
viewsQ: Compare Sqltimestamp type field
I have a question here... I have a field in the SQL Server database of the type Datetime that can be null. In Delphi, within the Memtable (or Clientdataset... would be the same thing in my case),…
delphiasked Rodrigo Tognin 1,057 -
1
votes2
answers1139
viewsA: PHP - Create a checkbox list dynamically
You can make PHP generate HTML code through echo: <?php echo '<input type="checkbox" name="'. $cats[$i]['nome_carac'] . '" value="' . $cats[$i]['nome_carac'] . '">' .…
-
1
votes1
answer252
viewsA: Drag div to another div and resize on drop!
Hello. You can use the function onDrop javascript: <div ondrop="Funcao(evento)"></div> In the function you resize using jQuery, manipulating the css of the div. I hope I’ve helped. **…
-
0
votes1
answer402
viewsA: How to extract a data from a php array
Try the following: $id = (string)$idcheck[0]['id']; From what I’ve seen, this $idcheck variable is a multidimensional array. I also suggested to force the value to string, to make sure that the $id…
-
1
votes1
answer761
viewsQ: Use Dblookupcombobox with only one table and one Clientdataset
People, I have a question about using Dblookupcombobox in Delphi. It is possible, instead of using two tables (take values from one and write to another), I have only the table where I will save the…
delphiasked Rodrigo Tognin 1,057 -
0
votes2
answers455
viewsA: Nomenclature for radio, checkbox, select, inputs, etc
I usually use the first three characters to define the field type and then the rest for the field itself, for example: sel_uf, active chk_name, edt_name, edt_address... and so on. Cool your interest…
htmlanswered Rodrigo Tognin 1,057 -
3
votes2
answers1059
viewsA: Database error Missing Driver Name Property
Fabrício, instead of loading each connection property, you could load all the parameters at the same time. SQLCon.Params.LoadFromFile('conexao.ini'); Here is an example of a file with the settings…
-
2
votes1
answer29
viewsA: Search between dates in 2 columns of the same table
You should choose one of the columns to be compared, or if you want to include both, you could use "AND" in the comparison. Where <campo_sql_1> Between InicioEvento AND FimEvento And…
mysqlanswered Rodrigo Tognin 1,057 -
0
votes3
answers710
viewsA: Sorting using Dbgrid with Clientdataset
You can use a DataSetProvider connected to the TBQuery, and in the estate "Providername" of the ClientDataset refer to it. Before the search, close the CDS, reopening it after the search. The data…
-
1
votes2
answers729
viewsA: How to view data in a dbgrid
I don’t usually run the project with the components open... In this case I would open the connection first, then Sqldataset, and then Clientdataset. I believe there is an extra CDS there... My…
-
0
votes1
answer152
viewsA: Merge two select, how do I do?
Try to do this: SELECT email, d.* FROM doador dd INNER JOIN doacao d ON (dd.iddoador = d.iddoador), LEFT JOIN foto f ON (d.iddoacao = f.iddoacao) WHERE (dd.iddoador IS NOT NULL) AND…
mysqlanswered Rodrigo Tognin 1,057