| Subject | Re: [IBO] cannot edit row error(because of fieldnames like t.field1,t.field2) |
|---|---|
| Author | Helen Borrie |
| Post date | 2003-11-14T12:52:05Z |
At 12:32 PM 14/11/2003 +0000, you wrote:
select field1, field2 from atable
The aliasing syntax is for multi-table queries, which can't be edited
unless you provide custom SQL for the DML methods.
Helen
>HiUse standard SQL syntax:
>when I set a query like
>"SELECT t.field1,t.field2 FROM table t"
>and try to edit the query(Requestlive=true) I get this error.
>I have no problem with SELECT * FROM table
>How can I solve this?
select field1, field2 from atable
The aliasing syntax is for multi-table queries, which can't be edited
unless you provide custom SQL for the DML methods.
Helen