Razzak,
Thank you very much. I knew there was a way to
do it I just didn't have the correct syntax. I didn't
know to put the brackets around the text. Thanks so much
for your help.
On Thu, 19 Apr 2001 16:03:59 -0400 "A.
Razzak Memon" <[EMAIL PROTECTED]> wrote:
>
> Bob,
>
> Here you go ...
>
> Follow these steps:
>
> 01. Launch TGRB2000!
> 02. CONNECT DBName
> 03. Click on Object Manager
> 04. Click on desired TableName
> 05. Click on Design
> 06. Click on Columns
> 07. Highlight appropriate column name
> 08. Select Data Type TEXT
> 09. Type 7 for length
> 10. Click on AutoNum to check [x]
> 11. Type 1 for Initial value
> 12. Type 1 for Increment
> 13. Type [HOT]0000 for data Format
>
> Save the Table.
>
> Your records will have the format of HOT0001 - HOT9999!
>
> Adjust the size of number accordingly.
>
> Have Fun!
>
> Very Best Regards,
>
> Razzak.
>
> At 03:38 PM 4/19/2001 -0400, Bob Powell wrote:
>
> >I want to be able to generate unique id's that always start
> >with the letters "HOT". Therefore, id numbers would be
> >HOT234, HOT235, etc. I would like the id number column to
> >be of type text. If so, is there a way to do this in the
> >table definition screen using an expression so that the
> >table does it automatically?
>
> ===================================-============================
> R:BASE Developers's Conference: http://www.rbase.com/conference
> Official R:BASE List Server: mailto:[EMAIL PROTECTED]
> RBTI Events/Training: http://www.rbase2000.com/events
> R:DCC Members: http://www.rbase2000.com/rdcc
> ================================================================
> R:BASE, Oterro & R:Tango are registered trademarks of RBTI.
> ==================================-=============================
>
----------------------
Bob Powell
The Hotchkiss School
Lakeville, Connecticut
Systems Administrator
[EMAIL PROTECTED]
