My scenario is.. I have created a table with employee id as identity column.
now i want to remove identity and replace datatype as bigint.im using Sql Compact edition
how to achieve this.
In psql we have PL/Perl to communicate with external program when the new row is inserted into our table. Like that is there any way (procedural language ) to communicate with external program in Oracle . For achieving this things, what should I do.....?
Can any one help me out of this problem.....
I have a grouped table view that does not need to scroll. I'd like each cell to highlight as the user moves their finger down the screen and call didSelectRowAtIndexPath on release.
This behaviour can be seen done by apple in 'settings mail add account'?
I can't seem to replicate it myself, all I can get is the default, where the cell deselects as soon as the user moves their finger.
I have two different QuerySets which both return a list of Users (with different fields). How can I display them both in one HTML table? One Query will always be a subset of the other; I just want to fill in the missing data with 0s. How can I do this?
Hi,
I have the following table in an access database
id VisitNo Weight
1 1 100
1 2 95
1 3 96
1 4 94
1 5 93
Now row 2 and 4 are deleted. So i have...
id VisitNo Weight
1 1 100
1 3 96
1 5 93
However what i need is...
id VisitNo Weight
1 1 100
1 2 96
1 3 93
What is the SQL query i need to accomplish the above?
thanks
Hi,
Is there any application that will read a MySQL database table and generate a SQL script of INSERT statements (so that I can copy tables from one db to another db)? OR how can I transfer content from db1.table1 to db2.table2 where table1 and table2 is same.
Thank you.
Lets say I have a table with 20 entries. They are sorted by date (date is a column name _) in descending order. How would I go about selecting ONLY the newest entry and the 15th oldest entry?
I am getting all 15 results by doing the following query
SELECT * FROM mytable m WHERE col1 = "zzz" ORDER BY date DESC LIMIT 15;
I have a table of customers with a 1 recorded against their customerid on different dates.
I would like to find the sum of the 1's recorded in descending order. I'm using MySQL and php
Thanks
if there is no data to display, jsf data table shows headers only. How to say that no records available and also tell me is there any way to get the row index with out having a specific method. thanks in advance
.
.
Hi,
I can set the edit mode for a while uitableview by calling [tableView setEditing:YES]; But that sets the edit mode for all the rows in a table.
Is there a way to detect what row was swiped an enable the edit mode only for that row?
Thanks
$('tr').click(function() {
$("#showgrid").load('/Products/List/Items/');
});
Using this.I am handling click event on the row of the table..
but my quetions is how Can i handle only on the first column?
that is giving click action to only first column not on entire row?
can anyboyd help me out
thanks
example: i need the numbers of which the sum of the amount where id = 1 is not equal of the sum of the amount where id < 1, together with the id's and difference.
The table (view in this case) may look like this:
NUMBER AMOUNT ID
0001 500 1
0001 500 2
0002 400 3
0003 299 1
0003 300 3
0003 300 3
Many thanks for your help on this one.
Hello,
I am currently using Silverlight 3. I want to create the equivalent of a 2x2 HTML table. I want each cell to have a black border. How do I do this in Silverlight? Isn't there a property I can set on a Grid element to make each cell have a border?
Thank you,
I was looking for some information about virtual table, but can't find something easy to understand, can somebody give me good example(not from Wiki, please), with explanations, or link, thanks in advance
I want to update Table2 names with names from Table1 with matching Ids
I have around 100 rows in each table.
Here is my sample tables.
Table1
ID
Name
Table2
ID
Name
Sample data
Table1
ID |Name
--------
1 |abc
2 |bcd
Table2
ID |Name
--------
1 |xyz
2 |OOS
Expected result
Table2
ID |Name
--------
1 |abc
2 |bcd
How can I do this?
In my hard drive windows takes up 100 gb, then backtrack takes up 100 gb. When I make backtrack's partition smaller i get 100 gb for windows, 50 gb for backtrack, and 50 gb of unused space (in that exact order). How do I reallocate that 50 gb of space to windows so that instead it is 150 gb for windows, then 50 gb for backtrack? I'm using gparted and i can't move the unused space or add it to windows' partition.
Hi All
Is there a reliable and correct way to find if VISTA/W7 is installed in a partition?
Please note, Searching for folder names is not reliable as one can manually create such paths in a partition and these can also be changed during the installation.
So, are there any paths which can not be changed during and after installation or any other reliable way?
Regards,
I've installed freebsd 8 with it's boot manager to the machine which had linux installed. Now linux doesn't boot because of invalid boot sector on the linux partition.
I see that freebsd has grub in ports (/usr/ports/sysutils/grub). Is it possible to utilize this port to install grub into the linux partition?
i have debian system in which i have mounted the OS on a ext-3 system . I have got a partition of 60 gb , which is formatted to ext-2 partition . Even if I mount , i cant write anything into it . How can i change that ? How can I make the disk writable?
I once used gnome-mount like this
gnome-mount -o ro -d /dev/sda2 or gnome-mount -o ro -p "Macintosh HD"
But, alas, gnome-mount seems to be no more. RIP.
I can do this
gvfs-mount -d /dev/sda2
(which generates a whole lot of errors but does mount the partition in the /media directory.)
This is a related question: http://superuser.com/questions/131918/gnome-mount-alternative-in-ubuntu-10-04-or-how-to-mount-partition-with-normal-use
But how do you do it by name?
I lost the D-partition in My Computer
I opened My Computer, but couldn't find it and I don't know where it is or how to return it.
I went to Disk Management and found it available as free space.
So I tried to make it NTFS, but I had to format the drive and I don't want to, since it will erase my data.
Does anyone know how I can restore my partition without losing my data?
I have a VAIO model VPC-F11JFX/B. I want to restore it to factory settings (instead of formatting it so I can keep the programs it comes with like VAIO Care). I have like 20 GB of data so I can't copy it into my flash drive and it would take up like 7 of my CD's so I can't do that either. So can I make a new partition (called D) and move the files to D from C. Because I don't know if restoring to factory settings is going to wipe the entire drive or just the partition.