Posts by JosefoSad • 45 points
4 posts
-
2
votes1
answer134
viewsQ: Select previous row if null
I have the following table in Oracle and I want to fill value that is null in the Activity column with the value of the previous row. How to do using Oracle?…
-
0
votes1
answer100
viewsQ: Use conditional to check dates if not in a search column with null value
I have the following tables in BD Oracle 11g irrigation ---------------- militet_applied, close_date rainfall --------------- rain_index, reading_date And I would like to make a select similar to…
-
2
votes1
answer50
viewsQ: Search Records with Latest Date Using Condition
I have the following appointment: SELECT fm.FIELDCODE, fm.BLOCK_CODE, bl.BLOCK_DESC, cat.CATEGORY_CODE, cat.CATEGORY_ABBREV, fm.FIELD_AREA, fm.PLANTATION_DATE, fm.HARVEST_END_DATE FROM FM_BLOCK bl,…
-
0
votes2
answers120
viewsA: textbox saving in bank even if empty
Use this conditional works directinho //Inicia o metodo aqui void VerificarCampos(){ if(txtFone.Text == "") { MessageBox.Show("O campo Telefone é obrigatório ", "Informação", MessageBoxButtons.OK,…