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!

  • Congratulations IamaSherpa 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: clo
  • Order by date
  1. clo

    WHERE condition in SELECT to retrieve records

    And what about this: SELECT no_id FROM myTable WHERE no_id LIKE '%a%' Is there is a way to replace the a letter by a range 'a-z' (lower)? Sorry to ask you again and thank you for your helpful help =:))
  2. clo

    WHERE condition in SELECT to retrieve records

    I can't just replace the lower characters by upper because exactly the sames records already exist in the database and are the good ones... no_id id is the key of the table; For example, let's say 'MICHEL01' is a no_id in my table. I don't want to have two persons named 'MICHEL01' (because the...
  3. clo

    WHERE condition in SELECT to retrieve records

    My tables are that big... I have 3 tables of at least 1 million records each. And I just can't "replace" them because records will be duplicated... Records with upper case already exists and are the good ones! I am new to oracle and I just don't figure out how I can do this, even with...
  4. clo

    WHERE condition in SELECT to retrieve records

    Hi! I have a text field in a table and its name is no_id. An exemple of a no_id is: 'AB39MUO1'. An error occured and a user had entered the letters contained in the no_id in lower case (for example: 'ab39muo1'). I'd like to retrieve those records in the table but I don't know how to do this...
  5. clo

    Date problem

    Hi, I have a field date on a table. The format of the date is the following: "9/12/01 11:14:15 AM". The date stored on the filed is the current date. I'll like to update this field to the next day; I know I can do it by using the expression "SYSDATE + 1". I'll also like to...
  6. clo

    Ole object on a report sent by mail

    Hi! I have text boxs and an ole object on a report. Everything is OK on the preview report on the screen. This report is to be send by mail with the send option of the file menu. On the electronic version sent by mail, everything is OK for the text boxs but the OLE object is replaced with a...
  7. clo

    Simplify a simple expression?

    I want to apply filter criteria in a report. I use a form to enter criteria and I use these criterias to sort report (in the filter propriety of the report). There are a lot of combo boxes and text boxes on the form and when I click the OK button of the builder, Access is telling me that...
  8. clo

    Text Box

    I have a Text Box control on a form. The text box is multiple line (when the enter key is pressed, another line is generated) and is related (source) to a memo field on a table. All records doesn't have the same number of line entries. Entries are different and typed by the user (that is why a...
  9. clo

    OLE object always shown as icon... and I don't want to!

    The action seems relatively easy, however... I have an OLE object field stored in a table to show an image on a form (the image is associated with a record). I also drag the field on my form to create a bound object to be able to view the picture associated with the record. To insert an image...

Part and Inventory Search

Back
Top