GreenLeyland's Q&A profile

• SQL Server How to populate a junk dimension?

  Is there any best practise to populate a junk dimension Should I just create the table and fill-in all the stuff using some SQL I believe most records in the junk dimension are static. Hello. Junk dimensions are related to the individual transaction. The transaction source key, in the fact table, depend on the granularity of the fact table. If it is a SalesOrderHeader fact table it can be the order number. If it is a SalesOrderLine item fact table it is usually the order number combined with the order line number. In fact tables you normally aggregate up to the individual order number so the order line details disappear. This is not a law so exceptions are possible. HTH Thomas Ivarsson ...Show All

• SQL Server Using VB file picker

  What would be the syntax to use the VB file picker in the code section I want to do something like =code.Filename in a parameter. Where this would cause the file picker to open and allow the user to use the standard interface to track down the file. If the files are in a known location then you could create a dataset that lists the available files in a dropdown rather than a free entry textbox. Check out http://msdn2.microsoft.com/en-us/library/ms160918.aspx ...Show All

• Internet Explorer Development Cannot print frames if a frame contains non-HTML

  I have found with IE7 that if you have multiple frames and one of the frames contains non-HTML (e.g., pdf, doc), you cannot print the frame that has the non-HTML in it. This worked in IE6. For pdf files in the frame, nothing prints. For doc files in the frame you get output indicating it cannot be printed as laid out. Hopefully Microsoft can fix this bug. I would not need to have a frame with Word in it if Microsoft supported the widows and orphans styles but I have some paragraphs that I need to keep together and use Word to print as it can handle orphans and widows. We are experiencing this problem with our clients where we have quite a few documents that are in Rich Text Format. This has greatly inconve ...Show All

• SQL Server How to get mobile subscription to sync with dynamic snapshot

  Hello Everyone, I have a publication on a Sql 2000 (SP4) server. This publication has dynamic filtering enabled. What I want to do is create an interface which will generate a new dynamic snapshot based on filtering input from users. So far I can create the dynamic snapshot easy enough and I can see the filtered results on a Sql 2000 subscriber. However, there seems to be no way to configure a mobile database to point to the dynamic snapshot. This is easy to configure in a Sql 2000 subscription - the options are right there are on the properties page. Yet, it seems like the mobile database only points to the required unfiltered snapshot through the IIS proxy. Is there any way to force the mobile database to use the dynamic snapshot ...Show All

• Visual C++ SP1 - Devenv hanging with 90% CPU - Mem constant - Hang dumps available

  Hello, We run an overnight build process (using batch files etc..) that worked fine with VC2005 but since installing SP1 'devenv' is hanging. I've captured a couple of hang dumps of devenv.exe if they are useful to any of the VC developers monitoring this forum. They are rather large though (~60meg each). Here's a snippet of the stack trace sections of both dumps. Many thanks Paul. PS: Is there a better place to post this stuff to If so, please let me know and I'll repost there. ========================================= TRACE 1 . 0 Id: 754.9a0 Suspend: 1 Teb: 7ffdf000 Unfrozen ChildEBP RetAddr Args to Child 0012f9e8 7c822114 77e67143 00000001 0012fa38 ntdll!KiFastSystemCallRet 0012f9ec 77e67143 00000001 0012fa38 ...Show All

• Visual FoxPro How to read an www adress and gather infos from there???

  Hi My question looks simple I hope... I want to read an adress for example I have adress http://www.test.com/ and I want to export the text from this site and import it into my table... Is there a way how to do so Please give me a sample code... And I forgot something... I want to have an automatic and real time in my program... Is there a way how to gather the exact time from the internet But the main task is the url reading and expotring. Thanks a lot... This would be great if I want to download whole site on the disk... But I want to import some text from the site to my table... is there code to do that for example, somthing like that : append from and type and i dont know xls or something lik ...Show All

• .NET Development setting XML attribute

  I'm trying to set a XML attribute whenever someone presses a radio button for example: before radio button click <row type=""> after radiobutton click <row type="header"> i can select the row and change the value however i am having problems writing the change back to the file. if i use the xmltextwriter it seems to clear the file the code im using to get to the button currently is XmlNodeList nodelst = _doc.GetElementsByTagName("row"); foreach (XmlNode node in nodelst) { XmlAttribute attr = node.Attributes["type"]; attr.Value = "header"; } can anyone help at all Colin Gemmell i created a new xmltextwr ...Show All

• Windows Forms Refresh DataSet

  Hi There, I have created a simple form containing a DataGridView. DataGridView displays the detail of an account from database. Details updates every 4-6 seconds in the database. My question is that how can I refresh the data displayed in DataGriedView every 5-6 seconds. And how can I retrieve the data into Dataset every 5-6 seconds from the database, which is DataSource for DataGridView control. Here is my code. ------------------------------------------------------------------------------------------------------------------------------ namespace DataGridViewSample { public partial class AccountForm : Form { public AccountForm() { InitializeComponent(); DataTable dataTable = GetAccountDetails().Tab ...Show All

• Windows Forms How to retrieve selected folders on OpenFileDialog ?

  Hi, I can retrieve selected files with .FileNames but how do I retrieve selected directories Is this possible or not Thanks ! Also, there are no events for the FolderBrowserDialog so you will have to use the following code: if (this.folderBrowserDialog1.ShowDialog() == Dialog Result.OK) { string folderPath = this.folderBrowserDialog1.SelectedPath; } ...Show All

• Windows Forms Method to set datagridview row background color

  Hi all, I had a datagridview. May I know how to set the particular row color of a datagridview to yellow Please help. Thanks Thanks. I was able to to get the form_load() to be created as you said and move the code to that method but the rows I try to change the background color on are still not changing. ...Show All

• Software Development for Windows Vista Why don't you create subforum for windows ddk?

  Why don't you create subforum for windows ddk ...Show All

• Visual Studio Team System Problem in creating the Release Mode Build using Build Type

  Hi , I am not getting the Release Mode Build using Build Type even though i specified the Mode of Build as Release in the Build Type Creation Wizard . Where should i change for getting this Release mode build using Build Type. Help me out with this issue. Regards, Anbu jeff, Thanks for your reply. i have the code already < ConfigurationToBuild Include = " Release|Any CPU " > < FlavorToBuild > Release </ FlavorToBuild > < PlatformToBuild > Any CPU </ PlatformToBuild > </ ConfigurationToBuild > in my TFSBuild.proj file But the build for the setup project is failing . I have this in my team build .proj file: <Target Name="AfterCompile" ...Show All

• Software Development for Windows Vista OpenThreadToken() failed with access is denied

  I have two users defined in my system. One is UserA, and the other one is UserB. Both of them are defined in the administrative group. UserA is a local user, and UserB is a domain user. I have an application running as UserA, and a service running as UserB. The application is calling a method defined in a COM object running in the service. I run into a problem when trying to call OpenThreadToken() when the thread is impersonating with a copied impersonated token. Here is the psuedo code: void SomeMethod() { // Try to retrieve the access token of UserA ::RpcImpersonateClient(); HANDLE hTok, hCopyTok, hNewToken; ::OpenThreadToken(GetCurrentThread(), TOKEN_ALL_ACCESS, TRUE, &hTok); ::DuplicateTokenEx(hTok ...Show All

• SQL Server SSIS package

  Guys I've migrated a SQL Server 2000 DTS package over to SSIS (which seems to have worked), its a really simple package with just one item, it first checks for a tables existance and deletes if necessary, then recreates the table and then inserts data from a selection of other tables, except its only creating the table no data is being inserted, yet the script to insert data works as I've tried it in a query. Any ideas Thanks inadvance Duncan, Leave the Create Table in one Execute SQL Task as your first Task. Configure a Source with your Select statement and a Destination insated of the Insert statement. ...Show All

• Game Technologies: DirectX, XNA, XACT, etc. some simple noob question

  Hi Well.. i learned c#.. and i said what the heck .. why not learn direct x.. and i have some problems understanding cerain things like: if i have like 30 meshs .. and the vertex buffer.. i have do render seperatly every mesh plus the vertexbuffer sorry if i sound crazy.. but.. need some help.. The normal way is to render each mesh with an own draw call. There are some tricks to render multiple objects with only one call but as you are a beginner you should not care to much about this now. With mesh you mean the mesh class In this case it manage the vertex buffers for you (create, fill, select, destroy). You only need to call “DrawSubset”. ...Show All