pilot-db-list

Re: [pilot-db-list] Fatal Error with one particular PDB

[<di...@ta...>]

On Thu, Jun 02, 2005 at 04:57:32PM +0100, Jonathan Fitt wrote:
> Hello all,
> 
> I'm having problems with the attached PDB. I originally had it working
> without the last column. I recreated it using JPilot-DB from a csv
> where I had added the last column. Since then it has thrown a fatal
> error everytime I try and open it. I've tried recreating it afresh,
> reinstalling Pilot-DB, everything I can think of, but it keeps
> throwing the error.
> Any ideas?
> 
> On a side note I've not had much luck editing schema and or records
> with JPilot-DB. It doesn't seem to accept changes, hence me recreating
> the db from a csv file.

I suggest you try using palm-db-tools. I tried pdb2csv on the db you
attached, and it worked well. It outputed an inf file with a line
view "newview"
which is invalid. I can't know what exactly was the reason - maybe
you did not define the view well or there is some other problem. If
I delete this line and csv2pdb, pilot-db can open the generated db.
-- 
Didi

[pilot-db-list] Fatal Error with one particular PDB

[Jonathan F. <jo...@gm...>]

Hello all,

I'm having problems with the attached PDB. I originally had it working
without the last column. I recreated it using JPilot-DB from a csv
where I had added the last column. Since then it has thrown a fatal
error everytime I try and open it. I've tried recreating it afresh,
reinstalling Pilot-DB, everything I can think of, but it keeps
throwing the error.
Any ideas?

On a side note I've not had much luck editing schema and or records
with JPilot-DB. It doesn't seem to accept changes, hence me recreating
the db from a csv file.

thanks.

Jon

Re: [pilot-db-list] PilotDB 1.1.2 - Buttons not working in Note

[<pl...@we...>]

Hello,

Kartik N <ka...@gm...> schrieb am 30.05.05 21:25:40:
>=20
> Hi All,
> I just installed PilotDB v1.1.3 (and also v1.1.2, after uninstalling
> the other one!) from the sourceforge site onto my Palm Zire 72 and
> created a new db. One of the fields was of type "Note". Whenever I try
> to update this note field I am not able to use the on-screen keyboard.
> In fact when editing the field of type Note, no buttons work other
> than the (on-screen) Done button or the (hardware) reset button! Even
> the power button, Menu button, etc don't work. I can, however, enter
> data using the graffiti area on the palm.
>=20
> When entering a lot of text, I always prefer to use the on-screen
> keyboard, and in many cases the copy-paste functionality. However I am
> not able to do both now.
>=20
> Not sure if any one has faced this before; I tried looking into the
> archives, but did not find anything like this.
> Any help is appreciated!

I know this problem. I dont't know why it still exists, but as a workaroun=
d you perhaps could use an=20
hardware keyboard. Take one with the sizes and the feeling of a notebook k=
eyboard, not
one with with rubber keys. They have the weight and size of a Palm III and=
 cost around 15 $ at
ebay, inulding handling + shipping. With them you can enter the text even =
faster than with the
onscreen-keiyboard.

Hth,

May God be with you,

F

>=20
> Kartik
>=20
>=20
> -------------------------------------------------------
> This SF.Net email is sponsored by Yahoo.
> Introducing Yahoo! Search Developer Network - Create apps using Yahoo!
> Search APIs Find out how you can build Yahoo! directly into your own
> Applications - visit http://developer.yahoo.net/=3Ffr=FFfad-ysdn-ostg-q22005=

> =5F=5F=5F=5F=5F=5F=5F=5F=5F=5F=5F=5F=5F=5F=5F=5F=5F=5F=5F=5F=5F=5F=5F=5F=5F=5F=5F=5F=5F=5F=5F=5F=5F=5F=5F=5F=5F=5F=5F=5F=5F=5F=5F=5F=5F=5F=5F
> Pilot-db-list mailing list
> Pil...@li...
> https://lists.sourceforge.net/lists/listinfo/pilot-db-list


=5F=5F=5F=5F=5F=5F=5F=5F=5F=5F=5F=5F=5F=5F=5F=5F=5F=5F=5F=5F=5F=5F=5F=5F=5F=5F=5F=5F=5F=5F=5F=5F=5F=5F=5F=5F=5F=5F=5F=5F=5F=5F=5F=5F=5F=5F=5F=5F=5F=5F=5F=5F=5F=5F=5F=5F=5F=5F
Mit WEB.DE FreePhone mit hoechster Qualitaet ab 0 Ct./Min.
weltweit telefonieren! http://freephone.web.de/=3Fmc=3D021201

[pilot-db-list] PilotDB 1.1.2 - Buttons not working in Note

[Kartik N <ka...@gm...>]

Hi All,
I just installed PilotDB v1.1.3 (and also v1.1.2, after uninstalling
the other one!) from the sourceforge site onto my Palm Zire 72 and
created a new db. One of the fields was of type "Note". Whenever I try
to update this note field I am not able to use the on-screen keyboard.
In fact when editing the field of type Note, no buttons work other
than the (on-screen) Done button or the (hardware) reset button! Even
the power button, Menu button, etc don't work. I can, however, enter
data using the graffiti area on the palm.

When entering a lot of text, I always prefer to use the on-screen
keyboard, and in many cases the copy-paste functionality. However I am
not able to do both now.

Not sure if any one has faced this before; I tried looking into the
archives, but did not find anything like this.
Any help is appreciated!

Kartik

Re: [pilot-db-list] Re: Pilot-db-list digest, Vol 1 #994 - 1 msg

[Craig B. <cbo...@gm...>]

On 30-Apr-05, at 5:57 AM, sho...@rc... wrote:

> I have a DB with a boolean field and want to 'find' only those records 
>  where it is checked.
>
> I've tried "Where the value of --- is 'yes'," I've tried 'true'. The 
> only thing that seem to have an effect is looking for where the value 
> is 0 or 1. But that only sorts: it does not isolate the 'checked' 
> items.
>
> I'm using v. 1.1.3 on a Tungsten E
>
> I've only just joined the list: please forgive me if this matter has 
> already been covered.

It's always worked for me, both in the find and in the filter searches.
Let me ask an obvious question, you are selecting the correct field 
from the drop down list, rather than leaving it as "all fields"?

Lastly, you may try an alternate approach.  You are able to use 
equations in the find fields as well.
So lets say you have a boolean field as field 5.  You can search for 
checked values in field 5 with this:
(seq %5 1)

Which is to say  the string in field five equals the string "1".  You'd 
leave the Seach field in the Find dialog box set to "All Fields" since 
you're specifying the field in the equation.

Anyway, there are lots of useful possibilities for equations in filters.

-Craig Bowers

[pilot-db-list] Re: Pilot-db-list digest, Vol 1 #994 - 1 msg

[<fri...@pa...>]

En/na pil...@li... ha escrit:

>Send Pilot-db-list mailing list submissions to
>	pil...@li...
>
>To subscribe or unsubscribe via the World Wide Web, visit
>	https://lists.sourceforge.net/lists/listinfo/pilot-db-list
>or, via email, send a message with subject or body 'help' to
>	pil...@li...
>
>You can reach the person managing the list at
>	pil...@li...
>
>When replying, please edit your Subject line so it is more specific
>than "Re: Contents of Pilot-db-list digest..."
>
>
>Today's Topics:
>
>   1. Re: "Finding" on Boolean Field (Yedidyah Bar-David)
>
>--__--__--
>
>Message: 1
>Date: Sun, 1 May 2005 09:48:13 +0300
>To: sho...@rc...
>Cc: pil...@li...
>Subject: Re: [pilot-db-list] "Finding" on Boolean Field
>From: di...@ta... (Yedidyah Bar-David)
>
>On Sat, Apr 30, 2005 at 06:09:43PM -0400, sho...@rc... wrote:
>  
>
>>When I ask DB to find those records in which the boolean field is "1", 
>>it displays all records in the DB. The only difference between looking 
>>for "yes" or "true" is the the records are sorted by that field: the 
>>checked items together and then the unchecked.  I want it to show only 
>>the checked records.
>>    
>>
>
>Well, as I said, it does work for me.
>Can you try with a small test db and email it (to me, not the list)?
>Also, what version of pilot-db (sorry if you already wrote that)?
>  
>
    Try filtering field=1 It does work for me.

-- 
Paco

Jabber-ID: pa...@ja...
Skype: frivieret
pa...@fr...
http://friviere.tk

<a href="http://www.spreadfirefox.com/?q=affiliates&amp;id=82042&amp;t=1">Baixa el  Firefox!</a>

Endevinalla: Qui vol ser d'un club d'on no pots sortir quan vols, fins i tot si hi has entrat a la força? (Aynapse)

'Never attribute to malice that which can be adequately explained by stupidity'

Si la velocitat mata, els usuaris de uin2 viuran eternament.


Hi han dos tipus d'usuaris de windows, els que tenen alguns virus, i els que no saben que en tenen molts.



-- 
Aquest missatge ha sortit sense virus.
Checked by AVG Anti-Virus.
Version: 7.0.308 / Virus Database: 266.11.0 - Release Date: 29/04/2005

Re: [pilot-db-list] "Finding" on Boolean Field

[<di...@ta...>]

On Sat, Apr 30, 2005 at 06:09:43PM -0400, sho...@rc... wrote:
> When I ask DB to find those records in which the boolean field is "1", 
> it displays all records in the DB. The only difference between looking 
> for "yes" or "true" is the the records are sorted by that field: the 
> checked items together and then the unchecked.  I want it to show only 
> the checked records.

Well, as I said, it does work for me.
Can you try with a small test db and email it (to me, not the list)?
Also, what version of pilot-db (sorry if you already wrote that)?
-- 
Didi

Re: [pilot-db-list] "Finding" on Boolean Field

[<sho...@rc...>]

When I ask DB to find those records in which the boolean field is "1", 
it displays all records in the DB. The only difference between looking 
for "yes" or "true" is the the records are sorted by that field: the 
checked items together and then the unchecked.  I want it to show only 
the checked records.



On Apr 30, 2005, at 9:19 AM, Yedidyah Bar-David wrote:

> On Sat, Apr 30, 2005 at 08:57:41AM -0400, sho...@rc... wrote:
>> I have a DB with a boolean field and want to 'find' only those records
>> where it is checked.
>>
>> I've tried "Where the value of --- is 'yes'," I've tried 'true'. The
>> only thing that seem to have an effect is looking for where the value
>> is 0 or 1. But that only sorts: it does not isolate the 'checked'
>> items.
>
> I do not understand. What do you do and what happens?
> Searching for 0 or 1 on boolean fields does work for me as expected.
>
>>
>> I'm using v. 1.1.3 on a Tungsten E
>>
>> I've only just joined the list: please forgive me if this matter has
>> already been covered.
>
> Welcome.
> -- 
> Didi
>
>
>
> -------------------------------------------------------
> This SF.Net email is sponsored by: NEC IT Guy Games.
> Get your fingers limbered up and give it your best shot. 4 great 
> events, 4
> opportunities to win big! Highest score wins.NEC IT Guy Games. Play to
> win an NEC 61 plasma display. Visit http://www.necitguy.com/?r=20
> _______________________________________________
> Pilot-db-list mailing list
> Pil...@li...
> https://lists.sourceforge.net/lists/listinfo/pilot-db-list
>

Re: [pilot-db-list] "Finding" on Boolean Field

[<sho...@rc...>]

On Apr 30, 2005, at 9:19 AM, Yedidyah Bar-David wrote:

> I do not understand. What do you do and what happens?

Re: [pilot-db-list] "Finding" on Boolean Field

[<di...@ta...>]

On Sat, Apr 30, 2005 at 08:57:41AM -0400, sho...@rc... wrote:
> I have a DB with a boolean field and want to 'find' only those records  
> where it is checked.
> 
> I've tried "Where the value of --- is 'yes'," I've tried 'true'. The 
> only thing that seem to have an effect is looking for where the value 
> is 0 or 1. But that only sorts: it does not isolate the 'checked' 
> items.

I do not understand. What do you do and what happens?
Searching for 0 or 1 on boolean fields does work for me as expected.

> 
> I'm using v. 1.1.3 on a Tungsten E
> 
> I've only just joined the list: please forgive me if this matter has 
> already been covered.

Welcome.
-- 
Didi

[pilot-db-list] "Finding" on Boolean Field

[<sho...@rc...>]

I have a DB with a boolean field and want to 'find' only those records  
where it is checked.

I've tried "Where the value of --- is 'yes'," I've tried 'true'. The 
only thing that seem to have an effect is looking for where the value 
is 0 or 1. But that only sorts: it does not isolate the 'checked' 
items.

I'm using v. 1.1.3 on a Tungsten E

I've only just joined the list: please forgive me if this matter has 
already been covered.

LBG

[pilot-db-list] re: Pilot-db-list digest, Vol 1 #990 - 1 msg

[Kyle D. <ky...@ky...>]

In an earlier version, there was a checkbox to enable very large database support.

Kyle

pil...@li... wrote:
__________
>Send Pilot-db-list mailing list submissions to
>	pil...@li...
>
>To subscribe or unsubscribe via the World Wide Web, visit
>	https://lists.sourceforge.net/lists/listinfo/pilot-db-list
>or, via email, send a message with subject or body 'help' to
>	pil...@li...
>
>You can reach the person managing the list at
>	pil...@li...
>
>When replying, please edit your Subject line so it is more specific
>than "Re: Contents of Pilot-db-list digest..."
>
>
>Today's Topics:
>
>   1. big file with Pilot DB (Volodya)
>
>--__--__--
>
>Message: 1
>Date: Thu, 14 Apr 2005 20:07:30 +0300
>From: Volodya <m.v...@ma...>
>To: pil...@li...
>Subject: [pilot-db-list] big file with Pilot DB
>
>1. I have generete with cvs2pdb.exe a pdb file:
>2. Then put it into SD card in this destination:
>\PALM\Launcher\pdb.pdb - 13,4 =D0=9C=D0=91 (14 143 877 baits) 250 000 rec=
>ords=20
>(time for creation ~20min on 3Gz duo-proc machine)
>
>3. After ~30 seconds of opening the database on Tunsten T3 (400Mhz, 60=20
>Mb RAM, SD 512Mb (Apacer))
>giving: (Error) "Unable to open database".
>
>Also, after ~30 seconds of opening the database gives: (Failed) "An=20
>error was encountered during the duplicate. No changes have been made.",=20
>then Fatal Exeption + button [reset] + soft-reset.
>
>PS. I am using the last version of pilot-db (1.1.3)
>
>Is this file to big for Pilot DB ?? :)
>
>
>
>
>
>
>--__--__--
>
>_______________________________________________
>Pilot-db-list mailing list
>Pil...@li...
>https://lists.sourceforge.net/lists/listinfo/pilot-db-list
>
>
>End of Pilot-db-list Digest

[pilot-db-list] Re: Sorting Times and Dates

[Tom V. <tw...@ss...>]

I don't have any trouble sorting on time- or date-stamp fields in the 
latest version. I thought perhaps this was an ASCII sort issue, since I 
have set my date format in Palm-Prefs to YY/MM/DD, which should sort 
the same ASCII or integer. But it worked fine regardless of date 
format.

I use DB all the time now, and it works fine on my Clie (sigh). The 
most complicated database I have calculates my gas mileage based on a 
fuel purchase log (it accumulates non-fill-ups and updates the MPG at 
fill-ups). Some usability tweaks would be nice, to eliminate some 
redundant tapping.

As for sorting on multiple fields, you can bring up the Sort dialog 
(command-S), then tap on the leftmost drop-down to "insert-after" to 
get more than one field showing. Specify the desired sort fields with 
the right-hand drop-downs.

The way I do it is with a Global Script. You may have read that the 
"(sort 0 1)" directive will sort on field 0 ascending. But you can also 
say "(sort 0 1 1 1)" to sort first on field 0 ascending, then for 
records with equal field 0 sort again on field 1 ascending. To resort, 
just re-execute the global script.


        twv@

[pilot-db-list] big file with Pilot DB

[Volodya <m.v...@ma...>]

1. I have generete with cvs2pdb.exe a pdb file:
2. Then put it into SD card in this destination:
\PALM\Launcher\pdb.pdb - 13,4 =D0=9C=D0=91 (14 143 877 baits) 250 000 rec=
ords=20
(time for creation ~20min on 3Gz duo-proc machine)

3. After ~30 seconds of opening the database on Tunsten T3 (400Mhz, 60=20
Mb RAM, SD 512Mb (Apacer))
giving: (Error) "Unable to open database".

Also, after ~30 seconds of opening the database gives: (Failed) "An=20
error was encountered during the duplicate. No changes have been made.",=20
then Fatal Exeption + button [reset] + soft-reset.

PS. I am using the last version of pilot-db (1.1.3)

Is this file to big for Pilot DB ?? :)

Re: [pilot-db-list] Fileformat

[<di...@ta...>]

On Wed, Apr 06, 2005 at 05:37:44PM +0300, Atte Sorri wrote:
> I'm trying to write a webpage witch reads data from pilotdb file, but I'm 
> pretty lost with its fileformat. Could I get it? ...great if it could be 
> found in wotsit.org

Search for palm-db-tools.
If you need support for scripts/filters, I have a patch for that,
waiting to be integrated.
-- 
Didi

Re: [pilot-db-list] Fileformat

[<no_...@ir...>]

En/na Atte Sorri ha escrit:
> I'm trying to write a webpage witch reads data from pilotdb file, but 
> I'm pretty lost with its fileformat. Could I get it? ...great if it 
> could be found in wotsit.org

There is a aplication to export pilotdb files to XML:

http://www.chickenshick.com/jpilot-db/index.php

[pilot-db-list] Fileformat

[Atte S. <att...@ho...>]

I'm trying to write a webpage witch reads data from pilotdb file, but I'm 
pretty lost with its fileformat. Could I get it? ...great if it could be 
found in wotsit.org

_________________________________________________________________
Hotmail vai Hotmail Plus? Tutustu palveluihin. 
http://www.imagine-msn.com/hotmail/fi-fi/

Re: [pilot-db-list] filtering

[<pl...@we...>]

=D2scar Jim=E9nez <no=5Fs...@ir...> schrieb am 05.04.05 11:07:22:
>=20
>=20
> I've installed the verion 1.1.3, and the filtering function don't work.
> I click at the "Find" and the "..." button to access filtering, but the=20
> application does nothing.

Have you activatet Filters in "Options" -> "Global Preferences" ->=20
"Actions" -> "Use filters when possible" =3F
Not doing this was the reason why =5FI=5F "didn't have" filtering for=20
some time...
=20
> Another problem is the last version come without "icons", only text butt=
ons.

No idea...

> Any help is welcome.
>=20
>=20
> -------------------------------------------------------
> SF email is sponsored by - The IT Product Guide
> Read honest & candid reviews on hundreds of IT Products from real users.=

> Discover which products truly live up to the hype. Start reading now.
> http://ads.osdn.com/=3Fad=5Fid=3D6595&alloc=5Fid=3D14396&op=3Dclick
> =5F=5F=5F=5F=5F=5F=5F=5F=5F=5F=5F=5F=5F=5F=5F=5F=5F=5F=5F=5F=5F=5F=5F=5F=5F=5F=5F=5F=5F=5F=5F=5F=5F=5F=5F=5F=5F=5F=5F=5F=5F=5F=5F=5F=5F=5F=5F
> Pilot-db-list mailing list
> Pil...@li...
> https://lists.sourceforge.net/lists/listinfo/pilot-db-list


=5F=5F=5F=5F=5F=5F=5F=5F=5F=5F=5F=5F=5F=5F=5F=5F=5F=5F=5F=5F=5F=5F=5F=5F=5F=5F=5F=5F=5F=5F=5F=5F=5F=5F=5F=5F=5F=5F=5F=5F=5F=5F=5F=5F=5F=5F=5F=5F=5F=5F=5F=5F=5F=5F=5F=5F=5F=5F
Mit WEB.DE FreePhone mit hoechster Qualitaet ab 0 Ct./Min.
weltweit telefonieren! http://freephone.web.de/=3Fmc=3D021201

RE: [pilot-db-list] Unsubscribe

[Dennis M. <dmc...@ny...>]

> -----Original Message-----
> From: pil...@li...
> [mailto:pil...@li...]On Behalf Of Frank D
> Sent: Tuesday, April 05, 2005 8:56 AM
> To: Pil...@li...
> Subject: [pilot-db-list] Unsubscribe
>
> I went to the page at
> https://lists.sourceforge.net/lists/listinfo/pilot-db-list
> but I did not see any option to unsubscribe.
>
> Could you please unsubscribe me? Thank you.

Enter the email address under which you are subscribed to the list in the
box at the bottom of the page, and click the Edit Option button.  You'll be
taken to an options page where you can unsubscribe, among other things.

> Frank Dauenhauer
______
Dennis

[pilot-db-list] Unsubscribe

[Frank D <fr...@lo...>]

I went to the page at =
https://lists.sourceforge.net/lists/listinfo/pilot-db-list but I did not =
see any option to unsubscribe.=20

Could you please unsubscribe me? Thank you.

Frank Dauenhauer

[pilot-db-list] filtering

[<no_...@ir...>]

I've installed the verion 1.1.3, and the filtering function don't work.
I click at the "Find" and the "..." button to access filtering, but the 
application does nothing.

Another problem is the last version come without "icons", only text buttons.

Any help is welcome.

RE: [pilot-db-list] Long-term experiences in

[Michael R. <ma...@ex...>]

I've used pilot-db for several years for several databases of varying sizes and have only good to say about it.  It runs nicely on my Tungsten E.  A recent bug in the sort functionj was fixed in about a month and didn't damage data.  I'd also recommend the DB-Editor program (www.jakewalk.de) for desktop manipulation of databases.  You should use the most recent stable release and avoid beta versions if working with valuable data.





Michael Reich

ma...@ex...



 --- On Sun 03/27,  < pl...@we... > wrote:

From:  [mailto: pl...@we...]

To: pil...@li...

Date: Sun, 27 Mar 2005 13:25:51 +0100

Subject: [pilot-db-list] Long-term experiences in "hard" daily usage?



Hello,<br><br>I'm thinking about using pilot-db for managing a big part of my <br>important data (in fact I'm quite close to doing it).<br>Has anybody here (best long-term) experiences in "hard" daily usage <br>of pilot-db and can tell me about it? Especially if there was any <br>pilot-db-related<br>loss of data.<br><br>Happy easter,<br>______________________________________________________________<br>Verschicken Sie romantische, coole und witzige Bilder per SMS!<br>Jetzt bei WEB.DE FreeMail: http://f.web.de/?mc=021193<br><br><br><br>-------------------------------------------------------<br>SF email is sponsored by - The IT Product Guide<br>Read honest & candid reviews on hundreds of IT Products from real users.<br>Discover which products truly live up to the hype. Start reading now.<br>http://ads.osdn.com/?ad_id=6595&alloc_id=14396&op=click<br>_______________________________________________<br>Pilot-db-list mailing list<br>Pil...@li...<br>https://lists.sourceforge.net/lists/listinfo/pilot-db-list<br>

_______________________________________________
Join Excite! - http://www.excite.com
The most personalized portal on the Web!

Re: [pilot-db-list] Long-term experiences in "hard" daily usage?

[<di...@ta...>]

On Sun, Mar 27, 2005 at 01:25:51PM +0100, pl...@we... wrote:
> Hello,
> 
> I'm thinking about using pilot-db for managing a big part of my 
> important data (in fact I'm quite close to doing it).
> Has anybody here (best long-term) experiences in "hard" daily usage 
> of pilot-db and can tell me about it? Especially if there was any 
> pilot-db-related
> loss of data.

Not from a first-hand experience, but I can tell you about Gal,
who is my brother-in-law, and for whom I did most of the conf
work regarding pilot-db. He uses it daily as a todo-list, much
wider (in num of cols) than the builtin one and with quite many
filters. It was quite slow on an m130, but a few months ago he
moved to a tungsten T and he is happy with it. He has around
500 open tasks, and it's quite fast.
His main problem(s) is Hebrew-support related, and does not
happen on normal English work. It still might be a bug (maybe
more than one) in pilot-db, but I did not have time yet to look
at it.
As far as I know, he never lost data, for around 1.5 years now.
But I do push him to backup his data daily, just in case, and
also recommend that to you.

Good luck,
-- 
Didi

[pilot-db-list] Long-term experiences in "hard" daily usage?

[<pl...@we...>]

Hello,

I'm thinking about using pilot-db for managing a big part of my 
important data (in fact I'm quite close to doing it).
Has anybody here (best long-term) experiences in "hard" daily usage 
of pilot-db and can tell me about it? Especially if there was any 
pilot-db-related
loss of data.

Happy easter,
______________________________________________________________
Verschicken Sie romantische, coole und witzige Bilder per SMS!
Jetzt bei WEB.DE FreeMail: http://f.web.de/?mc=021193

Re: [pilot-db-list] views that show only certain record?

[Craig B. <cbo...@gm...>]

On 21-Mar-05, at 1:02 PM, Jerry wrote:

> I've got a DB with entries for a number of different batteries. The 
> number entries for each battery will continue to grow over time. Can I 
> setup a view for each battery that will show only the records for one 
> battery and, if so, how? If not is there another way to do this? I 
> initially started this with a separate DB for each battery but would 
> really would rather have a single DB and just view them in groups.

-Well the simplest way is to create a filter in the drop down filter 
list at the bottom.  But if you really want it to be associated with a 
view, then here's the process.
-Create the filter in the filter list (as above).  Remember also that 
filters can use a script notation:
    Example: (gt (int %34)0).  Where %34 is a date field, and that date 
is greater than 0.  This taken from a PDA database where the date field 
was a Release date, so that unreleased PDA's could be filtered out.
-Create a global script from the options menu
     This can perform sorts and invoke a specific named filter (the one 
you created above). It would look like:
      (sort 1 1)(filt FiltName)

      Essentially-  Sort by column one, ascending (0 would be 
descending), and select the filter named "FiltName".
      Test it by selecting the Global script in the list and pressing 
the "Execute" button.
-Lastly, create a View, in the Script selector when editing the View, 
select the Global script you just made.

By choosing this view, you now not only select the fields you wish to 
display and their column widths, but you can sort and filter the 
records.
If there's anything else you can do with a "Global" script, besides 
sorting and calling filters, I don't think I've seen it mentioned here.


Anyway, I use the above extensively and it's quite useful. One example 
of it's usage is a media database where you configure it for CD's, 
DVD's, VHS, or books (all using different field types as appropriate - 
aspect ratio, sound encoding, publisher, genre, First edition, on-loan, 
status, etc) just by selecting a view.  In another database I keep 
track of target ammunition.  One View displays data from Scope sighting 
correction values, another view displays data to select the best Long 
range round to use comparing FPS, energy at impact, grouping, drop, 
etc, another View for medium range target round selection, another View 
for inventory - showing full and partial boxes - calculating total 
number of rounds - price per round of each type - and totals in number 
of rounds and dollars, etc etc.