|
Dunno avout 6.5, but it works ok on Sql Server 2000....
Regards,
Rob Philpott.
|
|
|
|
|
Try it and see what happens.
Paul Marfleet
"No, his mind is not for rent
To any God or government"
Tom Sawyer - Rush
|
|
|
|
|
Great Idea! Why didn't I think of that?
Because I don't have it installed? Because I am on a clients site and have to jump through many hoops to get anything installed?
I will try it when back in my own office, but was hoping somebody out there might help, not treat me as being one of the many lazy slackers on here who wants everybody to do their work for them.
-- modified at 10:59 Wednesday 14th November, 2007
Apology to Paul issued for this below. I won't delete this post as a) I hate it when people do that and b) Colin copied the whole lot in his reply so there'd be no point!:-O<br />
<br />
The flak jacket is buttoned up tight to try and deflect all those deserved '1' votes.
"More functions should disregard input values and just return 12. It would make life easier." - comment posted on WTF
"This time yesterday, I still had 24 hours to meet the deadline I've just missed today."
|
|
|
|
|
Malcolm Smart wrote: Great Idea! Why didn't I think of that?
Because I don't have it installed? Because I am on a clients site and have to jump through many hoops to get anything installed?
I will try it when back in my own office, but was hoping somebody out there might help, not treat me as being one of the many lazy slackers on here who wants everybody to do their work for them.
You could have said that up front so that people would know.
|
|
|
|
|
And how were we supposed to know that??
Everyone I know is using a minimum of 7.0 (mostly 2000), so 6.5 is a little hard to come by.
|
|
|
|
|
Dave Kreskowiak wrote: 6.5 is a little hard to come by.
It is still available to MSDN Subscribers.
|
|
|
|
|
It is! That thing should have died a long time ago!
|
|
|
|
|
Malcolm Smart wrote: The flak jacket is buttoned up tight to try and deflect all those deserved '1' votes.
I don't see any 1 votes. You don't deserve them because you have made a correction and quite graceously too. So many people don't do that and just jump in and argue back (which just irritates everybody). Sorry, I can't help in this instance. I hope you get your problem solved.
|
|
|
|
|
My last response to you was out of order. Sorry. A bad day, turning into a bad week. Doesn't bode well for the month.
I know most people on here post a question as their first port of call, hoping for somebody to do their job for them. I have STFW for this, asked around and got nothing. Posting is generally my last resort, and I got the same answer given to a lot of other posters and it narked.
I should have been clearer in my question, but I generally assume that the OP has tried, or is unable to do, what he is asking about. Unless they are from NIIT.
Thanks to Colin for picking me up on this.
"More functions should disregard input values and just return 12. It would make life easier." - comment posted on WTF
"This time yesterday, I still had 24 hours to meet the deadline I've just missed today."
|
|
|
|
|
I've been having a bad few weeks like this too.
Though the bottom line is you're going to have to try it anyway to see what works and what doesn't if you're going to support it, even if someone does say "Yeah, it works!". Personally, I trust what my testing tells me, not what other people think works.
|
|
|
|
|
That's OK. I see lots of posts where the obvious advice to give is 'Try it yourself and see what happens'. For some reason this doesn't occur to many people, especially those posting from the Indian subcontinent.
Paul Marfleet
"No, his mind is not for rent
To any God or government"
Tom Sawyer - Rush
|
|
|
|
|
|
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
|
|
|
|