On jeudi 22 janvier 2009, Randy wrote:
> 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
>
Finally, this is not a bug. Just that the database component can only create
indexes on already existing tables.
And the table you are creating does not exist until you call the "Update"
method. So you just have to move the ".Update" line just before
the ".Indexes..." lines.
Regards,
--
Benoit Minisini
------------------------------------------------------------------------------
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
