dbTalk Databases Forums  

Paradox 9 and Vista - Table look-up issues

comp.databases.paradox comp.databases.paradox


Discuss Paradox 9 and Vista - Table look-up issues in the comp.databases.paradox forum.



Reply
 
Thread Tools Search this Thread Display Modes
  #1  
Old   
gfranks
 
Posts: n/a

Default Paradox 9 and Vista - Table look-up issues - 08-20-2007 , 01:59 PM






I am running Paradox 9 under Vista and to date I have found only this one
issue. I use a lot of table lookups. I can do the Cntl space and select the
item I want, but when I select the item, I get a windows pop up that says the
app has stopped responding.

I hear there is something about a compatability function of Vista that is
suppose to make many XP programs work with Vista, but I don't know how to use
it or if it will help.

Anyone got any ideas on fixing this?


PS. Dropping support for Paradox is a really bad idea. I selected it many
many years ago as the db of choice for Project Managers. Why? Beacuse you
really did not need a programming background to use it. Like most things, if
it is marketed to the wrong group, it will fail. It is a perfect personal
and small business db. I am sorry to see that Corel is not going to continue
it.


Reply With Quote
  #2  
Old   
Tony McGuire
 
Posts: n/a

Default Re: Paradox 9 and Vista - Table look-up issues - 08-20-2007 , 02:15 PM







Quote:
Anyone got any ideas on fixing this?
Not exactly a fix, per se, but...


Roll your own lookup form; discussed often here, but not specifically
in relation to Vista.

Then you can trap your lookup key combination, and present your own
lookup with whatever functionality you wish. (Even automagically add
the ".." and "@" to the lookup if you wish.)


--
------------------------------
Tony McGuire




Reply With Quote
  #3  
Old   
Jim Hargan
 
Posts: n/a

Default Re: Paradox 9 and Vista - Table look-up issues - 08-20-2007 , 03:46 PM



On Mon, 20 Aug 2007 17:59:25 GMT, gfranks wrote:

Quote:
I am running Paradox 9 under Vista and to date I have found only this one
issue. I use a lot of table lookups. I can do the Cntl space and select the
item I want, but when I select the item, I get a windows pop up that says the
app has stopped responding.
There has been a *lot* of discussion about fixing Vista compatibility
issues on the PNews newsgroups. I don't have Vista so haven't really been
paying attention, but this strikes a bell. You'll probably find a solution
if you search the archives at http://www.thedbcommunity.com.


HTH

Jim Hargan


Reply With Quote
  #4  
Old   
Dennis Santoro
 
Posts: n/a

Default Re: Paradox 9 and Vista - Table look-up issues - 08-20-2007 , 04:04 PM



There is a demo of this with code on our paradox resources page (link in
my signature. You are better off trapping for the datalookup event than
the key combination but either way it is far better to roll your own
lookups that to use the built in even if just for the greater
functionality you can add in (such as incrmental searches, more fields
displayed, full field displays, etc.

Denn Santoro
President
Resource Development Associates
http://www.RDAWorldWide.Com
Offices in the United States and Germany
Providing solutions to health care, business, governments and
non-profits since 1982

Tony McGuire wrote:
Quote:
Anyone got any ideas on fixing this?

Not exactly a fix, per se, but...


Roll your own lookup form; discussed often here, but not specifically
in relation to Vista.

Then you can trap your lookup key combination, and present your own
lookup with whatever functionality you wish. (Even automagically add
the ".." and "@" to the lookup if you wish.)



Reply With Quote
  #5  
Old   
Dennis Santoro
 
Posts: n/a

Default Re: Need help, I am not a programmer - 10-09-2007 , 07:10 PM



Take a look at the typeahead example on our paradox resources page (link
in my signature). That should get you started. You can add multiple
fields using the model there or you can add a field with radio buttons
so they can toggle one field from filter to filter.

Denn Santoro
President
Resource Development Associates
http://www.RDAWorldWide.Com
Offices in the United States and Germany
Providing solutions to health care, business, governments and
non-profits since 1982

Inabón Yunes wrote:
Quote:
For the past 5 years I've been entering data using Pdx9.
My data is almost ready to be publish but I need a little help here. I want
to accompany it with an application where users can do intelligent searches
in the database.
The information includes wildlife species and I users to be able to enter a
criteria (10 total) where an undelying table updates according to the
entries made.
For example, a person saw a bird and only got to see the color of its legs,
bill and eyes.
How do I make a form where a person enters the color of eyes he/she saw and
the table is filtered for only those species that have black eyes, for
example. Then when the same user enters the color of its legs, the table
updates to only those species that have black eyes and yellow legs, if that
is the color entered. Again, when the person enters the color of its bill,
it only sees in the table the species that meet all the three criteria.
I was working with variables for the field and using queries to display the
result on the canDepart method but everytime I run a query and use the
table, it erases the index keys, actually, no record is erased it just
doesn't have the index keys anymore. The result is a non indexed answer
table.

If any of you can help me and direct me in the right direction, I think I
can do this.

Thanks!



Reply With Quote
  #6  
Old   
Tony McGuire
 
Posts: n/a

Default Re: Need help, I am not a programmer - 10-10-2007 , 10:03 PM




Quote:
The user may not have paradox.
Then you'll have to program using whatever they DO have, or that you
already have with which to create a program from the ground
up..Paradox does NOT create standalone applications.

Delphi? Foxpro?


Or, you could GIVE them Paradox runtime.


------------------------------
Tony McGuire




Reply With Quote
  #7  
Old   
Jim Moseley
 
Posts: n/a

Default Re: Need help, I am not a programmer - 10-10-2007 , 11:23 PM




Tony,

How could you forget this one? Use the Corel Web Server, and serve up HTML
pages. It takes a fair amount of programming skill, though.

Jim Moseley

Reply With Quote
  #8  
Old   
Anders Jonsson
 
Posts: n/a

Default Re: Need help, I am not a programmer - 10-11-2007 , 02:14 AM





Quote:
The user may not have paradox.
I think your task is much bigger than just creating a form that filters your
data.

1) You have a database
2) You want to be able to distribute/sell it to "anyone"
3) You don't have an interface to the database
4) You are not a programmer

You have a big task in front of you.

If you are not doing this to make money I'm pretty sure the best would be to
"publish" your data on the Internet with a web-site. This will probably
involve moving the data from Paradox tables to another format and then
creating an interface with php, asp or .net.

If you are going to sell your application do be used on other PC's, the
runtime version of Paradox might be a solution, but it will sure take some
work to design a good interface, create an install package, handle issues
with Vista, etc, etc.

Either way you must learn a lot or get help from someone.

Sorry to be so negative...

Anders





Reply With Quote
  #9  
Old   
Dennis Santoro
 
Posts: n/a

Default Re: Need help, I am not a programmer - 10-11-2007 , 07:40 AM



You sure you looked at the right example. The typeahead form lets the
user start typing in a value and finds the nearest match and also
filters the underlying table. If the nearest match is not correct then
they can just keep typing until what they typed either has filtered to
an exact match or doesn't have a match in the filter. Prefilling the
field is just a courtesy, so to speak. You can always turn that part of
in the code if you want but it is convenient to see what the first value
is that matches what you have typed so far as it may be what you planned
to type anyway.

So if that isn't what you were looking for I don't understand what you
are are asking for since this IS selecting a filter in a form.

Denn Santoro
President
Resource Development Associates
http://www.RDAWorldWide.Com
Offices in the United States and Germany
Providing solutions to health care, business, governments and
non-profits since 1982

Inabón Yunes wrote:
Quote:
That didn't help, it prefills the field...
I want users to enter a value and use that value to filter the underlying
table, is like selecting Filter and entering the names but within the form.
The user may not have paradox.
iy
"Dennis Santoro" <RDAPres (AT) NoRDASpamWorldWide (DOT) com> wrote in message
news:470c097e$1 (AT) pnews (DOT) thedbcommunity.com...
Take a look at the typeahead example on our paradox resources page (link
in my signature). That should get you started. You can add multiple fields
using the model there or you can add a field with radio buttons so they
can toggle one field from filter to filter.

Denn Santoro
President
Resource Development Associates
http://www.RDAWorldWide.Com
Offices in the United States and Germany
Providing solutions to health care, business, governments and non-profits
since 1982

Inabón Yunes wrote:
For the past 5 years I've been entering data using Pdx9.
My data is almost ready to be publish but I need a little help here. I
want to accompany it with an application where users can do intelligent
searches in the database.
The information includes wildlife species and I users to be able to enter
a criteria (10 total) where an undelying table updates according to the
entries made.
For example, a person saw a bird and only got to see the color of its
legs, bill and eyes.
How do I make a form where a person enters the color of eyes he/she saw
and the table is filtered for only those species that have black eyes,
for example. Then when the same user enters the color of its legs, the
table updates to only those species that have black eyes and yellow legs,
if that is the color entered. Again, when the person enters the color of
its bill, it only sees in the table the species that meet all the three
criteria.
I was working with variables for the field and using queries to display
the result on the canDepart method but everytime I run a query and use
the table, it erases the index keys, actually, no record is erased it
just doesn't have the index keys anymore. The result is a non indexed
answer table.

If any of you can help me and direct me in the right direction, I think I
can do this.

Thanks!



Reply With Quote
  #10  
Old   
Tony McGuire
 
Posts: n/a

Default Re: Need help, I am not a programmer - 10-11-2007 , 11:11 AM




Quote:
It takes a fair amount of programming skill, though.
"Need help, I am not a programmer"


--
------------------------------
Tony McGuire




Reply With Quote
Reply




Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off



Powered by vBulletin Version 3.5.3
Copyright ©2000 - 2008, Jelsoft Enterprises Ltd.