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.
==================================-=============================
