Search results for query: *

Hello all, After a lot of RTFM's I think Ive solved it: Originally I had the below in a errorroutine.prg... DO CASE CASE merror=109 Messagebox("Record in use by another user, please try again",0+16+0,"Record in use") ENDCASE ...which kept on bombing out. I then added... DO CASE CASE...

Hello Dave, Something weird going on here! I checked the whole program for cancel,quit,release etc, nothing here. I then used debugger and it worked??? After my error message it goes back to READ EVENTS (Exactly what I want). When I run two instances of the app. without debugger I get the error...

Hello all, Not this old chestnut I hear you say... Here we go; I have an app. in a multi-user environment using optimistic buffering. If user 1 edits the same record as user 2 Ive trapped the error to prompt a message box "Record in use by another, please try again", but then the app exits. I...

Hello Mike, I think you may of hit the nail on the head... I have tried looking for a close view, but only find drop view, delete view etc. Is there actually a way of closing a specific view and opening it after I’ve changed the properties? (most probably me thinks!!!) Ta, IanMc.

Hello Mike, Yes, Ive loaded the application, changed the setting then looked at the view in the project and the field is ticked. Once I change the field value after changing the Update type, it should call a trigger and update the field ive changed. Does FPW allow you to change the DB setting...

Hello all, Blimey this is getting good... Have you tried setting the cursor prop: cursorsetprop('buffering',3,'tablename') I know it shouldnt make a bit of difference but I set up a view in the same way, set Buffering to '5' and it didnt update the base table, then set it to '3' and it...

Hello Mike, Im sure the field isnt being updated. The changes to the update property on field X are taking effect, but when I change the value in the field on the grid it should call a trigger and update with the new value. When the application is loaded the update criteria for field X is not...

Hello all, I have a parameterised view on a form with a field that contains encryption, this field is not ticked in the update criteria tab of the view designer the reason for this is that I only want the decrypt routine to change the value in the grid on the form and not the base table, but...

Hello Barbara, Thanks for the valuable advice, that's exactly what Im doing. I will take it on board that the base table of a view should have a default buffer mode set? TX's everyone... IanMc.

Hello all, Thanks for your tips... I think Ive fixed it... It seems that I needed the View and base table's buffer mode set the same. Dont ask me why? But when they were different it didnt work. Cheers 4 now. IanMc.

Hello Mike, Oh dear what have i started.... The trigger is on the base table of the view in the forms grid. It basically calls a PRG and checks if (stock.qty)<=(stock.min_order), if so it sends an email to the stock controller. I am using a local view and set the update criteria to "SQL...

Hello Mike, I was trying to do the following: If the user modifies a record in the view and then closes the application, it would activate a method to tell the user it had been saved (with a tableupdate). I'd noticed that if a user changed a field but didnt move the cursor position and closed...

Hello all, I have a view that has an update trigger. If the user modifies a record, and then exits the application, it automatically saves and displays a message box "Auto save complete". This works fine unless its the very last record in the table Im updating... Any thoughts??? IanMc.

Thanks Guys!!! NoWayIsThisInUse: This was exactly what I was looking for. Many thanks for your help :) Mac

Hello all, I have a form that a user defines a sructure for a table. These values are stored in a list and I wish to use these values and create a table, then import the data file they have chosen. Any Ideas??? Tx's in advance. Mac.

Hello Mike, Thanks for your advice, I was so close with the details you mentioned and tried using everything else and forgot about the SET FILTER!!! Many thanks, works a treat now! Mac.

Hello all, I have a DBC with two tables, TableA Parent and TableB Child in the dataenvironment on a form. TableA has a primary Index set for the relationship with TableB. I have dragged TableB onto the form to create a grid. TableA's selections are in a ComboBox which when clicked will change...

Hiya All, I have a combobox which is populated with a company name from a table. When I click on a selection it works fine, but if i hover over a different choice without actually clicking it and then move off the control, it selects the last highlighted choice even though I didnt click it. It...

Hello all, I have a page that uploads a file to the server, it then creates a table as part of a FoxPro DBC, imports the uploaded file and then will do the following: Query=&quot;Select &quot; & NFileName & &quot;.postcode FROM lpcode INNER JOIN &quot; & NFileName & &quot; on &quot...