Login ProductsSalesSupportDownloadsAbout |
Home » Technical Support » DBISAM Technical Support » Support Forums » DBISAM General » View Thread |
Messages 1 to 4 of 4 total |
How to Insert memo data? |
Mon, Sep 22 2008 11:59 PM | Permanent Link |
Brent | I had Advantage export data as generated Insert statements and tried to run it in DSU. I
keep getting SQL parsing error whenever the memo wraps onto another line. Why? The memo is quote delimited and should import fine (into any other database). Why doesn't it work in DBISAM 4.25? TIA Brent |
Tue, Sep 23 2008 7:40 AM | Permanent Link |
Tim Young [Elevate Software] Elevate Software, Inc. timyoung@elevatesoft.com | Brent,
<< I had Advantage export data as generated Insert statements and tried to run it in DSU. I keep getting SQL parsing error whenever the memo wraps onto another line. Why? The memo is quote delimited and should import fine (into any other database). Why doesn't it work in DBISAM 4.25? >> DBISAM does not allow embedded CRLF pairs in string constants, so you have to convert them to this: 'Text'+#13+#10+'Text'+.....etc. -- Tim Young Elevate Software www.elevatesoft.com |
Tue, Sep 23 2008 11:32 AM | Permanent Link |
Brent | "Tim Young [Elevate Software]" <timyoung@elevatesoft.com> wrote:
DBISAM does not allow embedded CRLF pairs in string constants, so you have to convert them to this: 'Text'+#13+#10+'Text'+.....etc. Tim, Thanks, I was able to put the insert statements into an editor and do a global change on the returns. Most SQL that I've used in the past will parse the SQL values based on the closing quotes and will simply insert the returns into the text/memo fields. Since DBISAM has full text search capabilities, I would have thought there would be an easy way to import a lot of text data into one of your tables using SQL. Does ElevateDb SQL have the same problem? TIA Brent |
Wed, Sep 24 2008 6:56 AM | Permanent Link |
Tim Young [Elevate Software] Elevate Software, Inc. timyoung@elevatesoft.com | Brent,
<< Does ElevateDb SQL have the same problem? >> No, EDB allows embedded CRLF pairs. -- Tim Young Elevate Software www.elevatesoft.com |
This web page was last updated on Friday, March 29, 2024 at 03:30 AM | Privacy PolicySite Map © 2024 Elevate Software, Inc. All Rights Reserved Questions or comments ? E-mail us at info@elevatesoft.com |