Kent Boogaart's Q&A profile

• SQL Server Creating Graphs in access on a click of a button

  I need to create graphs in access in a lick of a button all the data will be in the sql transfered from the access. If anybody did this before ar having Idea please let me know I was talking about the Report Wizard in Microsoft Access. SQL Server does not have a report wizard. For SQL Server, you want to investigate installing SQL Server Reporting Services, it will let you create very nice reports inside Visual Studio against SQL Server. ...Show All

• SQL Server SQL CE 3.0 (Mobile 2005) Max DB Size Question

  Hi everyone, What are the consequences for just setting the Max DB Size to 4GB and letting it go at that Is the MAX Size any arbitrary value I want or must it be close to what the actual database is expected to be Also, why did they default to 128MB Wouldn't it have been better to set it to a larger value Thanks Dorothy Hi, I found that there is a difference in the way sqlce allocate memory for different max database size setting. In my device which is running Windows CE 5.0 with only 4 MB free storage space and 8 MB free program memory, I can not set the max db size setting larger than 512, if I set it to larger value the sqlce engine will throw a native exception -2147024882 with no ...Show All

• Visual FoxPro Not a table message...

  Hi All, I have a Visual FoxPro table which I use as a backup table. I have a lot of records in it at the moment. When I was trying to open it yesterday I got the following error: Not a table. I can't seem to open the table at all. The table must have got corrupted etc. Is there any way I can retrieve the contents of this table without having to do a restore from a previous backup. Pablo. http://fox.wikis.com/wc.dll Wiki~NotATable~VFP ...Show All

• Windows Search Technologies Windows Safe Search Filter - Application Error

  I use Windows Desktop Search and recently starting getting an error message. Details: WindowsSafeSearchFilter.exe - Application Error The exception unknown software exception (0x0eedfade) occured in the application at location 0x7c812a5b Followed by the error: Runtime error 217 007F0EEE What do these errors mean Hi all, I've also started getting this message, though my gut feel is its not to do with WDS. I've removed Outlook 2007 from the Search, and I still get the error when I try and get into Outlook 2007. Any thoughts anyone Cheers Nick ...Show All

• Software Development for Windows Vista GetWorkflowDefinition removed

  In a previous beta there was a method WorkflowRuntime.GetWorkflowDefinition(). I am now using June CTP and that method has been removed from this object (this happened in beta 2.2 I think ). The method is available on the WorkflowInstance, but this is not what I need. Is there a workaround for obtaining the WorkflowDefinition of a workflow type without using an instance of that workflow type The scenario: I want to iterate through a compiled workflow type and get all activities of a specific custom type so I can add records corresponding to these activities in my workflow engine database. So, at this stage, there are no workflow instances for me to GetWorkflowDefinition ... I need to perform this step before instances can be created b ...Show All

• SQL Server Identity field property lost after import tables between databases

  I have found an issue on sql server 2005 data importing function: For example, I have two databases named DB_A and DB_B. If it has a table named table_a on DB_A with an identity field (say field_a), then after transfer table_a to DB_B by using the 'Import and Export Wizard' of MS SQL Server Management Studio, the identity field of table_a on DB_B is no longer an identity field. i.e. DB_B.table_a.field_a is not an identity field any more. This issue is remain the same as transfering tables from sql server 2000 to 2005, or from sql server 2005 to 2005. Has anyone know how to work around for this problem Thanks in advance. Athens Yan P.S.: I have using sql server 2005 with SP1 applied (9.0.2047). ...Show All

• Visual FoxPro How to remove redundant phrase in field?

  Hi all........ I have a table field that contains things such as..... V DISCONTINUED W/O REPLACEMENT; V DISCONTINUED W/O REPLACEMENT -I&S MASTER; 7 SUB 2610-139-3704; I&S MASTER; 7 SUB FOR 2610-139-3704 What I need to do is remove the duplicate phrases, leaving only one instance of each phrase in the field. The amount of phrases in the field varies...could be 2 as shown above or there could be 6. I suspect that the 'common denominator' is the semi-colon, but everything I've tried has failed. Any help is greatly appreciated! First you should determine what a sentence is, for example: - From a delimiter (start, ";", end) to another. - A certain quantity of char ...Show All

• Visual Studio 2008 (Pre-release) Working with WCF Service

  I am trying to use the Entity Framework with a WCF service. It is giving me the following exception: System.ArgumentException was unhandled by user code Message="The default entity container name 'eKnowledgeSpaceDBModel.eKnowledgeSpaceDB' is invalid. The required mapping and metadata information could not be found.\r\nParameter name: defaultContainerName" Source="System.Data.Entity" ParamName="defaultContainerName" StackTrace: at System.Data.Objects.ObjectContext.CreateMapConnection(String connectionString, String defaultContainerName) at System.Data.Objects.ObjectContext..ctor(String connectionString, String defaultContainerName) at eKnowledgeSpaceDBModel.eKnowledgeSpaceDB..ctor(String connect ...Show All

• SQL Server SaveAs/Export

  Is there away with the reports to code to have them export into a excel template (a specific one) and have each report go into a different tab When I run the reports manually I can save to excel put not a pre-existing template. Each report has 3 to 12 stored procedures it needs to run so I am just not sure how to accomplish this task. Thanks in advance! Stokh OK, I'm not sure what you're asking for anymore. If you mean to ask if there's a way to do programmatic changes to a query at runtime, the answer (as far as I know) is no. But it sounds like RS can do what you need. Basically, you have the master report which takes a parameter, client_number or whatever your differentiator is. That parameter is used in a query on ...Show All

• Visual Basic Recompile from C# to VB.Net

  I downloaded the BeerHouse Starter Kit, E-Commerce website, to find it C#, could i convert it to VB.Net If yes, Kindly advise in detail how Thank youuu Since it's a website, the online converters (such as Kamal...) will not be of much help since they won't convert inline asp.net code, or the entire folder-based website, or any newer language features such as generics. Our Instant VB C# to VB converter will do this, but for conversions of this size you'll have some tweaking to do. David Anton www.tangiblesoftwaresolutions.com Instant C#: VB to C# converter Instant VB: C# to VB converter Instant C++: C# to C++ converter, VB to C++ converter Instant Python: C# to Python converter, VB to Python conv ...Show All

• Visual Studio 2008 (Pre-release) OpenXML vs XPS

  I just read an article which mentioned that the OpenXML standard was adopted by the standards committee ( http://www.infoworld.com/article/06/12/07/HNopenxmlastandard_1.html ) This is an XML standard for expressing documents. Does this have anything to do with the XPS standard used by documents in WPF If so, what's the relationship If not, why does WPF not support the standard which MS has pushed into being a new standard for expressing documents Thanks for any insights. AFAIK, OpenXML competes more with Office's XML formats. XPS is a print ready format that competes more with PDF than anything else. HTH, Drew ...Show All

• SQL Server Incorrect syntax near 'GO'. in sql 2005 management studio

  update test_table set flag_enabled = 1 where name = 'xxx' GO ALTER VIEW dbo.[ABC] AS SELECT * FROM [bt_ABC] WHERE is_visible = 'N' Simple statement like the above give Incorrect syntax near "GO" error. If I remove it, I get 'ALTER VIEW' must be the first statement in a query batch. Appreciate any tips/help. Thanks, Priti UPDATE test_table SET test_table.flag_enabled = 1 WHERE test_table.name = 'xxx' GO ALTER VIEW dbo.[ABC] AS SELECT * FROM [bt_ABC] WHERE is_visible = 'N' Let me know how you get on, this might be a good case for stored procedures. hth Pace ...Show All

• Windows Live Developer Forums Table/Panel showing pushpin names

  Hi there I'm a novice with Virtual Earth I have a number of locations around the country, defined by lat long, (92 to be precise) that split into 4 categories. What I want to achieve is - a map that plots the locations with different symbols from a GeoRSS feed (ACHIEVED!) - then allows the turning on and off of the 4 different layers (ACHIEVED) - but then has a table/panel that allows you to scroll through all the 92 locations based on their name in alphabetical order and when you click on one in the table the map zooms to that location at a suitable scale (NOT ACHIEVED) Any gentle advice with this last requirement would be gratefully received. david Sounds like your off to a grea ...Show All

• Windows Forms ComboBox control with shared DataSource (need explanation of behavior)

  I'm working with two ComboBox controls that share a list of items to select. Due to the sharing of the DataSource interaction with one of the ComboBox controls seems to effect the other, I imagine this is how it is supposed to work but I'm hoping someone can explain why. Example: ComboBox^ box1 = gcnew ComboBox(); ComboBox^ box2 = gcnew ComboBox(); ArrayList^ list = gcnew ArrayList(); list->Add(gcnew String("item one"); list->Add(gcnew String("item two"); box1->DataSource = list; box2->DataSource = list; When the Form containing the ComboBox controls is displayed both controls show "item one" by default as expected. However, when I drop down the list in box1 and select " ...Show All

• Game Technologies: DirectX, XNA, XACT, etc. General strategy question about XNA

  What is MSFT's strategy with GSE I mean, is it a stripped-down version of GS Pro meant to spark interest in GS Pro Is it actually going the core of GS Pro, and the hobbyist/student community is acting as both first adopters and beta (or even alpha) testers of the product Is it a way for MSFT to foster some kind of indie/small game shop Xbox360 game development (The latter would seem to be slightly odd: the actual dev kits, I gather, are not a minor expense, in addition to what I'm assuming are certification and any other testing expenses; I would think that releasing an alternate path for Xbox game development might cannibalize an existing revenue stream...) It would seem to me to be just simpler to wait for GS Pro to come out, and l ...Show All