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
Simple form with custom t...
by
GypsyPrince
[
Today
at 03:25:25 pm]
CENSIMENTO UTENTI ITALIAN...
by
xinyiman
[
Today
at 03:19:39 pm]
Enum visibility across un...
by
circular
[
Today
at 03:01:04 pm]
Is there a function calle...
by
Awkward
[
Today
at 02:48:28 pm]
MacOS intel : Lazarus-dar...
by
Selzig
[
Today
at 02:25:00 pm]
Serial port
by
ccrause
[
Today
at 01:35:10 pm]
Functions that return str...
by
440bx
[
Today
at 01:28:24 pm]
I can write your README.m...
by
wp
[
Today
at 01:23:12 pm]
Change font colour when s...
by
rvk
[
Today
at 12:58:47 pm]
[SOLVED] Ascii code to st...
by
Thaddy
[
Today
at 12:44:46 pm]
is atexit() availabel for...
by
Thaddy
[
Today
at 12:13:29 pm]
string argument as array ...
by
jcmontherock
[
Today
at 11:38:26 am]
How to install a patch - ...
by
TRon
[
Today
at 10:53:20 am]
Any way to change the TOD...
by
egsuh
[
Today
at 10:19:31 am]
Wiki access blocked
by
cdbc
[
Today
at 08:15:11 am]
RegisterClassA SegFault
by
paule32
[
Today
at 07:54:05 am]
Lazarus Release 4.0
by
Bart
[May 22, 2025, 10:32:44 pm]
Feature announcement: Fun...
by
Bart
[May 22, 2025, 10:14:44 pm]
DelteFile function - Unic...
by
PascalDragon
[May 22, 2025, 08:57:54 pm]
val return code
by
PascalDragon
[May 22, 2025, 08:46:06 pm]
I think I found a bug in ...
by
Hansvb
[May 22, 2025, 08:14:02 pm]
ignore class/record attri...
by
Thaddy
[May 22, 2025, 07:11:38 pm]
Dreaded 443 Error
by
Thaddy
[May 22, 2025, 07:00:08 pm]
How to close a window whi...
by
sensui
[May 22, 2025, 05:49:25 pm]
A little bug in fpsimages...
by
wp
[May 22, 2025, 04:19:23 pm]
« previous
next »
Print
Pages: [
1
]
Author
Topic: Load a Dbf Memo field from one table to another table Dbf Memo field (Read 1706 times)
1HuntnMan
Sr. Member
Posts: 361
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: 1376
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: 1602
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: 361
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: 361
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