Search results for query: *

The Answer! http://groups-beta.google.com/group/microsoft.public.dotnet.framework.adonet/msg/a5cf3b1642f671a6

i run the stored proc from my vb.net app...using ado.net but if i run it with the query analyzer it runs but only shows the row count in the "messages" tab

Hi I used to use the PRINT function to return debug msgs to myself. They appeared on my screen as message boxes. They no longer work! Any ideas what may stop these messages getting through? Regards GRUNGE

ive found this.... worth a read http://msdn.microsoft.com/library/default.asp?url=/workshop/networking/pluggable/overview/aplugprot_overviews_entry.asp

hi, Not quite VB.NET i believe, but its a dev question that ive had no luck with in OS specific forums. using Win 2000 & XP I need to use a URL style prefix to access my application. e.g. http:// ... opens up default web browser ftp:// ...opens up default ftp browser...

thanks to the TheLearnedOne for this answer in another forum.............................................. Private Const BITSPIXEL As Integer = 12 Private Declare Function GetDeviceCaps Lib "gdi32" _ (ByVal hDC As Integer, ByVal nIndex As Integer) As Integer Private Declare Function...

tried using this API... Private Const BITSPIXEL = 12 Private Declare Function GetDeviceCaps Lib "gdi32" (ByVal hdc As Long, ByVal nIndex As Long) As Long ... MsgBox("This system is using " & Format$(GetDeviceCaps(Me.Handle.ToInt64, BITSPIXEL)) & "-bit color.") this returns a...

oops... BPP :)

basically i need to find out the colour settings of my PC. Preferably using the framework. Ideas? Regards DiDGE

noted thx

had it answered in another forum... You just need to assign the value you're interested in to a previously declared variable and RETURN it at the end; viz: CREATE PROC ReturnAsExitValue AS BEGIN DECLARE @RowID INT SELECT @RowID = MIN(TransactionID) FROM tbl_Transactions RETURN @RowID END...

i tried this .. .didnt work (tried to use the AS to populate @Returny INSERT INTO tblProductRecord SELECT (SELECT MIN(ProductUID) + 1 AS @Returny FROM tblProductRecord WHERE ((ProductUID + 1) NOT IN (SELECT ProductUID FROM...

Hi there, I have finally come to the point where i can't proceed without learning how to use return parameters! i need to return minGroupID or ProductUID ... they are the same. So somehow i need to set the variable @Returny ideas? ...

Works a treat thx! UPDATE b SET ProductName = t .ProductName, TypeUID = t .TypeUID, CampaignUID = t .CampaignUID, PMUID = t .PMUID, PPUID = t .PPUID, StartDate = t .StartDate, EndDate = t .EndDate, ChargeUID = t .ChargeUID, Objective = t .Objective...

Thx chap... ill give that a go!

Hi there, Thanks for your reply... I simplified the SET set due to the huge list!... lets assume I have 2 fields to SET. Can that be done with 1 select statement? intead of having to run a query for each field. Regards,

UPDATE b SET ProductName = t .ProductName FROM tblProductRecord t INNER JOIN tblProductRecord b ON t .ProductUID = b.ProductUID WHERE t .ProductUID = 1887 AND b.ProductUID = 1884 This almost works.... not quite! Ideas??!

ah nice... just reincorporated the %20

thx! that seemed to sort most of my issues with it... now just need to figure out how to get the rich text box to detect a 'URI' with spaces.

Hi there, Im embedding file links into my rich text box ... like this... file://c:\test.txt Now this works fine until i get paths with spaces in... so i tried to replace the spaces with %20 .... like this File://C:\Documents%20and%20Settings\David\Desktop\Test.txt However, this %20 thing...