Tarey Wolf's Q&A profile

• SQL Server derived column transform (flat file blanks to 0)

  Hi, Is it possible using derived column transform to change all blank values in a flat file to say a "0" Basically convert "" to "0" Thanks for any help, Slash. Hi, I think you can generate your derived column like this : ([source_column] == "") "0" : [source_column] Arno. ...Show All

• Game Technologies: DirectX, XNA, XACT, etc. Texture alpha channel problem

  Is there a way to apply 2 alpha textures to a single polygon (with one draw call) What I mean is: I have GUI interface in my application, where everything is a textured quad. When I render a sprite (textured quad that has its own alpha channel) inside a "window" I need to clip it to the window edges (irregular boundaries). I already use SCISSORTEST to make simple rectangular clipping possible, but would like to be able to do something similar to Macromedia Flash's mask object. Ideally I'd like to have two alpha channels that would have a cumulative effect, and probably two sets of u/v coordinates as well. What's the best way to do this -nagual This section from the documentation should help y ...Show All

• Microsoft ISV Community Center Forums Code for end of month activity submission in an activity system

  Hi there - can anyone help with my syntax - when a user presses the submit command button i want the date that they have entered into an unbound drop down date field called 'dls' to be inserted into a field called 'datelastsubmitted' into 'tblusers' and it should enter it against the appropriate user who is logged in (this logged in users are stored in a global variable called 'loginname'). Her is my syntax: Private Sub submit_Click() Dim sql As String dls = Me!dls Dim rsdbase As Database Dim rstemp As Recordset Set rsdbase = CurrentDb Set rstemp = rsdbase.OpenRecordset("INSERT INTO tblusers[datelastsubmitted] VALUES dls WHERE tblusers[loginname] = '" & loginname & "'") DoCmd.RunSQL sql End Sub ...Show All

• Visual Studio Team System Code Analysis for device projects

  Hello, is anyone able to use the code analysis and unit testing tools on device projects If so, how is this accomplished Thanks in advance, Peter Vrenken All new application and assembly projects. I am looking into all the new features that TFS provides, and porting existing projects is not yet on the agenda. This is the content of the HelloWorld.exe.CodeAnalysisLog.xml: < xml version="1.0" encoding="utf-8" > < xml-stylesheet type="text/xsl" href="c:\program files\microsoft visual studio 8\team tools\static analysis tools\fxcop\Xml\CodeAnalysisReport.Xsl" > <FxCopReport Version="8"> <Localized> <String Key="Category">Category</String> <String Key="CollapseAll">Collapse All</Stri ...Show All

• Visual Basic Binding keys within the form

  Anyone know how to bind for say the "esc" key to a function Code Snippet 'make sure you set your forms keypreview property to true. Me .keypreview=true Private Sub frmMain_KeyDown( ByVal sender As Object , ByVal EventArgs As System.Windows.Forms.KeyEventArgs) Handles Me .KeyDown Select Case EventArgs.KeyCode Case Keys.Escape me .close 'function to call End Select End Sub ...Show All

• SQL Server Anyone know a self extracting tool for a zip file?

  I have a zip file that requires a password to extract the file inside of it. Is there away to do this automatically Can't find any software that does this. Mike expression: " e " + @[User::ZipFileName] + " -y" + " -ptestpassword" evaluates to: "C:\Program Files\7-Zip\7z.exe" e "D:\Test\Dropoff\update2.zip" -y -ptestpassword you might want to try getting your command to run from a dos prompt. once you verify it does what you want, create the expression to duplicate it. Frank ...Show All

• Game Technologies: DirectX, XNA, XACT, etc. PIX

  any way to use PIX with XNA... I like those Acronyms PIX should not care that this it is watching an XNA program. It intercepts the underlying native DirectX calls. If you can't get it to work then it could well be a PIX bug. However you will have to understand the native DirectX calls and how XNA uses them. e.g. PIX does not know about SpriteBatch - you will see lots of dynamic vertex buffers being drawn in PIX. ...Show All

• SQL Server Secure database ,only for 1 user

  Hello, Is possible to create database file with only one user(No local acount used by Windows authentication) I want copy with my aplication also database mdf file with secret data .I don't want so as user loged to sql server as 'dbo' user ( Windows authentication) can view or edit it. It is possible Ondra. Hi, It is not possible to restrict DBO users however you can use NTFS partition to restrict direct access of physical files. refer http://forums.microsoft.com/MSDN/ShowPost.aspx PostID=52094&SiteID=1 Here are some things to be consider for SQL Server Security 1). Strengthen Password Mechanism 2). Using NTFS File System 3). Change the Port of SQL Server other than default 4). Use named i ...Show All

• Visual Studio Express Editions how can we analyze the contents of datagrid view into excel?

  how can we analyze the contents of datagridview into excel like in ms access...after query we we can analyze it in excel how can we do that One idea. Use a Reportviewer to export data from a Report to an Excell or PDF file. Of course that the reportviewer is a control to print data to a printer, but still it can export data to Excell. You have to create a new form with a reportviewer, and a report where you place the fields that you want to export. Best regards. dp ( www.webhostservices.biz ) ...Show All

• Gadgets This is not a valid gadget package!! grr!

  hey, So i finished creating my gadget, i use winzip to zip it up to mygadget.gadget and then double click to install... However it just says: This is not a valid gadget package The gadget works if i move the folder to the windows gadget directory! Does anyone know how to fix this problem Regards I've had that error before. =) Check the XML. Is it named gadget.xml Check the code inside the XML. There should be a line that says <base type="HTML" apiVersion="1.0.0" src="(your HTML file).html" /> Is the (your HTML file) part the actual name of your HTML file After doing that, I discovered mine was #2. Try this and tell me the results. ...Show All

• SQL Server Possible bug: Lose members of server role when changing DataDir server property

  Hello, I think I have found a bug in AS and I would like it confirming before I report it. Please could someone try the following steps (don't do this on a production machine): Connect to your Analysis Server in SSMS with a user that is a member of the server role but NOT the user that installed the software Right-click on the server in Object Explorer. Select 'Properties...' On the general tab, change the value of the DataDir property to a different folder (it doesn't matter what) Click 'OK' on "Analysis Server properties" dialog. You will get a message telling you that the server needs to be restarted Restart your Analysis Server in Services panel. Re-Connect to the Analysis Server in Object Explorer aga ...Show All

• Windows Forms starting an .net application on another server

  I know how to start another application by using the command Process.Start(filePath) where filepath = "c:\program files\folder\run.exe" But when I install my .net app there is not a .exe only a short cut in the start/program menu ie c:\documents and settings\myname\start menu\programs\suntron\myprogram I need to install myprogram(consol application) on a server and have a button in a application that the user has on their desk top click to run the prcess.start(filepath) which is installed on a diffrerent server i tried \\server\c :...... but no good I have an application the user can make changes to some data in a DB. when they are finished they click a button in thei ...Show All

• Visual Studio Express Editions Running Programs in Vista

  Im about to install Windows Vista on my PC . I want to know if my code will still work, especially code that gets information from the registry and the system. Wish me luck... Access 2007 saves as .accdb files, which i dont know are compatible. Also how they are saved is changed. Office 2007 doesn't use the Assistant (the annoying paperclip) so this isnt comaptible ...Show All

• SQL Server PDF Rendering bug

  We are trying to publish a group of financial reports using SQL Server Reporting Services. We have hit a snag when we try to render the reports in PDF format. The leading spaces of each line are stripped in the output file. For example: Department 10.7240 - ICU Expenses SubDepartment -------- ------------- 1,200 100 454 150 Becomes: Department 10.7240 - ICU Expenses SubDepartment -------- ------------- 1,200 100 454 150 Does anyone know a solution for this problem By the way, we did upgrade to SP2. That did not correct the problem. Hi Russell, The data in one of our tables is written out indented in some cases and our users want to see ...Show All

• Visual Basic How to save active page displayed through I.E.6 under text page.

  Hello, I would like , through Visual Basic 2005 command, save under c:\test.txt an active sheet displayed on the screen through I.E.6 browser. I am working Windows XP . Any support will be welcome ! See http://forums.microsoft.com/MSDN/ShowPost.aspx PostID=1133806&SiteID=1 Sub Main() Dim strHTML As String = _ GetPageHTML( "http://www.microsoft.com/" ) Console.WriteLine(strHTML) Console.WriteLine( "Press enter to exit" ) Console.Read() End Sub Public Function GetPageHTML( ByVal URL As String ) As String ' Retrieves the HTML from the specified URL Dim objWC As New System.Ne ...Show All