A tawil's Q&A profile
SQL Server Schema changes after Replication
I see from help books that table changes are not allowed using Enterprise Mgr. after a publication exists. The only way to make db changes is to use T-SQL. I found the correct sp to make changes below. I am using sp_repladdcolumn <tablename>,<columnname>,<datatype(25)> sp_repladdcolumn does not allow datatype length to be supplied. Result defaults to 1 and sets to NULL. I need a variable length on my datatype. Is th ...Show All
Microsoft ISV Community Center Forums reportbuilder
Hi all, I have seen forms in databases where users select from unbound fields and click a button that would give them a report based on their selections. Here's is the code but it give me an error "object required" Private Sub cmdPreview_Click() On Error GoTo Err_cmdPreview_Click Dim strSQL As String Dim strnewQuery As String strSQL = strSQL & "[" & ctl.Name & "] " & " like " ...Show All
Architecture UI Frameworks
Hi, Wondering if anyone can point to some good UI frameworks. I've looked at the Composite UI Application Block and the UI Process Application Block. Just wondering if anyone knows of others that might be worth investigating. I'm primarily interested in this for use with Windows Forms, not ASP.NET Thanks, Matt Are you talking about Smart Client frameworks, or just those dealing with the visual as ...Show All
.NET Development License of the code that disassembled from .Net framework?
Hi all, After disassembling the code of .Net framework using Reflector , I found out some useful classes that I want to use in my own project. Because most of those classes are "Internal" or "Sealed" that I can't inherite directly. So, may I do that Do I break some laws Or what should I do After that I can put those source code in my application. Thank you very much. Regards, Bill ...Show All
SQL Server Data Access Differences in SQL Server 2005
Hello, We have a large set of applications that we developed and build for use with Borland InterBase (5.x-7.x). We have moved/migrated off of Borland InterBase to MS SQL Server 2005. We are find some situations where InterBase was an more elegant solution and finding it difficult to find the right way to change our applications to achieve the same result. In InterBase, our Database Transactions allowed our user to make changes to the DB ...Show All
SQL Server display filter info in Report Builder
hi all, is it possible to display the value of filter on the report (Report Builder) instead of displaying Filter: Productions with: All of (Month in (prompted)) which is not informative. thanks ! This is not supported by the auto-generated filter descriptions. However, a workaround is described here: http://blogs.msdn.com/bobmeyers/archive/2006/03/26/561147.aspx ...Show All
Visual C++ '/MT' and '/clr' command-line options are incompatible
I've just started using VC++ 2005 Express. I was watching live meeting demo and writing the code example with Bray. This was a very simple hello world app. I set the project options per his directions but I get this error: '/MT' and '/clr' command-line options are incompatible Any ideas Why is that so I'm writing a custom action for my installer, and I've found the re-distribution of vcredist_x86.exe to be ...Show All
Visual Studio Team System another TF30177: Team Project Creation Failed
Hi After making a clean install of Beta 3 refresh I’ve been getting the following error when trying to create a project named 'p': Error TF30170: The plugin Microsoft.ProjectCreationWizard.WorkItemTracking failed during task WITs from group WorkItemTracking. Explanation Plugin error text: “TF24016: Cannot find team project 'p'.” User Action Contact your Team Foundation Server administrator. Warning TF30144: The New Team P ...Show All
Visual Studio Express Editions Q: URI datatype in DataSet
hi, How can i set a constraint to a column in my dataset as URI , what i know is that dataset is XSD file, and xsd has a datatype xs:anyURI, but i didn't find this datatype in the dataset datatypes ,is there any idea if that is not possible or not recommended how can i make constraint for textbox entery to be a valid uri or to convert the text that the user entered to uri will be thxfull for any help thx, fox after lo ...Show All
SQL Server Installing SQL2005 causes program hangs when executing MSXML2 DOM clonenode method
Hi, I have a problem after installing SQL2005 on my laptop. Here is the scenario. The program loads an Xml file using MSXML4.0 DOM, then create a new DOM with clonenode method. This senario works fine before inatlling SQL2005. Now it hangs for about 5 minutes then continues; And I found two msiexec.exe running in Window task manager whenever I runs thr program. The following code can reproduce the problem. private void TestCloneNod ...Show All
Visual Studio Express Editions How can I Call the GetVolumeInformation API ?
Hello, I try to call the GetVolumeInformation API but the function returns zero and the GetLastError function returns the 1450 error code (Insufficient system resources exist to complete the requested service). What does it mean I think I can't use another solution because the GetVolumeInformation API is the only one which returns the serial number of a volume. My code is the following : Imports System.Runtime.InteropServices ...Show All
Visual Basic DataGrid Cell Value ???
Dear Team i want to capture the Pk value into a variable taken from textbox to put it in a certain Cell in a datagrid its width = 0 cause it is a forign key Dear Man this point is very important I am realy thank you very much for your help....and i hope to be Patient with me ......i tried to use the code but i discuverd that i need a certain cell like & ...Show All
Visual C++ Error 1 error LNK2022: metadata operation failed (80131187) : Inconsistent method declarations in duplicated types (types: DayPl
I am getting this error when I try to compile my project. Can anyone translate this into something I can understand Error 1 error LNK2022: metadata operation failed (80131187) : Inconsistent method declarations in duplicated types (types: DayPlanner.frmNewProject; methods: txtEstimatedHours_KeyPress): (0x06000321). DayPlanner.obj Thanks very much -Bryan St. Amour Try putting Code Snippet #p ...Show All
SQL Server Express Manager download for RTM version of SQLServer Express
Has MS updated the Express Manager tool for the RTM version of SQLServer Express It's a great tool and not having it causes so much pain (I have to use the command line tools!). Thanks in advance! I tried to install the client tools from SQL Server 2005 developer edition but the installer for this (after downloading another 2.8GB!) says components are already installed and cannot be upgraded (or message similar t ...Show All
Visual Studio Express Editions Making an app look like a Windows XP app
I am currently porting a VB5 app to VB2K5. I have installed VB2K5EE at home. I am trying to do the basic menu/toolbar. The trouble is that I can't seem to make those two look like regular Windows XP menu/toolbar. I.E. I look at the MSPaint and Wordpad menus and I can't make the menus in VB2K5 look and act the same. I can select System in the RenderMode property but it looks like a default Windows XP menu bar but acts like a Office2K3 menu. ...Show All
