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
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
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?
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
, 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
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
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
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