Primary key

[Ruslan Zasukhin]

On 10/24/04 6:37 AM, "Kim Kohen" <kim at torchpublishing.com.au> wrote:

Hi Kim,

> I've just this weekend started looking at Valentina for use with RB. I'm
> surprised there is no field of type Integer and am wondering how I go about
> creating a Primary key/auto-incrementing ID field?

1) Valentina 1.x do have SEVERAL integer types,
Just they have other names

    BYTE    - unsigned 1 byte
    SHORT   - signed   2 bytes
    USHORT  - unsigned 2 bytes
    MEDIUM  - signed   3 bytes
    UMEDIUM - unsigned 3 bytes
    LONG    - signed   4 bytes
    ULONG   - unsigned 4 bytes
    LLONG   - signed   8 bytes
    ULLONG  - unsigned 8 bytes

Enough Kim?  :-)

The INTGER type which you need, is analog LONG.


2) Valentina 1.x do not have PRIMARY KEY, Valentina 2.0 do have.
    but Valentina developers prefer to use RecID field of table.
    please read docs.

Valentina 1.x have mechanism RecID - OjectPtr fields,
Which allow you do the same as Primary Key concept,
But more easy and in more effective way.

-- 
Best regards,
Ruslan Zasukhin      [ I feel the need...the need for speed ]
-------------------------------------------------------------
e-mail: ruslan at paradigmasoft.com
web: http://www.paradigmasoft.com

To subscribe to the Valentina mail list go to:
http://lists.macserve.net/mailman/listinfo/valentina
-------------------------------------------------------------