Smart questions
Smart answers
Smart people
INTELLIGENT WORK FORUMS
FOR COMPUTER PROFESSIONALS

Member Login

Come Join Us!

Are you a
Computer / IT professional?
Join Tek-Tips now!
  • Talk With Other Members
  • Be Notified Of Responses
    To Your Posts
  • Keyword Search
  • One-Click Access To Your
    Favorite Forums
  • Automated Signatures
    On Your Posts
  • Best Of All, It's Free!

Join Tek-Tips
*Tek-Tips's functionality depends on members receiving e-mail. By joining you are opting in to receive e-mail.

LINK TO THIS FORUM!

Add Stickiness To Your Site By Linking To This Professionally Managed Technical Forum.
Just copy and paste the
code below into your site.

Partner With Us!

"Best Of Breed" Forums Add Stickiness To Your Site
Partner Button
(Download This Button Today!)

Feedback

"...One of the best run forums I have used in years! ...I like the way the site is organized and your no tolerance of flames..."

Geography

Where in the world do Tek-Tips members come from?
Lewy (TechnicalUser)
2 Jul 10 10:05
I wish to add the records from 1 table to another using objectpal, however the receiving table has an equivalent field shorter than in the main table that the records are coming from. For example the "first name" field in the main table is 10 characters in size but in the receiving table it is 1 character, so that the first name is shortened to an initial. Interactively in paradox you are just asked if you wish to trim the fields and I do this manually but in the objectpal coding I get the error message incompatible structure. Is there a command that will automatically trim the field?

Many thanks,

Lewy
Helpful Member!  mjt39 (TechnicalUser)
13 Jul 10 16:12
There is certainly a way to adjust the field contents in both tables with objpal code.
But you could also reformat the smaller field of the one table to the larger one of the other. Open the table with the shorter (alpha) field and reformat this field:
Format > Restructure Table > Field Roster tab > Size. To get more information, click the help button there.

Reply To This Thread

Posting in the Tek-Tips forums is a member-only feature.

Click Here to join Tek-Tips and talk with other members!

Back To Forum

Close Box

Join Tek-Tips® Today!

Join your peers on the Internet's largest technical computer professional community.
It's easy to join and it's free.

Here's Why Members Love Tek-Tips Forums:

Register now while it's still free!

Already a member? Close this window and log in.

Join Us             Close