amendez's Q&A profile

• SharePoint Products and Technologies Apprval workflow...

  Hi All, I have created a approval workflow and i have added approvers name as administrator,spuser1 and i have assighned the work flow to the test document.after that i have loged in to the sharepoint server as another user.when i want to open the test document without approving the document logedin user able to open and edit the document but it should display some type of message like "it is not yet approved by the administrator workflow is in process". is there any locking is available for the document when workflow is processing. please anybody can give the flow of the work flow and approval steps and workflow conifiguration. regards, Amar... ...Show All

• Visual Studio 2008 (Pre-release) Quick question, XAML to C#

  How do i write this in C# < Control Template = " {DynamicResource extrastuff} " /> That really ought to work. You might be having a timing issue of when you try to run SetResourceReference, if the resource is defined in the same page, in XAML. Loaded event handler is probably a good place to insert the code (alternatively, Initialized seemed OK, but I can't vouch whether that event is 100% timing safe for loading/setting a resource reference like that, I'd have to double check some things). In contrast, trying to do it with the partial class constructor would NOT work, because the resources aren't accessible yet. ...Show All

• SQL Server SQL Express in VC++ 6.0

  I apologize if I'm not posting this to the correct forum, please bear with me. I am a newbie to SQL Express. I am working with a product that was built back in the Borland days but was upgraded to Visual Studio C++ 6.0. I currently use mySQL, but need to upgrade to SQL Express 2005. Could anyone please tell me if it is possible to use SQL Express with VS C++6.0, or even point me to some documentation that would give me some light on the topic Many thanks! Hi Angie, Yes it's possible, you should be able to connect to the SQL Express database using the same method you currently connect to MySQL, only using a SQL Server connection string. Most people recommend http://www.connectionstrings.com to get ...Show All

• .NET Development Parsing a SQL query

  I am trying to parse a SQL select query. The idea is to pull out the field names in the query to use them in a lookup to get the units for each field. The problem is that I need to put units on the columns, but do not know in advance which fields are being queried. People can type in a free hand query using the field names, “as”, “sum(field)”, “count(field)”, etc. I am new to regular expressions. Has anyone done anything like this, or could point me to an example that I could use to get started Any help would be great. Thanks. David I have written a small parser which can parse out the column names from sql query. It may not work for some queries, but it do ...Show All

• SQL Server Stored

  I try to crate a STORED PROCEDURE whit this code. IF (( SELECT Count ( Id ) AS CountView FROM picx_opslagstavle ) > 2 ) SELECT TOP CountView * FROM picx_opslagstavle ORDER BY Id DESC GO my ide is if there are over 2 post in the database ist will delete all post where count is over 2 eks. post 1 post 2 post 3 post 4 post 5 so i will delete post 3,4,5 and not post 1 and 2 bot i can't find out of my problem. i hob i can be helpt here :) thanks for all help. Im done :) i get the problem here is the code IF (( SELECT Count ( Id ) FROM picx_opslagstavle ) > 20 ) BEGIN WHILE (( SELECT Count ( Id ) FROM picx_opslagstavle ) > 20 ) DELETE FROM ...Show All

• SQL Server Data Conversion Error on Excel Destination

  I am inserting rows using OLEDBDestination and want to redirect all error rows to EXCEL Destination. I have used Data Conversion Transformation to Convert all strings to Unicode string fields before sending it to Excel Destination. But its gives the following error. [Data Conversion [16]] Error: Data conversion failed while converting column 'A' (53) to column "Copy of A" (95). The conversion returned status value 8 and status text "DBSTATUS_UNAVAILABLE". [Data Conversion [16]] Error: The "output column "Copy of A" (95)" failed because error code 0xC020908E occurred, and the error row disposition on "output column "Copy of A" (95)" specifies failure on error. An error ...Show All

• Visual Studio Express Editions I have a Question

  When I open a link in a new window on my web browser, It opens it up with Internet Explorer. How can I tell it to open up new windows with itself, and not internet explorer Ok... If I try to open up a web page in a new window(With my custom built web browser) It opens up a new window with internet explorer. I want new windows to open up with my custom browser, not internet explorer ...Show All

• Visual Studio Report Body Column printing direction

  Halo, I've set the Body Columns & Width in the rdlc report. But it ends up printing the column from top -> down, then from left to right. Is it possible to print the body column start from left-> right, then only from top to down. e.g. My data is A,B,C,D,E,F,G,H... in sequence. I set the body columns to 4. I want it to print like A B C D E F G H I J .... Instead of A E I B F J C G .. D H .. ...Show All

• SQL Server Exclude duplicate records

  Hello I'm developing my fist Integration Service and I have this operations: Reading from a XML Check for duplicate records and discard them Insert the result into the database The XML I don't control and could came with duplicate records that I have to discard. How can I find them I want to find the duplicates in the XML and not in database. tkx for the help Paulo Aboim Pinto Odivelas - Portugal We have a SQL 2000 source and although we had a SQL 2005 staging database, we wanted to do this without staging data. This is what I ended up doing: Use a group by with a count(*) in the select statement to get data in to the pipeline. conditional split - split rows with count(*) > 1 (the duplicates ...Show All

• Visual Studio Tools for Office How to search for GlobalAppointmentID?

  Hi All, How do I search for AppointmentItem using GlobalAppointmentID There's not much info in MSDN docs on that. How global this ID Is it unique accross of all Calendars in the Exchange or just inside of a particular Calendar Thx... Alex Hello, Sorry - the link to the contacts folder search sample is http://msdn2.microsoft.com/en-us/library/ms269001(VS.80).aspx . Cheers ...Show All

• SQL Server LEAVES function causing problems in MDX Script

  Hello, Got a bit of a weird situation here and I'm having trouble fathoming it. I have a cube with a dimension called [Currency]. I have a MDX Script which contains the function call: LEAVES([Currency]) And up until this afternoon everything was getting processed fine. Since then I introduced a new measure group that does not include [Currency] and still everything is getting processed fine. I then added another measure group that, again, does not include [Currency]. I am now getting a processing error on my second new measure group: Leaves function for attributes with mixed granularity in different measure groups is not supported. I think I can kinda work out why I'm getting the error - its because the LEAVES function ...Show All

• Visual Basic Adding/removing dependencies at runtime?

  Is there any way to add or remove dependencies at runtime   I have a main app that references 4 other projects (class libraries), each of which reference other libraries.  Previously, each of the 4 modules were installed with every installation.  I am trying to modify the setup to allow installation of only specified modules along with the main app, since each of the modules are dependent of the others.  So I added dialogs and conditions to the .msi, and coded the main app so that it checks which modules are installed and disables any features which would require accessing the .dll's that weren't installed.  This works fine in debug mode within the IDE.  However, when I install and run the program without ...Show All

• Windows Forms URGENT HELP - PRINT

  C# - Windows Application (VS 2005) - OLEDB --------- Hi, I have a network printer IP: 1.2.3.4 shared name \\ns\admin_print$ I want to use a button within a form to print out the details of the form (data is from database). When I clicked the button, it will print straight to the designated printer. I do not want to have a print dialog to select printer. I do not know how to start with the code. Can someone advise private void PrintReport() { } What ahmedilyas said, and also. I wouldn't recommend printing to a networkshare/IP directly (and I'm not sure it's even possible in .net). What if the user/computer etc shouldn't have permissions to access that printer or the printer isn't ins ...Show All

• Visual Basic Question in adding item in ContextMenuStrip

  Hello I have two questions about ContextMenuStrip: 1- I want to add items by using code. But I want when I click on it, an action happens Look at this line: ContextMenuStrip1.Items.Add( "Close" ) I want when I click on Close, end the program using ( End ) How can I do it 2- How can add separator using code   Thanks I found this code and it works but I need someone tell how to work. I didn't understand how to work. Friend WithEvents nimenu As New ContextMenuStrip Private Sub Form1_Load( ByVal sender As System.Object, ByVal e As System.EventArgs) Handles MyBase .Load nimenu.Items.Add(CreateMenuItem( "Show" )) ...Show All

• Windows Forms runtime error while running the setup on vista

  Hi everybody, I am getting the following runtime error while running the setup on vista. If anybody has faced similar error, Pls help me. The error is as follows: Problem signature: Problem Event Name: APPCRASH Application Name: propglue.exe Application Version: 12.0.1.161 Application Timestamp: 452c8925 Fault Module Name: ntdll.dll Fault Module Version: 6.0.5744.16384 Fault Module Timestamp: 452358e5 Exception Code: c0150002 Exception Offset: 000089f3 OS Version: 6.0.5744.2.0.0.256.1 Locale ID: 1033 Additional Information 1: 9d13 Additional Information 2: 1abee00edb3fc1158f9ad6f44f0f6be8 Additional Information 3: 9d13 Additional Information 4: 1abee00edb3fc1158f9ad6f44f0f6be8 Read our privacy statement: http:// ...Show All