[V4RB] VText and Unique property

[Ruslan Zasukhin]

on 2/19/04 9:52 PM, Stan Busk at maxprog at mac.com wrote:

> Hi,
> 
> One of my tables has following field:
> myID = new VText("myID", 128, "ASCII", kV_Unique)
> but I can create as many duplicate I wish. Can the 'Unique' property be
> applied to VText?

Yes, no sense.

TEXT is intended for BIG chunks of text.

Why to force DBMS check that ?

And no easy way, to do this I need use the whole TEXT string in the index.
Bad idea.


> or do I need to use myID = new VText("myID", 128, "ASCII", kV_Indexed +
> kV_Unique)?
> I just don't remember the latter... :)

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