Article View: borland.public.vdbase.data.sql
Article #1597Re: Insert memo using SQL
From: Romain Strieff [TeamB]
Date: Tue, 04 Nov 1997 00:00
Date: Tue, 04 Nov 1997 00:00
31 lines
1810 bytes
1810 bytes
In article <01bce869$f9b79760$1030f489@jyuzamas.robins.af.mil>, jyuzamas@wrdiss1.robins.af.mil says... > > 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. ----- I'm sure you know that but no view is needed to use datalinks. Just an open table. A 'view' is nothing but a program with a funny extension so that the query designer knows he is meant, and that code just USEs the tables. > 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. ------ It really seems to be missing from the BDE version, can't get it to wotk with memo fields and SQL. Can't you just use the DML? use yourfile append blank replace mymemo with "whatever" -- Romain Strieff [TeamB] A few VdB utilities at: http://ourworld.compuserve.com/homepages/RStrieff/
Technical Details
Message-ID:
<MPG.ec915e7c253e62e989ed1@forums.borland.com>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> <01bce869$f9b79760$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: Romain@Do.not.reply.via.e-mail (Romain Strieff [TeamB]) Subject: Re: Insert memo using SQL Date: 1997/11/04 Message-ID: <MPG.ec915e7c253e62e989ed1@forums.borland.com> X-Deja-AN: 286993388 References: <01bce7bb$0b5ee400$1030f489@jyuzamas.robins.af.mil> <VA.000002be.01c7942c@umktgghc> <MPG.ec7e4abc20637b3989ec2@forums.borland.com> <01bce869$f9b79760$1030f489@jyuzamas.robins.af.mil> Reply-To: teamb@opto-pps.com Organization: TeamB Newsgroups: borland.public.vdbase.data.sql