Re: Insert memo using SQL

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

Article #1594

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

#1594

From: Gary Thoenen
Date: Mon, 03 Nov 1997 00:00

19 lines
1061 bytes

Joe Yuzamas wrote:
> Does anyone out there know how to insert a memo field using SQL?

Joe - To insert a field into an existing table, you need the SQL 
ALTER TABLE command:

  ALTER TABLE <table name> ADD <field name> <data type> 
  
For a memo field, the data type would be BLOB(n,1), where "n" is 
the length in bytes.  It seems to work OK using just 1 for n.

To insert the contents of an editor control on a form into a memo 
field in an existing table, set the DataLink property of the 
control to the field.  E.g.:

  form.editor1.DataLink = "MYTABLE->MEMO1"

-- Gary Thoenen (TeamB)

Technical Details

Message-ID: <VA.000002be.01c7942c@umktgghc>

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

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

Show Full Headers

Complete Article Headers

X-Google-Language: ENGLISH,ASCII-7-bit
X-Google-Thread: ff5a1,54de84368845dbc
X-Google-Attributes: gidff5a1,public
From: Gary Thoenen (TeamB) <teamb@opto-pps.com>
Subject: Re: Insert memo using SQL
Date: 1997/11/03
Message-ID: <VA.000002be.01c7942c@umktgghc>
X-Deja-AN: 286714844
References: <01bce7bb$0b5ee400$1030f489@jyuzamas.robins.af.mil>
Organization: TeamB
Reply-To: teamb@opto-pps.com
Newsgroups: borland.public.vdbase.data.sql

Reply to Parent Message