Changing a db

[Ruslan Zasukhin]

On 7/22/05 10:36 PM, "jda" <jda at his.com> wrote:

> if vdb.Table("format").StringField("sepLastNamesWith").MaxLength < 24 then
>         call vdb.SQLExecute("ALTER TABLE format CHANGE
> sepLastNamesWith sepLastNamesWith String (24)")
>          vdb.Table("format").StringField("sepLastNamesWith").IsNullable =
> false
>   end if
> 
> As you can see, I'm mixing API and SQL commands. But it works! In
> V1.x you told us not to do this. Will it cause problems in V2?

Danger is mix when you do access to records.

I.e. Mix VTable calls and Vcursors.


-- 
Best regards,

Ruslan Zasukhin
VP Engineering and New Technology
Paradigma Software, Inc

Valentina - Joining Worlds of Information
http://www.paradigmasoft.com

[I feel the need: the need for speed]