Home | Contact Us | FAQ | Search & Site Map | Link to Us
Sign In | Join | Other 45 Sites in Network
HomeAnnouncementsFree MagazinesWhite PapersSubmit Content
Discussion GroupsASP.NETWindows FormsLanguages.NET FrameworkVisual Studio.NET
Articles.NET FrameworkASP.NETToolsWindows Forms
.NET DirectoryOpen Source ProjectsUser GroupsWeb Resources
Related Topics
Visual Basic 6SQL ServerMS AccessOther DB ProductsMS Server ProductsMore Topics ...

.NET Forum / Visual Studio.NET / Debugging / November 2003

Tip: Looking for answers? Try searching our database.

SQL timestamp parameters in VS.NET

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
Patrick Seurre - 04 Nov 2003 11:13 GMT
I've managed to get SQL debugging working OK and have no
problems stepping through the stored procedures, setting
breakpoints and so forth.

The problem I have is that I can't find a way of entering
a timestamp value when there is a timestamp input
parameter.

I've tried doing everything I can think of - including
copying and pasting the value from the database - and
nothing is accepted as valid.
"Hartmut Maennel" - 27 Nov 2003 02:15 GMT
Hi Patrick,

Thanks for letting us know about this problem.

Timestamps are numbers that behave in a special way: They can be updated
automatically and they are guaranteed to be uniqe across the database, so
in theory they should come from the data base and not be set by the user to
some arbitrary value. Of course, if one tries to protect some users against
accidentally doing something, one may hurt other users who have a valid
reason to do the same thing...

Where do your timestamps come from? Maybe you could call your SP from
another SP that reads these timestamps so you do not have to set them
manually?

Hartmut Maennel, C# Team (Debugger)
This posting is provided "AS IS" with no warranties, and confers no rights.
--------------------
>From: "Patrick Seurre" <anonymous@discussions.microsoft.com>
>Subject: SQL timestamp parameters in VS.NET
[quoted text clipped - 11 lines]
>copying and pasting the value from the database - and
>nothing is accepted as valid.

Free Magazines

Get these publications absolutely FREE for up to 12 months. There are no hidden fees and no obligation. Simply choose a title, complete the application form and submit it. Read more ...

Oracle MagazineNetwork ComputingComputer WorldBio-IT WorldeWeekInformation WeekInfosecurity
 
Sign In
Join
My Latest Posts
My Monitored Threads
My Blog
My Photo Gallery
My Profile
My Homepage

Start New Thread
Enable EMail Alerts
Rate this Thread



©2008 Advenet LLC   Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.