Recent content by saturnius

Hi, Thanks for your answer. Apparently there was a problem with a stored procedure. I copied the text, deleted it, created a new SP and inserted the text - everything was working fine after. Thanks, Saturnius

Hello, suddenly the date format changed for an unknown reason to 'May 10 2004 4:15PM'. This is part of a datagrid and the original fromat is in the table of the SQL server is '10/05/2004 16:15:00'. I use this code to get the parameter of the Stored Procedure cmd.Parameters.Add(New...

Thank you. I have a look ....

Hi, Thanks for the fast answer. What kind of code do you mean?

Hi, I am looking for a SQL command to access the "Description" Column in MS Access. With the SQL Server I can use: SELECT cast(objname as Nvarchar(100)) as ob, cast(value as Nvarchar(100)) as va FROM ::FN_LISTEXTENDEDPROPERTY('MS_Description','User','dbo','table','myTab','column', default)...

Hi, recently the synchronised offline files under win XP are only available after 5 minutes and not immediately - why is it like that? Cheers Saturnius

Hello, We changed the user on a notebook. Personnel and public data is on a central server. I can not delete the synchronisation process for the first user. Can anyone help please? Cheers Oliver

Hi, Thank you very much for your help.Unfortunately I could not find out how to catch events on the child grid. I tried with ctype(sender, datagrid) but there is always the parent datagrid. Here is the code i try: ******* (1)Datagrid "dgCompany" - itemtemplate with imagebutton &...

Hello, I have two Datagrids on my Page: Company(Parent) and User(Child). I load all users belonging to a company on a child grid. How can I select a particular user? HTML-Code for Datagrid: <asp:datagrid id=&quot;dgCompany&quot; runat=&quot;server&quot; AutoGenerateColumns=&quot;False&quot...

Hi, I will try this tomorrow : To qualify once &quot;@strDetail&quot; as &quot;d&quot; seems the trick (FROM '+@strDetail+' as d) Thank you very much!!! Have a nice day - all of you :-) Cheers Saturnius

Hi, Below is the SP -- so far I did not try to apply [] Thanks for your ideas. Cheers Saturnius *************************************** CREATE PROCEDURE newsquote ( @strDetail char (30), @strOverview char (30) ) as declare @sql as varchar(3000) set @sql = ('SELECT...

Hello, Thank you for you comments. I changed both and it did not help: - I've declared the varibles as varchar like: @strDetail varchar (30) - There is only on line left in the SP - I did the following as well: declare @sql as varchar(2000) set @sql = 'Select ..see above ..(workstage = 0)' begin...

Hello, The code below works fine in the Query Analyzer but from a Stored Prodedure I get the following error. Any Ideas? ******************************* SP error:Line 1: Incorrect syntax near '.'. ------------------------------- ******************************* Query Analyzer works correct...

Hello, I have a Start/News page in my Web application with daily new items. On click I want to go to a detail page which should have the selected item in edit modus. Is this possible? Many thanks in advance!

Hello, Thanks a lot both of you. It works very well - actually I dropped the second SP and it is now only one. Have a nice day! Cheers! Saturnius