|
Hi,
In my application i have a database table which my client can access, now if he deletes any particular row from it i have to know the updation but when he is deleting the next row is coming up with out showing any gap in between the row. Im using VB with SQL Server 2000
how to show empty cell space when we delete a particular row from a table in sql server?Please help me
-- modified at 6:23 Wednesday 14th November, 2007
|
|
|
|
|
Hi Sivaram,
As far as i know, you can't have deleted tuple/row showing in any DBMS, not only in MS SQL Server. If you want to achieve this, you can use triggers (after or before, depends on the implementation). And you may also will like to use virtual table named "Deleted".
Regards,
Adeel
Do rate the reply, if it helps or even if it doesnot, because it helps the members to know, what solved the issue. Thanks.
|
|
|
|
|
Hi Adeel,
Thanx 4 ur reply,
Actually the client is deleting from front end i.e VB and here i can see it through database table only, im not able to know which one he has deleted as i need to keep track of the data. when he delete any value from front end can i get a blank space on tat particular row without the next row updating the deleted row.
pls do help me
|
|
|
|
|
No. You might want to consider some kind of deletion flag as a field in the row, so you can know that this record had existed, but has now been deleted.
|
|
|
|
|
Why not, rather that deleting the row, update the row and set every column to NULL with the exception of the Id column?
Steve Jowett
-------------------------
Sometimes a man who deserves to be looked down upon because he is a fool, is only despised only because he is an 'I.T. Consultant'
|
|
|
|
|
hi
You can create a back up table and write a trigger on the original Table from which u r client is deleting data.In trigger u wite the code to insert the deleting data in to a backup table.You will get the deleted data from the table "Deleted".U can use this to insert into back up table.Dont forget to insert the datetime at which the data is deleted..
Regards
Joe
|
|
|
|
|
how to use Distinct in ms access
i want to count distinct starttime from table
i am using
SELECT Count(*) AS MessageCount
FROM
(SELECT DISTINCT StartDateTime FROM messages) AS T;
but it show all starttime count. its not show according different starttime count
Piyush Vardhan Singh
|
|
|
|
|
That should work. Are you sure that your values are not distinct? Have you taken into account differences in the time portion of the values?
Paul Marfleet
"No, his mind is not for rent
To any God or government"
Tom Sawyer - Rush
|
|
|
|
|
Good Morning All
i have a Problem with my dts's , i see this Error. and i have to such DTS named "DTSSTEP_DTSDATAPumpTask_2" in my local dts that i use. where is it located ? here is the Error Message
http://vuyiswamb.007ihost.com/err.jpg[^]
Thanks
Vuyiswa Maseko,
Sorrow is Better than Laughter, it may Sadden your Face, but It sharpens your Understanding
VB.NET/SQL7/2000/2005
http://vuyiswamb.007ihost.com
http://Ecadre.007ihost.com
vuyiswam@tshwane.gov.za
|
|
|
|
|
Hi All,
Iam having one table in that i have 3 fields
UserId Password ULock
veeresh xyz 1
1-Unlock
0-Lock
If some budy enters wrong password 3 times that userid should be locked.
i.e ULock value should be 0.I need c# code for this.Please help me on this.
i want to join this group
|
|
|
|
|
Hi,
Thanks friend.I wil try it now.
Veeresh
i want to join this group
|
|
|
|
|
My MFC Apllication connected to MS Access Database using ADO via Jet 4.0
(the connection string look like this
Provider=Microsoft.Jet.OLEDB.4.0; Data Source=xxx.mdb)
Will my application work out of the box for every Windows XP/Vista ?
Is Jet OLEDB 4.0 Database Engine pre-installed on both XP/Vista ?
|
|
|
|
|
Ok, this is most likely an easy question, but for some reason I can't seem to get it to work. I have a SQL statement that is selecting data greater than a specific date. Do I need to convert the date somehow, because I keep getting incorrect syntax errors.
SELECT...
FROM...
WHERE DATESUBMITTED > 20040404 23:59:59
I tried single quotes, double quotes, leaving the time off... with no luck. There has to be a simple answer. I have a Pocket guide for SQL which has a few samples of convert logic, but is that really needed for this type of simple statement?
Any help is appreciated. 
Lost in the vast sea of .NET
|
|
|
|
|
Try putting the argument on the right side of your expression in single quotes.
...<br />
WHERE DATESUBMITTED > '2004-04-04 23:59:59'
I admit. I googled this. You can find more DateTime comparison methods here:
http://www.demiliani.com/blog/archive/2006/01/19/3384.aspx[^]
And probably in CodeProject as well.
|
|
|
|
|
Thanks, that worked! I just needed the dashes. 
Lost in the vast sea of .NET
|
|
|
|
|
|
The key is time,for example, every 10 records compose a group, so
group 0: 1st 2nd ...
group 1: 11th 12th ...
group 2: 21st 22nd ...
...
Now I want to get the sum of the first record of ten continuous group, so the values are from
records: 1st 11th 21st ... 91st
Does ado/mssql support this? Because my program need performance.
Thanks very much.
|
|
|
|
|
Hi,
Can you explain the table structure, like what keys you are having on it, its columns and their datatypes, etc?
Regards,
Adeel
Do rate the reply, if it helps or even if it doesnot, because it helps the members to know, what solved the issue. Thanks.
|
|
|
|
|
OK, essentially, it is like this
Col Name Type Length(bytes)
Time(key) datatime 8
Price real 4
|
|
|
|
|
Hi,
You are using MS SQL 2005? And are you using group by on time column and want to sum the price, am i right my friend?
Regards,
Adeel
Do rate the reply, if it helps or even if it doesnot, because it helps the members to know, what solved the issue. Thanks.
|
|
|
|
|
I'm using MS SQL 2000, I want to get the first record every n records.
For example if every group has 10 records, then the records I want are
1,11,21,31,41,51...
Doing it manually is too slow.
|
|
|
|
|
Hi,
Hopefuly one last question, do you have prior knowledge of the groups you will be making?
I hope i am not irritating you!
Regards,
Adeel
Do rate the reply, if it helps or even if it doesnot, because it helps the members to know, what solved the issue. Thanks.
|
|
|
|
|
No other prior knowledge of grouping.
Like the Moving Average Line in stock software, only how many records consists of a group is known when grouping.
-- modified at 3:28 Wednesday 14th November, 2007
|
|
|
|
|
Hi,
I haven't tried it, just a thought, try with the preprocessing of the data, like write a procedure/routine for knowing groups, and keep a count of each groups rows, and pick by using that count.
Second idea is, to try with a Top function, in multiple sub queries, or via partitioning.
This is tricky, because you are trying to do multi-dimentional sort of activity, on a DBMS which is not much familiar to it!
Even in MS SQL 2005, it is bit difficult, but do-able, using the ranking function with top function.
Hope this is of some help.
Regards,
Adeel
Do rate the reply, if it helps or even if it doesnot, because it helps the members to know, what solved the issue. Thanks.
|
|
|
|
|
I just worried about the performance, now I find that a creating a temporary table would solve the problem.
Thank you all the same.
|
|
|
|
General 
News 
Suggestion 
Question 
Bug 
Answer 
Joke 
Praise 
Rant 
Admin 
Submit an article or tip
