[Gambas-user] Safwan wants to chat

2009-01-24 Thread Safwan
--- Safwan wants to stay in better touch using some of Google's coolest new products. If you already have Gmail or Google Talk, visit: http://mail.google.com/mail/b-6131dbc20f-3541919a78-3315914473355238 You'll need to click this

Re: [Gambas-user] Gambas & PostgreSQL cannot create index. relation XXX does not exist.

2009-01-24 Thread Ron_1st
On Saturday 24 January 2009, Randy wrote: >     .Fields.Add("status", gb.String, 1) >     .PrimaryKey = ["account"] >     .Indexes.Add("glcoa_sort", "glsort", TRUE) >     .Update >    END WITH > > Here's the debug output with index. Their is NO CREATE TABLE SQL when you try > make table with inde

Re: [Gambas-user] Gambas & PostgreSQL cannot create index. relation XXX does not exist.

2009-01-24 Thread Randy
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) .Field

Re: [Gambas-user] Gambas & PostgreSQL cannot create index. relation XXX does not exist.

2009-01-24 Thread Ron_1st
On Saturday 24 January 2009, Randy wrote: > Hello Rolf, > > I try to make index on any of the fields. The code that I posted is the > last try and not what I intended for indexes for the table. If I try to > make indexes on any of the fields, Gambas fails with that error message. > I turn on t

Re: [Gambas-user] Gambas & PostgreSQL cannot create index. relation XXX does not exist.

2009-01-24 Thread Randy
Hello Rolf, I try to make index on any of the fields. The code that I posted is the last try and not what I intended for indexes for the table. If I try to make indexes on any of the fields, Gambas fails with that error message. I turn on the DB.Bebug and try to make index for glsort field onl

Re: [Gambas-user] Gambas & PostgreSQL cannot create index. relation XXX does not exist.

2009-01-24 Thread Ron_1st
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 >

Re: [Gambas-user] Gambas & PostgreSQL cannot create index. relation XXX does not exist.

2009-01-24 Thread Randy-53
Rolf Schmidt wrote: > > Hello Randy. > >> 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("descript

Re: [Gambas-user] Gambas & PostgreSQL cannot create index. relation XXX does not exist.

2009-01-24 Thread Randy-53
Rolf Schmidt wrote: > > Hello Randy. > >> 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("descript

Re: [Gambas-user] Gambas & PostgreSQL cannot create index. relation XXX does not exist.

2009-01-24 Thread Randy-53
Rolf Schmidt wrote: > > Hello Randy. > >> 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("descript

Re: [Gambas-user] Gambas & PostgreSQL cannot create index. relation XXX does not exist.

2009-01-24 Thread Rolf Schmidt
Hello Randy. > 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