Le 29 avr. 08 à 19:37, william humphrey a écrit :
How many lines of data in the big field? I don't have much data in my
SQLite database (about 2000 lines of data in some tables and about ten
tables). How come you are not using a database? It is so much fun
deciding
between SQLite or Valentin
On Apr 29, 2008, at 11:02 AM, william humphrey wrote:
So you always have to plan your database design so that you
can pull out one table to search on.
You can combine a multi-table query in one field, and the scripts I
posted will search in every column.
_
I should have clarified- with a remote server (ours is in Texas),
hitting the database with every character typed would make the
filtering sluggish.
With a local database, on the users hard drive, it might work fine.
On Apr 29, 2008, at 10:56 AM, william humphrey wrote:
Hey -- thanks for t
I wish I hadn't sent that email off unclear. Obviously apple's address book
does it that way (first time I realized this and thanks for helping me
realize this) as I was always trying to combine a search across all the
tables in the database the way hypercard does and it looks like that is what
is
Hey -- thanks for the quick answer. So what you are saying is that using a
direct SQL query of the database is too slow and you have to import the
section of the database that you are going to search on first? I was hoping
for a different answer. Do you think Apple's address book does it that way
(
On Apr 29, 2008, at 7:29 AM, william humphrey wrote:
The fld "bigList" could be a dump of data from a SQL database or the
search
code could be re-written to directly search the database?
At what point is it better to put the database in a search field and
search
that or use SQL directly a
How many lines of data in the big field? I don't have much data in my
SQLite database (about 2000 lines of data in some tables and about ten
tables). How come you are not using a database? It is so much fun deciding
between SQLite or Valentina and then learning all that SQL stuff...
__
I am not the right man to answer this question as, up to now, I never
used any database :-)
I am pretty sure that if you populate the field to be search in (from
a database or any other way) with short lines of text, then the
handlers below are working as expected (a list shows up at each n
The fld "bigList" could be a dump of data from a SQL database or the search
code could be re-written to directly search the database?
At what point is it better to put the database in a search field and search
that or use SQL directly and search the database? With the goal being a
list of results
Jacqueline, for me, if it were only just this list.
And thank you for the variation, André. I'll put it up beside what
I've got and perhaps nab the best of both.
Gregory
Montreal
On Sun, Apr 27, 2008, at 1:00 PM, Jacqueline replied:
Gregory Lypny wrote:
Thank you Jacqu
Hello Gregory,
If I well understand your aim, you could be interested in adapting the
search device I programmed thanks to very good advices from Éric
Chatonnet (as always :-)).
By the way, his tutorial "How to Master Users Data in Entry Boxes"
might interest you; you can find it on his site
Gregory Lypny wrote:
Thank you Jacqueline,
How embarrassing. I just read the fine print at the bottom of the
keyDown entry in the Rev dictionary. No excuse for my oversight. I
think I also found the answer to the Delete key issue there too.
I wish I had a nickle for every time I've embarr
Thank you Jacqueline,
How embarrassing. I just read the fine print at the bottom of the
keyDown entry in the Rev dictionary. No excuse for my oversight. I
think I also found the answer to the Delete key issue there too.
Regards,
Gregory
On Sat, Apr 26, 2008, at 1:00 PM, Jacque
Gregory Lypny wrote:
Hello everyone,
I tried to write a handler for one of those nifty search fields that you
find in Mac programs like Mail, where it pulls up found records as you
type a search phrase. I came up with the following. (Incidentally, I
do not use the filter command because it
Hello everyone,
I tried to write a handler for one of those nifty search fields that
you find in Mac programs like Mail, where it pulls up found records as
you type a search phrase. I came up with the following.
(Incidentally, I do not use the filter command because it is much
slower th
15 matches
Mail list logo