Posts by rcaratchuk • 441 points
11 posts
-
1
votes3
answers1890
viewsA: Query two tables in Mysql
I believe it’s a Join. follows an example in sqlserver, but the Join query can be used in several Dbms. create table REDE1 (COD INT, CAMPO_A VARCHAR(10) NULL, CAMPO_B VARCHAR(10),CAMPO_C…
-
0
votes3
answers1405
viewsA: How to export SQL records without duplicates?
First I believe that your modeling "even if for testing" there must be a primary key, which nay should allow the column "ID" get duplicity, but OK, let’s go for something like testing. in this case,…
-
0
votes1
answer476
viewsA: Convert column to row
Try using it as follows: SELECT id + id_unica + parametro + descricao + produto FROM inventario WHERE produto='Monitor' GROUP BY parametro ORDER BY parametro ASC; if the + signal does not work in…
-
1
votes1
answer84
viewsA: How to get the Foreign Keys creation script from the entire database? SQL Server 2008
exec sp_helpconstraint <tabela> return all dependencies that exist with this table and from this table.
-
1
votes0
answers149
viewsQ: how to measure speed in mobile broadband traffic on 3g or mobile wifi programmatically on iphone
In the app, I’m already collecting traffic on iphone, now I need to check how to measure the speed in mobile broadband traffic on 3g or in the wifi programmatically. For example: Every 1 minute or…
-
3
votes1
answer154
viewsA: How to recover elements from another table in an SQL query?
You did not pass the layout of the tables, but I believe that both have a primary key, which will make the connection between both ( what we call Join ). Your select would look something like this.…
-
1
votes0
answers77
viewsQ: How to collect internet usage information for iPhone with Xamarin / monotouch
I need to collect internet usage information on iphone , the code c# below that I am using only returns me zeroed values. I’m using the right class ? has some reference I need to add on Xamarin ? in…
-
3
votes1
answer302
viewsQ: What is the difference between "master Detail application" and "web view application"?
There is some difference in Xamarin between projects master Detail application and web view application? I am started a new project on Xamarin iPhone.
-
8
votes1
answer494
viewsQ: Read contacts contacts agenda iPhone using Xamarin
How do I read the contact list in my iPhone phone book using Xamarin? I need to read the contact list of the iPhone agenda. I do not know how to do and I did not find any Portuguese material on the…
-
6
votes1
answer678
viewsQ: Read SMS history log on iPhone using Xamarin
I need to read the SMS history log sent/received on iPhone, and your time spent on each shipment. I don’t know how to do it and I couldn’t find any material in Portuguese about it. Can anyone help…
-
8
votes2
answers6054
viewsQ: How do I read the record of incoming and outgoing calls on my iPhone using Xamarin?
How do I read the history log of incoming and outgoing calls on iPhone using Xamarin? I need to read the log of the calls/ made on iPhone. I do not know how to do and I did not find any material in…