I'm looking for free implementation of pivot table view for Qt. Does someone know where to find such piece of code? Or maybe it's trivial to implement...
I have table and I want to swap the values from two rows. I have the rows IDs of the two rows.
Is there any query to do that? Here is an example. Before the query I have this:
row1 : 1,2,3
row2 : 5,6,7
After the swap I want this:
row1 : 5,6,7
row2 : 1,2,3
I don't want write it in .NET code because I think an SQL query is easier than that.
i have a problem which is that i want to extract information about FAT(file allocation table) in C# but the restriction is i cannot use System.IO
so How i get drive types?cluster information e.t.c
Trying to get something similar for Firefox extension using XUL. The most difficult part is the grid with unequal number of rows.
I tried <grid> but it didn't work well. Also don't want to use HTML inside of XUL. Any ideas how to build such table?
Hi All,
I have a table called Employee with EmpID,Salary,Name fields.
I want to get top two employees with maximum salary.
How can i write this query ?
eg:table
pkey --guid
annualpay
datefrom
dateto--if null means current record
percentannualincrease
percent annual increase will be calculated only if there is a difference in newly inserted and previously existing last differing value.
percentannualincrease =
([newannualpay-just previous pay(if different from current)]/newannualpay)*100
eg
newid(),5000,today,null,0--very first row
newid(),5000,today+1,null(*),0
newid,5500,today+2,null(*),?????????????--> need to be calculated before insert
*--insert will close the previous record by updating dateto=null to todays date
How can I do this stuff in a trigger???
i am calling the data from xml in table view. after the the first row of data in tableview, my second row is empty in tableview, and from third row data is available. but my last data for row is missing from tableview, because of the second row.
how can i fill that second row.
hi friends,
I am trying to insert data into particular table through pl/sql stored procedure,my requirement is while inserting i should generate PRIMARY KEY values for particular column and also i should return that PRIMARY KEY value to output and one more thing is that for another column i should validate my string such that it should contain only characters not integers.
please help me in writing code for the above requirement
Thanks and regards
thulasi policherla
Hi,
I am trying to learn C++ maps. Was just wondering about the implementation of STL map. I read it employs Binary search tree.
Is there a implementation of hash table in STL?
How exactly do STL map stores Key Value pairs?
I am getting data from a query and processing it using Javascript in the xaction file.
Now I want to pass the processed data (a 2D array) down to a prpt where it will be used to generate graph and table.
What is the format in which Javascript would generate the data and how is it passed to and received by the prpt file from the xaction.
Thanks...
My table looks like this with duplicates in col1
col1, col2, col3, col4
1, 1, 0, a
1, 2, 1, a
1, 3, 1, a
2, 4, 1, b
3, 5, 0, c
I want to select distinct col1 with max (col3) and min(col2);
so result set will be:
col1, col2, col3, col4
1, 2, 1, a
2, 4, 1, b
3, 5, 0, c
I have a solution but looking for best ideas?
I am having a hard time understanding how to change the width of columns when creating a table view.
I know you can set the width in pixels of a column but that is not what I want to do.
Say, for instance, I have 2 columns and want each column to take up half the screen. How do I do this without explicitly setting the pixels, so that my code can work on multiple screen sizes?
I have 'Service' table and the following column description as below
Is User Verification Required for service ?
Is User's Email Activation Required for the service ?
Is User's Mobile Activation required for the service ?
I Hesitate in naming these columns as below
IsVerificationRequired
IsEmailActivationRequired
IsMobileActivationRequired
or
RequireVerification
RequireEmailActivation
RequireMobileActivation
I can't determined which way is the best .So, Is one of the above suggested name is the best or is there other better ones ?
can any one explain hiow this query works..It's for getting the Nth largest elemet from a table.here it's 4 th largest
SELECT a.ID
FROM tblitem a
WHERE (4) = (select count(*)
from tblItem b
where b.id < a.id)
Thanks in advance
How can I change the Default Size of the filterBy text box in Rich Table? In all the columns, it has a same (fix) size.
I used the property width, but it didn't work.
I am trying to get the value of a cell in a table view but it won't let me. If someone could help that would be great.
int numberOfChecks = -1;
numberOfChecks = numberOfChecks +1;
if ([objectsForTable count]-1 >= numberOfChecks) {
UITableViewCell *cell = [self.tableView cellForRowAtIndexPath:numberOfChecks];
NSString *cellTitle = cell.textLabel.text;
}
Hi,
I have a person table that contains the following fields:
id, name, parent_id.
the parent_id is actually a FK for column id.
the data should look like this (Like a pyramid):
"id" "name" "parent_id"
"1" "I am the Top Father" "1"
"2" "My Father Is 1" "1"
"3" "My Father Is 2" "2"
"4" "My Father Is 2" "2"
How is my bean suppose to look like?
Thanks
I try to draw a table on a panel in C# Windows Form by using GDI+. The problem is that when I minimize the application, my drawing disappears. How can I avoid this and why acting this way?
Hi All,
Is there some way to backup the data in a table in sql server by using sql scripts. Note: I dont want to take the backup of the whole database.
And later on restore the same data back in case of any failure.
Please suggest some solution.
Hey all
i am working at my project where it collects information from two database, one is supplied by the program lets name it DB Y and the other supplied by the user lets name it DB X , now i have an query that depends on companies which is on DB x so i want to transfer this table from DB x to DB y at run time and also checks if there is new updates in DB x and transfer them but i am confused
hey guys,
a curl function returns a string $widget that contains regular html - two divs where the first div holds a table with various values inside of <td>'s.
i wonder what's the easiest and best way for me to extract only all the values inside of the <td>'s so i have blank values without the remaining html.
any idea what the pattern for the preg_match should look like?
thank you.
I have 2 lists in my program one that store objects of type student and another one which stores objects of type marks.
I have 3 methods one that inputs the details of the students, one that inputs the marks and one to view student details and their marks. My question is how I can use a hash table to get the Id of a student and then use it to input the marks and then how to retrieve both the student details and their marks altogether.
Please help me if you can.
hello i have a issue and i want your help i have a table which is called citylink[10][2]
and i want to make a check before i move on in my code if it's full to continue if it's not to break!!i know that i should use an if loop but i don't know what to put inside it!!