Posts by Felipe Santos • 168 points
10 posts
-
1
votes2
answers1441
viewsQ: Find regular expression record in mssql
I have a column that stores data in the following pattern #campo#=valor;#campo#=valor (and so on) ex: '#aaaa#=1111;#bbbbb#=2222;#cccc#=33333' However, they added ; within the value and I wanted to…
-
0
votes3
answers628
viewsA: Make html class appear and disappear by js
If you are using Jquery, you can use the following code: To remove class: $( "seu-id" ).removeClass( "sua-classe" ); To add class: $( "seu-id" ).addClass( "sua-classe" ); More information Add Class…
-
3
votes2
answers34
viewsA: Select items that do not contain in a second table
Hello, try the following query: select * from public.entregaitem where public.entregaitem.codigoentrega not in (select public.retorno.codigoentregaitem from public.retorno)…
-
0
votes2
answers117
viewsA: Save phrase in Textview when closing the app
You need to overwrite the method onSaveInstanceState(Bundle savedInstanceState), in this method you must put the value of your variable that stores the index, follow the example: @Override public…
-
2
votes2
answers95
viewsA: Search with Inner John
The database returns the ambiguous message when you have a field is in more than one select table, in this case it is probably the ID_PEDIDO of the Where clause. Try to put the table name in front:…
-
1
votes2
answers54
viewsA: Passing values between screens
Luciano, to send a data to another screen use the following command in the call of the next screen: Intent mIntent = new Intent(context, SegundaTela.class); mIntent.putExtra("parametro_1", 2);…
-
4
votes5
answers972
viewsA: How to get the name of the day of the week on the first day of the month?
If you want to make the month flexible, you can leave it in a separate variable, follow the example: declare @mes varchar(2) = '12' select DATENAME(weekday, '2017-' + @mes + '-01') as dia_semana…
-
0
votes3
answers69
viewsA: How to read only Formatdatatime numbers
There is a function called Decodedatetime, that uses Unit Dateutils and it breaks the date and time parts, so you can work with each element. Follow an example. procedure TForm2.Button3Click(Sender:…
-
1
votes1
answer528
viewsA: How to click items from a list in Android Studio?
John, for this you have to add the event setOnItemClickListener, see an example of the click event and opening a new screen: lista_teste.setOnItemClickListener(new AdapterView.OnItemClickListener()…
-
-1
votes2
answers120
viewsA: How to perform an "IF" by SQL
Let me get this straight, do you want to update the dt_ini value of the table itself? if empty? If so, try this: UPDATE SUA_TABELA SET DT_INI = VALOR WHERE DT_INI IS NULL If you are an Insert…