Changing a db

Ruslan Zasukhin sunshine at public.kherson.ua
Sat Jul 23 02:10:49 CDT 2005


On 7/23/05 12:46 AM, "jda" <jda at his.com> wrote:

>> 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
> 
> I also see that when I change the length, the field is moved to the
> end of the table. This is OK, but it means I have to rearrange the
> fields in the API declaration (putting the field at the end), or I
> get exceptions.
> 
> Is this the correct way?

Very strange.

Ivan we have told many times that field should not change its position.
This should be fixed. We have for this mechanism of Field.index. Right?


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




More information about the Valentina-beta mailing list