Icon View Thread

The following is the text of the current message along with any replies.
Messages 1 to 4 of 4 total
Thread How to Insert memo data?
Mon, Sep 22 2008 11:59 PMPermanent 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 AMPermanent Link

Tim Young [Elevate Software]

Elevate Software, Inc.

Avatar

Email 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 AMPermanent 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 AMPermanent Link

Tim Young [Elevate Software]

Elevate Software, Inc.

Avatar

Email timyoung@elevatesoft.com

Brent,

<< Does ElevateDb SQL have the same problem? >>

No, EDB allows embedded CRLF pairs.

--
Tim Young
Elevate Software
www.elevatesoft.com

Image