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
Force parameters of my ap...
by
TRon
[
Today
at 03:02:47 am]
Pasettimino - Ethernet co...
by
avra
[
Today
at 02:54:29 am]
Scrolling the form.
by
OC DelGuy
[
Today
at 02:48:17 am]
raylib and addons
by
Guva
[
Today
at 02:11:58 am]
GTK3 still alpha
by
ALLIGATOR
[
Today
at 02:11:46 am]
Remote access to database...
by
duralast
[
Today
at 12:29:27 am]
New 2D StarField
by
Gigatron
[March 18, 2025, 11:19:00 pm]
NIL vs. Assign: when to u...
by
440bx
[March 18, 2025, 10:07:02 pm]
New version of BGRABitmap
by
sstvmaster
[March 18, 2025, 09:13:12 pm]
Sets Vs Arrays. When to ...
by
440bx
[March 18, 2025, 08:57:02 pm]
efficiency problem
by
PascalDragon
[March 18, 2025, 08:48:11 pm]
Connection to MySQL versi...
by
iginfo
[March 18, 2025, 08:32:32 pm]
Internal error
by
PascalDragon
[March 18, 2025, 08:24:30 pm]
Pagecontrol - Tabsheet ca...
by
Martin_fr
[March 18, 2025, 08:22:41 pm]
Dialogs and TTimer inside...
by
d2010
[March 18, 2025, 08:13:19 pm]
Add,update and delete by ...
by
wcage03
[March 18, 2025, 07:42:11 pm]
DbGrid or TSQLQuery best ...
by
wcage03
[March 18, 2025, 07:32:28 pm]
Converting a Project from...
by
wcage03
[March 18, 2025, 07:25:26 pm]
Undefined symbol: WSRegis...
by
d2010
[March 18, 2025, 07:15:20 pm]
TValueListEditor wont acc...
by
paule32
[March 18, 2025, 07:04:33 pm]
File open or File close -...
by
paule32
[March 18, 2025, 06:48:39 pm]
How To: Create and React ...
by
zxandris
[March 18, 2025, 05:19:20 pm]
Cursor changes to arrow o...
by
atlatl
[March 18, 2025, 05:16:44 pm]
dmg may contain virus
by
turunk
[March 18, 2025, 05:02:19 pm]
i have function named sho...
by
Thaddy
[March 18, 2025, 04:33:29 pm]
« previous
next »
Print
Pages: [
1
]
Author
Topic: Load a Dbf Memo field from one table to another table Dbf Memo field (Read 1668 times)
1HuntnMan
Sr. Member
Posts: 320
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: 1323
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: 1561
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: 320
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: 320
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