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
TSynEdit XML tag completi...
by
dsiders
[March 26, 2025, 11:57:47 pm]
Warning on identifier usa...
by
440bx
[March 26, 2025, 11:20:19 pm]
Fpcupdeluxe
by
TRon
[March 26, 2025, 11:07:43 pm]
/lib/x86_64-linux-gnu/lib...
by
TRon
[March 26, 2025, 10:55:08 pm]
Lazarus Release Candidate...
by
zeljko
[March 26, 2025, 10:14:14 pm]
Converting a Project from...
by
TRon
[March 26, 2025, 10:06:56 pm]
Programmatically trigger ...
by
Tommi
[March 26, 2025, 09:44:43 pm]
Weird error: component no...
by
jamie
[March 26, 2025, 09:36:56 pm]
Radio Buttons cause a "ST...
by
jamie
[March 26, 2025, 09:29:43 pm]
Planet designer
by
Lulu
[March 26, 2025, 07:40:54 pm]
I'm puzzled and bewildere...
by
cdbc
[March 26, 2025, 07:25:29 pm]
ld: library 'gtk-3' not f...
by
zeljko
[March 26, 2025, 07:10:52 pm]
Option "RemoveExpressionR...
by
Thaddy
[March 26, 2025, 07:03:42 pm]
basic question for good s...
by
Nicole
[March 26, 2025, 06:42:17 pm]
TStringGrid AlternateC...
by
Nicole
[March 26, 2025, 04:46:45 pm]
Lazarus Windows apps in M...
by
Xenno
[March 26, 2025, 04:36:19 pm]
Lazarus Release Candidate...
by
baldzhang
[March 26, 2025, 04:03:08 pm]
Displying tooltips for ea...
by
Zvoni
[March 26, 2025, 03:10:51 pm]
ParambyName - how to stri...
by
Zvoni
[March 26, 2025, 03:04:49 pm]
link error on Ubuntu 22.0...
by
tetrastes
[March 26, 2025, 02:06:17 pm]
A question on Modula2 vs ...
by
Thaddy
[March 26, 2025, 01:22:47 pm]
DateUtils *Span and *Betw...
by
Чебурашка
[March 26, 2025, 12:13:14 pm]
"database not open" - IBX...
by
Nicole
[March 26, 2025, 11:54:25 am]
How to Run Lazarus App wi...
by
incendio
[March 26, 2025, 04:59:33 am]
ADUG Symposium 2025 is on
by
Mathias Burbach
[March 26, 2025, 02:10:05 am]
« previous
next »
Print
Pages: [
1
]
Author
Topic: Load a Dbf Memo field from one table to another table Dbf Memo field (Read 1676 times)
1HuntnMan
Sr. Member
Posts: 325
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: 1331
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: 1564
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: 325
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: 325
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