f



Why isn't table A always key-preserved if equijoined to the key of table B?

Hi,

It seems to me table A should always be key-preserved if equijoined to
the key of table B, but Oracle seems to disagree. Example:

SQL> create table jvd_t1 (c1 number, c2 number,c3 number); 

Table created. 

SQL> create table jvd_t2 (d1 number, d2 number); 

Table created. 

SQL> alter table jvd_t2 add primary key (d1); 

Table altered. 
*********** the following update works: 
SQL> update (select t1.*,t2.* 
2 from jvd_t1 t1,jvd_t2 t2 
3 where c1 = d1 ) 
4 set c2=d2; 

0 rows updated. 

******* but this update does not: 
SQL> update (select t1.*,t2.* 
2 from jvd_t1 t1,jvd_t2 t2 
3 where c1||c3 = d1) -- this concatenation is the only difference 
4 set c2=d2; 
set c2=d2 
* 
ERROR at line 4: 
ORA-01779: cannot modify a column which maps to a non key-preserved
table 

Why does the key-preserverdness of a table depend on the way I use the
columns to equijoin to the key of another table? Oracle can conclude
that for every record of jvd_t1 I will still fetch only one record (at
the most) from the lookup-table, so jvd_t1 is still key-preserved.

Oracle 9.2 on Sun OS.

Jaap. 
0
5/5/2004 6:39:15 PM
comp.databases.oracle.server 22978 articles. 1 followers. Post Follow

1 Replies
759 Views

Similar Articles

[PageSpeed] 10

Your analysis is correct - the table is key-preserved,
and Oracle 'ought' to recognise it.

There are other, cases where the optimizer fails to spot
the key preservation.  One day, no doubt, they will
be covered.

-- 
Regards

Jonathan Lewis
http://www.jlcomp.demon.co.uk

The Co-operative Oracle Users' FAQ
http://www.jlcomp.demon.co.uk/faq/ind_faq.html

Optimising Oracle Seminar - latest dates
http://www.jlcomp.demon.co.uk/seminar.html



"Jaap W. van Dijk" <j.w.vandijk.removethis@hetnet.nl> wrote in message
news:gnci90ljpaushcuvctcea69quqdhu3q9l9@4ax.com...
> Hi,
>
> It seems to me table A should always be key-preserved if equijoined to
> the key of table B, but Oracle seems to disagree. Example:
>
> SQL> create table jvd_t1 (c1 number, c2 number,c3 number);
>
> Table created.
>
> SQL> create table jvd_t2 (d1 number, d2 number);
>
> Table created.
>
> SQL> alter table jvd_t2 add primary key (d1);
>
> Table altered.
> *********** the following update works:
> SQL> update (select t1.*,t2.*
> 2 from jvd_t1 t1,jvd_t2 t2
> 3 where c1 = d1 )
> 4 set c2=d2;
>
> 0 rows updated.
>
> ******* but this update does not:
> SQL> update (select t1.*,t2.*
> 2 from jvd_t1 t1,jvd_t2 t2
> 3 where c1||c3 = d1) -- this concatenation is the only difference
> 4 set c2=d2;
> set c2=d2
> *
> ERROR at line 4:
> ORA-01779: cannot modify a column which maps to a non key-preserved
> table
>
> Why does the key-preserverdness of a table depend on the way I use the
> columns to equijoin to the key of another table? Oracle can conclude
> that for every record of jvd_t1 I will still fetch only one record (at
> the most) from the lookup-table, so jvd_t1 is still key-preserved.
>
> Oracle 9.2 on Sun OS.
>
> Jaap.


0
jonathan5683 (1392)
5/5/2004 7:58:28 PM
Reply:

Similar Artilces:

don't need dictionary's keys
Hello, I am using some very large dictionaries with keys that are long strings (urls). For a large dictionary these keys start to take up a significant amount of memory. I do not need access to these keys -- I only need to be able to retrieve the value associated with a certain key, so I do not want to have the keys stored in memory. Could I just hash() the url strings first and use the resulting integer as the key? I think what I'm after here is more like a tradition hash table. If I do it this way am I going to get the memory savings I am after? Will the hash function always generat...

BUG #1055: no keys in inherited table with primary key when inserting into inheriting table
The following bug has been logged online: Bug reference: 1055 Logged by: Agri Email address: agri@desnol.ru PostgreSQL version: 7.4 Operating system: PC-linux-gnu Description: no keys in inherited table with primary key when inserting into inheriting table Details: let me desribe a bug in the term of sql commands: create table first (id int primary key ); create table second (f2 int) inherits (first); create table third (ref_id int); alter table third add constraint third_ref_first foreign key (ref_id) references first; insert int...

Is Primary Key always the index of the table in Oracle?
Can someone explain to me if the Primary Key always the same as Index of the table in Oracle? If not, how are they related? Thank you in advance! On Mar 6, 10:22 am, "Kaka" <kaka....@gmail.com> wrote: > Can someone explain to me if the Primary Key always the same as Index > of the table in Oracle? If not, how are they related? Thank you in > advance! I don't think that primary Key is same as index only. Infact primary key apply a index on column as well as it applies not null and unique constraint and can be use to bind table with another table using foreign key in it. Kaka wrote: > Can someone explain to me if the Primary Key always the same as Index > of the table in Oracle? If not, how are they related? Thank you in > advance! > Index is a structure Oracle uses in accessing the table, when it feels it is faster to do so. Indexes have one or several attributes of the table and a reference to the rows in the table that have those values. The index can be built so that there can be only one row associated to the attribute(s). If this is the case, one cannot add another row with same values without violating the constraint. Since primary key is a constraint that an attribute or attributes of the table can have only one row per one value of the attribute (or set of attributes if there are more than one), almost all RDBMSs make an index for the primary key. But, you can add more indexes to the table, and remove them if you l...

Can't create a table with primary key
I use, Ingres 2006 R2 (for Linux) v 9.1.0 on RHEL 5.0. I created a database called test. When I try to create a table without a primary key, it creates without any hassles. But, when I create a table with a primary key, it throws the following error: Code: * create table abc ( a i4 primary key);\g Executing . . . E_PS0480 CREATE TABLE: A column in a UNIQUE constraint has been defined as WITH NULL (on table 'abc'). All columns in a UNIQUE constraint MUST be created as NOT NULL. (Wed Mar 19 22:43:15 2008) continue * What could be the reason for this misbehavior? > All columns in a UNIQUE constraint MUST be created as NOT NULL. The default in column creation is "with null" so try: create table abc ( a i4 not null primary key);\g >> What could be the reason for this misbehavior? << Technically, you are right; Standard SQL and most other SQL products require that the PRIMARY KEY constraint also makes the column(s) NOT NULL. It is a good programming practice to explicitly declare the PK as NOT NULL in case the column is taken out of the PRIMARY KEY. --CELKO-- wrote: > >> What could be the reason for this misbehavior? << > > Technically, you are right; Standard SQL and most other SQL products > require that the PRIMARY KEY constraint also makes the column(s) NOT > NULL. It is a good programming practice to explicitly declare the PK > as NOT NULL in case ...

query sql server/oracle table from Db2 or join db2 table with sqlserver table
My application connects to a DB2 V8.2 EE database running on AIX. I need to now lookup a table in SQL SERVER via the DB2 connection. I also need to run an sql that joins a DB2 table with an Oracle table. How can I accomplish this ? Do i need a seperate product ? I also have license for Db2 v8 connect that I use for connecting to db2 on the mainframe. TIA Roger ...

Why aren't key strokes being recognized when a certain table row has focus?
Hi all, I am using IE version 6 and I am moding the jscript for an existing page in an application. I am setting the page up so that whenever a function key or any combination of keys (ctrl-s) for example are pressed, certain actions will be performed on the document. Everything is working well with the exception of some divisions in a table row. Whenever one of these divisions have the focus, the app stops processing the key down/up/pressed events. The only key event that it will now recognize is the tab key. If I mouse click anywhere else in the document or tab away from these two divisions the app suddenly will start processing the key down/up/pressed events again. This is pretty bizare behavior. I would sure appreciate any suggestions that you could offer. Thanks, Doug Harding State of Utah / Division of Finance Scripsit douha: > This is pretty bizare behavior. Not really. Multiposting and failing to post a URL is fairly typical - of people who haven't read Usenet groups like this for some days before throwing in a question. Oh, and you also posted to at least one wrong group: this one is for discussing HTML authoring for the WWW. -- Jukka K. Korpela ("Yucca") http://www.cs.tut.fi/~jkorpela/ douha wrote: > I would sure appreciate any suggestions that you could offer. I would imagine that you'd have more luck in one of the microsoft.public.* newsgroups, or perhaps a Javascript grou...

Renaming table doesn't rename primary key index or serial sequences
-----BEGIN PGP SIGNED MESSAGE----- Hash: SHA1 PostgreSQL 7.3.2 (Redhat 9) When creating a table, primary key indexes and serial sequences are created= =20 as well. Naively altering the name of the table does not modify the names= =20 of the dependent primary key indexes and serial sequences. It was expected= =20 that the indexes and serial sequences would've been renamed as if they had= =20 been created originally with the new table name. This isn't a critical bug, but it would make PostgreSQL that much more=20 accessible to novices. # CREATE TABLE test ( id SERIA...

query sql server/oracle table from Db2 or join db2 table with sqlserver table #2
My application connects to a DB2 V8.2 EE database running on AIX. I need to now lookup a table in SQL SERVER via the DB2 connection. I also need to run an sql that joins a DB2 table with an Oracle table. How can I accomplish this ? Do i need a seperate product ? I also have license for Db2 v8 connect that I use for connecting to db2 on the mainframe. TIA Roger Roger wrote: > My application connects to a DB2 V8.2 EE database running on AIX. I > need to now lookup a table in SQL SERVER via the DB2 connection. I > also need to run an sql that joins a DB2 table with an Oracle table. > How can I accomplish this ? Do i need a seperate product ? > I also have license for Db2 v8 connect that I use for connecting to > db2 on the mainframe. You need to look at Websphere Information Integrator along with the relational wrappers for MS SQL server and Oracle. Ian, its a canned CRM application that currently connects to DB2. I cannot run the app on Websphere. A few years could use relational connect and create federated nickname on db2. Can I still do that ? TIA On Apr 27, 6:01 pm, Ian <ianb...@mobileaudio.com> wrote: > Roger wrote: > > My application connects to a DB2 V8.2 EE database running on AIX. I > > need to now lookup a table in SQL SERVER via the DB2 connection. I > > also need to run an sql that joins a DB2 table with an Oracle table. > > How can I accomplish this ? Do i n...

pgsql-server: Repair 'expected both swapped tables to have TOAST tables'
Log Message: ----------- Repair 'expected both swapped tables to have TOAST tables' bug in 7.4 branch. I wasn't excited about doing this when the first report came in, but now that we have two of 'em, I suppose it had better get fixed. Tags: ---- REL7_4_STABLE Modified Files: -------------- pgsql-server/src/backend/commands: cluster.c (r1.116 -> r1.116.2.1) (http://developer.postgresql.org/cvsweb.cgi/pgsql-server/src/backend/commands/cluster.c.diff?r1=1.116&r2=1.116.2.1) ---------------------------(end of broadcast)----------------...

Chicken and egg problem: FOREIGN KEY reference to a table that doesn't exist yet
I'm trying to create a local copy of a popular CRM database called Salesforce.com. Many of the tables in the DB have FOREIGN KEY references that I want to preserve, but I've run into a chicken and egg problem. Table "A" has a reference to table "B," and table "B" has a reference to table "A." So I can't CREATE one until the other exists. Is there a way to disable these checks until I've created all the schema? Here's what I see (error first, then SQL that caused it): Server: Msg 1767, Level 16, State 1, Line 1 Foreign key 'FK...

SQL Select from table with partial key from other table
Hi, i have two tables with equal columns Column1, Column2, Column3,... In the first table all columns are filled with data. In the second table only some of the colums are filled. Now i want to find the records in the first table which are matching the partially defines records in the second table example: FirstTable column1 column2 column3 A B 1 A B 2 A C 1 SecondTable column1 column2 column3 A B NULL A C NULL The result should in this case all record from FirstTable SecondTable column1 column2 column3 A NULL NULL In this case also all columns should be returned SecondTable column1 column2 column3 A B NULL Now only the first and the second record from the FirstTable should be returned. My problem is to define a performant sql select. TIA, Soeren Soeren Muehlbauer wrote: > Hi, > > i have two tables with equal columns > > Column1, Column2, Column3,... > > In the first table all columns are filled with data. In the second > table only some of the colums are filled. Now i want to find the > records in the first table which are matching the partially defines > records in the second table > > > example: > > FirstTable > > column1 column2 column3 > A B 1 > A B 2 > A C 1 > > > SecondTable > > column1...

in table a but not in table b
Hallo, I have two tables, a and b. For the sake of clarity I use only one column in both tables. a. has a columns containing values NL,DE,FR, IT b has a column containing values NL and FR I need a query that selects the missing value(s), and only the missing values in table b. So the result should be DE and IT. I'm sure some join would work, but I am totally confused by them joins... ;-)) Please give me clue sjef escribi�: > Hallo, > I have two tables, a and b. For the sake of clarity I use only one > column in both tables. > a. has a columns containing values NL,DE,FR, IT >...

Get all child table and key names of a parent table
select stab.tabname Parent, scol.colname Primary_key, sstab.tabname Child, sscol.colname Child_key from syscolumns scol, syscolumns sscol, sysindexes sind, sysindexes ssind, sysconstraints scon, sysconstraints sscon, systables stab, systables sstab, sysreferences sref where scol.tabid=sind.tabid and scol.colno = sind.part1 and sind.idxname=scon.idxname and stab.tabid=scon.tabid and sstab.tabid=sscon.tabid and sscol.tabid = ssind.tabid and (sscol.colno = ssind.part1 or sscol.colno = ssind.part2) and sscon.idxname=ssind.idxname and sref.constrid=sscon.constrid and stab.tabid=sref.ptabid and stab.tabname='ParentTableName' above query works gr8 when single column primary key in Parent table, but when there is two or morecolumn primary key it does not gives right ans. plz try to solve.. "Kuldeep" <kuldeepchitrakar@gmail.com> wrote in message news:1144752804.917120.279890@i39g2000cwa.googlegroups.com... > select stab.tabname Parent, > scol.colname Primary_key, > sstab.tabname Child, > sscol.colname Child_key > from syscolumns scol, > syscolumns sscol, > sysindexes sind, > sysindexes ssind, > sysconstraints scon, > sysconstraints sscon, > systables stab, > systables sstab, > sysreferen...

Primary Key on a table is not coming over when I import table in SSIS
SQL 2005 SP2. When I try to import a table from one server to another using SSIS, the table imported on the new server does not have the primary key which exists on the source table. Help please. Thanks. Raziq. *** Sent via Developersdex http://www.developersdex.com *** There is a setting under the options to move it. Be sure all objects are checked within the options that you need. By default I dont not believe this is the case. i would bet any indexes and any foreign keys besides primary keys did not move over as well as this is also an option. Mike On Jul 21, 3:37=A0pm, Raziq Shekha...

Key version number for principal in key table is incorrect
Hi to the experts, I have a somewhat special setup here, some of you are in the know of it: I have three hosts running SAP servers under Linux, Win2k Server and SunOS respectively and am trying to make single sign-on working using MIT Kerberos. All three are connected to an Win2k DC. There are two issues left to do: ensure that the servers are up and running as long as possible - somehow it must be possible to renew the ticket indefinitely, does anyone know how to do this? The second one is that the SAP server writes the following GSSAPI message in it's log: "Key version number for principal in key table is incorrect". What could it be? The output of ktpass states that vno is 1 and ktutil on the Linux box says KVNO is 1 too. By the way: all three SAP servers use the same service principal in the AD, could this be an issue? Thanks in advance, Calin Barbat. ________________________________________________ Kerberos mailing list Kerberos@mit.edu https://mailman.mit.edu/mailman/listinfo/kerberos Hello again, I found out (Matt suggested this a long time ago, now I gave it attention) that issuing a: kinit -k -t <local_keytab> <principal> seems to get a fresh ticket from the KDC and is suitable to be run from crontab, as it doesn't ask the user for a password. Does this solve the first issue below, or do I still need to signal it somehow to the SAP server that the ticket got renewed? Calin. Barbat, Calin wrote: >Hi to ...

How do I find the primary key of a table by querying the system tables?
Hi all, I've googled for this for a while but haven't found anything. Please could someone tell me how I can find iF a table has a primary key and what is the name of the constraint. I have this so far (I'm on ASE 11.0 for Linux btw): select i.name, o.name from sysindexes i, sysobjects o where i.id = o.id and o.type = 'U'; I think all my primary key indexes start PK_, but I'm not sure. I figure the primary key must be flagged somewhere, but I can't see anything obvious on the system tables. TIA Rich Hi Richard, Try the "status" column on the sysindexes table, where (status & 2048 = 2048) identifies a PK constraint ... see the "sp_helpconstraint" sp in sybsystemprocs. Cheers, Sara ... Richard Gration wrote: > Hi all, > > I've googled for this for a while but haven't found anything. Please could > someone tell me how I can find iF a table has a primary key and what is > the name of the constraint. > > I have this so far (I'm on ASE 11.0 for Linux btw): > > select i.name, o.name from sysindexes i, sysobjects o where i.id = o.id > and o.type = 'U'; > > I think all my primary key indexes start PK_, but I'm not sure. I figure > the primary key must be flagged somewhere, but I can't see anything > obvious on the system tables. > > TIA > Rich On Thu, 24 Feb 2005 13:29:21 -0800, DBAGAL wrote: ...

Re: TABLES TABLES TABLES
sasbum@AOL.COM wrote: >How would you best describe to a retiscent SAS student that the concept of >TABLES isn't limited to SQL? This came up during a discussion on table >lookup methods - and lookup tables in particular (I mean, lookup tables >pre- >date SQL). Even SAS data sets are referred to as tables. This made the >student apoplectic. I find a visual works well here. If you show a grid with rows and columns, then you can show a picture of a SAS data set and a SQL table and a lookup table, and show that (regardless of terminology and buzzwords) they're all pretty much the same. >Words of wisdom most welcome!!! Sorry, all you get is me. David -- David L. Cassell mathematical statistician Design Pathways 3115 NW Norwood Pl. Corvallis OR 97330 _________________________________________________________________ Express yourself instantly with MSN Messenger! Download today - it's FREE! http://messenger.msn.click-url.com/go/onm00200471ave/direct/01/ ...

Finding index keys in a v large table that are not in a large table.
Ok, I have two tables called audit and audit_summary. Both are indexed on audit_seq (audit is non unique and audit_summary is unique):- Audit defn:- audit_seq, message_number, message_text Audit_summary defn:- audit_seq, <various other fields parsed out of the message text> In an online transaction processing system, many records can be written into the audit table all with the same audit_seq per transaction. Every so often, a job starts up that gets all the new audit_seqs that are not in the audit_summary table and inserts the new records into it. These tables are getting pretty big eg Audit is >15Million rows and Audit_summary is around a few million. Anyone have any thoughts on the most efficient way to extract the new audit_seqs in the audit table? select audit_seq,message_text from audit where audit_seq > (select max(audit_seq) from audit_summary) is no good as there is potential for audit_seqs to get skipped. I created two test tables called big (~ 1 Million rows) and small (~100K rows) both with columns audit_seq,object_id. I then ran the following:- 1 select big.audit_seq, object_id 2 from big, (select audit_seq 3 from big 4 minus 5 select audit_seq 6 from small) seqs 7* where big.audit_seq = seqs.audit_seq SQL> / 804033 rows selected. Execution Plan ---------------------------------------------------------- ...

Foreign keys referring table in other database
Hi ! IDS 11.50.FC6 I need to set up constraints between tables in different databases. According to the documentation the tables used in a foreign key definition must be in the same database. I have also tried to use synonyms and views thar refers the table in the other databas but no success. One idea is to use ER to replicate the tables in question, another would be to write triggers that does a check against synonyms. Any other ideas anybody ? TIA Ulf --_29528b80-cd1d-4bdd-9635-bd292cc1552a_ Content-Type: text/plain; charset="iso-8859-1" Content-Tr...

Linking SQL Server tables to Oracle Tables DSN-Less
Hi, i have an oracle database and an SQL Database i query both and at the mo i have to query one then put records in an array then query the other than update the array. Is there a method in VB6 that i can simply link the two (dsn-less connection)?? If anyone as a solution you would save me hours !! Cheers Gaz gonkowonko@gmail.com wrote: > i have an oracle database and an SQL Database i query both and at the > mo i have to query one then put records in an array then query the > other than update the array. > > Is there a method in VB6 that i can simply link the two (dsn-less > connection)?? BDE (Borland Database Engine) is similar to ODBC and it allows heterogenous database joins - e.g. you can select a table from one BDE data source and joined it (using SQL) with another BDE data source. Have done this a few times in Delphi (but never put that code into production). The vast majority of times this type of thing is not a bright idea. It can (and usually do) cause havoc with performance. > If anyone as a solution you would save me hours !! I would rather solve this at server side then in VB at the client side. Oracle provides a transparent interface into other databases, including SQL-Server. From the client side the SQL-Server table will look like a normal Oracle table. -- Billy Hey Gaz, You can use Oracle Heterogeneous Services to allow ODBC based Database Links to be created in the Oracle Server, after which you can query the SQL Server t...

I am trying to set up a database using the database connectivity toolkit and 8.5. I have tables setup and each one has an autoincrementing primary ID key.
I have very little experience with databases, but I have to set one up. I am setting up a relational BD, I have several tables set up, each has a primary key set up as a ID, autoincrement. &nbsp; How can I not send this column data, and let it autoincrement like it should so that it is a unique entry. I keep on getting an error that says that the number of colums don't match. Is there any way to do this. &nbsp; I want the database to keep track of the line count for this, and increment when each new entry arrives.&nbsp; Does this make any sense? The insert data VI has a Columns input which is a 1D string array. Each element in the array corresponds to an element in the cluster, so you can just use the names of the columns and not use the ID column. I think that is what I was doing, but it did not like it, I kept getting an error saying that the array that I was sending did not have the same number of columns as the table I was sending it to. When I read the database and list out the tables and the columns, I see that ID as one column in each table. That is my problem, It seems like I have to define each element and I have to send the same number of elements as there are in the table. I am using that as the primary key so I can not by definition send that a null, it has to be&nbsp;unique.&nbsp;&nbsp; questionable wrote: It seems like I have to define each element and I have to send the same number of elements as there are in the table. No, the...

Duplicate subforms content and key link to another master table key
Hi, Here is the following scenario. I do have a master table with related subforms from wich I need to create a revision. But I need to duplicate the content of the subforms and link them to the new entry in the master table. Each string possess its unique identifier number. So in this case I have a master table with the following structure (simplified) DesiID = Design Unique Identifier Pnum = Project number PPro = Prototype Number PRev = Revision Number FieldN = other fields And subforms attached to the master table by the Unique identifier PartID = Part Unique Identifier DesiID = Link to master table FieldN = Other Fields Both strings are attached ONLY by the DesiID I have the code (see code snippet) that allow me to create the duplicate I need but it keeps attaching it to the original DesiID instead of the new freshly created one by the revision generator. I am scr(..) with this because all new entries remains attached to the original DesiID instead of the new one... Thats my problem ! This is where I need a hand ! Thanks CODE ============================================================================ With Me.RecordsetClone .AddNew ' !PRev = Nz(DMax("PRev", "Design", "[PNum]=" & Me.PNum & " And [PPro]= " & Me.PPro), 0) + 1 !ProjID = Me.ProjID !PNum = Me.PNum !PPro = Me.PPro .Update Dim strSQL...

Can't access duplicate keys with key= in set statement
I'm not sure how to phrase this problem so it's clear, but I'll give it a try. In using the key= option to directly access observations in another dataset, I can't seem to access duplicate index values in the other table. Let me try to explain with an example which, by the way, is directly adapted from the book: Combining and Modifying SAS Datasets. data primary; format salary dollar8.; input empnum @6 salary dollar7.; cards; 1234 $55,000 1234 $66,000 3333 $72,000 4876 $32,000 5489 $17,000 ; data lookup; input empnum taxbrckt; cards; 1111 0.18 1234 0.28 3333 0.32 4222 0.18 4876 0.24 ; proc datasets lib=work; modify lookup; index create empnum; quit; /*salary $55,000 does get "merged" but salary $66,000 does not*/ data no; set primary; set lookup key=empnum; select(_iorc_); when (%sysrc(_sok)) do; net=salary*(1-taxbrckt); end; when (%sysrc(_dsenom)) do; taxbrckt=.; put 'Warning: No tax information for empnum ' empnum; _error_=0; end; otherwise do; put 'Unexpected ERROR: _IORC_= ' _iorc_; stop; end; end; run; title 'Info for salary $66,000 not "merged"'; proc print data=no; run; --------------------------------------------------------------------------- Notice how the variables taxbrckt and net do not have values in the second output observation, indicating that the indexed lookup did not work for the second empnum 1234 in the primary table. This is ...

Displaying Table Field in a report's title-bar ??? don't say it can't |3 done.
I have a Report and am trying to display some Fields from the table that the Report is producing in the title-bar of the window. I try things like: Me.Caption = [TABLE_NAME].[FIELD1] + " " [TABLE_NAME].[FIELD2] I want it to display the first and last name of the person the report is about in the title-bar -- because the data is used for a servay. The name can't be printed--but I'd like it to display in the title bar so that the end user can match the names together. How could I code this in Access? I get alot of wierd errors trying 2 do this? Thanx. P.S. Is there a way to show the user a value in the report, and not allow the printer to print it. I just thought it could be cool to have the name of the person the report is about in the title-bar. I am using Access 2002, and don't mind scripting if i have to. Me.Caption = [TABLE_NAME].[FIELD1] & " " & [TABLE_NAME].[FIELD2] use the ampersand when concatenating fields, the plus sign indicates you are trying to do a mathematical operation ____________________________________________________________________________ ________ select text box you want to hide during print properties format tab display when - change from always to screen only "Franz Kafka" <Symbolics_XL1201_Sebek_Budo_Kafka@hotmail.com> wrote in message news:b3b6b110.0308231302.110cbe7a@posting.google.com... > I have a Report and am trying to display some Fields from the > table that the ...

Web resources about - Why isn't table A always key-preserved if equijoined to the key of table B? - comp.databases.oracle.server

Key sites to be preserved, lest we forget
Key sites to be preserved, lest we forget

DPS Now Says Key Perry Travel Records Preserved
The Texas Department of Public Safety said Monday it had preserved certain travel records associated with the cost of providing security to Gov. ...

DPS Now Says Key Perry Travel Records Preserved
The Texas Department of Public Safety said Monday it had preserved certain travel records associated with the cost of providing security to Gov. ...

Resources last updated: 3/20/2016 7:35:47 AM