473,396 Members | 1,826 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,396 software developers and data experts.

Rearranging columns

Could Rearranging columns on a table, effect other areas of the database such as reports and queries?
Feb 10 '09 #1
8 2450
RuralGuy
375 Expert 256MB
The simple answer is NO.
Feb 10 '09 #2
@RuralGuy
i figured, just needed someone smarter than me to confirm.


Thank you!!!
Feb 10 '09 #3
RuralGuy
375 Expert 256MB
You're welcome, but I don't know about the smarter bit. Older maybe. ;)
Feb 10 '09 #4
ChipR
1,287 Expert 1GB
No one very old would have an awesome Doom avatar. But a gamer I work with said yesterday he had never realized Doom was a game and I almost cried.
Feb 10 '09 #5
RuralGuy
375 Expert 256MB
...and someone told me the other day that Paul McCartney was in a group before he started Wings.
Feb 10 '09 #6
OldBirdman
675 512MB
Yeah, I remember seeing that other group when they were first on "The Ed Sullivan Show". Lots of yelling from audience.
OldBirdman
Feb 11 '09 #7
RuralGuy
375 Expert 256MB
Me too! You've got me by 4 years.
Feb 11 '09 #8
NeoPa
32,556 Expert Mod 16PB
@OldBirdman
I wasn't very old at the time ;)

As to the original question - The only change that would be visible after changing the column order would be selecting * in a query. Even then, the only difference would be that the columns displayed in the new order found in the table.

Forms and reports all refer to fields explicitly by name, so their order is not significant.
Feb 16 '09 #9

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

Similar topics

2
by: Kevin | last post by:
Hi Al Can someone tell me how to hide colums in a datagrid. I have a one datagrid that is a master and child and I would like to hide specific columns, how do I do this TI Kevin
1
by: Amber | last post by:
The DataGrid allows you to make columns visible or invisible on demand - even edit and other special columns. This article will show you how it is done. Some developers have reported problems...
5
by: Gary Blakely | last post by:
I'm giving this post another try - it can't be too difficult for everyone.... In the program below, the web page has dataGrid1. the only thing that has been done to it at design time is to...
1
by: Tor Inge Rislaa | last post by:
Rearranging the row position in a datagrid Hi I have a datagrid that I fill from a dataset. When the data is displayed in the grid I want the user to be able to move the position of a row. E.g....
0
by: bappelsin | last post by:
Hello, I have a problem with the datagridview. I have a view with around 25 different columns. To make life easier for the users I have implemented a popup dialog where the user can select which...
5
by: explode | last post by:
I made a procedure Public Sub Novo(ByVal nova1 As String, ByVal nova2 As String) that creates a new oledbDataAdapter with insert update select and delete commads. I also added that commands can...
4
by: db2admin | last post by:
Hello, I want to plan rearranging tables in our database according to business areas. say all tables in business area A will be in seperate tablespace or tablespaces. I am planning to monitor...
0
by: selvakumari | last post by:
hi, In my project in a treeview i am doing drag and drop function and after that modifying some values in a treeview ascending order of nodes, some times the treeview may contain 255 nodes each...
7
by: kimmelsd33 | last post by:
I am using VB6. I want to read a tab delimited file, and assign each column value into a variable. If the variable is "-999.25", I want to make it a "0". I then want to reassemble the values, and...
0
BarryA
by: BarryA | last post by:
What are the essential steps and strategies outlined in the Data Structures and Algorithms (DSA) roadmap for aspiring data scientists? How can individuals effectively utilize this roadmap to progress...
1
by: nemocccc | last post by:
hello, everyone, I want to develop a software for my android phone for daily needs, any suggestions?
1
by: Sonnysonu | last post by:
This is the data of csv file 1 2 3 1 2 3 1 2 3 1 2 3 2 3 2 3 3 the lengths should be different i have to store the data by column-wise with in the specific length. suppose the i have to...
0
marktang
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,...
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
Oralloy
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,...
0
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
tracyyun
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...
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,...

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.