Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations bkrike on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  • Users: badscots
  • Content: Threads
  • Order by date
  1. badscots

    Record in use by another user

    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...
  2. badscots

    Updating View using DBSETPROP

    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...
  3. badscots

    TableUpdate not working if record is at end of file...

    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.
  4. badscots

    How to create a table without using CREATE TABLE

    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.
  5. badscots

    Database Index and sorting records

    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...
  6. badscots

    ComboBox not selecting

    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...
  7. badscots

    Query: Inner Join into a FoxPro table

    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="Select " & NFileName & ".postcode FROM lpcode INNER JOIN " & NFileName & " on &quot...

Part and Inventory Search

Back
Top