Posts by Diego Rafael Souza • 2,900 points
108 posts
-
0
votes1
answer168
viewsA: Pass multiple attributes to a Command Parameter in Xamarin Forms
I would strongly recommend a MVVM and bindings to do this kind of operation. But, for example, you can pass the entire object in the CommandParameter, just as you are trying to recover in the event.…
-
2
votes4
answers169
viewsA: I can’t convert seconds into minutes
For future reference: A query that seems simpler, exploits a little more the bank resources and decreases the overhead to solve the above problem would be: SELECT TIME_FORMAT( SEC_TO_TIME( AVG(…
mysqlanswered Diego Rafael Souza 2,900 -
1
votes1
answer149
viewsA: Foreignkey error with Sqlalchemy
According to what is in the Sqlalchemy documentation, in situations like this you need to explicitly define foreign keys that correspond to reverse mapping from the class Account: In short, you…
-
5
votes2
answers79
viewsA: How to create hierarchy functions? Ex Console>Error>Writeline()
Short version You need to place the objects within the desired hierarchy to have this effect. There are two ways to do this, either through namespaces or through composition of objects. Using the…
-
1
votes3
answers148
viewsA: How do I know if an Itemtapped has been clicked?
For its recurring function, it AtualizaDados, you are using the resource Device.StartTimer. From what you can see in your code, you already understand that this function will be repeated while the…
-
4
votes1
answer94
viewsQ: Customizing URI templates using Odata
I am working on a project that contains the package Microsoft.AspNet.WebApi.OData, which offers a well-simplified implementation to support Odata V3 by simply using the Attribute…
-
0
votes2
answers729
viewsA: Power BI - Oracle SQL Query
The format as you see the data when performing a query in the table does not make explicit the type of data you have in the corresponding column. The display is related to the result settings (and…
-
1
votes1
answer387
viewsA: Exit command in PL/SQL
According to the documentation, to terminate the routine execution you must use the command RETURN. Rectifying something you mentioned, the command Exit would be to terminate execution of ties. The…
-
1
votes1
answer43
viewsA: API and XAMARIN project
Well, you’ve answered your own question. Create another solution for the project in Xamarin, which most likely will have nothing to reuse from your API. The only thing he should do is consume…
-
3
votes1
answer223
viewsA: SQL SERVER Filter
When you wear one aggregation function in this way (in this example the SUM) you need to specify what the grouping criteria are to show in the result. In your case, you want the summing up of…
-
1
votes1
answer41
viewsA: Local search with detail for each typed letter - Xamarin Forms
In his method OnTextChanged you are activating the property IsRefreshing of his ListView. Here: //Pesquisa localmente a cada letra digitada private void OnTextChanged(object sender,…
-
3
votes3
answers255
viewsA: Calculate percentage between two MYSQL dates
The percentage will be determined by the number of items of a certain classification divided by the total of items of all classifications, but the other filters - in your case apparently are only…
-
2
votes1
answer847
viewsA: Failed to archive Xamarin.Forms project
The mechanism of Linker is not based on a compaction, but in removing unused features (basically methods and classes) in your app. This is how it reduces the size of the app - "capping" referenced…
xamarin-formsanswered Diego Rafael Souza 2,900 -
0
votes1
answer413
viewsA: Xamarin Forms error
I believe the mistake is not related to the Java version, SDK or its image features as suggested in the comments... You must have changed the properties of the android project. Specifically the…
xamarin-formsanswered Diego Rafael Souza 2,900 -
2
votes1
answer162
viewsA: Change more than one value in the same column with an UPDATE
It was just a small mistake in the syntax of CASE. The right thing would be: UPDATE RESPOSTA SET resposta = CASE WHEN pergunta_id = 1 THEN 'aaa' WHEN pergunta_id = 2 THEN 'bbb' WHEN pergunta_id = 3…
-
2
votes1
answer261
viewsA: Block Form Button - Xamarin
In the pattern MVVM in the Xamarin.Forms usually this is dealt with by the Command called CanExecute. With it, when associating a command to a button, every time there is change in the CanExecute…
xamarin-formsanswered Diego Rafael Souza 2,900 -
2
votes2
answers719
viewsA: How to organize this Layout using Xamarin Forms?
When you set the row or column measure of the grid as "Auto", the row/column size will be determined when its contents are allocated, increasing or decreasing according to what is required. In other…
-
2
votes1
answer254
viewsA: Retrieve item from a picker
In that reply, whose question has a little more detail about the implementation in question, you can see an example of how to use this resource. Basically, you can use the property SelectedItem of…
xamarin-formsanswered Diego Rafael Souza 2,900 -
1
votes1
answer207
viewsA: Xamarin - Picker View with list
For the good of all and the general happiness of nations, since version 2.3.4-pre of Xamarin.Forms the control Picker has its main properties bindables. This operation was much more boring before.…
-
3
votes2
answers279
viewsA: What is this "k_BackingField"
Coming from reverse engineering, I am believing that the tool has not been able to identify the name of field (private) of property, or is arbitrarily defining a name by its own standard. However,…
-
3
votes1
answer325
viewsA: Transition with different time when hovering the mouse (Hover) and removing
Have you tried to define the property of transition in the two css states, one with more and the other with less time? See in your own example, when activating hover reduce the transition time: img{…
-
1
votes1
answer18
viewsA: Problem when returning a query
You can use the DATE_ADD to contemplate the records that include time in your interval. Then, you add a day at the end date of the interval (which comes without time) and search for the records…
-
1
votes1
answer64
viewsA: Problem with custom control
What you missed was using the BindableProperty TextSearchProperty that you created in your component. It is already exposed to Bindings. Then you must have a property in your ViewModel, as…
-
1
votes1
answer58
viewsA: Add platform to Xamarin project already created
Yes. You will add the a new project of type iOS App in your solution, then install in it the package Xamarin.Forms from the NuGet (add the version corresponding to the one you are already using in…
-
0
votes1
answer347
viewsA: How to pass a interpreted parameter on the server to a javascript function?
I ended up finding in that OS post the answer to my question. In short, Cannot use expressions of type <% %> on controls that run on the server side. The solution I chose was to reverse the…
-
2
votes1
answer396
viewsA: Grid with spacing and Boxview
The Xamarin documentation provides an overview of this layout, so let’s go straight to your questions: What is the best way to give space between components? Because if I use Horizontaloption…
-
2
votes1
answer97
viewsA: Task List<T> showing Xamarin error
As I mentioned in the comments, if you intend to use Generics, the method statement is wrong, the generic type specification is missing. Change signature to the next one you must resolve: public…
-
1
votes1
answer92
viewsA: Nuget Paint Package or Digital Signature
Yes. There are some in the market, but I recommend one I’ve used and I know it works well: The Signaturepad. This is a open source component for collecting signatures with Xamarin.Forms from…
-
3
votes1
answer59
viewsA: How to show in a query records that do not have a referenced datum
(...) When the query is executed, the DataGridView returns me only the records that have a ID_Cargo other than nil This is due to the fact that you have defined an expression that will never be true…
-
-1
votes1
answer347
viewsQ: How to pass a interpreted parameter on the server to a javascript function?
I’m creating a control ascx that will have multiple impressions on the same page. In this control, there is an image that I intend to perform a function javascript when clicked. By example, like…
-
1
votes2
answers516
viewsA: Update or Insert with data from another table
Using the NOT EXISTS. If the field numero_requisição for a declared Pacific, you can use the INSERT ... ON DUPLICATE KEY UPDATE: INSERT INTO requisicoes (numero_requisicao, projeto) SELECT…
-
2
votes1
answer293
viewsA: Using Grid with Absolutelayout - Xamarin Forms
TL;DR; You don’t need to have the AbsoluteLayout to get the output you want. Only Grid is already able to provide the layout. Just include the StackLayout containing the ActivityIndicator at the end…
-
1
votes1
answer86
viewsA: Access carouselview inside a listview
To make your code work, I’ve included a new property Imagens in the model of Classificado to provide the collection that the Carousel needs as ItemsSource. The model would look like this: public…
-
3
votes2
answers106
viewsA: Differences between variable statements in C#
The difference is: 1st Case Classex xx = new Classex(); You have created a variable xx of the kind Classex which has already been initialized with a new instance of Classex. 2nd Case var xx = new…
-
2
votes1
answer309
viewsA: Space and color between Viewcell in a Listview
The StackLayout has a Spacing standard of 6 Dip. It’s just this spacing between the items that is appearing gray on your screen: it’s the space between your stack that contains the paired data and…
-
2
votes3
answers900
viewsA: how to find a string for json
I don’t think it’s worth you trying to build a parser by yourself. There are many things to deal with and you already have it ready. You can create a method that uses the library’s Reader and Writer…
-
3
votes3
answers546
viewsA: Convert char to integer in C#
According to the documentation of the C#, the char can be converted implicitly to int (... ) char can be converted implicitly to ushort, int, uint, long, ulong, float, double or `decimal. However,…
-
3
votes4
answers1474
viewsA: Remove text within column in MYSQL
If it is a fixed text snippet: If it’s purely text replacement it’ll be the same problem as me I answered here. Uses the function Replace to replace that part of the content. Would look like this:…
mysqlanswered Diego Rafael Souza 2,900 -
1
votes3
answers141
viewsA: Program Interface only once
It would be really cool and practical, right?! I don’t know any stable ones in use, unfortunately, and I don’t think - at least in the short and medium term - is an idea that will guarantee you a…
-
1
votes1
answer722
viewsA: How to replace all values of a given table in MYSQL at once?
Yes. There must be several, here is one of them: You can use the function REPLACE (not to be confused with the commando REPLACE) no update. It will return you the complete original string, only with…
mysqlanswered Diego Rafael Souza 2,900 -
3
votes1
answer164
viewsA: Error Code: 1215. Cannot add Foreign key Constraint/ Error to add foreign key
On the table Matriz you are declaring as primary key the composition of Curso_idCurso and anoInicio. Already on the table Disciplina you are trying to create a reference from only Matriz_idCurso.…
mysqlanswered Diego Rafael Souza 2,900 -
3
votes2
answers947
viewsA: Counting weeks between two dates
When you say progressively count the weeks can mean many things. However, in the example you present in the question I did not find what the meaning is, because week 1 has 3 days, and the days of…
mysqlanswered Diego Rafael Souza 2,900 -
1
votes1
answer43
viewsA: Query Mysql returning differently
You can simplify that expession there of the third column (turned first, according to your requirement). You need to group by columns that will be treated as 'totalizers''. SELECT CAST(SUM(CASE WHEN…
mysqlanswered Diego Rafael Souza 2,900 -
0
votes3
answers380
viewsA: Print a string with only numeric values
Marcelo, here you had a similar case (Look at this response from Maniero). In this case, the AP requested that if the character had been typed again, this repetition would also be ignored. Following…
-
1
votes4
answers949
viewsA: Day and month comparison on SQL Server
I would simplify the logic somewhat by adding the amount of years left to the current year at the customer’s date of birth. Once you were receiving as parameter the start and end dates considering…
-
0
votes2
answers2342
viewsA: Use IF function in SQL as if it were excel
To treat conditional results in sql-server you have basically three structures: 1. IIF(boleana expression, value if true, false value) Example: SELECT IIF(id = 1, 'VERDADEIRO', 'FALSO') as Expressao…
-
1
votes2
answers252
viewsA: Uppercase letter in a Searchbar - Xamarin Forms
The event itself does not provide the possibility to change the user input as it is triggered after the text has already been changed. This is far from being the ideal solution, I wouldn’t recommend…
-
0
votes1
answer223
viewsA: Doubt in SQL query with Group by and Order by
TL;DR; If I correctly inferred your model, to get the desired result your order by it must be so: order by cped.razsocial, cped.nrpedido, iped.descricao Explaining You don’t order by two fields at…
-
0
votes1
answer480
viewsA: Subquery returns more than one value
Beyond what the message itself suggests, I can’t imagine another reason why this error is being triggered. However, you can circumvent this in other ways. For example: Put a Limit 1 IF(SELECT nota…
-
5
votes2
answers76
viewsA: Failed to display Address class fields when using object creation method expressed in C#
This code should not be compiling: public Empresa() { Endereco = new Endereco(); Plano = new Plano(); } Note that you have declared the properties endereco and plano with the names completely on…