Hi,
Thank you for your help, but the idea was solve all in the select clause.
regards
----- Original Message -----
From: scoubes <[EMAIL PROTECTED]>
To: 'MAGS-Gerencia' <[EMAIL PROTECTED]>; 'MapInfo-L'
<[EMAIL PROTECTED]>
Sent: Thursday, July 05, 2001 2:56 PM
Subject: RE: MI-L Simple Select Problem. Simple ?
> 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.
