select a blob field from differents tables for report

Article View: borland.public.interbase.sql

Article #11146

Back to borland.public.interbase.sql Previous Next

#11146

From: Quique
Date: Tue, 03 Dec 2002 18:30

23 lines
2075 bytes

Hi, i woulk like to know if this is possible:

I would like to get in a stored procedure or a view the data of one table
"master" only that in this table "master" exists a field with the name of
one table of 5 existing in the DB, These tables has a blobl field named
"IMPRE" with differents values only that i have to take the value of the
field in the table that it name is in the "master" table.

The relation is MASTER.NUMEST = [ANYTABLEOFFIVE].NUMEST

So if in one record in the master table, the field "TABLE" is : CONSUL, i
have to take the value of the field "IMPRE" from the table "CONSUL" or if
the field "TABLE" in the master table is : ULTRAS, i have to take the value
of the field "IMPRE" from the table "ULTRAS" and so, existing the other 3
tables where i can take the value of their field "IMPRE"

i'll apreciate any help

thanx in advance

bye

QuiQue

Technical Details

Message-ID: <3decf22a$1@newsgroups.borland.com>

Path:

arc1-ca.pugleaf.net!archiver1.google.com!news1.google.com!sn-xit-03!sn-xit-01!sn-xit-09!sn-xit-08!supernews.com!telocity-west!DIRECTV!newsfeed-west.nntpserver.com!hub1.meganetnews.com!nntpserver.com!newshosting.com!news-xfer1.atl.newshosting.com!news-out.nuthinbutnews.com!propagator2-sterling!news-in-sterling.newsfeed.com!news-in.nuthinbutnews.com!news-spur1.maxwell.syr.edu!news.maxwell.syr.edu!eusc.inter.net!newsfeed01.sul.t-online.de!t-online.de!newsgroups.borland.com!not-for-mail

Show Full Headers

Complete Article Headers

X-Google-Language: ENGLISH,ASCII-7-bit
X-Google-Thread: 114a0e,4143ebe5b98bca24,start
X-Google-Attributes: gid114a0e,public
X-Google-ArrivalTime: 2002-12-03 10:10:06 PST
From: "Quique" <quique_gdlt@puebla.megared.net.mx>
Newsgroups: borland.public.interbase.sql
Subject: select a blob field from differents tables for report
Date: Tue, 3 Dec 2002 12:30:14 -0600
Lines: 25
X-Priority: 3
X-MSMail-Priority: Normal
X-Newsreader: Microsoft Outlook Express 6.00.2600.0000
X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2600.0000
NNTP-Posting-Host: 200.52.215.125
Message-ID: <3decf22a$1@newsgroups.borland.com>
X-Trace: newsgroups.borland.com 1038938666 200.52.215.125 (3 Dec 2002 10:04:26 -0800)
Path: arc1-ca.pugleaf.net!archiver1.google.com!news1.google.com!sn-xit-03!sn-xit-01!sn-xit-09!sn-xit-08!supernews.com!telocity-west!DIRECTV!newsfeed-west.nntpserver.com!hub1.meganetnews.com!nntpserver.com!newshosting.com!news-xfer1.atl.newshosting.com!news-out.nuthinbutnews.com!propagator2-sterling!news-in-sterling.newsfeed.com!news-in.nuthinbutnews.com!news-spur1.maxwell.syr.edu!news.maxwell.syr.edu!eusc.inter.net!newsfeed01.sul.t-online.de!t-online.de!newsgroups.borland.com!not-for-mail