Forum > Databases

Load a Dbf Memo field from one table to another table Dbf Memo field

(1/1)

1HuntnMan:
Usually I load data from one table field to another table field that are either string or integer fields, i.e.
 
--- Code: Pascal  [+][-]window.onload = function(){var x1 = document.getElementById("main_content_section"); if (x1) { var x = document.getElementsByClassName("geshi");for (var i = 0; i < x.length; i++) { x[i].style.maxHeight='none'; x[i].style.height = Math.min(x[i].clientHeight+15,306)+'px'; x[i].style.resize = "vertical";}};} ---    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.

paweld:

--- Code: Pascal  [+][-]window.onload = function(){var x1 = document.getElementById("main_content_section"); if (x1) { var x = document.getElementsByClassName("geshi");for (var i = 0; i < x.length; i++) { x[i].style.maxHeight='none'; x[i].style.height = Math.min(x[i].clientHeight+15,306)+'px'; x[i].style.resize = "vertical";}};} ---DbfAppmts.FieldByName('MemoFNAME').Value := DbfCntks.FieldByName('MemoFNAME').Value;

egsuh:
I think AsString will work.

1HuntnMan:
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

1HuntnMan:
If you key in:

--- Code: Pascal  [+][-]window.onload = function(){var x1 = document.getElementById("main_content_section"); if (x1) { var x = document.getElementsByClassName("geshi");for (var i = 0; i < x.length; i++) { x[i].style.maxHeight='none'; x[i].style.height = Math.min(x[i].clientHeight+15,306)+'px'; x[i].style.resize = "vertical";}};} ---  DbfAppmts.FieldByName('DIRECTIONS').Value:=     DbfClient.FieldByName('TRAVELDIRECTIONS').Value;  

Laz will allow when you key . then lookup Value:variant but won't allow .String.

Navigation

[0] Message Index

Go to full version