Search results for query: *

Hello, This is the buffer gets section of the statspack report. The statspack snapshots were taken in a 15 minute time interval. Does this mean that the query was executed 418 times in 15 minutes? The reason I am asking is another application related query in the same report was executed 40000...

Hello, We have a table in access 2003 that has around 140 fields. Some records might have many fields blank. Around 50 can be blank. All the fields of a record are related to a single person. This table is called person table. Data such as person flight number, hotel adress etc are stored...

Hello All, One of the fields in a table is 11 characters in length. Would access raise on error usually or truncate the input if an input string of length > 11 is inserted? In this case, access just chopped off the remaining characters without a warning causing data loss. Any comments? Thanks.

Hello, There's a form with a text box field "id". Length of it is 14 including two - chars. Its format is like AAA-00-0000-AA The two chars should always display in the text box. The user only enters the alphanumeric number. The text string should be "AAA-00-0000-AA". I tried input mask. It...

Hello all, I have a three page word 2003 document. The first two pages are filled up dynamically using access database data. I need the third page matter display on third page regardless of whether the first two pages are empty or full. They should not push the third page matter down. Is it...

We have a table whose text column value has to be reset to 0001 at the end of year. This column value is usually incremented everytime a form is submitted (that's when a database record is entered into another table). Therefore, it becomes 0002, 0003 etc .. After the end of year 2006, i.e this...

I am using an access form that loads the data into a word document and shows the completed ms word document. The word document can later be prined or saved. The code has several references top the word document as shown below WordObject.AppShow If WordObject.AppMinimize() Then...

Hello, I have to select only values that are numeric and length 7 from a table. Such as 1234567, 9092333 etc.. Values such as a190802, aaaaaaa, 10/2233 etc should not be selected. Any help? Thanks

I am currently using an ms access database that doesn't have the normal menu. It has "File" and other application specific menus. I did an F11. After a form is opened in design mode, it doesn't show the "view" option in the menu toolbar. So, there's no way to see the code, properties etc ...

Hello, I am using a pl/sql procedure block to insert records into a table. Some of them have special characters like ' and - How can I escape them? Thanks. Ex: pkgname.update('12345', 'aaaa-bbbb');

Hello, Is there a maximum size a mdb should be limited for better performance. Is it 2gb? We currently have an mdb of 17gb size. Performance is not great. Ay thoughts?

Hello, Will the performance of an access application degrade after the backend is changed to Oracle 9i (from access)? Is bypassing jet engine necessary? If so, are the below steps (given in the documentation) required? Modify all SQL statements within the VBA code to comply with Oracle SQL...

Hello, We have two schemas with different tables. Some of the tables have same structure and share same data. Could you suggest if I should use synonyms (keeping the shared tables in one of those schemas only) or a new schema for them? Is combining the databases any good?

Hello all, I have some questions about some of the tables that I am looking at (1) Is it ok to have LastName, FirstName, MiddleInitial in a single column separated by commas? (2) Is it good to have columns such as Problem 1, Problem 2 .. Problem 5 in the table even if the number of problems...

Hello all, Could I get a list of all schema objects - tables, forms, queries using a query or tool. I am just looking for a list of schema objects into a textfile. Thanks in advance

Hi, I tried issuing sql*plus and I get the following error: Message file sp1<lang>.msb not found Error 6 initializing SQL*Plus I then found appended the oracle directory to path. No use. PATH=${PATH}:/u01/app/oracle/product/8.1.7/bin:. Can you help me?