Search results for query: *

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

...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 & commandname "show" (2)Datagrid "dgCompany" -...

...= CommandType.StoredProcedure Me.daUser.Fill(dsUser, "user") tmpdg.DataSource = Me.dsUser.Tables("user").DefaultView tmpdg.DataBind() E.Item.FindControl("plcDG").Controls.Add(tmpdg) End If End Sub *** How can I ascertain wich user was selected

Hi, I will try this tomorrow : To qualify once "@strDetail" as "d" 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...

...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 exec(@sql) end go Nothing was successful. I think there is an issue with ***'*** an ***"*** (single and double quote). How does the SP...

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

Hi, I want to call a Stored Procedure from an other SP. SP1 is as follows: ********************************* CREATE PROCEDURE DetailUpdate ( @strname char (30), @id int, @rv varchar output ) AS exec @rv = getstatus @strname,@id select (@rv) GO ************************************ CREATE...

Hello, Is Winproxy supporting three NICs (1->ISP,2->LAN,3->DMZ)?

Hello, Thank you for your answer. It is easier to have the value of the sum of all detail scores in the overview table then to calculate it always new. But I will change the sum when I add a new item to the details. Thank you!

Hello, I have the following two tables with a column "sum" that should contain the sub-total as described. Thaks in advance! table1: overview column1:overviewID column2:name column3:sum -> (of all rows of table2.overviewID - this field shoul contain the sum of all single scores for...

Hello, We will probably develop a solution with MS BizTalk but I have to check the prices of other products first. What is the basic price for SeeBeyond Software? (Just to put something in my mind) Thanks in advance!