Article View: borland.public.vdbase.data.sql
Article #1596Re: Insert memo using SQL
From: Joe Yuzamas
Date: Mon, 03 Nov 1997 00:00
Date: Mon, 03 Nov 1997 00:00
27 lines
1726 bytes
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-mailReferences:
<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