dbTalk Databases Forums  

GPV on Filter dialog

comp.databases.paradox comp.databases.paradox


Discuss GPV on Filter dialog in the comp.databases.paradox forum.



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

Default GPV on Filter dialog - 11-01-2007 , 02:55 PM







This one's probably just for Bertil's buglist, but I thought others might
be interested.

In Pdx9 sp3, I'm setting a filter for a child table via code. It ends up
being a long string, and it works fine.

If I then click the Filter icon (yellow funnel), and click the child table,
I get a GPV (Runtime error 216 at 00071d6c) and get immediately thrown out
of Paradox - quite rudely!

My filter is:
dyn["InvoiceNo"] = "70094 or 70146 or 70190 or 70191 or 70196 or 70197 or
70202 or 70256 or 70277 or 70280 or 70281"
ok = ui.setGenFilter(dyn)

The code side of it works great, but the Filter dialog chokes.

Thanks,
Jim Moseley

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

Default Re: GPV on Filter dialog - 11-01-2007 , 05:50 PM







Not sure this applies, but...

If you look at HELP on setgenfilter, it says that you can't start a
value with a numeric. Instead, you have to 'escape' a starting
numeric character with a backslash.



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



Reply With Quote
  #3  
Old   
Bertil Isberg
 
Posts: n/a

Default Re: GPV on Filter dialog - 11-02-2007 , 07:25 AM



Jim

I tested your filter interactively in P7 SP4, and P9 SP4 and I got no GPV.

I used a form where Customer and Orders were linked as 1-M, and I applied
your filter on Order No.

I also set the filter with your code, and open the Filter dialog and
activated the child table, Orders, without getting a GPV.

So I cannot recreate your problem.

--
Bertil Isberg - CTECH
Paradox buglist:
online: http://hem.bredband.net/bertilisberg/

"Jim Moseley" <jmose (AT) mapson (DOT) attglobal.net> skrev i meddelandet
news:472a2126 (AT) pnews (DOT) thedbcommunity.com...
Quote:
This one's probably just for Bertil's buglist, but I thought others might
be interested.

In Pdx9 sp3, I'm setting a filter for a child table via code. It ends up
being a long string, and it works fine.

If I then click the Filter icon (yellow funnel), and click the child
table,
I get a GPV (Runtime error 216 at 00071d6c) and get immediately thrown out
of Paradox - quite rudely!

My filter is:
dyn["InvoiceNo"] = "70094 or 70146 or 70190 or 70191 or 70196 or 70197 or
70202 or 70256 or 70277 or 70280 or 70281"
ok = ui.setGenFilter(dyn)

The code side of it works great, but the Filter dialog chokes.

Thanks,
Jim Moseley



Reply With Quote
  #4  
Old   
Bertil Isberg
 
Posts: n/a

Default Re: GPV on Filter dialog - 11-03-2007 , 02:03 PM



Michel

Such a cause is very hard to verify.

--
Bertil Isberg - CTECH
Paradox buglist:
online: http://hem.bredband.net/bertilisberg/

"|-| /-\ |_ ()7 [°¿°]" <enleverlesO.OmcO (AT) OmclaveauO (DOT) com> skrev i meddelandet
news:472cb054$0$25950$ba4acef3 (AT) news (DOT) orange.fr...
Quote:
Hi!

I had the problem at one customer. But it was because a referentiel
integrity had a problem (broken).

@-salutations

Michel Claveau




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.