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
FPC Unleashed (inline var...
by
440bx
[
Today
at 01:25:18 am]
Splitting Picture into Qu...
by
ADMGNS
[June 06, 2026, 10:44:04 pm]
[New Component] ExtTabCtr...
by
wp
[June 06, 2026, 10:19:06 pm]
water filling simulation
by
ADMGNS
[June 06, 2026, 09:54:50 pm]
Array of structure -> str...
by
Seenkao
[June 06, 2026, 09:44:44 pm]
Very rough version of a s...
by
Hansvb
[June 06, 2026, 08:56:35 pm]
Portable verion of FPC an...
by
backprop
[June 06, 2026, 08:40:34 pm]
GDB 17 for Windows
by
Martin_fr
[June 06, 2026, 08:26:24 pm]
TStringGrid Question
by
J-G
[June 06, 2026, 08:05:52 pm]
Lazarus Main and Gnome/Wa...
by
zeljko
[June 06, 2026, 05:48:44 pm]
Benchmark: converting arr...
by
LemonParty
[June 06, 2026, 03:25:25 pm]
Read/Parse PDB file to ge...
by
marcov
[June 06, 2026, 02:48:12 pm]
[SOVLED]Curved text in La...
by
paweld
[June 06, 2026, 11:00:52 am]
Fast Canvas Library V1.05...
by
microxa
[June 06, 2026, 07:03:07 am]
"Identifier idents no mem...
by
Thaddy
[June 06, 2026, 05:43:52 am]
[SOLVED] TPrintDialog Pro...
by
spuds
[June 06, 2026, 01:30:20 am]
TPairsplitter could be be...
by
jamie
[June 06, 2026, 12:36:34 am]
FloatToStr issue
by
J-G
[June 06, 2026, 12:06:38 am]
Release ray4laz 6.0
by
Fred vS
[June 05, 2026, 09:06:27 pm]
Pascal for AI Agent CLI T...
by
Martin_fr
[June 05, 2026, 08:01:11 pm]
storing assets for releas...
by
flowCRANE
[June 05, 2026, 07:30:13 pm]
Benchmark aligned vs unal...
by
LeP
[June 05, 2026, 06:33:08 pm]
TstringGrid read cell col...
by
hedgehog
[June 05, 2026, 06:29:11 pm]
Range checks and `Move` o...
by
ASerge
[June 05, 2026, 05:17:19 pm]
Why is var after type in ...
by
Warfley
[June 05, 2026, 02:36:17 pm]
« previous
next »
Print
Pages: [
1
]
Author
Topic: Load a Dbf Memo field from one table to another table Dbf Memo field (Read 2118 times)
1HuntnMan
Sr. Member
Posts: 449
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: 1637
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: 1800
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: 449
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: 449
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