Search results

  1. T

    Question Updating Shared Drive App

    I have an app running from a shared network drive. The problem I’m having is updating/replacing the exe while it’s in use. I remember in pre-.net days I used to be able boot all the users by deleting right from the server but been unable to do so currently. I’m wondering if there is another way...
  2. T

    Question Coditional Inner Join

    If the result from b.Col1 = 1 then I'm to use b.Col2 as the result. However if b.Col1 is any other value (including null) then I need to include two more Inner Joined tables. I'm trying not to break it up in to seperate blocks of queries if at all possible. Select a.Col1, a.Col2, b.Col1...
  3. T

    Question Typed Datasets and Attributes

    I need to produce an Xml data file that follows specifications given to me by the USPS. I currently produce the file they want but I do it the long way and would like to upgrade this to use a Typed Dataset for the validation and also the easy output from there to an Xml file but they have a bit...
  4. T

    Question BackGround Printing

    I have a process that gets specified criteria, fills a dataset, and passes the dataset to a sub that prints a crystal report directly to the printer. Filling the dataset takes only milliseconds but printing the report takes a few seconds, I would like to do the printing in a background thread so...
  5. T

    Question Crystal Reports - Setting the details section for a fixed amount of records

    I’m looking for an efficient way to implement a fixed size / amount of records in the details section of a Crystal Report. For instance the details section size should always match the size of exactly 6 records. The problem is when less then 6 records are returned from a query. I dont need to...
  6. T

    Question PGP Encryption / Decryption

    My company receives PGP encrypted data files from customers which our employees then decrypt using the PGP software prior to using are in-house software to import the decrypted data file(s) into our system. I want to know if there is a way to add the decryption process into the coding of our...
  7. T

    Question Crystal Reports Slow Loading

    I’m having a problem with the load time of the crystal reports object in general and looking to increase the processing speed. In my project an order is processed and depending on the order; one of about a half dozen different reports is selected to be printed. Also depending upon which report...
  8. T

    Question Extra Spaces in Element Values

    I receive xml files from customers to be imported into our database and having some problems with extra spaces appearing between words in some of the field values. When viewing the xml file in a browser, the values appear formatted properly with a single space between each of the words. But...
  9. T

    Question Global Connection Object

    Two part question, Should a single global connection object in a module be used for the life of the application rather then a ton of local connections? And if so, should the connection.state remain open or constantly be re-opened & closed after each query? I'm running an app that will have...
  10. T

    Question Linked Severs

    Starting a new app that will be drawing data from two databases, both db's will be Sql Server 2005. At the moment both dbs are also on the same server but would like to leave some flexibility of this possibly changing in the future. For the most part, data drawn from the one database will be...
Top Bottom