ZhangQing's Q&A profile

• SQL Server Instead of insert trigger on view containing identity column

  I have an 'instead of insert ' trigger an a view containing multiple tables, one of the table-columns i use within the view is an identity-column. Trying to do an insert into query on the view without the identity-column (funcid) results in: insert into passw_functie (userid, functie, dienst, niveau) values(1, 'AGT', '6609', 1) Server: Msg 233, Level 16, State 2, Line 1 The column 'funcid' in table 'passw_functie' cannot be null. ...Show All

• Microsoft ISV Community Center Forums VB in Excel Macros versus VB Express

  In working with Excel in Office 2003 I see that macros have the title "Microsoft Visual Basic" Which version of Visual Basic is this Also, is this Visual Basic a fully featured one more so than the Visual Basic Express 2005 edition that is available for download free I am asking because I am finding that the transfer from VBE 2005 to Visual Basic in Excel is not that straightforward. ...Show All

• Visual Studio Express Editions Express Edition Release Candidates

  Hello Will there be any Visual Studio Express Edition Release Candidates and when will they be available Also if you could make them available to the general public not just subscribers that would be great. thanks Jason D. Somewhere, they are available. Someone from MSDN blogs was giving a link and I actually downloaded and installed. Then I switched back to Beta2 and now don't find the download link anymore :/ ...Show All

• Microsoft ISV Community Center Forums Problem with CWnd::RunModalLoop(DWORD dwFlags) in wincore.cpp

  Hello, We have created a VC++ application that has 2 menu options. - submenu 1 opens the VBA IDE - submenu 2 opens a Modal Dialog to execute a functionality (say FUNC1) Whenever we directly select submenu 2 the application executes properly. But the application hangs whenever we select submenu 1 (opening the VBA IDE) and then select submenu 2 (having the VBA IDE still open) On debugging we find that in the problematic c ...Show All

• SQL Server file attribute using a control

  I have managed to capture the file path through some SSIS tasks. Now I am looking to read get the File Name present for a file in this path. How can I possibly do this Do I have to use the script task and write something up in VB.NET Hope there is an easier way out. I have been trying to figure out the File SYstem task. But that seems really complicated as well. Please let me know. This is an emergency for a special DEMO. Thank you!!! ...Show All

• SQL Server Connecting To SQLExpress From a VB Console Application

  I've been reading through the forums and I have seen that I am not the only person to have trouble simply trying to connect to a database from VB. Firstly I have created a console application, and from within that application I have created a simple 1 table database and added two rows of data. So I now the database is there and working. Problem is I keep getting the following error which trying to apply a connection string to an SQLConnection ob ...Show All

• SQL Server How to use ODBC SQLSetConnectAttr from C# ?

  Hi, I'm having problems dealing with some large datatypes in a C# application using odbc. Basically certain datatypes, such as db2 CLOB, are not recognized as 'valid' by the odbc driver. It seems the fix is to use the SQLSetConnectAttr function using the appropriate key/value pair to 'map' those to datatypes known to ODBC but I'm not sure how to use it in C# code. The template seems to be more an unmanaged C type API with handles being ...Show All

• SQL Server Huge issue with the Lookup problem

  Hi, I have Script Component in the Transformation phase that returns me values like NO, OTH, OWN (comma separated string coded value) Now I want to use the Lookup component (preferably or any other task really) to get the description by looking up a table in another database. So eventually my string needs to look something like this None, Other, Owned (comma separated string decoded value) I tried using the Script component again to do this, but ...Show All

• Visual Basic add Data connection in VS server explorer

  hi everyone, I'm new to .net programming and to VisualStudio. I installed VisualStudio 2005 Beta 2 and SQL server Express on my PC and created Pubs database for my exercise using a script downloaded from MSDN site. Then I tried to add a new Data connection in VS Server Explorer. choose SQL server as my Data source and enter {machine-name}\SQLEXPRESS as my server name and tried to testConnection. I got an alert -"timeout expired ......server ...Show All

• Visual Studio Express Editions Printing from VB Express

  I have come across several posts indicating that it is nearly impossible to print documents, much less interact with Word, when using Visual Basic Express. Is this true If so, will this functionality ever be included or will I have to either purchase Visual Studio or learn another language While not impossible to print in VB 2005 ( this includes the Express Edition too) it takes a bit of work to get the result ...Show All

• SQL Server SQL Server CE problem

  i want to verify whether my Pocket PC emulator can communicate with my desktop computer using HTTP....i use IE (desktop) to browse the sscesa20.dll file...it pop up a message for me to save that file..I think my desktop is working well for connecting to my sscesa20.dll However, i use my Pocket PC emulator to browse the sscesa20.dll file using the same URL address...it can't work at all. It prompting message ask me to do the connection setting fo ...Show All

• Visual C++ static initialisation order

  Is it possible to call a global object inside another global object constructor There are techniques which can make this happen(like construct-on first use).But can it work without these techniques I would like to know if the following code make sense which is in an MFC App in constants.h const CString BLANK = ""; in CApp.cpp #include constants.h CApp myApp;//CApp is the MFC global application class CApp::CApp() { m_St ...Show All

• Windows Forms Big Problem, I think it's bug

  -VS2005 RC -Framework 2.0 release When I close a form with bindining datasource on it, I have this error.   An unhandled exception of type 'System.ArgumentException' occurred in System.Windows.Forms.dll Additional information: Sort string contains a property that is not in the IBindingList. Yes,I have the same problem. It only happened on my first table in my DataSet. If I remove the sorting string,the problem disappeared ...Show All

• .NET Development Updating (Refreshing) Dataset Source Info

  All, Can someone send me a clue on how to update a DataSet in visual studio 2005 after making changes to the stored procedure it is attached to (adding new fields, etc) There seems to be no way to do this that I can find without completing deleting it and starting over. Em, help. Joseph Just so it's clear...It's not the data records I am trying to refresh, it's the connection itself. As mentioned, I am u ...Show All

• Visual Studio Express Editions custom controls in C# express?

  aloha! i have this book on C# programming (windows forms programming in C# by chris sells), and it discusses custom controls. i wanted to make such a custom control with C# express beta 2, but i didn't manage :-( the book says: "in VS.NET, if you right-click on your project in solution explorer and choose Add - Add New Item - Custom Control, you'll get the following skeleton:" when i do this right-click in C# express, i don't get the option to ...Show All