Welcome, Guest: Register On Nairaland / LOGIN! / Trending / Recent / NewStats: 3,195,571 members, 7,958,766 topics. Date: Wednesday, 25 September 2024 at 11:06 PM |
Nairaland Forum / Science/Technology / Programming / Inserting Text With Apotrophe Into Access (726 Views)
Special Codes To Format Text On Nairaland / Help With Inserting Codes B/w php / Inserting And Retrieving Images To/From Database In ASP.NET (2) (3) (4)
Inserting Text With Apotrophe Into Access by leastpay(m): 3:26pm On Apr 03, 2013 |
Please help me out i'm having problem inserting a text with apostrophe from a textbox into a ms access . E.g st. Paul's academy. I'm using vb.net 2008 |
Re: Inserting Text With Apotrophe Into Access by Bossman(m): 5:48pm On Apr 03, 2013 |
You need to escape the apostrophe. Google found this - http://stackoverflow.com/questions/199889/escaping-in-access-sql |
Re: Inserting Text With Apotrophe Into Access by leastpay(m): 8:37pm On Apr 04, 2013 |
Thnks bossman, i did it using "replace". I discovered several ways of solving that problem like using parameterize query when inserting value |
(1) (Reply)
How Much Would You Charge For A Multi-platform App / Closed / Learn How To Create Android Mobile Apps WITH OUT CODING.WOW
(Go Up)
Sections: politics (1) business autos (1) jobs (1) career education (1) romance computers phones travel sports fashion health religion celebs tv-movies music-radio literature webmasters programming techmarket Links: (1) (2) (3) (4) (5) (6) (7) (8) (9) (10) Nairaland - Copyright © 2005 - 2024 Oluwaseun Osewa. All rights reserved. See How To Advertise. 6 |