QBF Writing into Table

[WayneBecker]

When I use the QBF buttons from Component Gallery it writes the search data into the table I'm using. I built an application with one table and it works perfectly. When I copied the whole project into a new project with a different table but most of the forms and reports are the same. The QBF function writes the data that I am using to search for into the table. Now I get a new record with the field filled in with the search data. I have cut the offending QBF from the copied form and installed it from the Component Gallery with the same result. Any help would be appreciated.

Thanks..........Wayne

 

[darrellblackhawk]

I've never used the QBF from the gallery, but I'll test it and get back to you if no one else does first.

Darrell

 

[rgbean]

Are you explicitly setting the QBF_Table property? According to the help file, if you don't, it will use the current table.

Rick

 

[xBaseDude]

Hi Wayne!

(Feel like I'm talkin' to myself somedays [g])

Recently had this issue myself, but not with QBF but same idea. This came back to me from....

DSummZZZ (Programmer) Aug 30, 2002

SET MULTILOCKS ON &&... must use this for buffering
USE SomeTable
=CURSORSETPROP("Buffering", 5) &&...

You can put this in your form code. But, since you said you are using a data environment, do this:
Open your form.
From the Form Designer toolbar, select 'Data Envrionment'
Right Click somewhere on the background of the data designer, not on a table, and select Properties.
Double click the Init event, and put in these two lines:

SET MULTILOCKS ON
=CURSORSETPROP("Buffering", 5)

Dave S.

************************************************************

The deal is to specifically set the table buffering properties.

Credit to Dave S. for this exact tip.

HTH - Wayne(xbasedude)

 

[WayneBecker]

Thank-you for the great solutions. I will try them and let you know how they worked.

Thanks again....Wayne