This topic is locked
[SOLVED]

 WE CAN NO INSERT A NEW FIELD IN A TABLE

1/8/2010 7:00:46 AM
PHPRunner General questions
A
Aleix author

Hi;
(PHPRunner 5.1 Build 2503 )
We have a table ( _country) like

IdCountry

Estate

Country
In the "Datasource tables" we select the table --> Modify table --> Insert field
If we add the new field at the end it works fine

IdCountry

Estate

Country

NewField ---> ok
But if we add in another point it does not work ok
IdCountry

NewField ---> no ok

Estate

Country
The error is:

Error occured processing thefollowing command:

alter table ·_country· change ·country· ·Estate· VARCHAR(50) null
Error executing query

Duplicate column name 'Estate·

alter table ·_country· change ·country· ·Estate· VARCHAR(50) null

Do you wish to continue altering table?
If you say "yes" it does not work fine
Do you know what are we doing bad?
Thanks in advance
Aleix

J
Jane 1/8/2010

Aleix,
unfortunately you can insert new field at the end of the table only.

A
Aleix author 1/8/2010

Thanks Jane
Aleix