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 Rhinorhino 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: teknikalbody
  • Content: Threads
  • Order by date
  1. teknikalbody

    [b]PASSING PARAMETER BETWEEN FORMS[/b]

    Hi, Never done this before, what do I need to do in order to pass a parameter from FORM_A to FORM_B. TIA
  2. teknikalbody

    [b}UPDATING UNKNOWN TABLE OR COLUMN [/b]

    Hi, People I need some of assistance... I have been asked to find all tables that may have the data = 'DATA' and then to update this with some new 'DATA'. As you may appreciate there are thousands of tables on the system and the column may be called anything. I have read some of the...
  3. teknikalbody

    SQL scripts

    Hi I have got around 53 SQL statments similar to: SELECT * FROM 'VARIOUS_TABLE' WHERE 'CHANGING_COLUMN_NAME' = 'CONSISTANT_VALUE' I NEED TO EXECUTE THESE TO SEE IF THEY BRING BACK ANYTHING DISREGARDING ANY THAT DONT. I'M JUST WONDERING IF THERE IS A FAST AND EFFICIENT WAY TO THIS. TIA
  4. teknikalbody

    Inserting photo into BLOB data type

    Hi all, Is it possible for me to insert a ‘.jpg’ photo into the table that holds photos in BLOB format? Any suggestions are appreciated. TIA
  5. teknikalbody

    Quick Update question

    Hi, I have a query as below; select A.Value from TABLE_A A, TABLE_B B where A.code in (select C.code from TABLE_C C where C.code = A.code and C.Value !=A.Value) and A.Value = B.Value Can someone please suggest how I may update the C.Value on TABLE_C with...
  6. teknikalbody

    Cant get the '£' sign

    Hi Can someone tell me how I can get the £ sign to display because at the moment its returning #. I have tried chr(163) but the same thing. Some details form the db if helps are: NLS_LANGUAGE = AMERICAN NLS_TERRITORY = AMERICA NLS_CURRENCY = $ NLS_CHARACTERSET = US7ASCII
  7. teknikalbody

    Quick duplicate question

    Hi experts, Just a quicky, I am doing... Select field_1, field_2 from table_A a, table_B b where a.identity = b.identity; However, table_B has duplicates but I just want the one record from the table because they are exactly the same so the fist one it comes across will do. Any suggestions ? TIA
  8. teknikalbody

    Conditional date

    Hi, Please can you help... I'm new to reports from a forms background... I am amending a report which always had one date that it brought back to be displayed however now there is a potential for two dates depending on the parameter the user chooses from a drop down option. For example, if...
  9. teknikalbody

    List of values

    Hi Please can you help...it is a forms thing but i will appreciate anything... I am bringing back images from a table that may have more than one so I need to give the user the choice to select. Please bear in mind that I am amending the form to implement this change that already brings one...
  10. teknikalbody

    UPDATE OUT OF SPACE

    Trying to do an update - but i run out of userspace. Any suggestions / advice / help appreciated. TIA
  11. teknikalbody

    SQL HELP

    Hi, If I have a table 'INPUT' made of the cols ex. ID, FLAG, FLAG2, DATE1, DATE2, DATE3, DATE4, TRIGGAR etc etc. then how can I update the TRIGGAR col to produce a resultant table 'OUTPUT' based on some criteria on the other 'INPUT' cols. Ex. if DATE1 > DATE2 then TRIGGAR = 1, but the triky...
  12. teknikalbody

    PROGRESS

    Hi ! Does anyone know of a query on progress ex. physical reads, writes, in / outs etc. that I could use to keep an eye on a query that I am running that can take a long time and sometimes collapse without me ever knowing about it. TIA
  13. teknikalbody

    NEW REMOTE SERVER LINK

    we have recently installed a new remote server named "TWOCOOL", can some one please help me set up all that is requred to link up to this server for use for my PC bearing in mind I already use "ONECOOL" and want to continue using this server aswell as the new one.

Part and Inventory Search

Back
Top