Single quotes in a string cause errors


Author
Message
Andria Jensen
Andria Jensen
Advanced StrataFrame User (600 reputation)Advanced StrataFrame User (600 reputation)Advanced StrataFrame User (600 reputation)Advanced StrataFrame User (600 reputation)Advanced StrataFrame User (600 reputation)Advanced StrataFrame User (600 reputation)Advanced StrataFrame User (600 reputation)Advanced StrataFrame User (600 reputation)Advanced StrataFrame User (600 reputation)
Group: Forum Members
Posts: 336, Visits: 497
I have some string fields on a few of my forms that have apostrophes (single quotes) in them in the database.  Things like New Year's Day cause errors when I go to save the BO using the Save method.  How do I get around this?
Reply
StrataFrame Team
S
StrataFrame Developer (6.5K reputation)StrataFrame Developer (6.5K reputation)StrataFrame Developer (6.5K reputation)StrataFrame Developer (6.5K reputation)StrataFrame Developer (6.5K reputation)StrataFrame Developer (6.5K reputation)StrataFrame Developer (6.5K reputation)StrataFrame Developer (6.5K reputation)StrataFrame Developer (6.5K reputation)
Group: StrataFrame Developers
Posts: 3K, Visits: 2.5K
When you run your application, in your SetDataSources() method of the AppMain.vb file, after the call to ConnectionManager.SetConnections(), add this line:

MicroFour.StrataFrame.DataLayer.DataSources("").SetDebugOn("C:\SFDebug.html", True)

When you run your app, and try to save, it will record the debug results to that output file.  Then, if you can attatch the file to a forum post, it will tell me the syntax of the command that it's trying to execute and should help me figure out what's going on.  Thanks.

GO

Merge Selected

Merge into selected topic...



Merge into merge target...



Merge into a specific topic ID...





Similar Topics

Reading This Topic

Login

Explore
Messages
Mentions
Search