vtortola's Q&A profile

• SQL Server Lookup Transformation Join Column Types

  Does anyone have a clue as to why DT_R4, DT_R8 are not allowed as join columns This means I cannot join tables on AccountNumbers, InvoiceNumbers, etc. What a pain... We didn't include support for floating point joins, because of the inherent inability of computers to accurately compare two floating point numbers. To make the comparisons consistent, we would need to introduce some sort of rounding and user specified precision. If we did not, you may might be now posting a question about why 1.75 is not equal to 1.75 J I hardly every see people store invoice or account numbers as floating point, I would be interested to know why you made this choice. ...Show All

• Game Technologies: DirectX, XNA, XACT, etc. Newb question: different textures for different resolutions?

  Hi there, I've made a couple of games in GSE now, and in each case I programmed the game in 800 x 600, which is rather silly given that I have a monitor that supports resolutions all the way up to 2560x1600. I understand that I can get the user's window size and adjust my game to fit it at startup, though I haven't really played with that yet. But what about textures Is the best practice to include one texture for "maximum" resolution and then let Windows scale it down to size depending on the user's window size Or do developers include several copies of the same texture for different resolutions Likewise, I'm wondering how to handle different aspect ratios. To release a game that supports both 4:3 and "widescreen&q ...Show All

• SQL Server 'Default' NON_EMPTY_BEHAVIOR behavior...

  Hi, The below query returns 20 rows when run against our production DW. When the NON_EMPTY_BEHAVIOR is removed, it returns 10 rows. Note the lack of a member list on the N_E_B. Anyone else seen this, or have any ideas as to why it's causing me a 'problem' WITH MEMBER [Container].[Container Type].[AllCalc] AS [Container].[Container Type].[All], NON_EMPTY_BEHAVIOR ={} SELECT ([Measures].[Container Load Count]) ON COLUMNS , NON EMPTY [Trade].[Trade].&[EAST_AFRICA] * [Container].[Container Number].[All]. Children ON ROWS FROM [DW_SM] WHERE ( <various slicers>, [Container].[Container Type].[AllCalc] ) Thanks, Will. ...Show All

• Windows Forms Performance impact on use of this/me keyword

  The this/me keyword isn't required in many circumstances. Is there a performance advantage or disadvantage to using it when it's not required Gus No, it does not affect the performance in any way. Basically if you don't specify this/me the compiler will "autogenerate" it anyway. ...Show All

• Software Development for Windows Vista Trouble with the ManualScheduler service and delays

  Hi, so I have this workflow I've been working on for a few months. It's made of a few parralel branches (5), which look like this : picture The whole thing is hosted in an ASP.NET webservice (in its global.asax file). Along with the ManualScheduler service (with UseActiveTimers on), I'm running a persistence, tracking and data exchange service. And while I thought I did everything right (according to other posts here), expired delays still don't cause the workflow to fire up, so I always have to wait for the runtime to do something (ie : instaciate another workflow, send an event to a workflow, etc...) before anything happens... (this, I assume is what it is supposed to do without UseActiveTimers activated). I really hope ...Show All

• Windows Forms Slow performace when setting this.Text

  Hello, I was doing performance tests and noticed something wierd. Setting the this.Text property of my form takes 0,4sec upto 1sec! I have no idea where to look or what the reason of this might be. any ideas Regards, Aussie It would help if you could provide sample, compilable code that demonstrates what you're trying to do. -Tom Meschter Software Dev, Visual C# ...Show All

• SQL Server Using IN and LIKE together (multi-value startswith)

  I use Oracle as the database and my problem I faced occured on the Crystal Reports' to SSRS migration. We can select multi-value for our parameters and I declared the parameter in the pl/sql query as below. Let's say our available values in the list are: BIOS DBH ERPA GUNDEM IBRAHIMA We select BIOS and ERPA SELECT * FROM PROBLEM_TABLE WHERE CLOSED_BY IN (:paramclsby) There is no problem with that query, it queries the table with the field CLOSED_BY includes BIOS or ERPA. But there are also records the field contains starts with ERPA1, BIOS-AS etc I want to get these records but I cannot produce the query. In Crystal Reports, the Select Expert has expression; {PROBLEM_TABLE.CLOSED_BY} startswith ["ERPA&quo ...Show All

• SQL Server External access to SQL Server

  Hello, I'm not sure whether this is right section to post this. It seems the most relevant one to me. (Please point me in the right direction if it is not). I am a programmer/web developer for a medium sized organisation in the financial industry (in Australia). Obviously being in the finance industry, we have very strict guidelines and access when it comes to security. We are currently in the process of converting our website to use a SQL Server database (instead of MS Access which we have been using for years). In the past, we have accessed our web database via SFTP as it was only an Access file. Now that we are converting to SQL Server, we will still need access to our database (which is on a server hosted externally). It seems a ...Show All

• Visual Basic Where is Clear? How can I clear all checks in a checkLISTBOX with out a loop?

  Why did they get rid of clear. I have a checkbox with 50 items. I want the user to be able to reset the selected checked items to none. I need to be able to clear the selecteditems in a checkbox. Any ideas besides doing a loop Thanks Theresa I know this is probably way too late, just happened across the post, but have you tried the following: myCheckListBox.Items.Clear(); ...Show All

• Visual Studio Express Editions Keeping existing database files while installing a new version

  I made a program for a user that uses several database files that were included with the 1st deployment. I frequently install new versions of the program but every time I do that it overwrites any changes the user has made since the last deployment. I tried changing the publish settings so it would not include the database files during publish, but then when I installed the new version of the program on the users computer and ran the program, it gave a error message saying it couldn't find the database files. How do I install new versions without overwriting the user's database changes Right-click the database file in the Solution Explorer, and select Properties. Look for the "Copy to Output Directo ...Show All

• Visual Studio Tools for Office Integrating Active Directory & Excel

  Is there any way to integrate active directory with excel workbooks I want certain areas in my excel workbook restricted or totally unavailable based on a users' windows authenticated login. Would've been awesome if Excel had something analogous to website admisnitration in ASP.NET websites. There's nothing special in vSTo to support this. You might try asking in the excel.programming newsgroup . There may he some way using IRM (Information Rights Management). ...Show All

• Smart Device Development problem with pInvoke

  I'm developing an application for pocket pc 2003. I need to use a dll with exposed C function to connect to an external device. Edit: the framework is 2.0 System error codes and their descriptions can be found at http://msdn.microsoft.com/library/default.asp url=/library/en-us/debug/base/system_error_codes__0-499_.asp 6 is for ERROR_INVALID_HANDLE 87 is for ERROR_INVALID_PARAMETER So the error could be in the way you declared the types and invoking the function in managed code. ...Show All

• Game Technologies: DirectX, XNA, XACT, etc. No Starter Kit

  This is frustrating. In File, New Project I am only seeing "Windows Game Library (XNA)". I don't see the Spacewar starter kit or Windows Game (XNA). Once I realised it was supposed to be registered first, I did that and reinstalled. Same problem though, no starter kit. There should be a few templates. The XNA ones are Windows Game (XNA), Windows Game Library (XNA), and Spacewar Starter Kit. The Spacewar template files should be at: C:\Program Files\Microsoft Visual Studio 8\Common7\IDE\VCSExpress\ProjectTemplates\SpaceWar.zip or something like that. ...Show All

• Architecture Xml string compression?

  Looking for a way to compress a huge xml string. Xceedsoft has a compression library but should we really buy it just for that. Any suggestions will be appreciated. Thanks, Sailu Hi Friends, the below code can compress any kind of string. if u like this code u can use it... using System.IO.Compression; using System.Text; using System.IO; public static string Compress(string text) { byte[] buffer = Encoding.UTF8.GetBytes(text); MemoryStream ms = new MemoryStream(); using (GZipStream zip = new GZipStream(ms, CompressionMode.Compress, true)) { zip.Write(buffer, 0, buffer.Length); } ms.Position = 0; MemoryStream outStream = new MemoryStream(); byte[] compressed = new byte[ms.Len ...Show All

• Silverlight (formerly WPF/E) Linux support?

  Having support for Mac, Firefox, Opera and Safari is terrific news for WPF/E.  The elephant in the room though is Linux support.  If Linux were supported in the next CTP, this would be unstoppable.  --Oren Hi, I got the information from Microsoft Germany that Microsoft will listen to the developers and end users. If there is a big request on supporting Linux they will be very open to build a plug-in for Linux. My hope currently is that Windows Mobile will be the next that will get the plug-in. Michael ...Show All