DB007's Q&A profile
SQL Server Simple Format() question date/time (offset from Greenwich time)....
All-- This is the expression I am using to display the date and time my report was executed: Format( "MMMM d yyyy h:mm:ss T" , Globals!ExecutionTime ) This works fine. However, I would like to be able to get the offset in hours from Greenwich Mean Time, as various consumers of these reports are scattered across the U.S. (and four time zones). The documentation for the Format() function mentions that appending the string 'z' to the user-defined format expression will force the GMT offset to appear. Well, guess what, it doesn't work for me. Anybody have any experience with this working (or not working, as the case may be... ) TIA, mattyseltz ...Show All
Visual C# How do you define a method with optional parameter
Hi, I know that there is no optional parameter in C#. but I need it!!! I need to add parameter to a method but I can't change it's signature. The method was already written in an API that was delivered for many customers. So changing the calling to the method (Adding the parameter to the calling) is impossible. Any suggestions thanks, Eitan you could create another method, same method name, just different parameters and call that. Example: public Foo() { ... } public Foo(string param1) {...} public Foo(string param1, string param2) {...} would this be ok for your solution as long as you don't have the same signatures (same parameters which are identical to a diff ...Show All
SQL Server Format Masking for creating leading periods
Is there an elegant way to fill the empty space leading a textbox in a table with periods, similar to a table of contents effect When I do not allow the textbox to grow and just append a long string of periods it looks fine in my report preview, but after I deploy everything appended after the primary field in that text box is missing My report has a lot of data to the right but it is collapsible so the fields to the left are a good distance away. This is why I am trying to include light visual aids that assist lining up data values. I am not stuck on the leading period idea but it seems the least cluttered. Aaron Hello Aaron, Can you try something like this in your field's expression: =St ...Show All
.NET Development Generic performance... benefit?
Hi, in every article about generics is written that they improve performance because no boxing, etc. occurs. So I wrote this simple test code and was astonished that the non generic part actually performs a couple milliseconds faster than the generic part About 59.8 seconds for the generic and 59.1 seconds for the non generic (avg. of 10 runs). Am I missing something here [code] using System; using System.Collections.Generic; using System.Text; using System.Xml; using System.Collections; namespace ConsoleApplication6 { class Program { static void Main(string[] args) { string s = ""; Test<string> test = new Test<string>("hi"); DateTime start = DateTime.Now; for (int j = 0; j < 1000000; j++) { foreac ...Show All
Visual Basic Type Mismatch
Hi, This is Function definition in VB6 Application (DLL) Public Function Main(ByVal Num As String, ByVal AcctNO As String, ByVal ChannelIn As String,ByVal CFlag As String, Optional ByVal PIn As String, Optional ByVal AccountArray As Variant,Optional ByRef MaxAvail As Double, Optional ByRef MinAvail As Double,Optional ByRef EscAmt As Double, Optional ByRef BipArray As Variant,Optional ByRef ErrCode As String, Optional ByRef InterestRate As Double,Optional ByRef SurchargeRate As Double, Optional ByRef SurChargeAmt As Double) As String I created a VB.net project (Visual Studio 2005) and add reference to VB6 DLL. In Button Click , i wrote. xyz = abc.Main(ID, "", "Some", StrChan,StrFlag, "", , "&qu ...Show All
Visual Basic Validating a date in a DataRow
Hi there, I have a date in a datatable which has been populated from an excel worksheet. Then scan the Datatable and validate each of the rows/columns as the data will be imported into the database. This is all fine with the exception of the date checking my code is below:- 'I've already populated the datatable etc then---->>> Public DataError As String = "#Bad Value#" Dim dt As DataTable = ds.Tables(0) For Each row As DataRow In dt.Rows If IsDate(row(5).ToString) Then DOB = row(5).ToString Else DOB = DataError End If Next row I've also tried:- If IsDate("#" & row(5).ToString & "#") Then and still no luck.... Can anyone out the ...Show All
Internet Explorer Development popup menu problem using IE7
I am having problems with my CSS pop up menu after I loaded IE7. I have a menu item that has a dash(-) in the title and for some reason IE7 shifts the text after the dash. Does anyone know a fix for this. You can view my website at: www.streambox.com It is under the product menu at the top. I can not find anything written about this problem. Can anyone help Replace " - " with − and it will work. If you have any other solution please let us know. ...Show All
Visual Basic textbox visible priority set to "false" will not keep value
Hi, This should be simple to do but I just can't figure how to fix the problem. I have a form with one master table and 20 other tables showing related data. The data is linked by the key value in the master form. For example, I have a "Long_Desc" variable in the master table which holds the ky value for the descriptions I keep in the "descriptions" table. Maybe I am doing this wrong but I in my test, I was displaying the content of the key "Long_Desc" in a read-only TextBox just to make sure I was getting the right record from the "descriptions" table. I could also display the content of the "Long_Desc" TextBox using a messagebox. Now, I would like to hide the the "Long_Desc" field on the form. I set the "ReadOnly" priority to True and "T ...Show All
Windows Forms Get the parent Control object...
I have a non-visual class like (avalible in the toolbox) public class MyClass: Component { public MyClass() {...} } In this class I have some asyncronus external events that needs to be syncronized with the "main - gui - thread" that consumes events from "MyClass"... Before I made a "toolbox" component of "MyClass" I hade a constructor like public class MyClass: Component { public MyClass(Control parent) {...} } This way I had the "parent" object to sync with... But using MyClass as a component in the "toolbox" forces me to have a constructor without any parameters... I need to get hold of the parents "Control - object" inside of "MyClass". How ca ...Show All
Visual FoxPro Guidance Required for VFP - MSSQL upgradation...
Hi all, I've developed a VFP application in vers. 6.0. Now that the client wants the same with MS SQL / Oracle. Please someone tell me the list of atricles and other notes i've to go through..... I'm ok with SQL querries.... Please suggest me regarding the -Remote views, SPT's...... The application as a whole has about 2 GB of data in VFP..... It's a multi-user application....running on VFP 6.0 ./ WIn2000 Platform. Thanks in advance... -Markish Markish, Even within VFP rlock() approach is not very good IMHO. Your application's needs would really shape it. Once I posted a sample code on universalthread demonstrating "rlock" for VFP/MSSQL table in asp.net. ...Show All
Visual Basic Drawing a line
How do I get a line drawing object into my toolbar S_DS, There are a couple problems with this code that I want to point out. Don't get me wrong, you've got some good examples of the math involved with plotting shapes by points (as opposed to drawing the shapes with the appropriate method). But there are some issues with the way you do the drawing itself. Number one is that you're using the CreateGraphics method of the picturebox to do your drawing. This is not desirable becuase any time the PictureBox is repainted, your drawing is lost. For any GDI drawing to be permanent it must be done either in response to the control's Paint event, or better yet, in an override of the co ...Show All
.NET Development Synchronization issue in System.Array
Hi, Currently I am working with System.Array class and I am having problem with Array synchronization using SyncRoot property. Basically I want to make sure that if my array is locked, no other threads are allowed to changed my array. In my code, the locked array is intArray and the thread I used to change the value of intArray is changeArray Delegate. It seems to me that the intArray is not actually locked because the thread could change the array value even though it is in the locked block. Below is my code //Start of code private delegate void changeArray ( int [] a); static void Change( int [] a) { a[1] = 100; } static void Main( string [] args) { int [] intArray = { 1, 6, 8, 3 }; ...Show All
SQL Server Unable to add Securables to a DB Role
Hi All, I am having problems with a sql server 2005 database. Basic information on the setup, I have two windows user groups, admin and users. These both have logins to the sql server 2005 which are using Windows Auth. They in turn are users inside a database. In the database, there is one Schema that has been used to create all the data tables, stored procs. This was all done back in sql server 2000 days. Now, I have created two roles (one Admin, one Users) and want to add Securables to each of these roles. Essentially, the Admin will have access to all the secureables (except tables - but all stored procs) - and the Users will have access to stored procs that Get data (ie: No updates, deletes, adds). When I add these secureab ...Show All
SQL Server Left outer join query?
Hello all, I am stuck in a bit of a mess, and i really don't know how to get out of it. I am a dot.net developer, working with MS SQL server 2000. I am trying to write a query which essentially gives the amount of stock available for a particular stock_code. select Stock_code, description from stock Now what i want to do is, for each one of the stock_code that apears in the table above i want to look into another table called pop_item, and get the closest delivery_date for that particular stock_code. So i have top 1 and order it by delivery_date desc. Individually for a particular stock_code, i can do this no problem. And here is my code for stock_code='E0016/6' select top 1 stock_code, delivery_date, order_number,qt ...Show All
Audio and Video Development Trying to get buffering data to wmplayer
I am building my own source filter and want to get beffering messages to apear in wmplayer. using media player 6.4 mplayer2 the buffering mesaging system works when i send an event EC_BUFFERING_DATA and it then calls by interface IAMNetworkStatus::get_BufferingProgress. and i return the percentage of the buffering state. Unfortuatly this doesn't work in wmplayer 9, running win2k so limited to this version. does anyone have any solutions to this problem. is there any other interfaces i need to implement to get the buffering messages to appear. I knw it can be done because when I open an asf file wmplayer 9 gives the buffering message. any solutions would be great. Thanks You might try asking th ...Show All