ODBiC Discussion Board


Table field length and EXPORT

by Dave Beller, February 4, 2004 10:04

I have a STUDENT table that contains a field LN and 2 TEMP tables (TEMP and TEMP1) that also contain a field calld LN. Each field length is set to 50; the fixed STUDENT table by default and '[LN] char(50)' when creating the TEMP tables. When I go to export data from the fixed STUDENT table the output looks like this "Humperdink"

When I go to export data from the result of the TEMP1 table (which is a comparison of the STUDENT and TEMP tables) the output looks like this "Humperdink " with all of the 50 spaces.

The field settings are exactly the same for all LN fields. This is happening for all of my text fields.

I'm stumped.

Dave


Replies:


Post Your Reply:

Name   
E-mail  optional
Topic  
Message:

HTTP Link: 
Link text: 


Copyright ©1997-2003, Roger Harris. All rights reserved.