🚀 go-pugleaf

RetroBBS NetNews Server

Inspired by RockSolid Light RIP Retro Guy

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

Re: Insert memo using SQL

#1596
From: Joe Yuzamas
Date: Mon, 03 Nov 1997 00:00
27 lines
1726 bytes
Thank you Romain, that is what I meant. I want to write a new memo record
or update an existing memo record. I can not use the datalink property, as
this form has no view. Because of special data handling required, I use SQL
statments to update form fields and to save data. Basicly I guess what I am
asking is how do you do memory substitution (:X) with memo fields. Surely
Borland didn't leave out a way to do this. There should be a way to use the
INSERT or UPDATE command to add or update a memo field in a DBF.

Joe

Romain Strieff [TeamB] <Romain@Do.not.reply.via.e-mail> wrote in article
<MPG.ec7e4abc20637b3989ec2@forums.borland.com>...
> In article <VA.000002be.01c7942c@umktgghc>, teamb@opto-pps.com says...
> > > 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:
> > 
> He meant creating a new record and changing that records memo value, not 
> inserting a new field into the structure. Alsmost fell into the trap 
> too.<G>
> -- 
> Romain Strieff [TeamB]
> A few VdB utilities at:
> http://ourworld.compuserve.com/homepages/RStrieff/
> 
Technical Details
Message-ID: <01bce869$f9b79760$1030f489@jyuzamas.robins.af.mil>
Path: arc1-ca.pugleaf.net!unknown!not-for-mail
References: <01bce7bb$0b5ee400$1030f489@jyuzamas.robins.af.mil> <VA.000002be.01c7942c@umktgghc> <MPG.ec7e4abc20637b3989ec2@forums.borland.com>

Show Full Headers
Complete Article Headers
X-Google-Language: ENGLISH,ASCII-7-bit
X-Google-Thread: ff5a1,54de84368845dbc
X-Google-Attributes: gidff5a1,public
From: "Joe Yuzamas" <jyuzamas@wrdiss1.robins.af.mil>
Subject: Re: Insert memo using SQL
Date: 1997/11/03
Message-ID: <01bce869$f9b79760$1030f489@jyuzamas.robins.af.mil>
X-Deja-AN: 286797437
References: <01bce7bb$0b5ee400$1030f489@jyuzamas.robins.af.mil> <VA.000002be.01c7942c@umktgghc> <MPG.ec7e4abc20637b3989ec2@forums.borland.com>
Organization: U.S. Air Force
Newsgroups: borland.public.vdbase.data.sql