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

2009-02-14 Thread Randy
Benoît Minisini wrote: >> I made the change to source and update before and after index. Now I get >> error 'No field". I checked database and the table and index is created, >> but what is the error for? What is the number "23" before the "No field" >> error in the debug output? >> > > The er

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

2009-02-14 Thread Benoît Minisini
> I made the change to source and update before and after index. Now I get > error 'No field". I checked database and the table and index is created, > but what is the error for? What is the number "23" before the "No field" > error in the debug output? The error comes from the second Update(). Re

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

2009-02-14 Thread Randy
> Just the last line tells me it wants a table to add the index. > > >From the past with msaccess and mysql i had a problem too > The solution was write the table first and change the field type. > > For the last line I would say it try to create the index "glcoa_sort" ON glcoa > and that the tabl

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

2009-02-02 Thread Benoit Minisini
On lundi 2 février 2009, Randy wrote: > Benoit Minisini wrote: > > 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

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

2009-02-01 Thread Randy
Benoit Minisini wrote: > 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.Ad

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

2009-02-01 Thread Ron_1st
On Sunday 01 February 2009, Benoit Minisini wrote: > 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") >

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

2009-02-01 Thread Benoit Minisini
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.

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

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

2009-01-23 Thread Benoit Minisini
On vendredi 23 janvier 2009, Randy-53 wrote: > 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

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

2009-01-23 Thread Randy-53
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

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

2009-01-22 Thread richard terry
On Fri, 23 Jan 2009 02:01:15 am 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) > .F

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

2009-01-22 Thread Randy
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"