vbtheo's Q&A profile

• SQL Server Reporting Services Count

  Hi All, I am trying to compare two dates: actual shipping date > promise shipping date. If the sctual shipping date is greater that the promised shipping date than count that order number if not than it is null. This is in the report designer in the "edit expression" =Count(iif(Fields!act_shp_dt.Value > Fields!prm_shp_dt.Value, Fields!ord_nbr.Value, "")) It is counting everything as true. Can anyone help me.   Thanks, Kerrie Kerrie - did this work for you - I am trying a very similar thing but when I use martins solution I get compilation errors. I have tried using a hidden field to show a 1 against exh record if condition is true  - then I try to do a simple count on this field but RS will only allow m ...Show All

• Smart Device Development Arabic Characters on PPC 2003 Emulator ...

  Hi, I've wrote some functions and tools for displaying arabic words on ppc device ... Now, I want to know is it possible to displaying arabic words on ppc Emulator ! I Simply copied the font that i wanted to work with it on Emulator but i just can see Squares on screen !! Is it possible ! If Yes so what's my wrong ! Regards, Hadi Dear Hadi, Could you kindly let me know if the issue mentioned in this thread was resolved, if yes how was it. I'm struck in a similar situation. TIA, Siraj ...Show All

• Visual C# How to Find the Duplicate Values in ArrayList

  Hi every body I have an ArrayList contains thousands of strings. How can I find the duplicate itmes in this array list Thanks one obvious way would be to iterate through each item, check to see if an item exists, store it locally in a bool value for example, if it finds it again during the foreach loop, then you know you have a duplicate. Example: bool found = false; foreach(string currentItem in theArrayList) { if (currentItem.Equals(" value ")) { if (!found) { found = true; } else { MessageBox.Show("Duplicate found"); } } } obviously not a good way as you could have alot of items to get through. othe ...Show All

• SQL Server What instead of "select" trigger?

  There are acting: MS SQL Server 2000 + SP4 OrCAD Capture CIS Capture CIS can read data from tables or views via ODBC. I'd created a view for this purpose, but now I want to implement logging: who had selected the data from view and when he did it the last time. Several difficulties arised: There are no triggers for SELECT in MSSQL Server I can call user defined function in a view, but can't write anything to user defined tables and can't call getdate() within my function Calling extended stored procedures is an excessively complicated way Our system administrator doesn't allow the existence of extended stored procedures on the server Any reasonable suggestions ...Show All

• Visual Studio Express Editions VB Express will not install

  Platform XP Pro v5.1 2600 sp2 I have tried for a while to install VBE , no luck, it just locks up. I have the D/loaded VBsetup.exe file (a couple of times) (2.89K) and when it runs the counter reaches about 90% install and just sits there, no err msgs, the system just hangs with the exe file grabbing all the sys resourses. I did run the clean down file, But I have not had Net 2 installed, etc. Any ideas please Dave dcterrill@hotmail.com Hi, try downloading an installing the complete .iso/.img image. You will finde it here: http://msdn.microsoft.com/vstudio/express/support/install/ ...Show All

• Visual Studio Express Editions Restore from System Tray - Two EXE's Interacting

  Hi everyone       I am new to the forum please be nice, also fairly new to programming in VB. I am currently looking for a solution to this odd procedure I need. I have a Program that I scripted in VB 05 .net that runs perfectly its a simple program that loads up a form that has three buttons one button hide the form and loads up the next form another button just hides the form and the last button quits the program. With this first form it also has a system try icon that when double clicked opens the form back up or if right clicked provides the same options that are on the form. Now I have explained this heres the second part, I have another EXE programmed in VB that when opened it checks to see if thi ...Show All

• SQL Server Need example of a "Hash" function.....

  Many articles on sql server security make reference to Hash functions. Do you know of a simple example of a hash function that I could show to others For example, would taking the first eight bytes of the mathematical "sin" of a number be a good function I don't know. Or is a hash "function" actually an involved algorithm, so the "simple" formula I was looking for really doesn't exist. TIA, Barkingdog In SQL Server 2005 we have a new builtin to calculate hash functions: HashBytes. For more details on this builtin I recommend consulting BOL ( http://msdn2.microsoft.com/en-us/library/ms174415.aspx ), but here is a short example: SELECT HashBytes ...Show All

• Smart Device Development C# Pocket PC Application With Sql Server Mobile

  Hi, I am absolutely new to Smart Device Application programming. I want to make my application work with Sql Server Mobile. I have been through a lot of links and very confused. I need some guidance from the expert on how to start with it. Development environment in use: 1. Windows 2000 Server 2. C# .NET 2005 3. Sql Server 2000 I have already tried a basic 2 forms application and tested it on a Smart Phone and i-mate JASJAR , and found the application working properly. My questions are as follows: 1. How to use my application so that I can connect to Sql Server Mobile 2. Do I have to install Sql Server Mobile on my development computer 3. If so from where will I download it Doesn't .NET Studio comes with its own Mobile Database 4. How ...Show All

• Visual Basic Help - cant refresh rows in datagridview!

  Im struggling to refresh my datagrid after updating its datasource from a different form. On Double click of the datagrid a new form is opened to edit the record, once the details in the form have been changed I need to get the datagrid to refresh and show the new detaisl(either a new row or changed record). I know the database has been changed but it will not reflect in the datagrid(note I have tried datagrid.refresh), I have also tried calling the sub which populates the datagrid but with no luck. Any ideas OK the key here is to providing the child form with a reference to the first. The code example here simply uses a button to initate the call to the second form but this is in essence what you dou ...Show All

• Visual Studio Team System Getting build path from BuildStore?

  I am currently using the GetListOfBuilds method from the BuildStore class. I do know the buildtype to pass in. However, I'm trying to find if there is any way to ascertain which path the buildtype currently points to. We have a list of builds by product name and by environment. So, one of our buildstypes is named something like MyProduct_Dev (build for MyProduct for the Dev branch - whatever it is currently). As we create a new branch I edit the workspacemapping file to point to the new branch. This mapped path is what I'd like to be able to extract for a given build type. Can this be done via the API Thanks in advance. You can't do it directly from the build API in version 1. You need to use the VersionControlServer object to get ...Show All

• SQL Server How to get DBName, IP, Domain Name, Data Path and stop services

  How can I get dbname ip domain name Data path using TSQL. how can I stop services using TSQL Emad If you are using sql server 2005 you can use the dynamic management view sys.dm_exec_connections. ( http://msdn2.microsoft.com/en-us/library/ms181509.aspx ). Run select * from sys.dm_exec_connections to get the ip of the both the server and the connecting host. By Dath path if you mean the path for the database files , you can use the catalog view sys.master_files. select * from sys.master_files. ...Show All

• Visual C++ Windows related Question (Concerning VC++)

  Hi all, I was wondering if someone could help me with the following problem that is occuring. The thing is that every now and again a computer of mine, gives a message that the computer has run out of resources. So the thing is, is there any way I can handle such an event in VC++. When I try to connect to that PC throught PC Anywhere, I can't because of this message. Can anyone help Thank you in advance Hi, I guess the message should also go into the system event log as "Application Popup". You might try to write a service monitoring for the occurence of this event. I think the message of the message box is included in the event log entry data. Have a look at the API NotifyC ...Show All

• Visual Basic Setting Dataview Rowfilter or Sort has no effect

  I have a really weird problem in my code. I have the following piece of code. Dim MyDS As DataSet = dsOrder.Copy Dim dvOrderJOT As New DataView dvOrderJOT = MyDS.Tables(1).DefaultView 'Point 1 dvOrderJOT.RowFilter = "ItemLogistics=2" dvOrderJOT.Sort = "ItemSupplier" After Point 1, the dvOrderJOT has 3 rows, two of them has ItemLogistics as 2, one has it as 1 (this is an integer field). After the RowFilter is executed on the following row, the dvOrderJOT still has the same 3 rows. How on earth is that possible I've used the same technique elsewhere in my App with great success, although then the dataview was bound to a Datagrid and the filter was set on a string field. How could I debug ...Show All

• Visual Studio Adding Snippets to toolbar in VS 2005

  I have a number of snippets which I would like to run from a custom toolbar in Visual Studio 2005. These snippets are "Surround With..." and are used for web site editing. My goal is to reduce the steps as follows: Currently: · Select text for a surround · Right click and select "Surround With.." from menu · Open folder with my custom snippets · Select and double click on a selected snippet – adds surround tagging Would like to: · Select text for a surround · Click on icon in toolbar to add snippet tagging Is there any way to create a custom toolbar that consists of my custom snippets I am ...Show All

• Windows Forms Microsoft SQL Server (SqlClient) connection for Visual basic

  why when i try to add a datasource in visual basic 2005 the option for Microsoft SQL Server (SqlClient) is no show...only for Microsoft SQL databasefile Help please In VB Express you can only add a datasource to an mdf or access database. The feature which allows you to connect to an existing sql server database is not available. You can still bind to the database with code. ...Show All