
	Home > Microsoft .Net Development Tips > ARCHIVE: Tips & Tricks > Darn that apostrophe

Win Development Tips:

EMAIL THIS

TIPS & NEWSLETTERS TOPICS

ARCHIVE: TIPS & TRICKS

Darn that apostrophe

Bruce Wood
02.20.2001
Rating: -3.79- (out of 5)

Digg This!

StumbleUpon

Del.icio.us

Darn that apostrophe
Bruce Wood

Your tips editor loves simple tips. These are tips that solve a big problem with a little fix. "An elegant solution," they used to call these things in engineering school. Here's a simple, elegant tip from reader Bruce Wood, about eschewing the commotion caused by apostrophes in user-input database entries.

When saving info to a database table the apostrophe character causes run-time errors. Most databases do not allow the use of the apostrophe as it is interpreted as a new field starting. This will cause syntax errors. Here is a very simple technique that overcomes this problem by handling it when it is typed in the form.

'Put this code in the keypress event
'of the selected text control

Select Case KeyAscii
  Case 39     'apostrophe
    KeyAscii = 96  'backwards apostrophe
  Case Else
    KeyAscii = KeyAscii
End Select

------------------------------------------------------
Thanks, Bruce. For your interest in SearchVB, we'll be sending you a SearchVB denim shirt.

Rate this Tip
To rate tips, you must be a member of SearchWinDevelopment.com. Register now to start rating these tips. Log in if you are already a member.
Submit a Tip

Digg This!

StumbleUpon

Del.icio.us

RELATED CONTENT

	ARCHIVE: Tips & Tricks
	SearchVB wants your tips
	Find out what VS.NET modules are installed
	Retrieving icons from an EXE-file
	Toggling Boolean values
	VS.NET multiple tabbed windows
	Set the value of a DataField in code behind
	Easy grid design
	Open using last Visual Studio.NET layout
	Save development time by using inherited forms
	Reusing code in VS.NET

RELATED RESOURCES

2020software.com, trial software downloads for accounting software, ERP software, CRM software and business software systems

Search Bitpipe.com for the latest white papers and business webcasts

Whatis.com, the online computer dictionary

DISCLAIMER: Our Tips Exchange is a forum for you to share technical advice and expertise with your peers and to learn from other enterprise IT professionals. TechTarget provides the infrastructure to facilitate this sharing of information. However, we cannot guarantee the accuracy or validity of the material submitted. You agree that your use of the Ask The Expert services and your reliance on any questions, answers, information or other materials received through this Web site is at your own risk.

Database Programming Solutions - .NET XML, Visual Studio LINQ, ORM .NET

SEARCH

TechTarget provides technology professionals with the information they need to perform their jobs - from developing strategy, to making cost-effective purchase decisions and managing their organizations' technology projects - with its network of technology-specific websites, events and online magazines.


TechTarget Corporate Web Site \| Media Kits \| Site Map All Rights Reserved, Copyright 2000 - 2009, TechTarget \| Read our Privacy Policy