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
"database not open" - IBX...
by
rvk
[
Today
at 04:51:02 pm]
TrayIcon doesn't work usi...
by
AlexTP
[
Today
at 04:43:30 pm]
IDE tabs and spaces, auto...
by
chris_laz
[
Today
at 03:58:43 pm]
Using Synchronize in a DL...
by
Remy Lebeau
[
Today
at 03:47:58 pm]
How to wirte a drag into ...
by
Nicole
[
Today
at 03:41:24 pm]
How to draw a point on a ...
by
wp
[
Today
at 03:09:38 pm]
Checking for number or no...
by
wp
[
Today
at 03:03:28 pm]
[maybe SOLVED] BUG in Inp...
by
robert rozee
[
Today
at 02:23:45 pm]
Program crashing with exc...
by
rvk
[
Today
at 01:43:23 pm]
File open or File close -...
by
paule32
[
Today
at 01:35:31 pm]
How To: Create and React ...
by
paweld
[
Today
at 01:19:22 pm]
ALSA lib pcm_dmix.c:1000:...
by
Fred vS
[
Today
at 12:42:33 pm]
Converting a Project from...
by
jcmontherock
[
Today
at 11:24:26 am]
Creating Self Signed Cert...
by
Trax
[
Today
at 11:22:19 am]
Lazarus Release Candidate...
by
timppl
[
Today
at 10:23:28 am]
Markdown Processor
by
Roland57
[
Today
at 08:31:53 am]
Uninstall
by
TRon
[
Today
at 08:26:46 am]
Internal error
by
WooBean
[
Today
at 08:18:23 am]
Problemas ao acessar o si...
by
Gustavo 'Gus' Carreno
[
Today
at 03:25:10 am]
[Solved] About TIdIRC and...
by
Gustavo 'Gus' Carreno
[March 20, 2025, 11:24:42 pm]
Tcsvdataset issue
by
silvercoder70
[March 20, 2025, 11:24:26 pm]
[Solved] Hooking to `OnIS...
by
Gustavo 'Gus' Carreno
[March 20, 2025, 10:39:36 pm]
Graphics32 installation e...
by
AndersM
[March 20, 2025, 09:12:27 pm]
How to assign value to re...
by
MarkMLl
[March 20, 2025, 08:50:09 pm]
Lazmapviewer: overlaying ...
by
MarkMLl
[March 20, 2025, 07:29:30 pm]
« previous
next »
Print
Pages: [
1
]
Author
Topic: Load a Dbf Memo field from one table to another table Dbf Memo field (Read 1672 times)
1HuntnMan
Sr. Member
Posts: 323
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: 1326
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: 1562
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: 323
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: 323
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