Hi,

Try it :

Commit Table "thetable" as "othertable"
Open Table "othertable"
Alter Table othertable (Modify ID Char(4))

Hope that helps you,__________________________________________________

Sophie Coubes
Conseillere en Geomatique
GIS Consultant

KOREM Inc.   (http://www.korem.com)

GEOdiffusion de l'information
GEObroadcasting your information
__________________________________________________

680, Boul. Charest Est
Quebec  (Quebec)  CANADA  G1K 3J4
tel.: 418 647-1555
fax : 418 647-1666
Telephone sans frais : 1 888 440-1MAP
__________________________________________________

Meilleur nouveau partenaire Mapinfo 2000 - Amerique du Nord
Best Mapinfo New Partner 2000 - North America
__________________________________________________

Push'n'See! Developed by KOREM  http://www.pushnsee.com
The Web-Mapping Software for Entreprise-wide Depoyment


-----Message d'origine-----
De : [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED]]De la part de
MAGS-Gerencia
Envoy� : 5 juillet, 2001 11:53
� : MapInfo-L
Objet : MI-L Simple Select Problem. Simple ?




Hi all.

I have a table with only one INTEGER field called ID. I need to do a =
select and save the selection in other table but changing the data type =
to CHAR(15).

I want to resolve all in the Selection in only one step.=20

if I do:=20
Select Str$(ID)  from Seta1015 into Selection     and save the selection =
table, the new CHAR field has 100 characters.

I have the solution !! I thought,  doing the next
Select Left$(Str$(ID),15)  from Seta1015 into Selection     but not. =
Again I have 100 characters.


Any solution ?

Thanks in Advance
Alejandro



_______________________________________________________________________
List hosting provided by Directions Magazine | www.directionsmag.com |
To unsubscribe, send e-mail to [EMAIL PROTECTED] and
put "unsubscribe MapInfo-L" in the message body.



_______________________________________________________________________
List hosting provided by Directions Magazine | www.directionsmag.com |
To unsubscribe, send e-mail to [EMAIL PROTECTED] and
put "unsubscribe MapInfo-L" in the message body.

Reply via email to