Skip to content
  • Categories
  • Recent
  • Tags
  • Popular
  • World
  • Users
  • Groups
Skins
  • Light
  • Cerulean
  • Cosmo
  • Flatly
  • Journal
  • Litera
  • Lumen
  • Lux
  • Materia
  • Minty
  • Morph
  • Pulse
  • Sandstone
  • Simplex
  • Sketchy
  • Spacelab
  • United
  • Yeti
  • Zephyr
  • Dark
  • Cyborg
  • Darkly
  • Quartz
  • Slate
  • Solar
  • Superhero
  • Vapor

  • Default (No Skin)
  • No Skin
Collapse
Code Project
CODE PROJECT For Those Who Code
  • Home
  • Articles
  • FAQ
Community
G

Gawiz

@Gawiz
About
Posts
3
Topics
3
Shares
0
Groups
0
Followers
0
Following
0

Posts

Recent Best Controversial

  • Hosting a Workflow in an MVVM application
    G Gawiz

    I'm designing a MVVM application that does not use WPF or Silverlight. It will simply present web pages in HTML5, styled with CSS3. The domain is a perfect case for using WF because it involves a number of activities in a long-running process. Specifically, I am tracking the progress of interactions with a customer over a 30 day period and that involves filling out various forms at points along the way, getting approvals from a supervisor at certain times, and making certain that the designated order of activities is followed and is executed correctly. Each activity will normally be represented by a form on a view designed to capture the desired information at that step. My research so far has turned up examples where the workflow is used to execute business logic in accordance with the flowchart that defines it. In my situation, I need for a user to login then pick up where she left off in the workflow (for example, some new external event has occurred and she needs to fill out the form for that or move forward in the workflow to that step.) And I need to support the case where the supervisor logs in and can basically be presented with activities that need approval at that time. So... it seems to me that a WF solution might be appropriate, but maybe the way I want to use it is inverted - like the cart pulling the horse so to speak. I'd appreciate any insight that anyone here can offer.

    Thanks so much! Steve Lackey

    WCF and WF wpf csharp html css hosting

  • Coach handbag spam
    G Gawiz

    Genetic Algorithm Library[^] Would be helpful if we could directly request removal of spam entries like the one on this page. Thanks

    Spam and Abuse Watch com algorithms

  • BULK INSERT problem with SQL Server 2008 DATE format
    G Gawiz

    SQL Server 2008 has the new 3-byte DATE format that I would like to use, being as I don't need the extra overhead of storing TIME. I used bcp to generate the following format file from my table definition: "<?xml version="1.0"?> <BCPFORMAT xmlns="http://schemas.microsoft.com/sqlserver/2004/bulkload/format" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"> <RECORD>    <FIELD ID="1" xsi:type="CharTerm" TERMINATOR="\t" MAX_LENGTH="10" COLLATION="SQL_Latin1_General_CP1_CI_AS"/>    <FIELD ID="2" xsi:type="CharTerm" TERMINATOR="\r\n" MAX_LENGTH="11"/> </RECORD> <ROW>    <COLUMN SOURCE="1" NAME="Symbol" xsi:type="SQLVARYCHAR"/>    <COLUMN SOURCE="2" NAME="myDate" xsi:type="SQLDATE"/> </ROW> </BCPFORMAT>" xsi:type="SQLDATE" is used to define the transformation for the date in my ascii file to the DATE in the table. A snippet from the input file is: AAI     19940101 ACL     19981231 AKA     20091208 BULK INSERT interprets all of these dates to be 1900-01-01, which would be the default value I suppose. But if I change my input file to: AAI     1994-01-01 ACL     1998-12-31 AKA     2009-12-08 BULK INSERT inserts the correct date values into my table. This is peculiar because if I define the table to be SMALLDATETIME instead of DATE and SQLDATETIM4 instead of SQLDATE, then either input file works OK. It wouldn't be such a big issue for me except that I have thousands of files each with thousands of rows and converting them all before importing is going to be time consuming. I think this is a bug in SS2008.   I tried to report it to Microsoft, but to open a support ticket costs $99:confused: 1) Is there a free/simple way to report the bug to Microsoft 2) Is there an updated version of bcp.exe (I can't find one) 3) Is there a workaround that doesn't involve pre-formatting the input Thanks Steve

    Database help database sql-server com sysadmin
  • Login

  • Don't have an account? Register

  • Login or register to search.
  • First post
    Last post
0
  • Categories
  • Recent
  • Tags
  • Popular
  • World
  • Users
  • Groups