473,624 Members | 2,249 Online
Bytes | Software Development & Data Engineering Community
+ Post

Home Posts Topics Members FAQ

2-3 words in field name

Can I define field names with more words in Access and SQL Server like
field: "Bus station" instead "BusStation " or "Bus_Statio n"? I have had
problems because of this in VB6. Can I have problems in VB 2005 or C# 2005
and SQL Server?
Dec 20 '06 #1
2 920
Goran (gz****@gmail.c om) writes:
Can I define field names with more words in Access and SQL Server like
field: "Bus station" instead "BusStation " or "Bus_Statio n"? I have had
problems because of this in VB6. Can I have problems in VB 2005 or C# 2005
and SQL Server?
Yes you can. You need to enclose the name in brackets [] or double quotes ""
whenever you use it.
--
Erland Sommarskog, SQL Server MVP, es****@sommarsk og.se

Books Online for SQL Server 2005 at
http://www.microsoft.com/technet/pro...ads/books.mspx
Books Online for SQL Server 2000 at
http://www.microsoft.com/sql/prodinf...ons/books.mspx
Dec 20 '06 #2
Hi,

It's not recommended though.

You shouldn't use the field names as captions if you want something more
readable. For instance, if you're using a DataSet you can assign the
Caption property to something other than the field name. In grids you can
easily set the headers at design-time.

--
Dave Sexton

"Goran" <gz****@gmail.c omwrote in message
news:em******** **@sunce.iskon. hr...
Can I define field names with more words in Access and SQL Server like
field: "Bus station" instead "BusStation " or "Bus_Statio n"? I have had
problems because of this in VB6. Can I have problems in VB 2005 or C# 2005
and SQL Server?

Dec 20 '06 #3

This thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

4
8742
by: mr_burns | last post by:
Hi there, I have a text box that I will use to search a database. I would like to use it so that it will not use a whole string (ie. 'red striped top') but instead break it up into individual words (ie. 'red', 'striped', 'top') and maybe put it into and array. I will then use the words in the array to search the database. How do I break a string up this way?
9
2966
by: Gary | last post by:
Hello, Is it possible to dynamically update a textbox with words chosen from a list using form checkboxes and javascript? Gary
8
2374
by: Peter Bungart | last post by:
I have a text field in Access (XP) that lists the occurrences of various plants, which are delimited within the field by commas (e.g., cactus, mesquite, yucca, cliffrose). Is there a way to tabulate the occurrence of each type of plant within the field, essentially allowing me to consider the text as data which can be analyzed across a geographic area? Would Word or Excel be a better tool for this? I hope my question is clear--its a little...
0
1553
by: PLENI SELENE | last post by:
HOW TECHNOLOGY MOVES FROM TALK TO ELECTRONIC DEVICES TO SPEAK GOOD SPANISH! Would you Like To Know How The Electronic Devices Understand When You Talk to Them, And How It Works To Speak Spanish? Because spelling words and names are common in English, Software have been developed to code names based on how they sound. Searching and matching is done by converting a word or name to some phonetic code. Phonetic encoding...
6
1250
by: yourtrashhere | last post by:
So basically, what I have is a bunch of words in one memo field, for example: dog cat cowboy tree flower To search it, this is the code I have now. ' Check for LIKE Last Name If Me.txtLastName > "" Then varWhere = varWhere & " LIKE """ & Me.txtLastName & "*" * "
5
5034
by: vonclausowitz | last post by:
Repost from an VB group. Hi All, I'm looking for a way to search for multiple words in a database. There is however one but. The words have to be within a certain range of each other. For example I would like to find records which contain the word MALE and within for example 10 words of it the word BROWN.
2
1465
by: Goran | last post by:
Can I define field names with more words in Access and SQL Server like field: "Bus station" instead "BusStation" or "Bus_Station"? I have had problems because of this in VB6. Can I have problems in VB 2005 or C# 2005 and SQL Server?
1
2508
by: saurcurban | last post by:
Hi, Following is the xml file: ------------------------------------- <?xml version="1.0" encoding="UTF-8"?> <wc> Delhi is the capital of India
0
8534
missinglinq
by: missinglinq | last post by:
When naming controls and variables in Access you should always be careful not to use Access Reserved Words! If you have to give them a similar name, use something like txtDate, or even better, OrderDate. The use of Date and Time is particularly troublesome! The statements Date = "12/31/07" and Time = "11:59:59 PM" will not place "12/31/07" in a textbox named Date, nor "11:59:59 PM" in a textbox named Time, it'll reset your...
11
2118
by: captainphoenix | last post by:
In VB (.NET?) building a query from a table made in MS Access. I'm trying to type the sql line WHERE = @ but it won't recognize the code because "Course Number" is two words. the whole thing would work fine if i had remembered in MS Access to name it Course_Number but it's too late for that. How do i fix this?
0
8675
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, 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...
0
8619
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 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...
1
8334
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 Update option using the Control Panel or Settings app; it automatically checks for updates and installs any it finds, whether you like it or not. For most users, this new feature is actually very convenient. If you want to control the update process,...
0
8474
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 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...
0
7158
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, and deployment—without human intervention. Imagine an AI that can take a project description, break it down, write the code, debug it, and then launch it, all on its own.... Now, this would greatly impact the work of software developers. The idea...
0
4078
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...
1
2604
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 we have to send another system
1
1784
muto222
by: muto222 | last post by:
How can i add a mobile payment intergratation into php mysql website.
2
1482
bsmnconsultancy
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...

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.