Is there an easy way to search all tables using a string as search criteria.
I have started writting a heap of nested for loops, getting table defs and fields however it is becoming a little bit of a pain.
Is there some kind of select statement one might be able to write in SQL that will search all tables and all fields.
I would ideally like to go through the database searching for say 'EXT2' and then display the entire row in the table where it is located, with possibilities of more than one result.
Any ideas greatly appreaciated.
4 3133
I'd suggest you post this again in the Access forum. (I'm assuming it's Access you're referring to).
However, your nested-loop technique may turn out to be the best way to go. I'm not aware of any sort of all-tables or all-fields database syntax (apart from Select * of course).
It might be a good idea to fill in some more detail on your situation, though. What VB version, what database product, etc. Of course, a good generic solution would be largely independent of any specific DBMS.
The only thing I can think of is a union query with an OR clause for every field in each table
The only thing I can think of is a union query with an OR clause for every field in each table
Yeah, but doesn't UNION insist that the fields from each table must be the same?
I wonder whether automation might help. Because I notice that if you do Edit | Find while browsing an Access table, you can choose to search the field or the whole table. Perhaps automation would provide a way into this function.
Sign in to post your reply or Sign up for a free account.
Similar topics |
by: disaia |
last post by:
2 problems:
Example: If a person types in a part number into Yahoo:
1. Is there a way for Yahoo to list your web site as one of the
results.
2. If the user clicks on your link, can your web application know the
part number the user typed into the Yahoo search box. I would like to
use that part number to query our database and present a dynamic web
|
by: Ryan |
last post by:
I'm looking for a stored procedure (or query) to search an entire
database for a specific string value and replace it with another. I'm
sure I saw an SP for this a while back by someone, but cannot find it
again. The SP took the search string and replace string as parameters
and did the rest. Any ideas where I can find this ?
Bear in mind, the idea is that this can be re-used and run on any
database, so it would have to find all tables...
|
by: robboll |
last post by:
Using MS Access 2003 I am looking for a function that will search the
entire Tables Collection for a specific string in text or memo fields.
For example if I enter "widget" it interrogates the entire tables
collection and returns the table name and column name where the word is
found, otherwise returns "Not Found"
Any help with this greatly appreciated.
RBollinger
|
by: Julie |
last post by:
What is the *fastest* way in .NET to search large on-disk text files (100+ MB)
for a given string.
The files are unindexed and unsorted, and for the purposes of my immediate
requirements, can't be indexed/sorted.
I don't want to load the entire file into physical memory, memory-mapped files
are ok (and preferred). Speed/performance is a requirement -- the target is to
locate the string in 10 seconds or less for a 100 MB file. The...
|
by: wilco |
last post by:
hello,
can any one tell me how to create a stored procedure that is beable to
search a table, or more table's and can make use of wildcards?
i just made somthing like this,:
SELECT * FROM tblUsers WHERE Adress LIKE '* Value from user how wants to
search the database *'
but I don't know where to place the @??? for the input
i also wants to make the user can select witch table and field he want's to
search.
| |
by: David Lozzi |
last post by:
I need to support multiple keyword search, not boolean searchs, just simple
searches, i.e. "marhsall ma". How is this done? Do I send the entire search
string to the Proc? How do I deal with it there? I'm thinking I need to
build the WHERE clause in the code behind and send it to the proc. What do
you think?
Thanks,
David Lozzi
|
by: Martien van Wanrooij |
last post by:
I have been using phpdig in some websites but now I stored a lot of larger
texts into a mysql database. In the phpdig search engine, when you entered a
search word, the page where the search word was found was displayed with
about 2 lines before and 2 lines behind the search word itself. Let us say
you look for "peanut butter" an the word is found in a larger text about
sandwiches, even when it is on the 40th line of the text you would get...
|
by: atl10spro |
last post by:
Hello Everyone,
I am new to MS Access and although I have created several different
databases I lack the VB knowledge to code a search function. I am
turning to your expertise for assistance. I am using MS Access 2003.
This is what I am looking for:
A text field for the user to enter the search string or keyword.
|
by: raamay |
last post by:
i have seen various tutorials on how to search a database but havent found one which teaches how to search a word or a string anywhere in a database. Well, a user may type 'hel' in the search box and look for matching record. So, in this case i want to search the entire database where there is a word which has 'hel'. Suppose if we have a record as 'hello' or 'shell' in the database, then this records should be included in the result.
How is...
|
by: marktang |
last post by:
ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However, people are often confused as to whether an ONU can Work As a Router. In this blog post, we’ll explore What is ONU, What Is Router, ONU & Router’s main usage, and What is the difference between ONU and Router. Let’s take a closer look !
Part I. Meaning of...
|
by: Oralloy |
last post by:
Hello folks,
I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>".
The problem is that using the GNU compilers, it seems that the internal comparison operator "<=>" tries to promote arguments from unsigned to signed.
This is as boiled down as I can make it.
Here is my compilation command:
g++-12 -std=c++20 -Wnarrowing bit_field.cpp
Here is the code in...
| |
by: jinu1996 |
last post by:
In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven tapestry of website design and digital marketing. It's not merely about having a website; it's about crafting an immersive digital experience that captivates audiences and drives business growth.
The Art of Business Website Design
Your website is...
|
by: tracyyun |
last post by:
Dear forum friends,
With the development of smart home technology, a variety of wireless communication protocols have appeared on the market, such as Zigbee, Z-Wave, Wi-Fi, Bluetooth, etc. Each protocol has its own unique characteristics and advantages, but as a user who is planning to build a smart home system, I am a bit confused by the choice of these technologies. I'm particularly interested in Zigbee because I've heard it does some...
|
by: isladogs |
last post by:
The next Access Europe User Group meeting will be on Wednesday 1 May 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM).
In this session, we are pleased to welcome a new presenter, Adolph Dupré who will be discussing some powerful techniques for using class modules.
He will explain when you may want to use classes instead of User Defined Types (UDT). For example, to manage the data in unbound forms.
Adolph will...
|
by: TSSRALBI |
last post by:
Hello
I'm a network technician in training and I need your help.
I am currently learning how to create and manage the different types of VPNs and I have a question about LAN-to-LAN VPNs.
The last exercise I practiced was to create a LAN-to-LAN VPN between two Pfsense firewalls, by using IPSEC protocols.
I succeeded, with both firewalls in the same network. But I'm wondering if it's possible to do the same thing, with 2 Pfsense firewalls...
|
by: adsilva |
last post by:
A Windows Forms form does not have the event Unload, like VB6. What one acts like?
|
by: muto222 |
last post by:
How can i add a mobile payment intergratation into php mysql website.
| |
by: bsmnconsultancy |
last post by:
In today's digital era, a well-designed website is crucial for businesses looking to succeed. Whether you're a small business owner or a large corporation in Toronto, having a strong online presence can significantly impact your brand's success. BSMN Consultancy, a leader in Website Development in Toronto offers valuable insights into creating effective websites that not only look great but also perform exceptionally well. In this comprehensive...
| |