Insert memo using SQL

Article View: borland.public.vdbase.data.sql

Article #1592

Back to borland.public.vdbase.data.sql Previous Next

#1592

From: Joe Yuzamas
Date: Sun, 02 Nov 1997 00:00

23 lines
821 bytes



Does anyone out there know how to insert a memo field using SQL? I have
tried the following;

form.memo  is defined as a memo field on a form

memo1 is define as a memo field in a .DBF

cMemo = form.memo.Value
INSERT INTO DBF (MEMO1) ;
	VALUES (:cMEMO)

AND

cSqlStr = "INSERT INTO DBF (MEMO1) ;
	VALUES ("+cMEMO+")"

I get the error 'UNSUPPORT OPERATION ON BLOB FIELD". Does anyone have an
answer?

Joe

Technical Details

Message-ID: <01bce7bb$0b5ee400$1030f489@jyuzamas.robins.af.mil>

Path: arc1-ca.pugleaf.net!unknown!not-for-mail

Show Full Headers

Complete Article Headers

X-Google-Language: ENGLISH,ASCII-7-bit
X-Google-Thread: ff5a1,54de84368845dbc,start
X-Google-Attributes: gidff5a1,public
From: "Joe Yuzamas" <jyuzamas@wrdiss1.robins.af.mil>
Subject: Insert memo using SQL
Date: 1997/11/02
Message-ID: <01bce7bb$0b5ee400$1030f489@jyuzamas.robins.af.mil>
X-Deja-AN: 286607519
Organization: U.S. Air Force
Newsgroups: borland.public.vdbase.data.sql