Hi,

(dbisam 4.24)

Can I use tdbisamtable to alter the size of a stringfield in a table ( and
how ?) or does I have to use tdbisamquery to alter the field ?

I have found in the manual to add a field, but not how to change the size of
it.


thanks in advance

regards

Erik

Erik


You can do, but its so long ago I did that I can't remember how. The sql route is much easier.

Roy Lambert

Erik,

you can use as model the code made by reverse engineerig. Here is an example
what we use for table 'TableName' restructure from minor version 6 to
version 7 changing size of string file from 30 to 40:

   with TableToCreate do begin
     DatabaseName := CreateDatabaseName;
     TableName := 'TableName';
     Exclusive := True;
     if (userMajorVersion = 1) and (userMinorVersion = 6) then begin
       FieldDefs.Update;
       IndexDefs.update;
       fieldDefs.Items[fieldDefs.IndexOf('NameOfStringField')].Size := 40;
       AlterTable(1, 1, 7, False, '', 'description of table', 4096, 512);
     end;
  end;

HTH
Iztok Lajovic



"Erik" <bellaard@wega.nl> je napisal v sporoèilo
news:C6447A71-DFCC-4657-BC26-216B18EB1E75@news.elevatesoft.com ...
> Hi,
>
> (dbisam 4.24)
>
> Can I use tdbisamtable to alter the size of a stringfield in a table ( and
> how ?) or does I have to use tdbisamquery to alter the field ?
>
> I have found in the manual to add a field, but not how to change the size
> of it.
>
>
> thanks in advance
>
> regards
>
> Erik
>

Erik,

<< Can I use tdbisamtable to alter the size of a stringfield in a table (
and how ?) or does I have to use tdbisamquery to alter the field ? >>

Iztok's answer is spot-on.

--
Tim Young
Elevate Software
www.elevatesoft.com

Thanks !!!

Erik

"Iztok Lajovic" <iztok.lajovic@amis.net> schreef in bericht
news:45B06083-7CEE-4EA3-BCFF-E01ACD82BEBD@news.elevatesoft.com...
> Erik,
>
> you can use as model the code made by reverse engineerig. Here is an
> example what we use for table 'TableName' restructure from minor version 6
> to version 7 changing size of string file from 30 to 40:
>
>    with TableToCreate do begin
>      DatabaseName := CreateDatabaseName;
>      TableName := 'TableName';
>      Exclusive := True;
>      if (userMajorVersion = 1) and (userMinorVersion = 6) then begin
>        FieldDefs.Update;
>        IndexDefs.update;
>        fieldDefs.Items[fieldDefs.IndexOf('NameOfStringField')].Size := 40;
>        AlterTable(1, 1, 7, False, '', 'description of table', 4096, 512);
>      end;
>   end;
>
> HTH
> Iztok Lajovic
>
>
>
> "Erik" <bellaard@wega.nl> je napisal v sporoèilo
> news:C6447A71-DFCC-4657-BC26-216B18EB1E75@news.elevatesoft.com ...
>> Hi,
>>
>> (dbisam 4.24)
>>
>> Can I use tdbisamtable to alter the size of a stringfield in a table (
>> and how ?) or does I have to use tdbisamquery to alter the field ?
>>
>> I have found in the manual to add a field, but not how to change the size
>> of it.
>>
>>
>> thanks in advance
>>
>> regards
>>
>> Erik
>>
>
>