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: DCH
  • Order by date
  1. DCH

    null query

    Or you can enter the condition "# is null" in the field (double quotes not included), provided its query length allows for that. HTH - Didier
  2. DCH

    Foreign Keys in E-R Diagrams

    At the level of the E/R diagram (upper case = abstract level), the will-be foreign keys are represented by the relationships themselves. It's only when you go down to lower case ( = table implementation level) that those relationships are materialized by columns and foreign keys on the tables...
  3. DCH

    Printing a Server Model Diagram in PDF

    I usually Edit/select All => Edit/Copy => Paste into a Word document => turn the Word document into a .pdf file (using the PDF pseudo printer Driver for instance). HTH - Didier
  4. DCH

    ORACLE Reports: how do I dynamically change a text field

    Last time I did something similar in Oracle Reports was in version 2.5, so for whatever this still is worth currently: try to look up "Format triggers" (triggers that fire before an object is formatted for display) and "srw.set_field_char" (the package and specific function...
  5. DCH

    I dont know if this the right forum

    Try simple quoting the values you wish to insert: Insert into orders (FirstName, LastName, Company) Values ('John', 'Smith', '1 Higher Learning');
  6. DCH

    Designer Repository Backup

    Other objects than the Designer repository tables may appear in the Oracle schema where the repository is installed. You might fi create local copies of your application tables in there, so they can be accessed by the generator to generate some forms.
  7. DCH

    Oracle Designer - Table Implementation Problem

    The idea is that you describe your tables in the server model, and that you decide to put them (some or all) in one or several databases in the dB admin part. In a few words, now that you have some tables in the server model part, go to the dB admin part and: - create at least one Oracle...
  8. DCH

    Form Generator: Inconsistent Cache after creating 2nd version of appln

    I just had the very bad idea of creating a second version of one of the applications in the Designer repository... Ever since, I get the error message with "CDI-21600: inconsistent cache" when I try to generate an Oracle form based on any of the modules in the repository (even those...
  9. DCH

    Starting the designer tutorial

    Running 2.1.2: my "start" menu does include an Oracle Designer Tutorial folder, in which four icons are present (something like: "about...", "Populate tutorial tables", "Drop tutorial tables", "Oracle Designer for Tutorial User") However, I seem...
  10. DCH

    Table changed back in designer 1.3.2

    If by "generating" you mean: actually creating the table in your target Oracle database, then you may have to drop the table manually before using the Designer-generated script to recreate it (because those scripts don't include a "drop table" command). You might also take a...
  11. DCH

    Simple Q - priveledges rqd for creating workareas

    By the sound of it, I'd try to grant a 'CREATE ANY SYNONYM' (perhaps you need to create some specific synonyms for your new workarea?) HTH - Didier
  12. DCH

    Changing Run-Time property of Text Field in Forms 6

    Not quite sure about Developer 6, but in the previous versions you should have replaced 'yes' by property_true: set_Item_property('TEXT_ITEM22',Visible,property_true); Give it a try... HAND - Didier
  13. DCH

    Designer 2000 Rel 2.1

    I use the E/R modeller =&gt; table definitions =&gt; scripts for the tables, and also the Forms Generator (for Forms 5.0) for one specific application.<br><br>I also gave a try at the Web application generator, but was rather worried by the volume of code generated (PL/SQL packages), compared to...
  14. DCH

    How to pass parameters across modules

    I'm trying to get Designer 2000 to call a module (with an action button), in such a way that the called module will either auto-query or start inserting, putting the values of passed parameters into some bound items in the process.<br><br>Auto-query or start inserting: CG$STARTUP_MODE looks...

Part and Inventory Search

Back
Top