jerfoo's Q&A profile

• SQL Server textbox in every page

  My report has a group "order_no" and after each 1 there is a page break.... on each page I want a textbox which refers to the product column in the table...  How do I get the textbox to refer to the column on that page (I no to refer to the column in the table is: = ReportItems("product").Value But now that I have moved the textbox to the page header, it returns no value!!!      Thanks in advance header fields cannot directly reference dataset fields, thats why when you moved the textbox with your =ReportItems("product").Value it returned nothing. I'd advise you to keep the textbox in the body but make it hidden and reference it from header. ...Show All

• Visual FoxPro Random Sample

  I have a table containing 3773 records, and i need a random sample of 2500 of these records. Does is there any easy way to to this w/ foxpro or do i have to come up w/ an algorithm myself Thanks in advance, Mike It's not a matter of crediting. I think neither Tamar nor me needs crediting (at least she has an enormously high credit among VFP community). I simply can't see the benefit of multiplying with reccount(). How does it give 'required' result How does it affect accuracy If you think that column values would match with the actual recno() of their source rows then you're mistaken. ...Show All

• Architecture SOA - Availability vs. consistency

  Hello, I had an architectural question: Could someone please explain the tradeoff between Availability and consistency in SOA Thanks Houman Well I was listening to Vogels (CTO of amazon) as he was describing amazon's internal architecture as purely service oriented. Then he went on to say that they have to consider trade offs such as availability vs consistency for each service. I think what he was saying is that they don't run 2 phase commit trx across all thier services. Rather they have to decide which services needed 2 phase commit and sacrifice availability to achieve it. Again, this is just my guess. So I'm not sure about any of this, and was hoping that someone who has work ...Show All

• SQL Server bottom row

  How to display bottom row should be in dotted line One way of doing this is to put a group in with a grouping of =1 (will force only one group) and then in the group footer make the top dotted. If you need this on every page, just have the group footer displayed on every page. ...Show All

• Visual Studio Express Editions Pr

  I have information on a tab. How do I print that information. Please Help Thank-you Scott Do a search of the forum, and you'll find a few discussions on printing from VB 2005 Express. Try this one for size: http://forums.microsoft.com/MSDN/ShowPost.aspx PostID=181311&SiteID=1 A few posted snippets in there as well. Try and filter out the noise, but it does demonstrate that printing is different from previous versions of VB. ...Show All

• Visual Basic Picking out the year

  Can anyone tell me how to pick out the 4 digit year from a date I'm using VB.Net 2003 thanks tattoo date.ToString("yyyy") http://msdn.microsoft.com/library/default.asp url=/library/en-us/cpguide/html/cpconcustomdatetimeformatstrings.asp ...Show All

• Visual Studio Team System CTP5 - Schema Compare Options

  I cannot for the life of me find out where I can change or set schema compare options. How/where is this done Thanks - Amost It is available at the following place : Visual Studio Menu ->tools->options ->database tools->schema compare -Sachin Kumar (Microsoft) ...Show All

• Visual C# Multi Interface inheritance

  Lets say you have two interfaces: interface IA: IComparable { int A {get; set;} } interface IB: IComparable { int B {get; set;} } and a class which implements both IA and IB class C: IA, IB { } class C now has to implement CompareTo, but the problem is that CompareTo should do different things if being used to compare this object to another IA, IB or classC. How do you implement the CompareTo function For instance lets say there is code like this: C c1 = new C(); C c2 = new C(); IA ia = c2; int comp1 = c1.CompareTo(ia); int comp2 = c1.CompareTo(c1); In this case, comp1 should equal 0 if c1.A == c2.A, and comp2 should equal 0 if both c1.A and c1.B are equal to c2.A and c2.B. Since you can only have one CompareTo method on class C how do ...Show All

• SQL Server Is there a "hack" that would allow you to reuse identity numbers that were orphaned by deleted records?

  I guess this is a fairly common topic but couldn't find the right words to find anything in a search. What I'm getting at, is there any tsql functions or combination of commands for the following. You have identity columns in your tables, if you set the a seed and autoincrement, I enter in rows 1 -10 and then I delete 4, 6, 7, 8. My next new record uses 11. Is there any logic that allows you to check and reuse 4, 6, 7 & 8 described above Not looking for something that consists of having to create an extra ID table for each table and handle configuring what the next available number is everytime an Insert or delete is called. Thanks. There is no built-in method to use gaps in identity values. You will have to writ ...Show All

• Visual Studio Using the MPF to Implement a Project Type (C#)

  Hello, I am trying to create a simple new project type, following : http://msdn2.microsoft.com/en-us/library/bb166157(VS.80).aspx I have now run out of documentation on which interfaces etc I need to implement.. Should this bolier plate code actually do any thing Because I see no new project in the exp hive Thanks Tom Hi TurboTom, TurboTom wrote: For example the IronPython project has resx files that contain the strings used in the "new project window" How would my demo project know this ... Regarding the resources I had a problem with it when I started working on our MPF based package. The thing I missed when I create the package (using IronPython as a sample) was very simple - ...Show All

• SQL Server I-Mate JasJar And compact framework installation Problem ?

  Hi everyone here   i have a little problem : i tried to install the compact framework onto my pocket pc with windows mobile 5.0 but the installation fiailed and gave me an error . the error message said that :  the version of installation is not specified for this version of  operating   system   .. so what can i do to install compact framework on the device   please help ! in regards to the SqlServerCE error message, SQL Server Mobile needs to be installed separate from the framework: http://msdn2.microsoft.com/en-us/library/ms171938.aspx ...Show All

• Visual Studio Express Editions Start-Up Application

  Hi there, I have this programme and I want this checkbox, when it is checked the programme will add it self to... hkey_local_machine -> software -> microsoft -> windows -> current version -> run ...But I dont really understand what code to put in the Checked Event to make it add itself to the registry and take it self off. If anybody could tell me about the code, it will be a great help . Thanks, AliQ ...Show All

• .NET Development ASP.NET user permissions

  I am running an ASP.NET application on Server 2003. I want my application to start an external process.   E.g. System.Diagnostics.Process process = System.Diagnostics.Process.Start(processPath,arg );   When I try and do this using the above code it doesn’t work. I do not have any debugging facilities on the server so my only guess is that the ASP.NET user does not have adequate permissions to execute the process. Sound plausible   How do I give the ASP.NET user the rights to do this   Or, can i somehow launch this process using another user login   Thanks Thanks for your answer. I tried to put the code in a separate class library. ...Show All

• Audio and Video Development How to record from 'Wave' or 'Stereo Mix' in Vista?

  Hi all, On Windows XP or earlier, I could capture the audio stream to the speacker not from the external device (maybe endpoint device in Vista) like the microphone. In other words, D irectSoundCapture was able to capture from the selected recording device/source line in the Windows record control utility or mixerXXX APIs. And if "Wave Out Mix" or "Stereo Mix" or something similar was selected as recording source line, D irectSoundCapture was able to record the audio stream to the speacker. However, I could not find the way to do that in Windows Vista. Windows record control utility in Vista is just showing only external devices (endpoint devices) like mic., line-in or S/PDIF in but I could not find "Wav ...Show All

• Visual Studio Express Editions Create a Shortcut on Desktop "VBExpress"

  Hi I wont to do one thing. When I'm clicking on the button that must send shortcut of current application to the Desktop. How can i do this Thank you need to use IWSH interface/COM I believe. try this:   Add a reference to the Windows Script Host Object Model (COM component) add the imports statement:   imports IWshRuntimeLibrary   on the click of a button...try this:   Dim theShellClass as new IWshShell_Class() Dim theShortCut as new IWshShortcut_Class() theShortCut = theShellClass.CreateShortcut("MyApp.lnk") theShortCut.Description = "Description here" theShortCut.TargetPath = Application.StartupPath + "\MyFile.exe" theShortCut.Save()   & ...Show All