Jimvh28's Q&A profile

• SQL Server import from binary file

  I am importing data from binary data files into SQL Server. This is the code I am using: Do While Not EOF(1) Get #1, , NonStdCurrRecord adoRS.AddNew adoRS!Field1 = CDate(NonStdCurrRecord.Field1) adoRS!Field2 = CSng(NonStdCurrRecord.Field2) adoRS!Field3 = CSng(NonStdCurrRecord.Field3) adoRS!Field4 = CSng(NonStdCurrRecord.Field4) adoRS!Field5 = CSng(NonStdCurrRecord.Field5) adoRS!Field6 = CSng(NonStdCurrRecord.Field6) adoRS!Field7 = CSng(NonStdCurrRecord.Field7) adoRS.Update Loop Unfortunately, it takes about 8 mins to import a file with 180k records. Is there a faster way to do this ...Show All

• Visual FoxPro report preview form problem

  I posted a post related to some problem with memo fields in reports. What I've done so far was to create an intermediate table, a workbench with a single field of a character string length 95. When I need to preview or print a memo field I first format it and place every word sequentially in records of that table. It required a bit of coding but now it seems to work. In any event, the problem I am about to inquire is not related to it at all. It was just an introduction to show that I do have a preview form filled with some meaningful stuff to the limit. Here is the weird part: once I get this preview form with the report on it it cannot ...Show All

• Windows Forms Problem with editing tree nodes

  I have an item in the main menu associated with the Del key. There is also a tree view on the main form. When the del key is pressed while a node's text is being edited, the app executes the menu item's event handler instead of deleting a character from the tree node's text as it should normally do when the tree node's edit box has  ...Show All

• SQL Server Analyzing MDX query evaluation

  Are there any tools or tricks for looking at how an MDX query is evaluated in SSAS 2005 Something that indicates how aggregations are being used, for example - sort of like a SHOWPLAN for MDX. As you might know, AS 2005 MDX query execution events are now captured in SQL Server Profiler. What's not as clear from the docs (that I've come across, anyway) is the aggregation usage info available via SQL Profiler. This was well explained at the recent SQL PASS Conference, in Session 108: "Understanding Analysis Services 2005 Aggregations from Every Angle", by Dave Wickert a ...Show All

• Smart Device Development I'm looking for an article...

  I'm wondering if any readers here have come across an article on CAB and Enterprise Library 2.0 that featured a pluggable UI. More specifically, this article featured the same UI hosted in multiple environments including a standalone WinForm and also in an Office application. It was a demonstration of why one would want to use CAB to build modular UIs. Is anyone familiar with this article For the life of me, I can't find it nor can I remember the root domain where it came from. Any assistance would be much appreciated! It appears you've posted in a wrong forum. Are you sure that is relevant on devices ...Show All

• Visual Studio Problem Adding Web Project Solutons to Source Control

  Ok. So I am just getting started with VSS 2005 and am trying to correctly add a web project into Visual Source Safe. The project is called Events. The add goes fine. As with a regular project, I would have expected something like this: $/Events.root Events (solution folder - contains solution file and project folder) Events (project folder - contains source code, etc) However, I end up with something like this: $/Events.root Events (solution folder - contains solution file) Events_1 (project folder - contains source code, etc) Now, I assume that this is happening because I have the Events web project open ...Show All

• SQL Server Syntax for "In" Operator

  Does anyone know what the syntax for the "In" operator is when setting a filter on a matrix. If you want to use the IN filter, the filter value expression has to return a multi-dimensional array. Typically you would use an IN filter with a multi-select report parameter. If you want to define your own list of values, you can use an expression like this: =Split("value1,value2,value3", ",") The Split function will create a multidimensional string array out of the original string. -- Robert ...Show All

• Smart Device Development Visual Studio 2005 Downloads ("Deployment")

  Deployment to my target fails unless I first manually delete the previously deployed exe/dll on the target. How to avoid this What is the exact error message you are receiving from the deployment Short of the files being in use by a process, or out of memory on the device, we normally don't see any deployment errors like you describe. ...Show All

• Windows Forms Item Selection from the ComboBox

  In VB.net Windows forms application I am populating the comboBox as follows dstUsers = objUser.GetList()                 cboxName.DataSource = dstUsers.Tables(0)         cboxName.DisplayMember = "Name"         cboxName.ValueMember = "user_id" On click of the comboBox I want to retrieve it's Display member and Value&nb ...Show All

• Visual C# DllImport and enumerations

  I have a dll that was made in c that I would like to invoke from C#. Some of the parameters want enumeration values to be passed to them. These enums are defined within the c project. Is there anything I can do with this Hi, You may either declare the int parameter where enumerator parameter is used, or you can redeclare the enum in C# code. See below: suppose that there are following declarations in your C code: enum EWestern{good,bad,ugly}; TESTDLL_API int fnTestDll(EWestern e); Then in C# you have two options. Option 1: [DllImport("TestDll.dll", EntryPoint = "fnTestDll" ...Show All

• SQL Server Dynamic SQL in SSIS

  Hi All, I am new to SSIS. I want to be able to write a dynamic SQL statement for a Data Flow task. It would go something like this. I want to schedule an SSIS package to run everynight and extract data from an ODBC source and collect the previous day's sales info based on a date parameter, so the date parameter of the query would have to get a value based on the previous day's date EX: SELECT * FROM Sales WHERE Invoice_Date = <previous day's date> So far I am looking at a Script Component to do this and populate the Data Source, but I just wanted to check and make sure there isn't a better or more efficient way. ...Show All

• Visual Studio 2008 (Pre-release) Starting a transform animation in style event not working

  Folks: Trying to get a transform animation working from within a style. The animation works fine when bound to a particular image outside the style.Triggers section, but when I move it into the EventTrigger, I get a runtime exception:' [Unknown]' property does not point to a DependencyObject in path '(0).(1).(1).(2)' Trying to create a timeline the style editor causes Expression to crash, by the way. Here is the storyboard by the way: < Style.Triggers> <EventTrigger RoutedEvent="Mouse.MouseEnter"> <EventTrigger.Actions> <BeginStoryboard> <BeginStoryboard.Storyboard> <Storyboa ...Show All

• Visual FoxPro Timer Control not kicking in

  Hi All, We have a small VFP 8.0 synchonization utility that picks data from a VFP 8.0 database , converts it into XML  and sends it over the net to an Oracle database . It has a timer control on it which makes sure that this utility sends the data from VFP 8.0 to Oracle every 45 mins. It has always worked on all the setups till now, except one. We have not been able to figure why it does not work on that one. Any hints or directions to think in Regds, BABS BABS, Do you have error diagnostic code in place Do you have any logs that indicate each time it runs Do you launch the exe and it just runs forever with the timer firing off e ...Show All

• Visual Studio Team System Team Build Error - TF42046 - Unable to Execute Team Build

  All,  I am working with a new installation of Team Foundation Server and I am struggling to get the Team Build component to work.  Here is the Setup that I  am working with: All Systems are running in a seperate Domain (BOOKSTORE) from my company's domain (CTS) BSTEAMSYSTEM - this is the Team Foundation Server that is running  Team Foundation Server.  I have the application that I want to build stored here in Source Control This is a Virtual Server that is hosted via Virtual Server. The installation has both the App Tier and Database Tier running on this VHD. Team Build IS NOT installed on this VHD. BSDEVBH ...Show All

• Visual Basic how do I access Picture URLs in my database?

  I am using VB Express windows application, how do I access Picture filenames (relative) in my database I have 13 records in which the last coloumn contains those relative picture filenames. I wish to display the pictures that those locations in a picture box on my form. As a filename is simply a string. I'm unclear on what you really want to do here. Are you saying you have filenames in a database and the actual picture are stored in file locations relative to the location of the database. So if the database was in c:\ and you have a path that if folder\xyz\abc.jpg then you want to retrieve the picture from c:\folder\xyz\abc.jpg ...Show All