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
IBSQL - CheckClosed
by
Zoran
[
Today
at 10:36:43 pm]
Failed to connect to a si...
by
MarkMLl
[
Today
at 10:16:12 pm]
Why free pascal suppress ...
by
dseligo
[
Today
at 10:09:34 pm]
What's up with PtcCrt's d...
by
TBMan
[
Today
at 10:07:17 pm]
FPC can't link screen_dem...
by
marcov
[
Today
at 09:22:40 pm]
Treeview: full-width back...
by
d7_2_laz
[
Today
at 09:11:10 pm]
Transparent animation
by
majolika
[
Today
at 08:22:22 pm]
Read Excel file with fpsp...
by
zeljko
[
Today
at 08:17:38 pm]
Error assembling some lab...
by
Fred vS
[
Today
at 08:11:17 pm]
Drawing with psInsidefram...
by
wp
[
Today
at 08:05:48 pm]
Scrollbox, scrollbar Back...
by
dsiders
[
Today
at 07:32:48 pm]
Deal or no Deal graphic
by
TRon
[
Today
at 07:27:51 pm]
MQTT made easier...
by
cdbc
[
Today
at 07:10:17 pm]
zeoslib av on transactio...
by
jksmithiii
[
Today
at 07:07:16 pm]
A basic windows program s...
by
TBMan
[
Today
at 05:44:37 pm]
Is there a way to emphasi...
by
cdbc
[
Today
at 04:17:43 pm]
RTL: export/import WriteL...
by
paule32
[
Today
at 04:15:30 pm]
read keys from windows ko...
by
marcov
[
Today
at 03:49:22 pm]
my programs crash
by
jamie
[
Today
at 01:22:58 pm]
Custom self drawn compone...
by
cdbc
[
Today
at 12:50:10 pm]
IsNan
by
robert rozee
[
Today
at 12:07:43 pm]
Reading and writing AVIF ...
by
Boleeman
[
Today
at 12:01:52 pm]
Reading FLIF images in La...
by
Boleeman
[
Today
at 11:58:25 am]
FLIF and FUIF Formats (Fr...
by
Boleeman
[
Today
at 11:42:17 am]
efficiency problem
by
photor
[
Today
at 11:33:05 am]
« previous
next »
Print
Pages: [
1
]
Author
Topic: Load a Dbf Memo field from one table to another table Dbf Memo field (Read 1566 times)
1HuntnMan
Sr. Member
Posts: 284
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: 1293
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: 1533
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: 284
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: 284
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