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

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.

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.

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.

Hello Richard, I have pgAdmin and made the table with SQL then I tried in gambas code without index. That works Ok. Next I added the .Index.Add and the code failed with error "Cannot create index. relation glcoa does not exist." I would like the program to use Postgresql and sqlite for the datab