bug at combo using *.qpr
From: Vernandy (ferman_chen_at_yahoo.com)
Date: 03/30/04
- Next message: Abet: "BufferMode Setting"
- Previous message: David Frankenbach: "Re: Huge files > 2 GB (follow-up)"
- Next in thread: Stefan Wuebbe: "Re: bug at combo using *.qpr"
- Reply: Stefan Wuebbe: "Re: bug at combo using *.qpr"
- Reply: Fred Taylor: "Re: bug at combo using *.qpr"
- Messages sorted by: [ date ] [ thread ]
Date: Tue, 30 Mar 2004 21:53:04 +0700
1. Can you tell me where I can read the statement
"A form can not contain more than 1 combo with same cursor".
2. My program are upgraded from VFP 7, this technic work fine before
upgrade.
3. Try this more simple sample for your sake.
3a. Create the tables and query just like before.
3b. Now to create the form not use the wizard,
however, you manually create all controls from empty form
(except buttons to save your time).
3c. Run it. MIRACLE HAPPEN, IT RUN SMOOTHLY????????
How about other "MVP" opinion, please.
Other question, may someone can help me.
I can not create new/reply thread from website,
nothing happend when I click the button.
Explorer told have error in page.
Fred wrote:
VFP doesn't handle multiple ComboBoxes referencing the same cursor/view in
the manor that you would like it to. That's the way it is, you can't force
it to work to work that way just because you'd like it to. Use separate
cursors, that's all there is to it. Call it a bug if you will, but that's
the way it works, and I doubt that it will change, but if you've reported it
as a bug, they'll review it. Just don't hold your breath waiting for that
to change, it's been that way now for nearly 10 years and 5 versions plus
service packs.
Fred
Microsoft Visual FoxPro MVP
"Vernandy" <ferman_chen@yahoo.com> wrote in message
news:4068f510@news.cbn.net.id...
> I use *.QPR because;
> 1. Can streamdown line code
> 2. Manage the querys better
> 3. When I mush use the query again,
> I just look at the querys rather than codes and use it anymore.
>
> I tried like your sugesstion, and I'm not satisfied to it because;
> 1. fyi, I have feature to directly APPEND to master table when
> the input value are not in table (place at combo.lostfocus).
> The result, One more mistery came out, when combo #1 Refreshed
> with new value, the combo #2 still don't have new value although it
> resfreshed too.
> The result master table can append twice .
> 2. If I very often to copy the *.qpr what the mean of "Manage the querys".
> (My *.qpr file will enlarge too much)
>
> However, your opinion still out of my statement.
> If no one can tell where I did mistake on the technic I did,
> I assume that it's a BUG and please someone can tell microsoft that VFP 8
> has this BUG.
> fyi, I had post this issue many time at FoxPro Bug Report, but it seem I
> just wasting my time.
> fyi, to wrote this message I took 3 hour, because of my bad english :)
>
> Thanks for your help.
> Regards
> Vernandy
>
> "Fred Taylor" <ftaylor@mvps.org!REMOVE> wrote in message
> news:#bQStvfFEHA.3724@TK2MSFTNGP11.phx.gbl...
> > You'd need 2 .QPR files, but if they are very similar, you can certainly
> > just copy one to a new name and modify the INTO CURSOR clause to be a
> > different name. To tell you the truth, I've *never* used a .QPR file,
> I've
> > always found it easier to just code the query myself, especially since
> there
> > too many problems with earlier versions of the View/Query designer.
> >
> > Fred
> > Microsoft Visual FoxPro MVP
> >
> > "Vernandy" <ferman_chen@yahoo.com> wrote in message
> > news:406844de$1@news.cbn.net.id...
> > > > When I was using VFP 7 I did many combo on a form using same *.QPR
> > > > Now on VFP 8 for many months I try to eliminate very distrubtive
error
> > > message "Cannot Access the selected table", but I had not the best
> > solution
> > > that I need.
> > > >
> > > > The problem that I see, VFP 8 can not read cursor for combo #1 any
> more
> > > when combo #2 is initiated.
> > > > (Seem like cursor combo #1 is replaced by cursor combo #2).
> > > >
> > > > Please help me to solve this problem.
> > >
> > >
> > > Fred wrote:
> > > It's not a bug, you must use uniquely named cursor for your two
> > comboboxes.
> > >
> > > Fred
> > > Microsoft Visual Foxpro MVP
> > >
> > > Vernandy wrote:
> > > So, you mean I must create 2 same *.QPR with different cursor name to
> use
> > it
> > > at a Form or 2 view?
> > > However, both of them are out of my question.
> > > Maybe, because my explaination are too brief.
> > >
> > > Please, try this simple test out and please tell me what fenomena it
is.
> > > fyi, I run VFP 8 SP1 in Window 2000 SP4 (I think this not relavan)
> > > 1. Create Master Table : Unit.dbf value {PCS,KG,BOX,etc}
> > > 2. Create Transaction Table : TestTbl.dbf field (Key,Unit1,Unit2)
> > > 3. Query: Unit.qpr to cursor 'curUnit'
> > > 4. Create a Form Wizard with Buttons.
> > > 5. Change field control of Unit1 and Unit2 to Combo, set like below.
> > > TestTbl.Key : Textbox
> > > TestTbl.Unit1 : Combo
> > > } RowSourceType=4 Query(.QPR) RowSource='curUnit'
> > > TestTbl.Unit2 : Combo
> > > 6. Run. The message "Cannot access selected table" appear immediately
> and
> > > Combo Unit 1 will disappear.
> > > at error reff: Cannot access the selected table (Error 1152)
> > > You have attempted to select a table outside the 32K work area range
> > > or are attempting to reference a file variable in a table that is not
> > open.
> > >
> > > Thanks for your help.
> > > Regards
> > > Vernandy
- Next message: Abet: "BufferMode Setting"
- Previous message: David Frankenbach: "Re: Huge files > 2 GB (follow-up)"
- Next in thread: Stefan Wuebbe: "Re: bug at combo using *.qpr"
- Reply: Stefan Wuebbe: "Re: bug at combo using *.qpr"
- Reply: Fred Taylor: "Re: bug at combo using *.qpr"
- Messages sorted by: [ date ] [ thread ]
Relevant Pages
|
