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
> 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
> 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
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
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
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")
>
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.
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
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
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
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
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
>
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
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
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
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
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
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
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
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"
20 matches
Mail list logo