473,472 Members | 1,728 Online
Bytes | Software Development & Data Engineering Community
Create Post

Home Posts Topics Members FAQ

Any disadvantage of querying a query object?

Jerry Maiapu
259 Contributor
I would like to ask a general question about any disadvantages that maight exist for queries that are based on queries.

For example if I create a query using the Query Wizard and
Select fields from a query instead of tables.
Will any defects result in the final query in the long run assuming that only the final query is run every time ? Lets say that the table records is increasing every now and then.

I am just curious if the final query will return updated records of the table.

Welcome for any comments
May 13 '10 #1
2 2409
Jim Doherty
897 Recognized Expert Contributor
@Jerry Maiapu
It doesnt matter Jerry, queries are SQL language and SQL is what asks question of a table or tables The growth in table data size is immaterial.
May 13 '10 #2
Jerry Maiapu
259 Contributor
Thanks Jim for your comment
May 13 '10 #3

Sign in to post your reply or Sign up for a free account.

Similar topics

0
by: Phil Powell | last post by:
I have a very simple mySqlQuery object that takes two parameters: 1) the string query 2) the db connection resource I tested and was certain everything is passing correctly (the string query...
4
by: MLH | last post by:
I apologize in advance to forum readers noticing this somewhat redundant post. I fear that my Subject Heading was ill-chosen in earlier post I made on this topic. Am hoping that a clearer Subject...
4
by: Max Harvey | last post by:
Hi, I have looked at the example called "Open Parameter queries from code" from the site http://www.mvps.org/access/queries/qry0003.htm I made up a test which I though looked pretty close...
3
by: eddie wang | last post by:
Hello, I am working on an Access database. For some strange reason, my query keeps getting erased by itself. The SQL view of my query object looks like this: SELECT * FROM emp WHERE...
0
by: Sebho | last post by:
Hi, I'm under VS2005, in a web project. I'm using an XSD component for accessing data. In my XSD component i have an Query Object, that contain some Querys Every querys have an Connection...
3
by: Idlemind23 | last post by:
Ahoy! I'm hoping for some help on what (I believe) should be a simple task. I have a form with a button. I would like that button to have a caption with a date. That date should be pulled out...
6
by: =?Utf-8?B?UHVjY2E=?= | last post by:
Hi, I'm using vs2005 and .net 2.0. I currently prcoess each Security Log entry one by one to extract those that fit the selection criteria. Is there a function that I can use to query the entries...
7
by: Kelii | last post by:
Well, I've been searching around the groups for an answer to this one, and none of the suggestions seems to be working for me. I'm almost positive that this is a simple fix, but for the life of me...
3
by: ndeeley | last post by:
Hi, I need to produce a report in CF that extracts a range of values repeatedly from a database and displays the record count. For example I need to extract the recordcount where a record has a...
1
by: Humakt | last post by:
I've seen the solution to do this vice versa, but what if I have an object that has collection and I want to return the objects from query using where clause where I check if any of the items in...
0
by: Hystou | last post by:
There are some requirements for setting up RAID: 1. The motherboard and BIOS support RAID configuration. 2. The motherboard has 2 or more available SATA protocol SSD/HDD slots (including MSATA, M.2...
0
by: Hystou | last post by:
Most computers default to English, but sometimes we require a different language, especially when relocating. Forgot to request a specific language before your computer shipped? No problem! You can...
0
jinu1996
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...
1
by: Hystou | last post by:
Overview: Windows 11 and 10 have less user interface control over operating system update behaviour than previous versions of Windows. In Windows 11 and 10, there is no way to turn off the Windows...
0
agi2029
by: agi2029 | last post by:
Let's talk about the concept of autonomous AI software engineers and no-code agents. These AIs are designed to manage the entire lifecycle of a software development project—planning, coding, testing,...
0
by: conductexam | last post by:
I have .net C# application in which I am extracting data from word file and save it in database particularly. To store word all data as it is I am converting the whole word file firstly in HTML and...
0
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...
0
by: 6302768590 | last post by:
Hai team i want code for transfer the data from one system to another through IP address by using C# our system has to for every 5mins then we have to update the data what the data is updated ...
0
muto222
php
by: muto222 | last post by:
How can i add a mobile payment intergratation into php mysql website.

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.