[prev in list] [next in list] [prev in thread] [next in thread] 

List:       gambas-user
Subject:    [Gambas-user] Gambas & PostgreSQL cannot create index. relation XXX
From:       Randy <bug.me () comcast ! net>
Date:       2009-01-22 15:01:15
Message-ID: 49788A3B.7090704 () comcast ! net
[Download RAW message or body]

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
[prev in list] [next in list] [prev in thread] [next in thread]