Search results for query: *

Hi Have found the solution Call the proc from another proc and return a "recordset" Reference this in .NET code CREATE PROC test ( @person numeric(8, 0), @name numeric(8, 0) OUTPUT ) AS IF @person = 1 SELECT @name =23 CREATE PROC testCall ( @person numeric(8, 0)...

Hi I am only using this really for testing the real stored proc I want to call has 6 input and 2 output parameters so I've cut it down I always pass it 1 Rgds ;-)

Hi Have been looking into this and a return value is returned fine Is there a bug when using sybase that output parameters do not get returned? Rgds S ;-)

Hi Am trying to execute a very basic stored proc (sybase) It appears to run fine but no values get returned It works perfectly when i execute it through sql advantage any ideas? here is code CREATE PROC test ( @person numeric(8, 0), @name numeric(8, 0) OUTPUT ) AS IF...

Hi Is there any way to send an email in VB3 Thanks in advance ;-)

Hi, Am sorted imported the spec from the database it was working in, added in my new fields and now it is fine Thanks ;-)

Hi, Am using a specification created from an access table One database outputs numbers with two decimal places e.g. 100.00, another specification created from an identical access table (I exported the table)but in a different access database ouputs numbers with no decimals unless they are...

Another Stupid Question: Does my PC have to be switched on to log in ? ;-)

I am getting the following error when I try and get a list of databases in the Silverstream designer. Status code: 500 "Unexpected exception occured attempting to obtain access rights information" Exception Information com.sssw.srv.ambry.AmbryInternalException Expected internal...

Hi not sure if this is what you mean but there is a function in Transact SQL called ROUND ROUND(variable, number to round to) e.g ROUND(83.86363636363, 2) will give you 83.63;-)

Yes Did anyone find oout the answer to this?

Hi I need to be able to run tbe command BULK INSERT on a file which is held on \\servername\path\file.txt but I keep getting an error returned: Could not bulk insert because file '\\servername\path\file.txt' could not be opened. Operating system error code 5(error not found). Which after some...

Hi guys I have to take a flat file which is not very well delimited and read it in one line at a time and pass each line individually to a stored procedure Bulk insert is not suitable as the delimiters are not very clear e.g. this is one line...

I set up the application on the Server side directory structure as //{server name}/inetpub/registration on the client it was created as C:/inetpub/Registration/registration service_local I have the VirtualRoot of my client side project setup to be /registration service_root When I run the...

I am using POST Thanks

Hi I'm stuck again! I am trying to pass variables which I am picking up from a form as part of a URL to another form <INPUT TYPE=&quot;TEXT&quot; NAME=&quot;description&quot; style=&quot;font-size: 10;&quot; SIZE=12 MAXLENGTH=100 VALUE=&quot;&quot; &_ Request(&quot;description&quot;) &...

Hi TazzMann That worked perfectly Thanks very much Stessie ;-)

I have a sub procedure called Export in my ASP page Sub export() ............ End Sub I have an image that I am using as a link and I'm trying to call the export sub but it's not working <a href=&quot;Statement.asp?<% = QStrg %>&quot; onclick = &quot;export()&quot;><IMG...

Apparently SilverStream does not recgonise soft links We have come across this problem too You have to re set up the links in SilverStream

When I select * from AgerrorLog I can see these error messages appear <c3;client3>: dying due to ThreadDeath (probably request timeout) <c7;client7>: finished with unknown status 3 has anyone ever seen these before? I have been working with SS for over a year and have never seen anything like...