Hello. New to Gambas and having problems with following code:
STATIC PUBLIC FUNCTION CreateGLTables() DIM hTable AS Table hTable = Global.$hConn.Tables.Add("glcoa") WITH hTable .Fields.Add("company", db.String, 3) .Fields.Add("account", db.String, 12) .Fields.Add("description", gb.String, 32) .Fields.Add("gltype", gb.String, 1) .Fields.Add("glsort", gb.Integer) .Fields.Add("status", gb.String, 1) .PrimaryKey = ["account"] .Indexes.Add("glcoa_account", "account", TRUE) .Indexes.Add("glcoa_sort", "glsort", TRUE) .Update END WITH CATCH Message.Error("CreateGLTables Function: " & DConv(Error.Text)) END The error is "Cannot create index. relation glcoa does not exist." Why? Can not find any information on the internet about this error. Help :-( Randy =-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=- Scanned with Copfilter Version 0.84beta3a (ProxSMTP 1.6) AntiSpam: SpamAssassin 3.2.3 AntiVirus: ClamAV 0.91.2/8885 - Wed Jan 21 12:48:08 2009 by Markus Madlener @ http://www.copfilter.org ------------------------------------------------------------------------------ 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