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(description, gb.String, 32)

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(description, gb.String, 32)

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 The error is Cannot

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 the

[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