Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations derfloh on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  • Users: sjh
  • Order by date
  1. sjh

    Getting work items from TFS

    Hi, I'm new to using MS Project. We have a MS Project file linked with Team Foundation Server (TFS), which grabs list of work items from TFS. We are keeping the Project file read-only, so all the "Publish and Refresh" column values for work items are set to Refresh Only. Whenever I click Get...
  2. sjh

    How to display border around a NULL field?

    D'oh... you're right. The border is not displayed when the field is suppressed. What's the best way to handle this? Should I add text fields with borders and put them on top of the database fields, and suppress one or the other accordingly? I guess another way is to have two versions of the...
  3. sjh

    How to display border around a NULL field?

    Hi, I have a report that I want to use for two purposes: a blank form report that user prints out to hand-enter the data and another report that retrieves the values from the database. I have a parameter IsForm. If {?IsForm}="Y", then I set the Suppress property of database fields to True and...
  4. sjh

    Commit necessary after Dbms_Refresh.Refresh?

    I followed your instructions, and the DBMS_REFRESH.REFRESH procedure did not COMMIT. Thank you!
  5. sjh

    Commit necessary after Dbms_Refresh.Refresh?

    Hi, I have an Oracle procedure that has the Dbms_Refresh.Refresh statement to refresh a materialized view before processing records. It later calls the materialized view to retrieve a value. Is it necessary to add the Commit after the Dbms_Refresh.Refresh? Thank you in advance...
  6. sjh

    Role's table privileges in a procedure?

    Hi, I found the following quote from http://www.psoug.org/reference/OLD/roles.html "Object privileges granted through roles do not work within procedures, functions, and packages." I apologize for asking such a basic question, but I'd appreciate it if anyone can confirm that this is indeed...
  7. sjh

    Oracle directory that points to a different server?

    Yes, it was a permission problem. I found the following info from this website(http://www.orafaq.com/forum/t/58485/2/). I ended up reading the image in stream insted of using BFILENAME. Thanks for all of your help! Windows shares and mapped drives Oracle does not understand about mapped...
  8. sjh

    Oracle directory that points to a different server?

    Hi, I have an Oracle procedure that loads an image file (blob) from Oracle directory and inserts into a table. BFILENAME works fine if the directory is local (i.e. C drive), but if I change it to point to a different server, it doesn't read the file anymore. I tried using UNC-formatted path...
  9. sjh

    Get Device Name of Pocket PC?

    Hi, I'm developing a Pocket PC (Mobile 5) application using VB.NET in Visual Studio 2005. Does anyone know how to retrieve the device name of a Pocket PC? You can find this in "Start -> Settings -> System -> About -> Device ID tab -> Device Name". I read that this is stored in the registry...
  10. sjh

    How to create a grid control in Win Mobile 5.0?

    Hi, I am creating a program for the Windows Mobile 5.0 platform using Visual Studio 2005. It's intended to run on a Pocket PC. I want to create a grid in my application, but I don't see it in the Visual Studio tool box. There's ListBox and DataGrid, but that's not what I'm looking for. I...
  11. sjh

    How to lookup description from a code

    Thanks for your advice, LB! When I link the lookup tables, does it matter what join I use and whether the arrows points to or from the lookup table?
  12. sjh

    How to lookup description from a code

    Hi, I'm using Crystal Reports 11.5. In my database, all the data descriptions are stored in one lookup table called "tblLookup". This table is composed of following columns: table_name, field_name, code, and description. For example, the contents of this table looks like this: tblCustomer...
  13. sjh

    How to insert JPG into a ASA9 table?

    Hi, I never worked with images and database before and I'd really appreciate your help! I need to know which data type (image, bigint?) to use for the column for storing images, and also how to use an insert statement to load the image to a table. I'm using ASA 9 database. Thank you in advance!
  14. sjh

    ORA-00907: missing right parenthesis error when div in SQL

    My application uses a SQL query that does a division operation in the SELECT statement like this: SELECT length / 0.3048 as length_eng, width / 0.3048 as width_eng, ...... This SQL works fine if Oracle 9i driver is used to connect to the database, but when Oracle 10g driver...
  15. sjh

    How to export data to a SQL file?

    I will clarify my original question. We are doing development, and I want to "rebuild" the database each time (create tables and then insert the data) we have a new application build. We are still in the design phase, so the database may change. I don't think backup and restore would work...
  16. sjh

    How to export data to a SQL file?

    Hi, Is there a way in SQL server to export data in all tables to a SQL Insert script (and in correct dependency order)? I looked into Enterprise Manager and Query Analyzer, but I don't see any tools for doing such task. Thank you in advance for your help! J
  17. sjh

    How to define a default value for DATETIME column?

    Hi, I would like to assign a default value (i.e. current date time) to a DATETIME column in my table. What is the correct syntax for specifying that? In Oracle, I can use SYSDATE, but I don't know if that's possible in SQL Server database. create table SESSION_INFO ( SESSION_KEY numeric...
  18. sjh

    Where to enter "WHERE" clause in a Crystal Report?

    Hi, I am using Crystal Reports (version 9) for Visual Studio.NET. By using the Expert Wizard, I added a crystal report to a web application project. This is a really dumb question, but I couldn't find where to enter the WHERE clause in the SQL for the report. I found the <Database - Show SQL...
  19. sjh

    Question about creating a dump file in PL SQL

    Hi Mufasa, Sorry...my previous posts were vague. I meant the Export Tables utility in the PL/SQL Developer. (http://www.allroundautomations.nl/plsqldev.html) I am going to stick with using the EXP command. Sorry for the trouble & thanks again for your valuable help! Susie
  20. sjh

    Question about creating a dump file in PL SQL

    Hi Mufasa, Thanks for your post! It was very helpful and easy to understand. So it's correct to say that the "export table" functionality in PL SQL is different from the "EXP" command? Many thanks! Susie

Part and Inventory Search

Back
Top