Re: [libreoffice-users] Base/SQL help

2012-01-04 Thread Jeff Sadowski
    This is all confusing to me. How many tables are in this database and what are they? What are the fields and to what table to they belong? What are the field types of each one of the fields? What do you mean by ip and serial are character arrays? Character arrays are not one of the field

Re: [libreoffice-users] Base/SQL help

2012-01-04 Thread Dan Lewis
On Wed, 2012-01-04 at 10:39 -0700, Jeff Sadowski wrote: This is all confusing to me. How many tables are in this database and what are they? What are the fields and to what table to they belong? What are the field types of each one of the fields? What do you mean by ip and serial are

Re: [libreoffice-users] Base/SQL help

2012-01-03 Thread Mark Stanton
The SQL is something like SELECT TOP 2 * FROM yourtable ORDER BY counter, DESC WHERE ip = selected ip depending, as Jay says, on your SQL engine. Mark Stanton One small step for mankind... -- For unsubscribe instructions e-mail to: users+h...@global.libreoffice.org Problems?

Re: [libreoffice-users] Base/SQL help

2012-01-03 Thread Fernand Vanrie
Jeff , You need a combination of some macro-coding and SQL statements best start is Googling ANDREW BASE DOCUMENT There you will find al you need todo the job Roberto Benitez wrote a exelent book and there is lot of info on his site http://www.baseprogramming.com/ Hope it helps Fernand I

Re: [libreoffice-users] Base/SQL help

2012-01-03 Thread Tom Davies
, Mark Stanton m...@vowleyfarm.co.uk wrote: From: Mark Stanton m...@vowleyfarm.co.uk Subject: Re: [libreoffice-users] Base/SQL help To: users@global.libreoffice.org Date: Tuesday, 3 January, 2012, 8:57 The SQL is something like     SELECT TOP 2 * FROM yourtable     ORDER BY counter, DESC     WHERE ip

Re: [libreoffice-users] Base/SQL help

2012-01-03 Thread Dan Lewis
On Mon, 2012-01-02 at 15:05 -0700, Jeff Sadowski wrote: I can't figure out the best place to get help with SQL to use to get the information I want. Situation: I have a script gathering information about printers daily. It puts the information directly to the database. The fields in

[libreoffice-users] Base/SQL help

2012-01-02 Thread Jeff Sadowski
I can't figure out the best place to get help with SQL to use to get the information I want. Situation: I have a script gathering information about printers daily. It puts the information directly to the database. The fields in the database are date,ip,serial,counter date is a timestamp ip and

Re: [libreoffice-users] Base/SQL help

2012-01-02 Thread Jay Lozier
On 01/02/2012 05:05 PM, Jeff Sadowski wrote: I can't figure out the best place to get help with SQL to use to get the information I want. Situation: I have a script gathering information about printers daily. It puts the information directly to the database. The fields in the database are