Search results for 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

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

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

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

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

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.

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

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

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

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

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

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

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

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