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
Use tts0, This example is...
by
Thaddy
[
Today
at 06:28:12 am]
Developing a Kernel Modul...
by
Thaddy
[
Today
at 05:56:45 am]
Storing line colors
by
user5
[
Today
at 05:03:24 am]
Type Library Viewer, Impo...
by
UamhForever
[
Today
at 03:12:22 am]
Python4Lazarus Undefined ...
by
Jurassic Pork
[
Today
at 02:07:28 am]
Show Form at Top
by
TRon
[
Today
at 12:48:24 am]
Problem with Hints
by
simsee
[
Today
at 12:08:54 am]
ZDataset.Locate + loParti...
by
Sieben
[December 03, 2024, 11:30:03 pm]
Zaos Transliteration on l...
by
hamacker
[December 03, 2024, 11:12:53 pm]
Breakpoint dosn't work
by
Joanna from IRC
[December 03, 2024, 11:04:55 pm]
[SOLVED] Howto use a DEFI...
by
PascalDragon
[December 03, 2024, 09:42:38 pm]
Random SnowFlakes:
by
Boleeman
[December 03, 2024, 09:07:14 pm]
AVRPascal – free code edi...
by
ackarwow
[December 03, 2024, 09:04:00 pm]
Secondary Installation fo...
by
TRon
[December 03, 2024, 08:21:03 pm]
Error when attempting to ...
by
dsiders
[December 03, 2024, 08:01:39 pm]
The Form cannot be resize...
by
daxnet
[December 03, 2024, 02:51:42 pm]
Api/component pack for Ra...
by
MarkMLl
[December 03, 2024, 02:15:57 pm]
kernel 6.8 and checking s...
by
MarkMLl
[December 03, 2024, 02:13:41 pm]
storing string
by
Thaddy
[December 03, 2024, 09:38:41 am]
OverLapping Snowflake Fra...
by
Boleeman
[December 03, 2024, 09:04:01 am]
[SOLVED] StringGrid color...
by
Vodnik
[December 03, 2024, 08:26:44 am]
YM Player
by
TRon
[December 03, 2024, 02:32:16 am]
How single procedure ends...
by
Marion
[December 03, 2024, 01:57:43 am]
ct2laz - convertor betwee...
by
Sharfik
[December 03, 2024, 01:26:03 am]
Amigo programming languag...
by
maurog
[December 02, 2024, 11:19:44 pm]
« previous
next »
Print
Pages: [
1
]
Author
Topic: Load a Dbf Memo field from one table to another table Dbf Memo field (Read 1391 times)
1HuntnMan
Sr. Member
Posts: 276
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: 1268
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: 1489
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: 276
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: 276
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