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
  • Content: Threads
  • 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?

    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...
  3. 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...
  4. 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...
  5. 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...
  6. 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...
  7. 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...
  8. 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...
  9. 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!
  10. 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...
  11. 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
  12. 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...
  13. 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...
  14. sjh

    Question about creating a dump file in PL SQL

    Hi, I am new to Oracle... Is using the "Export Tables" feature from PL SQL same as running the "exp" command? Do I have to log in as a SYSDBA or is it OK to log in as schema owner? If my goal is to copy the exact database environment to a different server, is using "Export Tables" enough...
  15. sjh

    How to enumerate fields within a record??

    Hi, I am a beginner to Oracle programming. I am writing a stored procedure that takes in a random SELECT SQL and outputs the result to email. Since I won't know the structure of the SELECT statement, I am not sure how to access a field within a record. Normally, it would be...
  16. sjh

    System variable that stores database specification??

    Hi, Is there an Oracle system variable that stores the current database specification? As in the database_specification in the following command? CONNECT username/password@database_specification Thank you in advance! Susie
  17. sjh

    using substitution variables for a schema owner?

    Hi, I would like to use a substitution variable to store the name of thw schema owner. I have something like this: define sv_SchemaName = 'SUSIE'; CREATE VIEW &&sv_SchemaName.TEST_VIEW blah blah BEGIN DBMS_STATS.GATHER_TABLE_STATS(ownname =>'&&sv_SchemaName', tabname => 'TEST_VIEW')...
  18. sjh

    How to run oracle multiple scripts in different files?

    Hi, I am looking for a way to run multiple oracle scripts stored in different files. So I don't have to create one huge script file. Thank you in advance for the info. Susie
  19. sjh

    Possible to design .NET application as web and standalone?

    Hi, This is a newbie question. Is it possible to design a .NET application that can run in both web environment and standalone? In the standalone setting, the user would not be connected to the internet, but would still use the same UI as the web application. Does the user need IIS installed...
  20. sjh

    Editing custom Excel toolbar??

    Hi, I am updating an excel application that someone else developed. He created a custom menu/toolbar which gets displayed as the application starts (the standard menu gets hidden). I am trying to add a new menu item to this custom toolbar. I go to Tools -> Customize -> and then select the...

Part and Inventory Search

Back
Top