Recent content by sjh

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...

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...

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...

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

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...

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...

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...

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...

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...

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...

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?

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...

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!

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...

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...