Lazarus
Home
Help
TinyPortal
Search
Login
Register
Lazarus
»
Forum
»
Programming
»
Databases
»
Load a Dbf Memo field from one table to another table Dbf Memo field
Free Pascal
Website
Downloads
Wiki
Documentation
Bugtracker
Mailing List
Lazarus
Website
Downloads (Laz+FPC)
Packages (OPM)
FAQ
Wiki
Documentation (RTL/FCL/LCL)
Bugtracker
CCR Bugs
GIT
Mailing List
Other languages
Foundation
Website
Useful Wiki Links
Project Roadmap
Getting the Source
Screenshots
How to use the forum
About donations (wiki)
Bookstore
Computer Math and Games in Pascal
(preview)
Lazarus Handbook
Search
Advanced search
Recent
[SOLVED] Anyone can tell ...
by
1HuntnMan
[
Today
at 11:25:03 pm]
I can write your README.m...
by
schuler
[
Today
at 11:24:01 pm]
Command-line args are not...
by
AlexTP
[
Today
at 11:10:52 pm]
Include Informative Line ...
by
munair
[
Today
at 10:53:36 pm]
A little bug in fpsimages...
by
Roni Wolf
[
Today
at 10:14:19 pm]
How to use MySQL by PHP ?
by
Leledumbo
[
Today
at 09:11:11 pm]
A problem with ptcmouse
by
TRon
[
Today
at 09:08:24 pm]
Why there is no build-in ...
by
TRon
[
Today
at 08:42:45 pm]
Anyone into mDNS?
by
bobby100
[
Today
at 08:31:52 pm]
Why isn't Lazarus / Free ...
by
Joanna from IRC
[
Today
at 08:04:37 pm]
Add an off topic category...
by
Joanna from IRC
[
Today
at 08:03:18 pm]
Practical Ways to Help La...
by
Joanna from IRC
[
Today
at 07:58:45 pm]
FPC 3.2.2 + NASM Windows ...
by
marcov
[
Today
at 07:39:06 pm]
Compilation Failure of Me...
by
wp
[
Today
at 07:30:50 pm]
Binary Matrix Effect
by
Gigatron
[
Today
at 07:06:02 pm]
Need some clarificatio pl...
by
Aruna
[
Today
at 03:30:09 pm]
object width, object.canv...
by
Phoenix
[
Today
at 01:31:31 pm]
LCL? - Working with files...
by
djongepier
[
Today
at 01:03:15 pm]
[SOLVED] Android: how to ...
by
mirce.vladimirov
[
Today
at 11:54:41 am]
Added components from lis...
by
Rico54
[
Today
at 11:39:41 am]
Errors linking the projec...
by
MarcoST
[
Today
at 10:10:18 am]
Help Wanted
by
af0815
[
Today
at 08:38:16 am]
Can copy area ?
by
dodgex
[
Today
at 05:19:05 am]
Who avalible TvisualPlani...
by
eldonfsr
[
Today
at 02:27:07 am]
BGRAGtkBitmap
by
Fred vS
[May 13, 2025, 10:44:48 pm]
« previous
next »
Print
Pages: [
1
]
Author
Topic: Load a Dbf Memo field from one table to another table Dbf Memo field (Read 1701 times)
1HuntnMan
Sr. Member
Posts: 356
From Delphi 7 to Lazarus
Load a Dbf Memo field from one table to another table Dbf Memo field
«
on:
May 23, 2024, 11:27:04 pm »
Usually I load data from one table field to another table field that are either string or integer fields, i.e.
Code: Pascal
[Select]
[+]
[-]
DbfAppmts
.
FieldByName
(
'CNTKFNAME'
)
.
AsString
:
=
DbfCntks
.
FieldByName
(
'CNTKFNAME'
)
.
AsString
;
DbfAppmts
.
FieldByName
(
'CNTKMI'
)
.
AsString
:
=
DbfCntks
.
FieldByName
(
'CNTKMI'
)
.
AsString
;
but have a need to xfer a Memo field TravelDirections from one table to another.
Logged
paweld
Hero Member
Posts: 1364
Re: Load a Dbf Memo field from one table to another table Dbf Memo field
«
Reply #1 on:
May 24, 2024, 12:19:08 am »
Code: Pascal
[Select]
[+]
[-]
DbfAppmts
.
FieldByName
(
'MemoFNAME'
)
.
Value
:
=
DbfCntks
.
FieldByName
(
'MemoFNAME'
)
.
Value
;
Logged
Best regards / Pozdrawiam
paweld
egsuh
Hero Member
Posts: 1600
Re: Load a Dbf Memo field from one table to another table Dbf Memo field
«
Reply #2 on:
May 24, 2024, 04:39:29 am »
I think AsString will work.
Logged
1HuntnMan
Sr. Member
Posts: 356
From Delphi 7 to Lazarus
Re: Load a Dbf Memo field from one table to another table Dbf Memo field
«
Reply #3 on:
May 27, 2024, 05:49:23 pm »
Thanks, just couldn't find it in my downloaded docs. I'm adding this to my docs.
I'm going to test both .Value and .String
1HuntnMan
Logged
1HuntnMan
Sr. Member
Posts: 356
From Delphi 7 to Lazarus
Re: Load a Dbf Memo field from one table to another table Dbf Memo field
«
Reply #4 on:
May 27, 2024, 07:23:24 pm »
If you key in:
Code: Pascal
[Select]
[+]
[-]
DbfAppmts
.
FieldByName
(
'DIRECTIONS'
)
.
Value
:
=
DbfClient
.
FieldByName
(
'TRAVELDIRECTIONS'
)
.
Value
;
Laz will allow when you key . then lookup Value:variant but won't allow .String.
Logged
Print
Pages: [
1
]
« previous
next »
Lazarus
»
Forum
»
Programming
»
Databases
»
Load a Dbf Memo field from one table to another table Dbf Memo field
TinyPortal
© 2005-2018