• RELEVANCY SCORE 3.89

    DB:3.89:Search Screen Multiple Tables k8




    Hello,
    is there a way to create a search screen for multiple tables?
    We have tables for:
    - workstation data (model, Name, Inventoryname etc.)
    - Server data (model, Name, Inventoryname etc.)
    - and some other
    No we want to have a start screen, where we can search for e.g. Inventoryname in multiple tables.
    So the user has the possibility to search without using the search screen for the specific table.
    Regards

    DB:3.89:Search Screen Multiple Tables k8

    Can you supply an example of a query that spans all three tables ? Can this be done in the designer or do we need code?

    Thank you

    Kevin

  • RELEVANCY SCORE 3.74

    DB:3.74:Search Every Table In A Schem am




    Does anyone know the correct query to search every table in a query? I am trying to find the same column in multiple tables.

    SELECT specific_column
    FROM All Tables

    DB:3.74:Search Every Table In A Schem am

    a sample of it:

    SQL*Plus: Release 10.2.0.3.0 - Production on Fri Nov 30 15:20:48 2007

    Copyright (c) 1982, 2006, Oracle. All Rights Reserved.

    Connected to:
    Oracle Database 10g Enterprise Edition Release 10.2.0.3.0 - 64bit Production
    With the Partitioning, OLAP and Data Mining options

    SQL set serveroutput on
    SQL Create table abc as select rownum c1 from dual connect by rownum=10;

    Table created.

    SQL Create table xyz as select 5 c1 from dual connect by rownum=10;

    Table created.

    SQL Declare
    2 cnt number(10);
    3 begin
    4 for x in (select table_name from all_tab_columns where column_name='C1') loop
    5 begin
    6 execute immediate 'select count(*) from '||x.table_name||' where c1 = 5' into cnt;
    7 dbms_output.put_line('The count of C1 5 in the table '||x.table_name||' is :'|| cnt);
    8 exception
    9 when
    10 others
    11 then
    12 null;
    13 end;
    14 end loop;
    15 end;
    16 /
    The count of C1 5 in the table ABC is :1
    The count of C1 5 in the table XYZ is :10

    PL/SQL procedure successfully completed.

    SQL

  • RELEVANCY SCORE 3.73

    DB:3.73:Ultra Search( All Tables In Database) sa




    Is it possible to search the entire datase using the Ultra search.

    i read in article that we can provide the datasource to it as only one single table and map the columns , if we want to search in multiple columns then we have to create the view of those table and give as datasource .

    so if i want to search all the tables in the datasource then how to make it ... is there any alternative way of doing it.

    please provide any source or link related to these kind of search .

    thanx in advance

    DB:3.73:Ultra Search( All Tables In Database) sa

    Thanks a lot satish ..

    i havent used this technology ever before , i just need some clarification thats all...

    based on the article i read:

    Table Sources Comprised of More Than One Table

    "If a table source has more than one table, then a view joining the relevant tables must be created. Ultra Search then uses this view as the table source. "

    here i want to know is it possible to use multiple views at a single time as table source

    just help me out regarding this ..

    thanx in advance

  • RELEVANCY SCORE 3.73

    DB:3.73:How To Join Multiple Tables In Oracle For Example 5 Tables 3a


    How to join multiple tables in oracle for example 5 tables

    DB:3.73:How To Join Multiple Tables In Oracle For Example 5 Tables 3a

    I guess you could also do the following:.... from table1 t1, table2 t2, table3 t3, table4 t4, table5 t5wheret1.columnname = t2.columnnameand t2.columnname = t3.columnnameand t3.columnname = t4.columnnameand t4.columnname = t5.columnname"columnname" being a column in the respective tables that match some criteria you require such as person_id.

  • RELEVANCY SCORE 3.69

    DB:3.69:Which Option To Use To Search Text In Multiple Table Columns jk


    Hi, I have a case where I have 4 db tables. On the UI there is an option to search a keyword from some columns of these 4 tables.
    Table1 = summary, description are the columns user can search on
    Table2 = project_name is the column user can search on
    Table3 = need_by_date is the column user can search on
    Table4 = owner is the column user can search on

    On the UI, user can enter a keyword and check the columns they want to search on. Out of the above, they can check one column, or more, or all.

    My question is what is the best option to use oracle text search in this case.
    Option 1 = I create a procedure to select these columns and then create an index on this procedure. In this case, is there a way to specify
    which columns to search on?
    Option 2= Create 4 separate indexes on these table/columns and then query the columns which user has selected to search on.

    Any other better idea?

    DB:3.69:Which Option To Use To Search Text In Multiple Table Columns jk

    Hi,

    multicolumn only works on columns in the same table.

    If you can also query just on one field, then an index per field will be preferable. If you query always on all the fields then the one index approach is good. For this last the options are:
    1. Use User_datastore, create a procedure and a dummy column
    2. Create a materialized view for the query and build an index on this materialized view
    3. Store the fields as an xml in the main table and index the xml column.

    The maintanance of options 1 and 3 are bigger, because you need triggers to be aware of an update. Option 2 and 3 will need more storage.

    Herald ten Dam
    http://htendam.wordpress.com

  • RELEVANCY SCORE 3.61

    DB:3.61:How Do You Create Single Lookup Transformation Using Multiple Tables? xp



    Hello everyone,

    How do you create single lookup transformation using multiple tables?

    DB:3.61:How Do You Create Single Lookup Transformation Using Multiple Tables? xp


    use Lookup Override. this is the best way to join the multiple tables in a single lookup transformation

  • RELEVANCY SCORE 3.50

    DB:3.50:Insert Into Multiple Tables 1j


    Can someone tell me the syntax / example of INSERT into multiple tables with one SQL statement ? Thanks.

    -Pat

  • RELEVANCY SCORE 3.47

    DB:3.47:Help Building Search Engine f8


    Hi Guys,

    I'm building a site using JSP, Servlet, and MySQL 5.0.
    In my site user store their information in the database, in multiple tables (tbl_personal_details, tbl address,,,etc.)

    I need your help to build Search Engine that searchs and display the information from the database. Just I need links, tutorial, or software that help me build the search engine in my site.

    Thanx,

    DB:3.47:Help Building Search Engine f8

    Check out

    http://lucene.apache.org/java/docs/index.html

  • RELEVANCY SCORE 3.41

    DB:3.41:Re: Intergration Services 7j


    Adding multiple tables in the EIS doesn't create tables on the SQL side?

    DB:3.41:Re: Intergration Services 7j

    You are right, I did want the year with the Qtr. I did use the user defined table and it works. I wasn't using the functionality to concatenate, it was doing it on it's own. What was weird was, it wouldn't work properly in the outline if you used the hierarchy I built in the model. I had to pull the members one by one into the outline and create the hierarchy that way. It works now fine.....I just don't understand why it wouldn't work with the pre-built hierarchy. It doesn't make sense to me because when you drag/drop the hierarchy or drag/drop the members to create the hierarchy.....it's still the same hierarchy!!!

  • RELEVANCY SCORE 3.36

    DB:3.36:Multiple Insert x7


    How to insert values into multiple tables..

    thanks in advance

    DB:3.36:Multiple Insert x7

    http://download.oracle.com/docs/cd/B19306_01/server.102/b14200/statements_9014.htm#i2125362

  • RELEVANCY SCORE 3.30

    DB:3.30:Creating An Oracle Text Index On Multiple Columns From 3 Different Tables f3


    I need to create an index on 3 tables:

    Table A
    col1
    col2
    col3

    Table B
    col1
    col2
    col3

    TABLE C
    col1
    col2

    This index should get the values if any matching word is found in either of the 3 tables.

    For example

    If I do a search for col1 = 'ALEX' the query should look for the records from all the 3 tables which have anything similar to 'ALEX in either of the 3 tables in any of the columns.

    Can someone please suggest me how to implement this ?

    Thanks

    Kevin

    DB:3.30:Creating An Oracle Text Index On Multiple Columns From 3 Different Tables f3

    scott@ORA92 create table a
    2 (col1 varchar2(10),
    3 col2 varchar2(10),
    4 col3 varchar2(10))
    5 /

    Table created.

    scott@ORA92 insert into a values ('BUSH', 'ALEX', 'SR')
    2 /

    1 row created.

    scott@ORA92 create table b
    2 (col1 varchar2(10),
    3 col2 varchar2(10),
    4 col3 varchar2(10))
    5 /

    Table created.

    scott@ORA92 insert into b values ('BUSH', 'ALEX', NULL)
    2 /

    1 row created.

    scott@ORA92 create table c
    2 (col1 varchar2(10),
    3 col2 varchar2(10))
    4 /

    Table created.

    scott@ORA92 insert into c values ('ALEX', 'WOODLAND')
    2 /

    1 row created.

    scott@ORA92 create materialized view mv_a_b_c as
    2 select col1 as names from a
    3 union
    4 select col2 as names from a
    5 union
    6 select col3 as names from a
    7 union
    8 select col1 as names from b
    9 union
    10 select col2 as names from b
    11 union
    12 select col3 as names from b
    13 union
    14 select col1 as names from c
    15 union
    16 select col2 as names from c
    17 /

    Materialized view created.

    scott@ORA92 create index search_idx on mv_a_b_c (names)
    2 indextype is ctxsys.context
    3 /

    Index created.

    scott@ORA92 select token_text from dr$search_idx$i
    2 /

    TOKEN_TEXT
    ----------------------------------------------------------------
    ALEX
    BUSH
    SR
    WOODLAND

    scott@ORA92 set autotrace on explain
    scott@ORA92 select * from mv_a_b_c
    2 where contains (names, 'ALEX') 0
    3 /

    NAMES
    ----------
    ALEX

    Execution Plan
    ----------------------------------------------------------
    0 SELECT STATEMENT Optimizer=CHOOSE (Cost=2 Card=1 Bytes=14)
    1 0 TABLE ACCESS (BY INDEX ROWID) OF 'MV_A_B_C' (Cost=2 Card=1 Bytes=14)
    2 1 DOMAIN INDEX OF 'SEARCH_IDX' (Cost=0)

    scott@ORA92 select * from mv_a_b_c
    2 where contains (names, 'BUSH') 0
    3 /

    NAMES
    ----------
    BUSH

    Execution Plan
    ----------------------------------------------------------
    0 SELECT STATEMENT Optimizer=CHOOSE (Cost=2 Card=1 Bytes=14)
    1 0 TABLE ACCESS (BY INDEX ROWID) OF 'MV_A_B_C' (Cost=2 Card=1 Bytes=14)
    2 1 DOMAIN INDEX OF 'SEARCH_IDX' (Cost=0)

    scott@ORA92 select * from mv_a_b_c
    2 where contains (names, 'BARBARA') 0
    3 /

    no rows selected

    Execution Plan
    ----------------------------------------------------------
    0 SELECT STATEMENT Optimizer=CHOOSE (Cost=2 Card=1 Bytes=14)
    1 0 TABLE ACCESS (BY INDEX ROWID) OF 'MV_A_B_C' (Cost=2 Card=1 Bytes=14)
    2 1 DOMAIN INDEX OF 'SEARCH_IDX' (Cost=0)

    scott@ORA92 set autotrace off
    scott@ORA92

  • RELEVANCY SCORE 3.29

    DB:3.29:Optmization In Multiple Search Scenario c1


    I have a situation where the tables have more than 500 columns and users haveprivilegesto construct dynamic query using an application.
    we need to optimize search in this scenario. I can't create indexes on all columns or even a single index for all columns. also we need to do this with out changing the database schema and application.Cheers!!! SqlFrenzy

    DB:3.29:Optmization In Multiple Search Scenario c1

    thanks...will check it out. I know the thing regarding 500 cols. I was planning to shift to analysis services as these databases are only used for select queries. its not code....its the user who choose from application to get specific data...the query
    is then constructed on the fly through the application.Cheers!!! SqlFrenzy

  • RELEVANCY SCORE 3.29

    DB:3.29:Re: Catsearch Multiple Table k1


    Q1) Is it possible to create 1 CTXCAT index across many tables?No.

    Q2) Would I be able to emulate above CTXCAT index with conventional b-tree index using like search?No.

    You could use a context index with a user_datastore and a procedure to join the data from the tables, then search using contains. If you search the online documentation and this forum for user_datastore, you will find many examples. Another alternative is to create a materialized view that joins the tables and create your index on that.

    DB:3.29:Re: Catsearch Multiple Table k1

    My tables are joined through union and we already have materialized view but we are looking for ways to revamp it. The materialized view has individual names and organization names.
    SELECT BUS_NAME
    FROM
    (
    SELECT
    BUS_NAME
    FROM
    IA_OTHER_BUS_NAME
    WHERE
    ORGANIZATION_ID = IORGID
    UNION
    SELECT
    ORG_NAME
    FROM
    ORG_OTHER_NAME
    WHERE
    ORGANIZATION_ID = IORGID
    UNION
    SELECT
    ORG_DBA_NAME
    FROM
    ORG
    WHERE
    ORGANIZATION_ID = IORGID
    UNION
    SELECT
    ORG_APLCT_NAME
    FROM
    ORG
    WHERE
    ORGANIZATION_ID = IORGID
    ...
    )Typically we run following queries
    select SEARCH_NAME from SEARCH_NAME_MV
    where catsearch ( SEARCH_NAME, 'MA* .*', null ) 0

    MARIA . NAKHLEHA
    LAINIE MALHOTRAE .
    MATTHEW CHRISTOPHER BEAUIEU .
    JOAN MAREN . GRAY
    .CAROL A. MARTINE

    select SEARCH_NAME from SEARCH_NAME_MV
    where catsearch ( SEARCH_NAME, 'AME* LOR*' , null ) 0

    LORETA AMEILA ANDERSON
    LORETA AMEILA PACE
    CANDACE AMEILA LORA MACCARONE
    CANDACE AMEILA LORA HUCK
    LOREN PAUL AMEN
    CARLA AMELIA ROMER LORA
    LORI GUNDER AME I had also provided preference for the text index in the beginning of the thread. We choose CTXCAT instead of CONTEXT because we thought CTXCAT index would be more suitable to search for Names(Varchar2(200)) , which is more like catalog type search. Another reason is it is trasactional

    Could you please tell me why would you choose CONTEXT or regular index over CTXCAT ?

    I greatly appreciate your time.

  • RELEVANCY SCORE 3.28

    DB:3.28:How To Join Multiple Tables ! k1



    Give me the Example to join multiple tables 1

    DB:3.28:How To Join Multiple Tables ! k1


    check this thread...

    joins...

    Regards,

    Chandru

  • RELEVANCY SCORE 3.28

    DB:3.28:Search Abap Programs, Functions, Tables px



    Hi ,

    I need your help, I am trying to find out the best ways to search inside ABAP programs, Functions and Tables.

    for the ABAP programs:

    Scan across multiple programs:

    I am using RS_ABAP_SOURCE_SCAN but it is very slow and actually crashes when you want to search the entire system.

    Scan inside Single Program :

    SE38 - Utilities Menu - Find in source code

    for Functions:

    I am using SE37, Utilities Menu -Find . I can only search inside function names or descriptions , but not for the actual code of the function.

    I need your suggestions regarding the best ways to search inside ABAP programs, Functions and Tables.

    I am reading about TREX but I am not sure if TREX can be used to search for the ABAP programs, Functions or tables !?

    is TREX separate product that I need to install ?

    I am using Netweaver 7.01 ABAP and it has the TREX admin tool, but I am not sure if this is enough !

    Thanks

    Misbah

    DB:3.28:Search Abap Programs, Functions, Tables px


    Hi Misbah ,

    Check the standard report RSDEMO_EVENT_ON_FIELD

    using this report u can select more then one category like

    u can find out FM,Report,Package,Class,Local object etc

    Edited by: krupa jani on Aug 18, 2009 7:52 AM

  • RELEVANCY SCORE 3.27

    DB:3.27:Full-Text Search Over Mutiple Tables af


    Hi,
    I'm just wondering if someone could help me with figuring out how to perform a search over mutiple full text indexed tables in the same database?
    Here's my query on one table that works, I need to expand it to over multiple tables. 
    sqlComm.CommandText = SELECT RANK, intID, chTitle, txtBody, chLink, intProfID +                                               FROM FREETEXTTABLE ( tblPortfolio, *, 'ISABOUT( + strSearchText + WEIGHT(1.0))') a + JOIN tblPortfolio b on a.[KEY] = b.intID + ORDER BY RANK DESC; ;
     
     
     

    DB:3.27:Full-Text Search Over Mutiple Tables af

    Without table schema, sample data, and expected output, it's hard to know what you're looking for.Depending on how/what you want with the data, a simple union all should do.e.g.SELECT RANK, intID, chTitle, txtBody, chLink, intProfIDFROM FREETEXTTABLE ( tblPortfolio, *, 'ISABOUT( + strSearchText +  WEIGHT(1.0))') a  JOIN tblPortfolio b on a.[KEY] = b.intID  union allSELECT RANK, intID, chTitle, txtBody, chLink, intProfIDFROM FREETEXTTABLE ( TBX, *, 'ISABOUT( + strSearchText +  WEIGHT(1.0))') a  JOIN TBX b on a.[KEY] = b.intID  ORDER BY RANK DESC;

  • RELEVANCY SCORE 3.26

    DB:3.26:Multiple Exchange Rate Tables z1



    ommitt

  • RELEVANCY SCORE 3.22

    DB:3.22:Add And Search In Multiple Tables The Easy Way??? j1


    Hi,
    I'm still quite new to JDBC, SQL, and database design.
    I'm creating a web application to transfer funds using java servlets, jdbc, and mysql.
    My database has the tables:
    user, -- username, password
    owns -- foreign key for username and acctID
    accountBalance -- acctID, balance

    What is the simplest way to add a user to all 3 tables at once?
    What is the simplest way to search for the user's balance to display it?

    Thanks in advance.

    DB:3.22:Add And Search In Multiple Tables The Easy Way??? j1

    Thanks for the reply.

    I thought I could get around from having to insert a new user account to each table but I guess not.

    Thanks for the reassurance.

  • RELEVANCY SCORE 3.22

    DB:3.22:Multiple Joins With Ibatis dd


    Hi;

    I Search an example of code source with mutltiple joins implying lists :

    T1 = 1..*T2 = 1..*T3 = 1..1 T4 or any exemple with several tables and java beans and list of objects.

    Regards;

    DB:3.22:Multiple Joins With Ibatis dd

    Hi;

    I Search an example of code source with mutltiple joins implying lists :

    T1 = 1..*T2 = 1..*T3 = 1..1 T4 or any exemple with several tables and java beans and list of objects.

    Regards;

  • RELEVANCY SCORE 3.21

    DB:3.21:User_Datastore And Xml Docs In Multiple Tables zd


    Hi, I have a question about user_datastore. My Oracle version is 10.2.0.3.

    If I'm not wrong it's usefull above all when i'm trying to concatenate informations from differents columns stored in differents tables that are in some way related each other.

    I have differents XML docs stored into XMLTYPE cols based on different schemas. I would like to create a context index to make full-text search over all these docs.

    Is there a way to use USER_DATASTORE? Consider that due to my data it doesn't make sense to concatenate this XML docs that are stored in different tables. I would need something like e UNION.

    Should I instead create a materialized view or create an index for each tables as suggested How to compute a global SCORE over a few oracle text indexed tables? ?

    Thanks

    DB:3.21:User_Datastore And Xml Docs In Multiple Tables zd

    Only now I had time to watch your message and it's a good solution to my problem.

    Thanks.

  • RELEVANCY SCORE 3.21

    DB:3.21:Multiple Independant Routing Tables x8



    Can the Catalyst 4500 support more than one routing table .

    DB:3.21:Multiple Independant Routing Tables x8

    No, there is only one routing table. What is it you are trying to achieve? Maybe there is another way.

    Kevin Dorrell

    Luxembourg

  • RELEVANCY SCORE 3.21

    DB:3.21:Query Output Table Including Multiple Kinds jf



    I know that multi-kind queries normally result in 2-layer reports where the end user has to drill down to view multiple subgroup tables, one for each kind.

    Is there a way that I could run a multi-kind query which SHOWs attributes that are common for the kinds, where the results would display in a single table? The following attempts do not work:

    SEARCH NetworkDevice WHERE name matches "^w" AS q1
    SEARCH Printer WHERE name matches "^z" AS q2
    SEARCH IN (q1 OR q2) SHOW name

    (For some reason the simplest search clauses, like 'SEARCH NetworkDevice WHERE name matches "^w"' do not generate usable "node sets" according to this documenation).

    ------------------------------------

    SEARCH ManagedElement WHERE name matches "^[wz]" SHOW name

    (Apparently virtual classes can't be used in queries, since "SEARCH ManagedElement" returns no rows when subkind nodes are present).

    DB:3.21:Query Output Table Including Multiple Kinds jf


    You must search on the node kind you are interested in, inheritance is not visible within the search service. You can use the search flag no_segment to prevent splitting the results into different node kinds. You can also provide a list of node kinds from where to start.

    SEARCH FLAGS(no_segment) NetworkDevice, Printer

    WHERE name matches "^[wz]"

    SHOW name

  • RELEVANCY SCORE 3.21

    DB:3.21:Help Building Search Engine fx


    Hi Guys,

    I need your help to build a Search Engine which enables the users of my site to search for details storde in multiple tables in MySQL 5.0 database. for ex. (tbl_address, tbl_personal_info,,,,etc.)

    I'm bulding my site using JSP and Servlet technologies, and I almost finished, and I need your help in building the search engine, code, tutorials, or links to sites discuss this issue.

    Thank you for your help........

    DB:3.21:Help Building Search Engine fx

    Hi Guys,

    I need your help to build a Search Engine which enables the users of my site to search for details storde in multiple tables in MySQL 5.0 database. for ex. (tbl_address, tbl_personal_info,,,,etc.)

    I'm bulding my site using JSP and Servlet technologies, and I almost finished, and I need your help in building the search engine, code, tutorials, or links to sites discuss this issue.

    Thank you for your help........

  • RELEVANCY SCORE 3.20

    DB:3.20:Using Sql To Search Multiple Tables And Columns For Search Function d1


    Hello, Im making a search function for an application and they need to be able to search by any value in the DB in any of the three tables. Im wondering the best wayto about this. 2 of the 3 tables have the same columns while the last one is totally different. Below is what I kinda thought itd look like but no. SELECT * FROM cases, opencases, staff WHERE Crime =' txtsearch.Text.ToString ' I need to query the results the user can search for anyterm and if it matches something in the columns it return it to the user. Im wondering if the best way to go about this is to maybe query all the tables and then put all the matching records in a seperate table and the dgv look at that table or how to exactly go about it. That seems like more trouble then its worth, if I dont come up with a solution Im just going to end up putting options for the user to select to search by lol. Any ideas? Thanks

    DB:3.20:Using Sql To Search Multiple Tables And Columns For Search Function d1

    Hi Seth Hall,Welcome to MSDN forums!1. Firstly let me demonstrate the code sample: How to search database based on your criteria and display result on DataGridView. (Take MS Access database for example)

    Imports System.Data.OleDb
    Public Class Form1
        Private Sub Form1_Load(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles MyBase.Load
            Dim con As OleDbConnection = New OleDbConnection(Provider=Microsoft.jet.oledb.4.0;data source=C:\MyDB.mdb)
            Dim cmd As OleDbCommand = New OleDbCommand(SELECT * FROM CasesTable WHERE Crime =' txtsearch.Text.ToString ', con)
            con.Open()
            Dim myDA As OleDbDataAdapter = New OleDbDataAdapter(cmd)
            Dim myDataSet As DataSet = New DataSet()
            myDA.Fill(myDataSet, MyTable)
            DataGridView1.DataSource = myDataSet.Tables(MyTable).DefaultView
            con.Close()
            con = Nothing
        End Sub
    End Class

    2. they need to be able to search by any value in the DB in any of the three tables. Im wondering the best wayto about this.I need to query the results the user can search for anyterm and if it matches something in the columns it return it to the user.- It would be better to elaborate your question.If you want to query in any one table of the three tables, you can add these table name into a ComboBox as items, then use this SQL statement:
      Dim cmd As OleDbCommand = New OleDbCommand(SELECT * FROM ' ComboBox1.Text ' WHERE Column1 =' txtsearch.Text.ToString ', con)If you want to query in multiple tables based on your criteria, you can consider this SQL statement:  Dim cmd As OleDbCommand = New OleDbCommand(SELECT * FROM Table1,Table2, Table3 WHERE Table1.Column1 =' TextBox1.Text 'OR Table2.Column1 =' TextBox2.Text ' OR Table3.Column1 =' TextBox3.Text ', con)
    Best regards,Martin XiePlease remember to mark the replies as answers if they help and unmark them if they provide no help.
    Welcome to the All-In-One Code Framework! If you have any feedback on our support, please contact msdnmg@microsoft.com

  • RELEVANCY SCORE 3.19

    DB:3.19:Visual Basic Programming sz


    search multiple access tables and add data using visual basic 2010 coding

    DB:3.19:Visual Basic Programming sz

    I miss that the others show this thread to you, it gives good information how to get your problem solved.
    http://social.msdn.microsoft.com/Forums/en-US/vbgeneral/thread/36cfcded-06ea-4163-9c82-1bf35c510c6dSuccess
    Cor

  • RELEVANCY SCORE 3.19

    DB:3.19:Benefits Of Having Multiple Main Tables jk



    Hi All,

    I would like to see what users have experienced with multiple Main Tables in a repository in MDM 7.1 in the areas of:

    - Data model

    - Search, querying

    - Performance

    - Any limitations?

    - Has anyone tried adding custom main tables in the Procurement Catalog scenario?

    Thanks,

    David

    DB:3.19:Benefits Of Having Multiple Main Tables jk


    Hello David,

    First explain with a scenario, for the usage of Multiple Main Table.

    Lets say you have two seperate repositories Product repository and Customer Repository, whre you have to maintain these two.

    the advantage of Multiple main Table is lets say certain product have to be deleverd to a perticuler customer, at that time you can have two main tables one as Product and another as Customer and basic rule of Main table is we maintain the Initial data like Name, address,Base unit etc.

    Which avoids the maintenance of two repositories and in a single repository you can have the details and syndicate the same to Remote system in one show.

    Hope it gives bit idea on its usage.

    Regards,

    Girish

  • RELEVANCY SCORE 3.19

    DB:3.19:Sql Server 2008 Full Text Search Internal Index Tables And Performance Issue f9


    I have installed full-text search on a Microsoft SQL Server 2008 enterprise server to be able to index and easily search across multiple tables. The indexing/searching works perfectly. Now, I want to add an auto complete feature that suggests words as
    the user types in the search input box (like Google, Bing). I have the UI working but I have a performance problem.

    DB:3.19:Sql Server 2008 Full Text Search Internal Index Tables And Performance Issue f9

    For that coding algorithm , I do think it suffers basically from the usage of TVF where no sufficient index is
    there and thereby any relevant search on its columns particularly more if there :

    1.
    Free Search by name
    LIKE
    'test%'.

    2.
    Union commands are used there

    Which both consume performance resources and perhaps might be reach to a culprit point of performance for huge data entity .

    What probable assumptions here
    :

    Use CTE expression

    To switch over all business logics of TVF to this CTE expression.

    Keep these filters as
    LIKE
    'test%'
    inside CTE.

    Then Optimize indexes well for the new query execution plan.

    Please work out that and please let me know your input

    Think more deeply of performance terms

  • RELEVANCY SCORE 3.18

    DB:3.18:Join Tables And Replicate (Multiple Rows) cd


    Hi,

    i have two tables TAB1 (A, B, C) and TAB2 (C, D)
    i want to join the tables and replicat such that the resultant table TAB3 has columns A, B, D

    select x.a, x.b, y.d from tab1 x join tab2 y on x.c=y.c where y.d=1;

    but the problem here is that the above command gives multiple rows and i need all those to be in the target table. When i am using SQLEXEC-QUERY in the mapping, only the first search result is being entered into the TAB3. Then i Found out that sqlexec will return only one value. But i need all the search results to be replicated.
    What alternatives are there and what GG recommend in such use case?
    Any helpful advice is much appreciated.

    thanks,

    Oracle Database 11g Enterprise Edition Release 11.2.0.1.0 - 64bit Production

    DB:3.18:Join Tables And Replicate (Multiple Rows) cd

    Thanks Nick Thanks Joe for your suggestions.

    But i didnt quite understand the concept of RESOLVECONFLICT ... i tried looking it up but couldnt figure out how to work with that in this scenario. It would be really helpful if you could elaborate a little more. Thanks in advance.

    And Joe, currently i am trying with staging tables only but i want to explore other options ... mainly using a filter. Because when i tried with filtersqlexec the problem i faced was that sqlexec returns only single row instead of returning all the columns in the view genrated(as i described in the first post). If i can figure out a way to work around this problem it will be useful in my future projects.

  • RELEVANCY SCORE 3.16

    DB:3.16:How To Display Data From Multiple Tables At Once. mc


    I was wondering how i would go about showing data from multiple tables. I thought of making a Link table to then use in LightSwitch but I'm not quite sure how to go about it. My situation is I'm building a search for the Claims department that will also
    show the information of the contract, and information of the repair facility. Claims is already linked to both by contract id and facility id. I was wondering if i should make a claimAndContractAndRepairFacilityLink table to maybe be able to display data from
    all 3 tables? I'm not quite sure how queryies transfer over into LightSwitch or if lightswitch can even pull information onto one screen from multiple tables.

    DB:3.16:How To Display Data From Multiple Tables At Once. mc


    Do you have LightSwitch relationships defined between the Claims table and the contract/factility tables? Instead of just having Claims hold a contract id property, you should click the Add Relationship button at the top of the table designer.
    There you can model a relationship between the two tables.
    Once you have a relationship defined between the tables, you can now easily add a screen for the Claims table, and show data from related tables. You can even display information from both tables inside the same grid. In order to do that, follow
    my instructions here
    http://social.msdn.microsoft.com/Forums/en-US/lightswitchgeneral/thread/73d86589-3ab4-4949-91c6-c315dba51fe9

    This solved my problem thank you very much. The relationships where there i just did not know you had to name the fields as such.

  • RELEVANCY SCORE 3.16

    DB:3.16:Full Text Search Result Ranking Across Multiple But Similar Tables 11


    Hello,
    I have a very large table that I had to break up into smaller tables and then full-text index it.
    Example:
    Very Large Table:                            T1
    T1 broken into smaller tables:        S1, S2, S3 S4 where the content of S1+S2+S3+S4=T1
    S1-S4 tables all have the same columns i.e. Col1 and Col2.
    I have individually created a unique index on Col1 of S1 through S4 tables.
    I have individually full-text indexed Col2 of the S1 through S4 tables. 
    To perform a full-text search query with ranking on the one of these tables I do the following: 
    SELECT
                    S1.*,
                    KEY_TBL.RANK
    FROM
                    S1
                    INNER JOIN  CONTAINSTABLE
                                    (
                                                    S1,
                                                    *,
                                                    N'test',
                                                    500
                                    ) AS KEY_TBL 
            ON S1.Col1 = KEY_TBL.[KEY]
    Order by
                      KEY_TBL.RANK;
     
    How can I extend the above query to perform the same search on S1 through S4 and rank the result across all the 4 tables?
    I do realize that the ranking function in SQL Server (presumably Okapi BM25) logically makes sense if its performed within the context of a single table (not a series of tables). But then, perhaps, there could be an algorithm that performs a relative re-ordering of ranking results across multiple tables (all other variables being the same).
    If this cumulative ranking query is not possible, is there a different path I can take (short of reverting back to the T1 table and indexing it).
    Thanks,
    Tareen

    DB:3.16:Full Text Search Result Ranking Across Multiple But Similar Tables 11

    You can't expect to get meaningful results when you do something like this. You might want to try to put an indexed view over all the tables. This will give you a consistent rank.looking for a book on SQL Server replication? http://www.nwsu.com/0974973602.html

    looking for a book on SQL Server 2008 Administration? http://www.amazon.com/Microsoft-Server-2008-Management-Administration/dp/067233044X

    looking for a book on SQL Server 2008 Full-Text Search? http://www.amazon.com/Pro-Full-Text-Search-Server-2008/dp/1430215941

  • RELEVANCY SCORE 3.16

    DB:3.16:Integrating Lucene d8


    I want to provide a very thorough search mechanism for my app, to search across multiple uploaded documents and document types. I'm considering using Lucene to provide this functionality, with all uploaded files stored in MySQL.

    Does anyone have experience in doing this, and if so, could you provide some pointers?

    Things I'm interested in are;

    How to call Lucene - preferably with as little coding as possible
    Integrating the search results into JSC tables
    Any general observations - or even better options for search

    Thanks in advance

    DB:3.16:Integrating Lucene d8

    Hi Fatmal,
    Sorry because my reply it's only for a question.
    I have a very similar configuration in my app(a web in JSC with Mysql and files).

    have you any example for uploading multiple files in a one action?
    My post is the HELP WIT FILE UPLOADING
    thank's in advance!

  • RELEVANCY SCORE 3.15

    DB:3.15:Searching Slicers Or Linking Filters To Multiple Pivot Tables cz


    Hello,
    Is there any way to allow the user to search the Slicer? We have a slicer that contains a lot of values, and it is linked to multiple pivot tables. If there is no way to search them, a Report Filter provides a search function but how can Ishareitwith
    multiple pivot tables?
    Essentially I'm trying to set up a page with a set of slicers (or filters if necessary) that set the criteria for a number of charts based on different pivot tables.
    Thanks

    DB:3.15:Searching Slicers Or Linking Filters To Multiple Pivot Tables cz

    Thank you for the reply. I'll take a look at using formulas.

  • RELEVANCY SCORE 3.15

    DB:3.15:Update On Data From Multiple Tables ax


    How can i update data from multiple tables(Using a Join)
    using a single update statement.

  • RELEVANCY SCORE 3.15

    DB:3.15:Extracting Data From Multiple Tables c7



    how to extract data from multiple tables? plz give sample code

    DB:3.15:Extracting Data From Multiple Tables c7


    To perform selection from multiple tables, check for the common fields preferably key fields are required to establish the relationship.

    You can achieve it by using Joins/for all entries.

    Joins(Preferably Inner Joins) is really a good approach.

    Check this query.

    Here I am using two tables MKPF and MSEG.

    MKPF(Material Document Header)

    MSEG(Material Document Segment)

    Both the tables contains the common fields MBLNR and GJAHR.

    Now check the query.

    select amblnr agjahr bmblnr bgjahr bmatnr bmenge bmeins from mkpf as a inner join mseg as b on amblnr = b~mblnr where mblnr in select-options

    Now here you can place several conditions based on your program. "a" is called the alias name for MKPF table and "b" is called as the alias name for MSEG table.

    Similarly you can establish the link with several tables. Now based on the material in MSEG table You can establish link to MARC(Plant data) etc.

    It is very similar for adding the other tables in the same select query, but follow the rules of establishing links using joins.

    Also follow the "Indexes" properly so that database performance is optimized.

    Regards,

    Santosh Kumar M.

  • RELEVANCY SCORE 3.13

    DB:3.13:Dql To Insert Multiple Rows In Registered Tables?? pp



    HI everyone

    Is there a DQL to insert multiple rows in registered tables ??

    DB:3.13:Dql To Insert Multiple Rows In Registered Tables?? pp


    Hi,

    You can write all your dql insert statements into a dql script and call dql script from your code or run the script from idql.

    Eg:

    insert into dm_dbo.tablename values ('A','B')

    go

    insert into dm_dbo.tablename values('X','Y')

    go

    Save this dql script and call this from idql located at $DOCUMENTUM/product/6.5/bin

    Hope it helps.

    Rajalakshmi

  • RELEVANCY SCORE 3.13

    DB:3.13:Search Across Tables j1



    How do I search accross many tables?

    DB:3.13:Search Across Tables j1


    I would echo other wise advice you have received under this question and suggest you take a look at this recent thread on Single Table Architecture

    https://fmdev.filemaker.com/message/160877

    Then - having thought carefully about the advice you have received - what you could do very easily given the nature of your data - which I believe has one table for each book of the Bible (?) - is this:

    (1) Create a new file in FM13 - with an appropriate theme for your content - and import a typical table from your existing solution

    (2) Add a key field which will serve to identify the Book from which data is derived (use an alphanumeric key) and either a second field to hold the textual name of the relevant Book - or - a little more complex but better in the long run - a second table to just hold the book names linked by the new key field

    (3) Import the data from one short Book table in the old system - I imagine each verse is a record - on an isolated import layout for speed - ie. based on a Table Occurrence with zero relationships - and add your Book Identifiers using Replace or something similar and deal with the Book Name as above

    (4) now build how you will search it - experimenting with this small data set - I use portal filters for this sort of thing - others will prefer other methods - see my recent piece on how to build a good portal filter here

    https://fmdev.filemaker.com/message/163067

    (5) Test it on WebDirect - if you have access to FMServer13 and perhaps fine tune your Theme styles if required

    (6) Finally import each of your other Books in turn - marking the set of records from each with their alotted Book Identifier and Book Name

    You now have your entire data set in a single table and can do whatever you wish with it - including search it all - and only have 1 table and layout to maintain and improve - not 66.

    This method and the inherant simplicity you are creating will not take you long - since you only need do things once and its plays to Filemaler's inherant strengths - it also - if you use FMS13 and WebDirect - gives you an easy means of making your system accessible on mobile device - so someone can search for Biblical quotes on their iPhone - for example.

    This process is refered to traditionally as data normalisation in that you reduce your data to the simplest structure that fits its real character and here - of course - each Book in the Bible is structurally the same as any other Book - just the data differs - which is why they are normally published in a traditional normalised structure called a Book - in the printing sense as opposed to the Biblical sense.

    Do feedback what you actually do - I am sure that we will all be interested to see you reach a great result.

    Cheers, Nick

  • RELEVANCY SCORE 3.13

    DB:3.13:Fuzzy Search On Multiple Words. fs


    Hi,

    I have successfully created context index with user_datastore on multiple columns in different tables and queried database with fuzzy search on single word such as 'dog'. When I did fuzzy search using multiple words like 'bread winer restrant', it threw out the error message. My question is 'May i apply fuzzy search function in oracle text on a phase?'. If I can not, does that mean I have to break the phase into tokens and do fuzzy search on each tokens? Thanks very much for your reply!

    Susan

    DB:3.13:Fuzzy Search On Multiple Words. fs

    Hi,

    I have successfully created context index with user_datastore on multiple columns in different tables and queried database with fuzzy search on single word such as 'dog'. When I did fuzzy search using multiple words like 'bread winer restrant', it threw out the error message. My question is 'May i apply fuzzy search function in oracle text on a phase?'. If I can not, does that mean I have to break the phase into tokens and do fuzzy search on each tokens? Thanks very much for your reply!

    Susan

  • RELEVANCY SCORE 3.13

    DB:3.13:Dropping Multiple Tables x1


    How to drop multiple tables in a single sql statement in oracle 10g database....?

    DB:3.13:Dropping Multiple Tables x1

    How to drop multiple tables in a single sql statement in oracle 10g database....?spool drop_many_tables.sql
    select ' drop table '||table_name|| ' purge;' from user_tables;

    spool off

    @drop_many_tables.sql

    -Anantha

  • RELEVANCY SCORE 3.13

    DB:3.13:Search Functionality Of String On Multiple Tables p9


    Hi,

    We are actually in the process of implementing search functionality for database

    im stuck up at a particular location

    1) i have a "SEARCH" Table which contains columns (table_name,Column)

    2) when user wants to search for particular string(Say "ora")
    There are chances that in Table1 i can get 2 records, Table2 - 10 records, Table3- 50 records and so on..

    i have the logic for Retrieving the data from particular table on search condition, but how do you exactly retrieve the data from N number of tables for same search condition?

    What is the best possible method?

    Hope so i was clear..

    Regards,
    ~ Sri

    DB:3.13:Search Functionality Of String On Multiple Tables p9

    Hi, Sri,

    sri_ora wrote:
    Hi,

    I have a table "SEARCH" with Columns

    1) table_name varchar2(100)
    2) Column_name varchar2(100)( It can be multiple Columns)
    3) Primarykey_id number
    4) Search char(1) Check Constraint 'Y','N'(This is given dynamically)Sorry, I don't understand what this means. Do you want to pass 'Y' or 'N' at run-time? If so, what is the purpose of the column search.search?

    'Y' - Like (Pattern Matching)
    'N' - ContainsI don't understand this, either. Give specific examples that show the difference between 'Y' and 'N'.

    When the user searches for string "ora"

    select table_name,column_name from search where search LIKE 'ORA'

    NOTE:It can be in N number of columns of the same table OR
    It can be in N number of columns in N different tables

    In "Search" Table,

    table_name Column_name Column_name1 Column_name2 Primarykey_id Search

    A A1 A2 A3 1
    B B1 B2 B3 2
    C C1 C2 C3 3 Earlier, you said the search table had four columns. Now you say it has six. Which is it?
    When you said that column_name "can be multiple Columns" did you mean that it is some kind of list, such as 'A1,A2,A3'?

    I have 100 records in Table A, now after search criteria('ORA') i could get 10 records matching on different columns of same table(A).Please post a few rows of sample data from table_a, as I requested before.
    Make sure the sample data includes any special cases. (For example, several columns in different tables all meet the search criteria.)

    Each Column has an id that i need to retrieve that and pass to function?Sorry, I don't understand.
    Please post the results you want to get from your sample data, as I requested before.
    If some of the results come from a user-defined function, explain. (For example, "the last column that I want in the output is the result of a user_defined function my_fun. That column is 350 in the first row, because table_a.id = 35 in the first row, and my_fun (35) returns 350."

  • RELEVANCY SCORE 3.11

    DB:3.11:Searching Multiple Mysql Tables, Joins? cc



    I'm creating a mysql keyword search on my website and I know how to search a single mysql table, my problem is I need to search 15 different tables simultaneously, they also all have the same column names. I was told I have to you JOINS but i've never used them before. How is this done?

    MY SQL SELECT:

    SELECT *

    FROM mytable1

    WHERE keyword LIKE %colname% OR id LIKE %colname%

    DB:3.11:Searching Multiple Mysql Tables, Joins? cc


    OK, that really doesn't answer my question. Just because they are in different categories is not a valid reason. Why can't they be mixed?

    In any case, you could probably use a UNION query to solve the current problem, but I would have to know more about the complete query. You don't want to use a JOIN.

  • RELEVANCY SCORE 3.11

    DB:3.11:How Can I Use Union To Get Multiple Tables? md


    Sir,
    how can i use union to get multiple tables?

    Thanks in Advance.

    DB:3.11:How Can I Use Union To Get Multiple Tables? md

    for an example, I have 3 tables, all fields are the same, except the number of records are more then the other table/s. Objective is to show up the Descriptions , Material, QTY (which are their fields), then QTY sum up together for each table. The desired report is the 3 fields + sum of QTY on the other tables, and then difference of 2 QTY(filed).

    DESCRIPTIONS MATERIALS QTY1 QTY2 QTY3 Q3-Q2
    ----- ------ ------ ---------------------------------------- ----------------- ---------- ----------
    SW FLAN ASTM A105 15 15 20 5
    PL FLAN ASTM A105 40 44 48 3

    Each record on all the 3 tables, the filed QTY, value is 1. The query need to sum up the records that have the same occurance.

    Your kind advise is appreciated.
    Nerdy..

  • RELEVANCY SCORE 3.10

    DB:3.10:Load Multiple Tables On A Single Datagridview a1


    Hi,
     
    Can someone please help me with the following question.
     
    I am trying to load two tables that have a one to many relationship from an access db on to a datagridview in vb.net 2005 but I can only get one table to display.
     
    I would also like users to type search criteria into a text box and the corresponding data from the tables will be displayed into a datagridview.  
     
    Thanks for any help you can give.
     
    Dan 

    DB:3.10:Load Multiple Tables On A Single Datagridview a1

    Hi,
     
    Can someone please help me with the following question.
     
    I am trying to load two tables that have a one to many relationship from an access db on to a datagridview in vb.net 2005 but I can only get one table to display.
     
    I would also like users to type search criteria into a text box and the corresponding data from the tables will be displayed into a datagridview.  
     
    Thanks for any help you can give.
     
    Dan 

  • RELEVANCY SCORE 3.09

    DB:3.09:Is That Possible Of Sqldependancy To Monitor Multiple Tables?? kk


    hello
    i wish to know is that possible of using sqldependancy to monitor 2 tables at the same time??
    i tried search internet of my question, what i found is AggregateCacheDependency, which is different from sqldependancy.

    DB:3.09:Is That Possible Of Sqldependancy To Monitor Multiple Tables?? kk

    Hi siewchoong,

    SqlDependency is used to detect the results change of from a query according to the SqlCommand, while AggregateCacheDependency is used to monitor a set of dependency objects, such as CacheDependency, SqlCacheDependency. In this case, you may have a try to create
    on SqlCacheDependency object per each dependent table, and add these dependencies within the

    AggregateCacheDependency.

    This thread maybe helpful to you:
    SqlCacheDependency on Multiple Tables with SQL 2000.

    Stephanie Lv
    TechNet Community Support

  • RELEVANCY SCORE 3.09

    DB:3.09:Finding Table/Tables That Contain A Column jd


    Hi all,

    Let's say there is a column name 'cust_id' that is in multiple tables. How can I display a list of tables that contains this column?

    Also, I was trying to do an advanced search by title in this forum and it does not seem possible is this correct?

    Thanks!

    DB:3.09:Finding Table/Tables That Contain A Column jd

    Hi apex,

    use please "Reports -- Data Dictionary Reports -- Table -- Columns -- Columns".

  • RELEVANCY SCORE 3.07

    DB:3.07:Cross Catalog Search 3z



    Can you search across multiple documents from one search box?

    DB:3.07:Cross Catalog Search 3z


    Can you search across multiple documents from one search box?

  • RELEVANCY SCORE 3.06

    DB:3.06:How To Insert One Table Data Into Multiple Tables By Using Procedure? az


    How to insert one table data into multiple tables by using procedure?

    DB:3.06:How To Insert One Table Data Into Multiple Tables By Using Procedure? az

    Hi,INSERT (including INSERT ALL) works in procedures the same way as it works in pure SQL.When I said you could do INSERT ALL outside of a procedure, I didn't mean to suggest that you couldn't do it inside a procedure.

  • RELEVANCY SCORE 3.06

    DB:3.06:Inefficient Query Plan When Using In And Or In Where Clause For Multiple Search Conditions xm


    By request, here's a modified example of my original post (http://social.msdn.microsoft.com/Forums/en-US/transactsql/thread/e80f2bae-76ee-4a41-ad32-57f18e0fd8e1/)
    that includes the multiple search conditions. Please keep in mind this is an example using AdventureWorks tables so that you can run it yourself. This is not a real world example though it does illustrate the problem.
    We've all written queries that contain a WHERE clause like:

    (CreditCard.CardNumber = @nvcSearch OR @nvcSearch IS NULL)
    AND
    (CreditCard.ExpMonth = @tiMonth OR @tiMonth IS NULL)

    DB:3.06:Inefficient Query Plan When Using In And Or In Where Clause For Multiple Search Conditions xm

    Charles,
    Yep, I'll report the bug once I find time to build a SQL 2008 test box with CU 5 installed. Once I confirm that CU 5 doesn't work properly I'll submit the bug.
    I have to disagree with your marking of SQLUSA's suggestion of dynamic SQL as an answer. It's a workaround, as I acknowledged in the original post, but it's not a solution. For example, I have several cases of this being a problem in functions. Since I can't
    use dynamic SQL in functions it's not really a solution in those instances.

  • RELEVANCY SCORE 3.06

    DB:3.06:Search A Record From Multiple Tables s3


    Is there a pl/sql command or way that searches for a specific record (text, number) in multiple tables? Given that you don't know the column you are searching from.

    DB:3.06:Search A Record From Multiple Tables s3

    There is no built in method, but you can roll your own.

    I posted one way Re: How to find out a tablename

    HTH
    John

  • RELEVANCY SCORE 3.06

    DB:3.06:Search With Single Selection Details c3


    I have a search page whose results are a single selection. I have a PPR on the selection which displays detail rows based on the selected master (result) row. This works fine when the search returns multiple rows. However, when the result is a single row, the single select fires the action as expected but the detail rows are not displayed. The two tables are connected via a VL through an AO. Can someone please shed some light as to why this might be happening and a possible solution/workaround?

    Thanks!

    DB:3.06:Search With Single Selection Details c3

    This is still an issue, but I am currently using a workaround to manage the master-detail relationship instead of utilizing the VL as I had originally done. Any ideas would be helpful.

  • RELEVANCY SCORE 3.05

    DB:3.05:Re: Which Is Better:Search Jtables Or Search Database Tables? 33


    any ideas here

    DB:3.05:Re: Which Is Better:Search Jtables Or Search Database Tables? 33

    greetings all i have UI With many jtables,every jtable reads data from it's own table in a MySQL database and i want to make a search mechanism in a specific column in all the tables and once item is found the row is highlighted. i made it with two ways: 1-make for loop in each jtable and once item is found , current loop is exited and other loops are not entered 2-make connection with the database and create several resultsets ,every resultset execute a select query on the desired item and if one of the Resultsets returns data means item is found then i highlight it in the equivalent jtable. i executed the two ways and felt no difference in the speed of finding item but i want to know what is the best way of them or in general,as better design or in case of large applications? thanks in advance

  • RELEVANCY SCORE 3.05

    DB:3.05:Single Data Entry Form-Multiple Tables sd


    Hi,

    DB:3.05:Single Data Entry Form-Multiple Tables sd

    Somewhere, somehow, you need to a way to identify which team a user belongs to. Once you know that, you can use some code in each form's Open event:
    Select Case team
    Case "team1"
    Me.RecordSource = "team1table" ' a sorted and/or filtered query is usually better than a table
    Case "team2"
    Me.RecordSource = "team2table"
    Case Else
    MsgBox "unknown team"
    End Select
    An alternative is to just make a copy of your front end database and use the Link Table Manager to link to the second team's tables. Then copy the appropriate front end db to each team member's system.

  • RELEVANCY SCORE 3.05

    DB:3.05:Index Multiple Column Of Multiple Tables 7c


    Hi All,

    I would like to know how to create a index which can search through all column in my database tables. Eg: I have 30
    tables and every tables have around 10 columns. I want to create a index which can search through the columns in
    these tables.

    I know that User_DataStore can helps in create multiple column search across multiple tables. But in my case the BLOB
    created will be very huge. Any work around? I mean is there any solutions like concatenated datastore?

    Thank You.

    Regards,
    LG Tan

    DB:3.05:Index Multiple Column Of Multiple Tables 7c

    Hi,

    I figured out how to do this today. The first thing is that the type of index you need is a USER_DATASTORE.

    The idea behind this type of index is pretty straight forward but the documentation does a very good job of not drawing attention to just how powerful it is.

    The idea behind a USER_DATASTORE is that you can write your own stored procedure to extract the data that you want to index and return it to the indexer. Take an example where you have a master table which contains enough information to allow you to find associated data in other tables i.e. a shared key. The idea is that when you set up a USER_DATASTORE index, you specify the name of a stored procedure that the indexer will call for each row in the master table. The stored procedure has one input and one output parameter, rowid (in) and clob (out).

    When the index is created, the stored procedure you specify is, as I said above, called for each row in the master table. Your stored procedure uses this ROWID to extract the shared key (this can be anything you want) from the master table and uses this to build the necessary SELECT statement to retrieve the related data from the other tables. The rest of the stored procedure simply appends the data returned from your select statement to the return CLOB. The indexer then indexes the inforamation in this CLOB and discards the data.

    The index can of course only return hits against the master table. It's up to your application to extract shared key from the returned row(s), bind to the other tables and present the results.

    You will find a basic example of how to implement USER_DATASTORES in the Oracle Text Reference Guide (http://download.oracle.com/otndoc/oracle9i/901_doc/text.901/a90121.pdf). Feel free to email me if you want some example code.

    --
    Dean

  • RELEVANCY SCORE 3.05

    DB:3.05:Messagetextinput Field In Search Region Table 18


    Hi,

    I have a seeded search page which contains the search area and the associated advanced table region. The table columns are all READ ONLY and the underlying VO is based on a SQL which joins to multiple tables. It displays Invoice and its related fields.

    We have a requirement for having a user enterable field (MessageTextInput) added in this table, where the supervisor user can enter their notes based on the records info. against the Invoice table.

    Is this possible ?
    If so, can you please explain the steps to achieve this.

    Thanks
    Shanky

    DB:3.05:Messagetextinput Field In Search Region Table 18

    Hi,

    I have a seeded search page which contains the search area and the associated advanced table region. The table columns are all READ ONLY and the underlying VO is based on a SQL which joins to multiple tables. It displays Invoice and its related fields.

    We have a requirement for having a user enterable field (MessageTextInput) added in this table, where the supervisor user can enter their notes based on the records info. against the Invoice table.

    Is this possible ?
    If so, can you please explain the steps to achieve this.

    Thanks
    Shanky

  • RELEVANCY SCORE 3.04

    DB:3.04:Indexing Multiple Columns Across Multiple (Unrelated) Tables mf


    Hi,

    I'm working on a general site seach which needs to search up to about 20 unrelated tables. I've managed to get a basic version of this working using Oracle Text (10g) with a materialized view, but I'm not sure how this will perform when the table sizes grow (say in the region of 100s of 1000s of records). Do anyone know if performance will be an issue using a materialized view for Oracle Text search? Is it efficient to use a materialized view to concatenate the data from, say, around 20 tables?

    Is that any other methods that can be used to index multiple columns on multiple tables? I've seen an example where multiple related tables are joined and indexed using a stored procedure here:
    Building index from multiple tables for text search

    However in my case the tables are unrelated. For example I have a Film table with name and description, classification etc columns and a Jobs table with job title, job description, qualification required etc.

    Thanks

    DB:3.04:Indexing Multiple Columns Across Multiple (Unrelated) Tables mf

    * You add a procedure (user datastore) on the materialized view?

    * When using CTX_DDL.SYNC_INDEX will the index be synchronized when the materialized view is updated?

  • RELEVANCY SCORE 3.04

    DB:3.04:Regarding Multiple Tables ak



    How can we retrieve data from multiple tables into a single screen? Is it possible?

    Rgds, Jona

    DB:3.04:Regarding Multiple Tables ak


    Hi Rona,

    If you just want to show the data you can use the datatable query with the grid.

    Regards

    Ad

  • RELEVANCY SCORE 3.04

    DB:3.04:Internal Tables a7



    hiii,

    Internal table uses a ____ search for standard tables,a _____

    search for sorted tables and a _____ search for hashed table.

    DB:3.04:Internal Tables a7


    Internal table uses a linear search for standard tables,a binary search for sorted tables and a hashed search for hashed table.

    Standard Internal Tables

    Standard tables have a linear index. You can access them using either the index or the key. If you use the key, the response time is in linear relationship to the number of table entries. The key of a standard table is always non-unique, and you may not include any specification for the uniqueness in the table definition.

    This table type is particularly appropriate if you want to address individual table entries using the index. This is the quickest way to access table entries. To fill a standard table, append lines using the (APPEND) statement. You should read, modify and delete lines by referring to the index (INDEX option with the relevant ABAP command). The response time for accessing a standard table is in linear relation to the number of table entries. If you need to use key access, standard tables are appropriate if you can fill and process the table in separate steps. For example, you can fill a standard table by appending records and then sort it. If you then use key access with the binary search option (BINARY), the response time is in logarithmic relation to the number of table entries.

    Sorted Internal Tables

    Sorted tables are always saved correctly sorted by key. They also have a linear key, and, like standard tables, you can access them using either the table index or the key. When you use the key, the response time is in logarithmic relationship to the number of table entries, since the system uses a binary search. The key of a sorted table can be either unique, or non-unique, and you must specify either UNIQUE or NON-UNIQUE in the table definition. Standard tables and sorted tables both belong to the generic group index tables.

    This table type is particularly suitable if you want the table to be sorted while you are still adding entries to it. You fill the table using the (INSERT) statement, according to the sort sequence defined in the table key. Table entries that do not fit are recognised before they are inserted. The response time for access using the key is in logarithmic relation to the number of

    table entries, since the system automatically uses a binary search. Sorted tables are appropriate for partially sequential processing in a LOOP, as long as the WHERE condition contains the beginning of the table key.

    Hashed Internal Tables

    Hashes tables have no internal linear index. You can only access hashed tables by specifying the key. The response time is constant, regardless of the number of table entries, since the search uses a hash algorithm. The key of a hashed table must be unique, and you must specify UNIQUE in the table definition.

    This table type is particularly suitable if you want mainly to use key access for table entries. You cannot access hashed tables using the index. When you use key access, the response time remains constant, regardless of the number of table entries. As with database tables, the key of a hashed table is always unique. Hashed tables are therefore a useful way of constructing and

    using internal tables that are similar to database tables.

    Regards,

    Maha

  • RELEVANCY SCORE 3.04

    DB:3.04:Search Object Listing Hide At The Back af



    Hi all,

    I am using Qlikview 10 SR2.

    In a qlikview document, I create multiple pivot table and search object. Search objects will be display according to the pivot tables which is maximized. Also, I have create Fast Change for my pivot tables which allows fast change pivot table to straight table and vice versa.

    Everything works fine and search object list down the possible values on top of the pivot table. (as per image below)

    However, once I fast change the pivot table to straight table or vice versa, the search object list will be shown at the back of the pivot / straight table, as per image below.

    Anybody know the root cause of this?

    Note that I have set the search object layout = TOP and PIVOT table = NORMAL.

    Thanks in advance.

    Regards.

  • RELEVANCY SCORE 3.03

    DB:3.03:Drop Tables kz


    hi techies,

    how to drop multiple tables in a single statement?

    DB:3.03:Drop Tables kz

    it is not possible in sql,
    but a way-around may be created in pl/sql by using execute immediate

  • RELEVANCY SCORE 3.03

    DB:3.03:Can One Interface Load Data Into Multiple Tables z3


    hi,

    i have a single target tables and need to load into multiple tables(3).Is it possible to have multiple target tables in one interface in odi.

    DB:3.03:Can One Interface Load Data Into Multiple Tables z3

    Aside from what John has said, lets be realistic - There is nothing stopping you changing the IKM to load your collection data (C$_ from the LKM) into multiple targets, the limitation is the interface UI only allows one target mapping (unless you follow Johns approach).

    If the 2nd and 3rd tables are identical, you could create a flexfield on the master target that holds the 2nd and 3rd table names and reference these flexfields in the IKM. If the 2nd and 3rd targets are in different schemas it gets interesting. Try and stick to best practices and not hard-code any object names. Better still, hold the internal ID of the 2nd and 3rd target tables as flexfields then you can use the standard %=snpRef.getInfo("FULL_TABLE_NAME")% to return the schema.table.

    This is messy but not impossible, you need to balance out if its worth it, why not duplicate the interfaces , change the targets and dont clear your collection data until the 3rd table is loaded ? Nice and simple workflow handled in a package then?

  • RELEVANCY SCORE 3.03

    DB:3.03:Querying Multiple Tables kd


    I have a need to provide an interface where queries can be performed on tables and the results from the queries are presented in a list (like the search component listview).In order to do this, I launch the "search" component from my custom componentand pass it the DQL query string. The query is executed and the results are presented by the "search" component. I use the "search" component, since userswill want to perform "actions" on the results like, open, checkout etc.Example:"select object_name from permits where ((apn = '123') or (apn = '234'))" permits is a custom documentum type, apn is a custom property. This gets complicated, if users want to select from several tables at the same time and view the results from all the tables. Example:"select object_name from permits where ((apn = '123') or (apn = '234'))" "select object_name from deeds where ((deedNo = '987') or (deedNo = '678'))" If I try to combine the queries like: "select object_name from permits, deeds where ((apn = '123') or (apn = '234') or ((deedNo = '987') or (deedNo = '678'))" I get all the results; however the individual tables are "CROSS-JOINED" first. This makes the query extremely inefficient. What I want is for the result setsto get concatenated.Is there a way to do this while still using the "search" component?

    DB:3.03:Querying Multiple Tables kd

    Be very careful with UNIONs - UNION is a set operator which means the database will not return duplicate rows. Possibly you want this but you should be aware of this behaviour

  • RELEVANCY SCORE 3.03

    DB:3.03:Database Design (Bitwise And Performance Question) m1


    I've many tables that has fields that can take multiple values. Joining all of them doesn't seem good for performance. For example, product table has serveral columns that require multile values, for example one product can be in many catagories and can have many primary features. Catagaries and primary features are separate tables, but this just an example and overall some tables have more than 6 tables like these. Joining all of them to perform search is costly.
     
    So I thought I could make another table for search purpose and use bitwise operation to search through without joining. But I came across a topic on another forum which says it is bad for performance. My main concern is performance, so why this is bad? Is there are better way to increase performance?
     
    Here is the topic I'm talking about http://bytes.com/forum/thread142621.html
     
    Thanks

    DB:3.03:Database Design (Bitwise And Performance Question) m1

    This forum is specific to SQL Server Data Mining. Please post T-SQL and Performance questions to the following forums:
     
    http://forums.microsoft.com/MSDN/ShowForum.aspx?ForumID=85SiteID=1 (T-SQL)
    http://forums.microsoft.com/msdn/ShowForum.aspx?ForumID=93SiteID=1 (Sql Server Engine, Performance)
     
    Thanks
    Shuvro

  • RELEVANCY SCORE 3.02

    DB:3.02:Inner Join With Multiple Times The Same Fieldname. a1



    hello,

    i have a screen in my web dynpro where there are multiple fields that are search parameters. these are not required.

    the data that i need to show is from 8 different tables and need to be filtered with the search parameters.

    in the list of data that i need are also multiple fields with the same fieldname and from the same table.

    the best way to get the data out of the 8 tables is by a inner join, i think?

    but how can i do this if i need multiple times the same fieldname and also filter on the searchparameters?

    DB:3.02:Inner Join With Multiple Times The Same Fieldname. a1


    Hi Joeri,

    You can use field aliases to select database fields having the same name. For example...

    SELECT table1~samename as field_1

    table2~samename as field_2

    FROM table1

    JOIN table2 ON table2~key = table1~key

    INTO ...

    WHERE table1~otherfield = p_param1

    AND table2~thirdfield = p_param2.

    If you use INTO CORRESPONDING FIELDS OF in your INTO clause, the system will expect the target itab or structure to have fields named field_1 and field_2.

    Cheers,

    Amy

  • RELEVANCY SCORE 3.02

    DB:3.02:Unable To Crawl/Search Multiple Tables From External Database (Sql) In Sp 2010 8k


    hi everyone,
    I was able to crawl a table (from an external SQL database) via SP 2010 and search it and it works great. However, I wanted to have SP crawl multiple tables from that same database and it's not happening. For some reason, it only returns results from that
    1 table. I've checked the ECT settings and they have CRUD permissions on all the tables. I don't know what to do.
    Any ideas??? thanks!PR

    DB:3.02:Unable To Crawl/Search Multiple Tables From External Database (Sql) In Sp 2010 8k

    First thing to do is to check crawl log and also USL logs to see what went wrong. Once you have that information will be easier to make suggestionsLightning Tools Check out our SharePoint tools and web parts

  • RELEVANCY SCORE 3.02

    DB:3.02:Need Help - Oracle Text And Structured Data Queries xk


    We are trying to provide a "Google" like search results page but are only querying structured data across multiple tables. We do not have any documents. Our results need to show snippets of the data containing the search string, which table we found it in, and the search string highlighted. Is this possible? I've only found reference to highlighting within documents. Thanks in advance.

    DB:3.02:Need Help - Oracle Text And Structured Data Queries xk

    The ctx_doc.highlighting package needs a document and its text index so I guess it won't be useful for your scenario.

  • RELEVANCY SCORE 3.02

    DB:3.02:How To Convert Multiple Pdf Tables To Excel kz



    How to convert multiple pdf tables to Excel. Anyone to help please?

    Silkman

    DB:3.02:How To Convert Multiple Pdf Tables To Excel kz


    How to convert multiple pdf tables to Excel. Anyone to help please?

    Silkman

  • RELEVANCY SCORE 3.01

    DB:3.01:Indexing Multiple Columns In Multiple Tables ma


    I have a multiple tables in which I want to search. I need to do text search that supports fuzzy logic for which I've currently set up a context index using the user_datastore. I also need to search columns such as numbers/dates/timestamps which from what I understand is not supported with the context search. I'm looking at setting up a second index of type ctxcat for this purpose - but I will need to index multiple columns in multiple tables. Is this possible?

    Can someone advise on the best way to create indexes and search when a table schema such as the following exists. I've tried to keep it simple by just giving a few example columns and tables.

    Order Table
    - Has columns related to the order details - order name (varchar2), description (varchar2), date order placed (timestamp), date order completed (date), order amount (number), customer Id

    Customer Table
    - Has columns related to the customer information - customer name, address, city, state, telephone etc (all varchar2 fields)

    Items Table
    - Has details about the items being ordered - item name (varchar2), item description (varchar2), cost (number) etc

    Order-Item Table
    - Table that maps an order to the items in that order - orderId, itemId, quantity

    Comments Table
    - Logs any comments with the customer - comment description (varchar2), call type (varchar2), comment date (timestamp)

    Currently with the Context index, I have it set up so I can search all text columns in all tables for a search term. This works fine.

    I now need to be able to do more advanced searches, where I can search for a specific text in all orders as well as orders created after a certain date or orders above a certain amount or orders with a item quantity purchase of more that 10. The text has to be searched across the all text columns in all tables. How can I achieve this with Oracle Text?

    DB:3.01:Indexing Multiple Columns In Multiple Tables ma

    Somewhere in the thread that Barbara has pointed you to is a mention of SDATA sections. If you are using 11g, this is highly recommended.
    If you are not using 11g, the combination of less custom work to do AND the performance benefit you will receive would/might/should justify the move to 11g.

  • RELEVANCY SCORE 3.01

    DB:3.01:Dynamic Where Clause In Linq With Multiple Tables In A Join 7m


    How do you easilty create dynamic where clauses in LINQ when you have multiple tables in a join.
    Dim oDataOut = From customers In db.Customers, contactsIn db.Contacts_Select customers, contactsThis does NOT work
    If Not String.IsNullOrEmpty(oPerson.name) Then
    oDataOut = oDataOut.Where(Function(customers) person.name=oPerson.name)
    End IfOperson is a simple object containing person search attributesIt works for single tables but not a LINQ statement with joins. 

    me

    DB:3.01:Dynamic Where Clause In Linq With Multiple Tables In A Join 7m


    What you are trying should work fine for a LINQ statement with joins. Can you post an example with a join that is not working for you?

  • RELEVANCY SCORE 3.01

    DB:3.01:How To Create Multiple Rows In A Child Table From The Multi Select Lov mx


    Hi

    We have Departments and EmployDept and Persons tables and each employee can associate multiple departments and vice versa.While creating a Department page there should be a Multi Select LOV(values from Persons table) with search option for the Persons.From the search panel we can select multiple persons for that department.Suppose we have selected 5 persons and click on submit, then it should create 5 rows in the EmployDept table for 5 persons with that department id.

    Any inputs on how to implement this scenario please..

    DB:3.01:How To Create Multiple Rows In A Child Table From The Multi Select Lov mx

    Maybe you can get some ideas from here -
    http://adfdeveloper.blogspot.com/2011/07/simple-implementation-of-af.html

  • RELEVANCY SCORE 3.01

    DB:3.01:Deleting Records From Multiple Tables Based On Userid zp


    Hi Everyone
    Im looking to delete a user through a form based on their UserID. However, the user has data stored in many tables and this is causing me problems.
    The tables data is stored in are : tblUser, tblReview, tblFavFilm, tblFavGenre
    I would ideally like the person deleting the user to be able to search for the userID and then delete all the records that include that UserID to be deleted at the click of a button

    Thanks
    Dylan

    DB:3.01:Deleting Records From Multiple Tables Based On Userid zp

    What you want is a Cascade Delete:
    http://www.databasedev.co.uk/delete_query.html

    More here:
    http://support.microsoft.com/kb/304466
    http://office.microsoft.com/en-us/access-help/delete-one-or-more-records-from-an-access-database-HA001173951.aspx

  • RELEVANCY SCORE 3.01

    DB:3.01:How To Search Keyword In A Multiple Lines Of Text Field With Caml Query sk


    Hi all,I have a Multiple lines of text field (Enhanced rich text (Rich text with pictures, tables, and hyperlinks)) in my custom sharepoint list.now i wanna search keyword in this field and i write query like this:Contains    FieldRef Name=\Description\ /    Value Type=\Text\key/Value/ContainsThe problem is that in the Enhanced rich text field there are mass of html tags, but what i wanna to search is just the displayed text. So do u guys have any idea?JackieLee

    DB:3.01:How To Search Keyword In A Multiple Lines Of Text Field With Caml Query sk

    Value Type in the query should be 'Note' for rich text field Value Type='Note'

    -Deepti

  • RELEVANCY SCORE 3.01

    DB:3.01:Sql Loader ca


    how to insert multiple files into multiple tables using SQL LOADER

    DB:3.01:Sql Loader ca

    http://www.orafaq.com/wiki/SQL*Loader_FAQ#Can_one_load_data_from_multiple_files.2F_into_multiple_tables_at_once.3F

  • RELEVANCY SCORE 3.01

    DB:3.01:Multiple Tables In Ms Accsess ck


    how to add ,edit, delete, search in vb,net 2008into multiple tables in MS Accsess with ADO.Netplz help meKOOOOOKOOOOO

    DB:3.01:Multiple Tables In Ms Accsess ck

    Hi Kouro,Could you tell us how you manipulate the multiple tables? After you fetched data from the multiple table and if you want to save the data with multiple tables, you need to use the OleDbCommand to issue the SQL statement to manipulate every table respectively. Best regards,Riquel Please remember to mark the replies as answers if they help and unmark them if they provide no help.

  • RELEVANCY SCORE 3.01

    DB:3.01:Ultra Search And Text Going Against Multiple Columns In Multiple Tables ap


    Does anyone have any info or lessons learned regarding the subject of this post? Need to know how to do it and what are any problems in doing it....

    Stacy

    DB:3.01:Ultra Search And Text Going Against Multiple Columns In Multiple Tables ap

    Are you asking if you can search against all of your sources with one query? Yes, you can do that.

  • RELEVANCY SCORE 3.01

    DB:3.01:Selecting Multiple "Windows Checkbox" In A List Box x9



    Hi,

    I am develouping a qlikview application where there is an use of search object for searching data from tables.

    For example

    The above table has 3 columns and I have provided check box in QV to define the search. Suppose if I type "Apple" in the searchbox and check the checkbox "Col_A", It will only search in column A.

    Now, I want to get all the three checkboxes "Checked" (by default) when an user opens the QV doc.

    Please help..!

    Thanks

    Paul

    DB:3.01:Selecting Multiple "Windows Checkbox" In A List Box x9


    you can use on open trigger

    select the action "select Possible" and select the desiered field

  • RELEVANCY SCORE 3.01

    DB:3.01:Jdbc Getting Data From Multiple Tables f9


    hi guys

    how can i get data from multiple tables in MSAccess
    please help

    DB:3.01:Jdbc Getting Data From Multiple Tables f9

    Hi

    thank you for all your rplies
    i make it because of your helps

    my query="SELECT * FROM table1,table2 WHERE table1.ID=table2.ID;";

    i learnd that when getting string getString() ResultSet from one table to another wil jump to 3 fields.

    thanxxx

  • RELEVANCY SCORE 3.01

    DB:3.01:Multiple Word Search zf


    Cannot make multiple word search in Finder ?

    DB:3.01:Multiple Word Search zf

    Cannot make multiple word search in Finder ?

  • RELEVANCY SCORE 3.01

    DB:3.01:How To Pass Multi Value Parameter To Lightswitch Preprocessquery a1


    Hi,

    I have Products and Categories Tables and i need to set up search screen where user can select multiple Categories .

    how can i configure Auto complete Box to allow multiple selection of categories.?
    How can i pass these values to the PreprocessQuery ?

    partial void ProductsByCategories_PreprocessQuery(string Categories, ref IQueryableProduct query)
    {

    }

    thanks

    DB:3.01:How To Pass Multi Value Parameter To Lightswitch Preprocessquery a1

    Hi,

    I have Products and Categories Tables and i need to set up search screen where user can select multiple Categories .

    how can i configure Auto complete Box to allow multiple selection of categories.?
    How can i pass these values to the PreprocessQuery ?

    partial void ProductsByCategories_PreprocessQuery(string Categories, ref IQueryableProduct query)
    {

    }

    thanks

  • RELEVANCY SCORE 3.01

    DB:3.01:Multiple Tables In One Wsdl d9



    Hi All, Can we link multiple tables using one WSDL? Any idea?

    DB:3.01:Multiple Tables In One Wsdl d9


    Thanks everyone for the answers. More answers are expecting as I keep this an Open Question.

  • RELEVANCY SCORE 3.01

    DB:3.01:Search Button In A Form Help! kz


    I have created a forum which displays data from three joined tables. the table displays the data based on one table using a sort of reference number (ex 1.01, 1.02, 2.01, etc.). The other two tables display the data from the rows that have that reference
    number attached to is (using a drop down menu which allows for multiple reference number other tables when inputting the data, i.e. one record can have 3 reference numbers of the main table attached to it).
    When i search by reference number using my search method, the search returns the correct records for the reference numbers, however it only displays partial data from the other two tables. i have values like Name? and #### returning instead of the actual
    data. However, if i do not start a search and just scroll through the records, all the data is returned without error.
    I am unsure of what to do!
    Here is my search code:
    Private Sub SearchRecs_Click()

    Dim Enter_FOM_Number As Doublet

    On Error GoTo Err_cmdSearchRecs_Click

    DoCmd.ApplyFilter , [FOM List.FOM Section] = Enter_FOM_Number
    GoTo cmdSwitchButtons_Click

    Exit_cmdSearchRecs_Click:
    Exit Sub

    Err_cmdSearchRecs_Click:
    MsgBox Err.Description
    Resume Exit_cmdSearchRecs_Click

    cmdSwitchButtons_Click:
    Reset.Visible = True
    Reset.SetFocus
    SearchRecs.Visible = False

    End Sub

    DB:3.01:Search Button In A Form Help! kz

    like Name? and ####
    Name? is displayed when there's an error in your SQL query (for the RowSource / RecordSource properties). #### appears when the underlying field value is too wide to display in the control (best to resize control or widen column).
    This code is slightly suspect:

    DoCmd.ApplyFilter , [FOM List.FOM Section] = Enter_FOM_Number

  • RELEVANCY SCORE 3.01

    DB:3.01:Merge Into On Multiple Tables 3f


    Can we Insert/Update multiple tables using a single MERGE INTO statement?

    Thanks.

  • RELEVANCY SCORE 3.01

    DB:3.01:Multiple Tables Using Single Bean Managed Persistence Bean fp


    Hi,
    How to connect the multiple tables using single bean managed persistence bean?

    Thanks in advance!

    DB:3.01:Multiple Tables Using Single Bean Managed Persistence Bean fp

    You can use JDBC from within the bean managed persistence EJB

  • RELEVANCY SCORE 3.00

    DB:3.00:Multiple Tables In Select Statement 9f


    I am using the following SPROC in a FullText Search, passing @box as the search string:
    CREATE PROC [dbo].[spFTS_pages]
    @box nvarchar(100)
    AS
    select @box = ''replace(@box,' ',' AND ')''
    SELECT page, page_url
    FROM pages
    WHERE CONTAINS(content, @box) AND activity='y';
    GO
    It works fine.
    Ido, however, have two tables to search and am currently searching them separately (a different SPROC for the second) and displaying the resilts on the same page but in separate ASP.NET GridViews.
    I'd like to search them togather and mix their results in one GridView.
    The reason... I'd also like to rank on relevance regardless of table.
    Can anyone alter my code for me so I can achieve this, please?
    Thanks.

    DB:3.00:Multiple Tables In Select Statement 9f

    To Dan,
    Thank you for this. Please see my longer response to Seth, above.

  • RELEVANCY SCORE 3.00

    DB:3.00:Ability To Query On All Columns From A View With Multiple Tables pk


    I have view with 4 tables. view has about 50 columns.
    hypothetically, I want to build a form to give the user an ability to query on any of those 50 columns. user can search on one or more fields.
    what is the best way to write the query to retrieve the results without performance impact.
    please let me know if the question is not clear.

    DB:3.00:Ability To Query On All Columns From A View With Multiple Tables pk

    If you want to permit them to query any of 10 fields with no restrictions, you could create 10 separate single-column indexes. The optimizer would have to try to pick the best of these indexes if you specified multiple search criteria. But since you have a view which presumably means that you've got multiple other indexes involved for the underlying join conditions, you'd probably want/need to combine the column lists of the indexes you're adding for searches with the indexes you've created for joins, which requires looking at the text of the view and figuring out the best way to optimize the 10 single-column searches. Of course, it is possible that the optimizer could chose to do something like a b-tree to bitmap conversion on multiple indexes which could allow it to use multiple independent indexes for your queries, but that's generally not ideal performance-wise.

    All this is a fancy way of saying that there probably isn't a cut and dried answer to your question. You need to figure out the queries you're trying to optimize (say, the 10 single-condition queries) and you need to figure out what set of indexes on the various underlying tables provides the best performance weighing those benefits against the cost on other side of maintenance during DML. Which is going to depend on the text of the view, the underlying tables, the existing indexes, etc.

    Justin

  • RELEVANCY SCORE 3.00

    DB:3.00:Export Command dx


    Can we use multiple Query in Export command for multiple tables

    DB:3.00:Export Command dx

    Can we use multiple Query in Export command for multiple tables

  • RELEVANCY SCORE 3.00

    DB:3.00:How To Refresh A Jtable xz


    Hi,
    I have a Jtable that displays results from a database after a user clicks on a search button. And the data diplayed on the table depends on the input the user entered into a textField. All these woks fine.

    My problem is that after the first search is completed and the table displays the results, and I click on the search button again, another table is diplayed. Now I have 2 tables displayed in 2 different scrollpanes.

    How can I refresh the first table to display the result of my second search instead of having multiple tables displayed? Thanks a lot in advance!!

    Cheers,Yinx

    DB:3.00:How To Refresh A Jtable xz

    I'm going to assume that you are using a custom TableModel which you achieve by extending the AbstractTableModel. If you aren't and need to know how, check out:

    http://java.sun.com/docs/books/tutorial/uiswing/components/table.html

    If you are, then you need to have your TableModel (e.g. SearchTableModel) reference your updated search results. For me, this got a little ugly as everything needs to be in an Object[][]. Once your search results have changed (assuming your SearchTableModel references these new search results), you need to fire off the table changed event like this searchTableModel.fireTableDataChanged(); and then the table should redraw itself with the new data.

    If you're trying to avoid creating your own table model (as I did at first), I don't think you can do it but I may be wrong.

    Good Luck,

    Mike Dalrymple
    www.mikedalrymple.com

  • RELEVANCY SCORE 2.98

    DB:2.98:Database Operations xp


    how can i insert or update or delete multiple rows from multiple tables ?

    DB:2.98:Database Operations xp

    To erase multiple rows in a table, you can simply do the following:
    com.sun.sql.rowset.CachedRowSetXImpl pkRowSet = new com.sun.sql.rowset.CachedRowSetXImpl();
    try {
    pkRowSet.setDataSourceName("java:comp/env/jdbc/express");
    pkRowSet.setCommand("delete from cart where cart_id = " + cartid);
    pkRowSet.execute();
    pkRowSet.commit();
    }catch(Exception e) {
    error("Error fetching Max(cart_id)+1 : " + e.getMessage());
    }finally {
    pkRowSet.close();
    }
    This code is the action event of a button and it receives the parameter cartid which is the one that it will delete from the table, now, you can customize the sql query so that it deletes as many rows as you wish. If you want to do the same thing with more tables, you can create a function and send the name of the tables as parameters.

    I hope it helps !!

    Yesenia.

  • RELEVANCY SCORE 2.98

    DB:2.98:How To Use Join Queries With Toplink dz


    Hi there

    I'm using toplink within the JDeveloper 10.1.3.3. with great success.
    Now, I need to query multiple tables using a join SQL.

    How do you configure toplink now without creating database views?
    I could not find an easy with within the JDev IDE or from google search.

    Any help please?

    Thanks
    Henkie

    DB:2.98:How To Use Join Queries With Toplink dz

    In a TopLink query you can query across any relationship to another object. You can also join or batch read the object's relationship using the ObjectLevelReadQuery and ReadAllQuery API (see TopLink documentation).

    You can also map a class to multiple tables.

    -- James : http://www.eclipselink.org

  • RELEVANCY SCORE 2.98

    DB:2.98:Data Extraction sj



    HOW CAN WE EXTRACT DATA FROM MULTIPLE TABLES WITH USING SELECT STATEMENT ,WITHOUT USING JOIN IN ABAP?

    Moderator message: please no theoretical exam-type questions, search for information, do not post in all upper case.

    Message was edited by: Thomas Zloch

    DB:2.98:Data Extraction sj


    Hi,

    Pabitra

    try like this

    with out JOIN

    select vbeln erdat ......... from vbak

    into table it_vbak

    where .....

    if it_vbak is not initial

    select vbeln posnr from vbap

    for all entries in it_vbak

    where vbeln = it_vbak-vbeln......

    endif.

    Thanks

    Gourav.

  • RELEVANCY SCORE 2.97

    DB:2.97:Sharepoint 2013 Search Crawl External Sql Database 7f


    Hi,
    I am new to SharePoint Search using Crawling. I have a database in SQL with multiple tables joined to each other. Now I want the whole SQL Database to be crawled and search in SharePoint. Which are the possible and optimized way to do that? Will I have to
    create External Content Types for each of the SQL Tables? Or is there any other way to achive it?

    Please let me know in little bit more detail steps because I am new to it.

    Thanks in advance.

    DB:2.97:Sharepoint 2013 Search Crawl External Sql Database 7f

    Thanks Waqas.
    If I use BCS then I would require to create External Content Types for all the SQL tables individually right? So it would be a tedious job.

    My scenario is as below:
    I have an MVC application with SQL database on back end. And I want to use SharePoint Search Crawling which can search through the MVC application.So I can either do it by Content Source as SQL Database OR Content Source as my MVC Website.
    So if I use Content Source as MVC Website, will there be any disadvantages in doing so?

    Thanks.

  • RELEVANCY SCORE 2.97

    DB:2.97:Search Relevance Using Full Text Search Across Multiple Tables as


    I am using Full Text Search across multiple tables.
    Below is my query
    SELECT b.FK_Publication_ID, b.PageNumber as PageNumber, b.SearchText as SearchText, a.Title as Title , TitleSearch.[Rank] PubSearch.[Rank] * 10000 AS [Rank]FROM PublicationSearch INNER JOIN Publication a ON b.FK_Publication_Id = a.IdINNER JOIN FREETEXTTABLE(PublicationSearch, SearchText, searchtext) PubSearch ON b.Id = PubSearch.[Key] INNER JOIN FREETEXTTABLE(Publication, Title, searchtext) TitleSearch ON a.Id = TitleSearch.[Key] UNION SELECT a.Id, null as PageNumber, null as Searchtext, a.Title as Title, TitleSearch.[Rank] * 100 AS [Rank]FROM Publication aINNER JOIN FREETEXTTABLE(Publication,Title, searchtext) TitleSearch ON a.Id = TitleSearch.[Key]UNIONSELECT b.FK_Publication_ID, b.PageNumber as PageNumber, b.SearchText as SearchText, null as Title, PubSearch.[Rank] AS [Rank] FROM PublicationSearch bINNER JOIN FREETEXTTABLE(PublicationSearch, SearchText, searchtext) PubSearch ON b.Id = PubSearch.[Key] ORDER BY [Rank] DESCFirst query in the union : Gets search records which exist in both the tables 'Publication' and 'PublicationSearch'Second query : Gets search records which exist only in PublicationThird query : Gets search records which exist only in Publication SearchMy question is, if i have 4 or 5 tables, the number of UNIONS will increase and hence the complications as well as performance.How can i search records across multiple tables without using or with minimal use of UNIONS.Please help me..Thanks,Aneesh

    DB:2.97:Search Relevance Using Full Text Search Across Multiple Tables as

    I think you will find full-text indexing an indexed view will work better. Full-text ranking is done on a per table basis. If you have 3 different tables and combine them ranking will be inconsistent. A null ranking means there is no match with the left
    join. Perhaps a equi join is what you want.looking for a book on SQL Server 2008 Administration?
    http://www.amazon.com/Microsoft-Server-2008-Management-Administration/dp/067233044X looking for a book on SQL Server 2008 Full-Text Search?
    http://www.amazon.com/Pro-Full-Text-Search-Server-2008/dp/1430215941

  • RELEVANCY SCORE 2.97

    DB:2.97:How To Make A Search Box That Will Search Every Field Across Multiple Tables? x1


    I'm trying to make a search box that will let me search for any record, in any field, across more then one table.... I don't want to use a combo box as it is a drop down list. I want something like the asset template that comes with access.
    That search box is nice but i cannot customize it to my liking. If anyone knows how to modify this existing search box please let me know how.

    Thanks.

  • RELEVANCY SCORE 2.97

    DB:2.97:Instr Or Like fc


    Need to do text specific search's on 2 tables, but will be searching multiple fields in tables also (name, address, email and such)

    instr(upper(CONTACT),upper('SMITH'))0

    (upper(CONTACT) LIKE '%SMITH%')I am using an input box to feed a text search and the input text could be in various fields/tables.

    There are only several thousand records in each.

    Oracle 11

    Which of the above options is better or am I way off base here?

    Thanks
    Rich

    Edited by: LostOne on Mar 15, 2010 6:56 AM

    DB:2.97:Instr Or Like fc

    Perhaps Oracle Text is another option to consider?
    "Oracle Text provides indexing, word and theme searching, and viewing capabilities for text."
    See/search the docs to get an idea:
    http://download.oracle.com/docs/cd/E11882_01/text.112/e10945/query.htm#CCAPP0400
    http://www.oracle.com/pls/db112/search?word=textpartno=

  • RELEVANCY SCORE 2.95

    DB:2.95:Re: How To Search Between 2 Tables In Htmldb? dc


    union all

    DB:2.95:Re: How To Search Between 2 Tables In Htmldb? dc

    You might as well try this:

    Select
    a.item1,
    a.tem2,
    a.item3,
    a.itemn,
    b.tem1,
    b.tem2,
    b.temn
    from table a, table b
    where a.id = b.id(+)

    Of course all that has been said is cool.

    Now the question I got for Scott, Raj et all, is: How do you write a finer code to perform a search, irrespective of the search criteria? I mean whether you enter just a letter (e.g., l or L, c or C, or you spell out the entire term in cap or lowercase)?

    Thanks!

    J-P

  • RELEVANCY SCORE 2.95

    DB:2.95:Building Url From Ultrasearch Result 1d


    Hi
    I want to develop a Java Portlet, that uses the UltraSearch Java API to access indexed data from Portal page groups, or database table sources.
    I have multiple portlets in multiple pages, wich retreives data from database tables.
    The Search portlet find the data, but I must build an URL to jump to the specific page, to the specific portlet instance, with specific parameters.
    How can a do this?

    Thanks in advance.
    Csaba

    DB:2.95:Building Url From Ultrasearch Result 1d

    Hi
    I found a solution.
    In the crawler, in the Table Data Source tab Display URL settings, I copied the portal page URL, where the portlet was placed.
    When I click the link on the search result page, the browser navigates to the portal page where the portet was placed.
    Because the portal page URL is hardcoded in the crawler, I think this solution isn't the best.
    There is another problem: if on the same page there is two or more instance of the same portlet, the paramters are received in all portlets.

  • RELEVANCY SCORE 2.95

    DB:2.95:1 Form Page With Multiple Search m3



    Hello to everyone I have a question. I have a page that has a form to input into MySQL using PHP. What I am trying to do is have two searches that pulls out the information from different tables within the database, and put that information into the form and then save the form into its own table. I can search the tables and use dynamic record set to post the information to the form but when I do the second search the first search disappears. But the second search is posted into the form. This is the sample page. http://www.1stsourcesolution.com/ins...rmit_index.php. The code for the page is quite lengthy but here it is. Thanks for any input.
    CONTENT GO HERE Search PermitInspectionAdd PermitAdd Inspection Permit Search:
    Search for Permit by:

    Search TMS: BY TMS Number, Owners Name, Address

    Search Result:
    Edit | Add | Delete |Select

    DB:2.95:1 Form Page With Multiple Search m3


    You will likely have better luck and certainly better exposure posting your question here -

    http://forums.adobe.com/community/dreamweaver/dreamweaver_development?view=discussions

    at the Dreamweaver Application Development fourm.

  • RELEVANCY SCORE 2.95

    DB:2.95:Text Index Of Several Tables jd


    I have 3 tables with multiple columns however I only want to create an index on a blob column in each table. I already have a text index for this column on each individual table but I would like to search for let's say Oracle in all three tables over all the documents the table contains.

    I see where you can use the multi_column_datastore but from what I read this is done on columns in the same table. There was no such thing as a multi_table_datastore so I do I get the text from all three tables together for one index?

    Please help!!

    DB:2.95:Text Index Of Several Tables jd

    http://asktom.oracle.com/pls/asktom/f?p=100:11:0::::P11_QUESTION_ID:9455353124561

  • RELEVANCY SCORE 2.95

    DB:2.95:How To Drop Multiple Tables ? 87


    i want to drop multiple tables,please give me details with query.
    EXAMPLE:drop table table_name1,table_name2

    DB:2.95:How To Drop Multiple Tables ? 87

    You can directly do it sql instead you can use execute immediate inside a loop in an anonymous block

    Please modify the select query in the block to suit ur requirement

    Something like this,

    declare
    type ty_table_name is table of user_tables.table_name%type index by binary_integer;
    tab_table_name ty_table_name;
    begin
    select table_name bulk collect into tab_table_name from user_tables where table_name like 'AB%';
    for i in 1..tab_table_name.count
    loop
    begin
    execute immediate 'drop table '||tab_table_name(i);
    exception
    when others then
    dbms_output.put_line('Error while dropping table '||tab_table_name(i)||' due to '||sqlerrm);
    end;
    end loop;
    exception
    when others then
    dbms_output.put_line(sqlerrm);
    end;

  • RELEVANCY SCORE 2.95

    DB:2.95:Error: Missing Property Value kd


    Hi!
    I am trying to search values from multiple tables using OAF. I have created Entity Objects for all the required Tables and one View Object to select my requried fields. I am getting the following error:

    Error:
    Cannot run "StanfordHomePG.PageLayoutRN" as a standalone component due to a missing property value. Please set "AM Definition" on this component.

  • RELEVANCY SCORE 2.95

    DB:2.95:Search A Text In A Multiple Tables And One Table Has Blob Column 87


    Hi,

    I couldn't find a solution/examples for below scenario in oracle text documentation or related forums.

    I need to search a text in a multiple tables,in that one table has blob column which is used to store the documnents(pdf,doc,jpg..etc) and other tables have varchar2 columns,These tables have realation each other.

    Please provide a sample examples for above scenario.

    Thanks in advance..

    DB:2.95:Search A Text In A Multiple Tables And One Table Has Blob Column 87

    Have a look at my blog entry here:
    https://blogs.oracle.com/searchtech/entry/indexing_data_from_multiple_tables
    That describes two methods of achieving what you are looking for.

  • RELEVANCY SCORE 2.95

    DB:2.95:Help Needed : Searching In Repository as


    We have implemented a system that allows a user to search through multiple columns in multiple tables and the content of documents (as clobs) using Oracle Text. I have been asked to find a solution that allows us to also search through documents held in a directory. I have come across webdav and Oracle Drive.

    My question is does oracle provide a solution where i can search through a documents content held in a directory similar to Oracle Text through a uploaded document.

    Regards

    Kevin Mann

  • RELEVANCY SCORE 2.95

    DB:2.95:Search Entire Web Site sc


    I have a cilent who would like to give users the ability to
    search his entire web site - all the records stored in all the
    tables in his database. I've created tons of searches in the past
    using multiple, joined tables, but is there a better way to do
    this? I have never used CF Search, and I'm not even sure how to
    start. Any suggestions?

    DB:2.95:Search Entire Web Site sc

    Yes you also can search from the database query by
    registering as collection object with verity. There are two ways
    one with file document and another with query object to make
    collection object.

    First create a collection object using coldfustion
    administrator page under verity secton. Then then using
    cfindex passing this query object and passing action
    parameter as update.

    After done this action, using cfsearch tag you can search for
    the keywords of the database content. Since the database records
    keep changing you can update on day to day basis.

    This is some outline. Keep reading with coldfustion
    documentation under verity subject.

  • RELEVANCY SCORE 2.95

    DB:2.95:Full Text Search Multiple Tables k9


    Hi all,I want to full text search on multiple tables.Example my strSearch = example full text search engine.SELECT     TOP (100) PERCENT FT_TBL.Description AS mota, FT_TBL.test1_ID, KEY_TBL.RANKFROM         dbo.test1 AS FT_TBL INNER JOIN                      CONTAINSTABLE(test1, *, '+strSearch+') AS KEY_TBL ON FT_TBL.test1_ID = KEY_TBL.[KEY]UNION ALLSELECT     TOP (100) PERCENT FT_TBL1.Description1 AS mota, FT_TBL1.test2_ID, KEY_TBL1.RANKFROM         dbo.test2 AS FT_TBL1 INNER JOIN                      CONTAINSTABLE(test2, *, '+strSearch+') AS KEY_TBL1 ON FT_TBL1.test2_ID = KEY_TBL1.[KEY]I want to show results order such as GOOGLE: show top records full keyword example full text search engine, then continune left phrases.pls help me

    DB:2.95:Full Text Search Multiple Tables k9

    hello,I have a similar question,I also want to perform fulltext search on 2-3 tables,just like google search .I am using SQL server 2005 and visual studio 2008.One textbox and a button,which will give me result in data grid, code  in C#.I am a new bii, and would really appreciate,if anyone can help me in this. Also if anyone can provide me sample work which is similar to this would be really helpfull,would be egarly waiting for replyThank You