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
Forum Rules
About donations (wiki)
Bookstore
Computer Math and Games in Pascal
(preview)
Lazarus Handbook
Search
Advanced search
Recent
Getting results from sql ...
by
cdbc
[
Today
at 10:47:53 am]
Hello! Anything new?
by
Thaddy
[
Today
at 10:46:18 am]
Exiting HeapTrace dump
by
Thaddy
[
Today
at 10:34:52 am]
could Ardour's YTK be use...
by
abouchez
[
Today
at 10:23:16 am]
Debian releases a Gtk3 La...
by
dbannon
[
Today
at 10:05:16 am]
mORMot again (HttpServer/...
by
DonAlfredo
[
Today
at 08:47:54 am]
CONCAT formula
by
Zvoni
[
Today
at 08:17:21 am]
Any way to "embed" Window...
by
egsuh
[
Today
at 05:38:10 am]
Is it me or is there some...
by
Martin_fr
[
Today
at 12:51:22 am]
[SOLVED] GTK3 : Icons hav...
by
Schmitty2005
[March 15, 2026, 08:43:28 pm]
emuloader: help to resurr...
by
arcadegamer
[March 15, 2026, 08:30:31 pm]
AutoSize TMemo.Height?
by
wp
[March 15, 2026, 05:55:05 pm]
Initialization & finaliza...
by
Martin_fr
[March 15, 2026, 05:24:36 pm]
Possible Enhancement to t...
by
jamie
[March 15, 2026, 04:10:38 pm]
lazarus 4.99 and missing ...
by
wp
[March 15, 2026, 03:11:43 pm]
Questions about TFuncSeri...
by
hedgehog
[March 15, 2026, 06:58:29 am]
Problem with drawing orde...
by
wp
[March 15, 2026, 12:57:00 am]
CryptoLib4Pascal
by
Xor-el
[March 14, 2026, 06:17:32 pm]
Extended Module Player
by
Gigatron
[March 14, 2026, 05:32:06 pm]
[AGGPas] Difference betwe...
by
Roland57
[March 14, 2026, 04:36:02 pm]
declaring Array
by
Thaddy
[March 14, 2026, 01:24:11 pm]
TChart: Wrong default val...
by
wp
[March 14, 2026, 11:30:54 am]
Text Fill (Memo)
by
paweld
[March 14, 2026, 09:09:13 am]
Qt6/Wayland clipboard: pa...
by
AlexTP
[March 14, 2026, 08:56:58 am]
Pocketbase
by
PierceNg
[March 14, 2026, 06:29:04 am]
« previous
next »
Print
Pages: [
1
]
Author
Topic: Load a Dbf Memo field from one table to another table Dbf Memo field (Read 2062 times)
1HuntnMan
Sr. Member
Posts: 437
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: 1582
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: 1761
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: 437
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: 437
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