Re: [Gambas-user] file size limit on sql file in gambas????

2011-10-18 Thread Caveat
ISTR at one time Benoit saying that the drivers for some of the dbs weren't that smart and may read the whole table into memory. How much RAM do you have? Can you see how much you have free as the program runs? 2Gb or more also sounds like it may be hitting some kind of limit (certainly historic

Re: [Gambas-user] Issue 129 in gambas: For-loop does not work on large ranges

2011-10-18 Thread John Spikowski
Are you running on a 32 or 64 bit OS? On Tue, 2011-10-18 at 23:10 +, gam...@googlecode.com wrote: > Status: New > Owner: > Labels: Version Type-Bug Priority-Medium OpSys-Any Dist-Any Arch-Any > Desktop-Any GUI-Any > > New issue 129 by emil.len...@gmail.com: For-loop does not work on

[Gambas-user] Issue 129 in gambas: For-loop does not work on large ranges

2011-10-18 Thread gambas
Status: New Owner: Labels: Version Type-Bug Priority-Medium OpSys-Any Dist-Any Arch-Any Desktop-Any GUI-Any New issue 129 by emil.len...@gmail.com: For-loop does not work on large ranges http://code.google.com/p/gambas/issues/detail?id=129 1) Describe the problem. For-loop does not work

[Gambas-user] file size limit on sql file in gambas????

2011-10-18 Thread Ivan Williams
Greetings once more I have been doing some experimenting with the unable to locate database error in gambas.  I am able to open smaller files but when I attempt to open the most current current version of the file (2.4 GB) in size the program blows up.   Does anyone know if gambas has any file

Re: [Gambas-user] Unknown field -- Case sensitive fields?

2011-10-18 Thread fvegaf
I'm using mysql database. fvegaf wrote: > > I'm getting the error "unknown field: codigo" > > This os the code: > '- > cQuery = "Select Empleado, Codigo from Empleado where empleado=101010" > resEmp = con1.Exec(cQUery) > > FOR EACH resEmp > var = resEmp!codigo > NEXT > '

[Gambas-user] Unknown field -- Case sensitive fields?

2011-10-18 Thread fvegaf
I'm getting the error "unknown field: codigo" This os the code: '- cQuery = "Select Empleado, Codigo from Empleado where empleado=101010" resEmp = con1.Exec(cQUery) FOR EACH resEmp var = resEmp!codigo NEXT '- The line os on the line: "var = resEmp!codigo", chang

[Gambas-user] sqlite3 - unable to locate table

2011-10-18 Thread Ivan Williams
Greetings I ran into a problem this morning where my program has started displaying unable to locate a sqlite database which I had previously been accessing without any difficulty.  I check the database, accessed it via command line and verified that it was accessible.  The file is around 2.4 G