On Thursday 22 January 2009, Randy wrote: > ---8<--- > .Fields.Add("account", db.String, 12) > .Fields.Add("glsort", gb.Integer) > ---8<--- > .PrimaryKey = ["account"] > .Indexes.Add("glcoa_account", "account", TRUE) > .Indexes.Add("glcoa_sort", "glsort", TRUE) > .Update >
> The error is "Cannot create index. relation glcoa does not exist." Why? > Can not find any information on the internet about this error. There is something going wrong with the names 'glcoa_account' and 'glcoa_sort' Try it with 'glcoaaccount' and 'glcoasort' (without the underscore). Best regards, Ron_1st -- ------------------------------------------------------------------------------ This SF.net email is sponsored by: SourcForge Community SourceForge wants to tell your story. http://p.sf.net/sfu/sf-spreadtheword _______________________________________________ Gambas-user mailing list Gambas-user@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/gambas-user