🚀 go-pugleaf

RetroBBS NetNews Server

Inspired by RockSolid Light RIP Retro Guy

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

Re: Insert memo using SQL

#1597
From: Romain Strieff [TeamB]
Date: Tue, 04 Nov 1997 00:00
31 lines
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-mail
References: <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