Ying06's Q&A profile

• SQL Server SQL Data in a hyperlink

  I was wondering if it would be possible to put report data in a hyperlink. For instance I have a report that pulls up a UPS tracking number and I want to be able to put it in the hyperlink to check the status from the UPS website. I.E. http://www.upstracking.com/myhsk <sql-data>jkhaskd I was put this expression = "http://<crm_server>/sfa/accts/edit.aspx id=" + Fields!accountid.Value but it doesn't work ...Show All

• SQL Server Combining established columns into one

  I have a table whose schema is already defined and populated with data. I would like to create a column named Name that combines the first and last name columns in the following format "last name, first name". I tried to create a formula that concatenated these two columns, but it kept spitting up on me. Any ideas Actually, splitting the name into it's constituent parts and storing it is the correct way. You can use a computed column or view with the computed expression or modify your SP to include the computed expression. With all these methods, you can get the required column for display purposes. But if you want to search on this concatenated string then it is a different deal. Performance dep ...Show All

• Visual FoxPro where condition too complex?

  Hi, Basically I have a where statement in my code that is similar to this: "where productcode in ('0001','0002','0003'.....'0020')" and Foxpro is telling me that the SQL code is too complex. The output file is an Excel file so I suppose I could just extract the particular product codes that I need in Excel but I was just wondering if there was a way to bypass this "SQL Code is too complex" conondrum and just grab the numerous product codes that I need. Thanks! :) Put the values you want to match in a cursor and JOIN that cursor in the query. That way, no matter how many are in the list, you won't ever bump against any limits. Tamar ...Show All

• Visual C++ Is there a macro which converts a 32 bit signed integer to 64 bit unsigned integer ?

  Hello All, Is there a macro which converts a 32 bit signed integer to 64 bit unsigned integer Thanks in Advance, CPPUser7 It doesn't matter that it's defined in 3 header files (all of which are probably included directly or indirectly) as all three define it the same way. So I don't see how you get a warning. ...Show All

• Visual Basic How to stop vs 2005 publishing vssver2.scc!

  How does one stop vs 2005 publishing the hidden system file vssver2.scc! Is this just broken, or is there a work around to stop vs 2005 spublishing this unwanted file.. Thanks. hi, I got the solution from ur windows browser click Tools --> folder option and then click on view tab and uncheck option Hide protected operating system files. now u will be able to search *.scc files and then u can also delete them from ur local work location if required. ...Show All

• Visual Studio Team System error whyle tryng to export to excel

  When i try to export a report with a Matrix i get this error: Hi there, Checkout the SQL Reporting Services forum: http://forums.microsoft.com/MSDN/ShowForum.aspx ForumID=82&SiteID=1 they should be able to help you. Mauli ...Show All

• Windows Forms Is there any property to keep a form on top but within an application?

  Top Most property of the form keeps the form on top of everything that's running. I want to keep a form on top but only within my application. Is there any easy way to that I know if a form got the focus from form_actiavted event. How can i know if my applciation got the focus. Regards Mani lol, you're funny. If your program window has focus, its obviously already above all the other applications. (Unless they have their TopMost property set to true.). You already have your solution. When your program has focus, its above everything else because "focus" means the program window that the user is currently using. When your program does not have focus, the user is using another program, and yours is inactive. If you want your p ...Show All

• SQL Server navigate to another target

  Hello, I have an html page which has a frameset with two frames named: "reportFrame" and "browserFrame". the "reportFrame" is an aspx page which contains a reportViewer opening a report which has a table. I want from this table's rows to navigate to a url, but that the new url will be opened in the "browserFrame" frame. If I use the textbox properties->Navigation->Jump to URL, the parameter which is passed there is the soure of the new url. the question is if there is any option to pass also the target, something like: target="secondFrame" Thanks a lot, Talia. talia, Would you please tell me how did you resolve it I am encounteri ...Show All

• Visual Studio 2008 (Pre-release) Best Way To Animate Image Sequence

  What is the best way to animate a sequence of PNGs so that it plays consistently smooth Currently I am preloading the images into a BitmapImage array during app startup and I am also both applying caching and setting scale quality to low: //inside a loop bitmap = new BitmapImage(); bitmap.BeginInit(); bitmap.UriSource = new Uri(@"pack://application:,,/Images/img" + i + ".png"); bitmap.CacheOption = BitmapCacheOption.OnLoad; bitmap.EndInit(); BitmapImageArray[ i ] = bitmap; RenderOptions.SetBitmapScalingMode(BitmapImageArray[ i ], BitmapScalingMode.LowQuality); I set the Source proprty of an Image object to the desired BitmapImage within a CompositionTarget.Rendering callback. On Vista RTM the animation doesn't ...Show All

• Visual C++ Why CView derived classes don't support WS_TABSTOP ?

  Dear VC team and all : The problem is here : I created a SDI project with VS2005 MFC wizard named "Test",and a CView derived class called "CTestView" was created automately by MFC wizard,then I created controls dynamicly using "Create" function and "WS_TABSTOP" style was specified,but no use at all,the controls created dynamicly didn't pay attention to the "TAB" key in keyboard any more ! To solve the problem, I changed "CTestView" base class from "CView" to "CFormView", and then the style "WS_TABSTOP" came to work ! I just wonder to konw how did this happen Can anyone tell me Thanks ! Tab key is handled by IsD ...Show All

• Visual C# c# books

  i have just started programming in c# plz tell me site for good ebooks for c# C# Web Development with ASP.NET: Visual QuickStart Guide Visual C# .NET Programming Data Structures and Algorithms with Object-Oriented Design Patterns in C# C#.net Web Developer's Guide (With CD-ROM) .NET Compact Framework Programming with C# (Microsoft Net Development Series) Programming C#, Fourth Edition Essential ASP.NET with Examples in C# C# and VB .NET Conversion Pocket Reference Distributed .NET Programming in C# Visual C# 2005: A Developer's Notebook Visual C#: .Net Developer's Handbook with CDROM Microsoft C# Language Specifications C#: A Programmer's Introduction C# Primer: A Practical Approach C# Cookbook Microsoft Visual C# .NET ...Show All

• .NET Development How Do I Load MySQL DB Data

  I have an account at godaddy.com that provides .NET2 and mysql databases. I am trying to learn Visual Studio 2005. I have setup my project localy and publish the website to godaddy.com. I would like to connect to the db, download the data, and add to grid control on form load. I cannot find any way to do this without having the database local. Is there a way to do this See the below forum post. It looks like there is a solution for this problem: http://forums.asp.net/thread/1314486.aspx ...Show All

• Visual C++ _beginthread error

  Hi all. How come i get the error that i _beginthread is a undeclared identifier When i clearly have #include <process.h> This is strange. Im using the VC++ 6 compiler and MS 2003 SDK - i hope these arnt the problems. Thanx in advance. Simple Samples wrote: You really can solve this problem yourself. ...Show All

• Microsoft ISV Community Center Forums VBA Excel Module opening Access DB with Recordset

  Here is the code: Dim cConn As ADODB.Connection Dim rs As ADODB.Recordset Dim sSql As String sSql = "SELECT Table1.Field1,Table1.Field2, Table1.Field3 FROM Table1 WHERE Table1.Field4 = Yes" Set cConn = New ADODB.Connection Set rs = New ADODB.Recordset cConn.Open "Provider=Microsoft.Jet.OLEDB.4.0;Data Source='\\path\files\folder\database.mdb'" Set rs = New ADODB.Recordset rs.Open sSql, cConn I get the same error on the rs.Open statement every time: "Run-time Error '-2147217904 (80040e10)' No value given for one or more required parameters" Any thoughts Thanks, J Hi, That was my initial thought that your connection string was off but if it were then the error wou ...Show All

• Software Development for Windows Vista frame grabbing via directShow for windows mobile

  Can anyone tell me what directShow filter would help me grab frames from a video being captured by a phone camera I use the windows mobile for pocket PC SDK for development. I heard that SampleGrabber is the standard filter used but I cannot find it in the above SDK. Is there an alternative someone has provided this on the net. It seems to be a template which can create a transform filter. But how can I retreive the frame buffer from the filter-graph into my application http://www.ifp.uiuc.edu/~chenyq/research/Utils/DShowFilterWiz/DShowFilterWiz.html ...Show All