>>Help!
>>I have a program that uses several free tables. But also it uses the database called order entry. Inside the database there is several tables. I been having a problem with a couple of items. Set exclusive is OFF. Like people cannot print a report that involves a free table and enter a delivery ticket. The delivery ticket uses a SQL in a combo box to get the customer name. I get a file in use. I also get an update conflict when a person is in the delivery ticket and a sales quote. I have a feeling that this one is dealing with the company file that stores the quote number and ticket number.
>>
>>Currently there is no error checking in the system. I am trying to resolve these issues before throwing another log on the fire. I have an error checking program for foxpro for dos. I don't think that it will migrate over to the visual foxpro. I am currently looking for a shell of an error checking program that will work globally not on each form.
>>
>>Thanks for the help. If any questions, please reply.
>>
>>Thanks Jim Boden
>
>
Jim,
>Probably you're not using an SQL for the combo (though you think you do). What I mean is if you're first SQL selecting and then assigning the cursor to a combo with rowsourcetype "alias" then you're in trouble. If that's the case simply set combo rowsourcetype and rowsource to their default values. In init of combo :
>
this.Rowsourcetype = 3
>this.rowsource = "select myF1, myF2 from mytable "+;
>"where mySomeField = thisform.SomeControl.Value "+;
>"into cursor crsCombo"
>
>* Combo.when, SomeControl.lostfocus, somebutton.click etc code
>thisform.myCombo.Requery()
DOS error checking routines would work with VFP.
>Cetin
Thanks for responding.
I am glad to hear that dos error routines will work.
The form does have the rowtype set as sql as you have stated. and the Rowsource is filled at the init of the screen. Using the method of writing the code. Now I do have the files opened in the data environment. Should I do this or not.