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!

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

Recent content by smartglass

  1. smartglass

    Securing Approach

    HI: I have a an approach database but I want the users not be able to use any of the smarticaons and/or menu bars; just the form I have written. Does anybody know if - and how - this may be acheivable? Thanks!
  2. smartglass

    How to edit a form

    Please excuse my ignorance but I am trying to set all components of a form (including a grid) to be editable (ie can add or amend records), and save the record. My users are used to simply keying in data and the edit/save process is causing problems. I have at least 4 vfp manuals and not one is...
  3. smartglass

    email address blank

    I apologise: I have fixed it. Because it was a string, then I used the Len to give me a number, then read from the number as follows: count = Len(stRcp) if count >1 then.... else ImpRep.CloseReport Set ImpRep = Nothing MsgBox "There is no email address!
  4. smartglass

    email address blank

    Hi: Still using a variant of the magnificent thread401-249399 to email reports, I populate the email address with field data. What I am trying to do now is warn the emailer when the field is blank; along the lines of "If strRcp is blank then (message or report) else send"...but I am not getting...
  5. smartglass

    no result set returned for one field, but OK for another

    Thanks, Mike. THe table xxdespatch resides in Oracle. I can write a local query, reading the view (unfiltered), that returns order 570500.But I am trying to filter (and parameterise)the view first! THe dialog box I get reads:"No result set has been returned by the server". Buttons cancel...
  6. smartglass

    no result set returned for one field, but OK for another

    Hi: VFP 9, SP2, remote view against Oracle 8. I want to filter against one field (orderno, number(38),not null) but 'no result set' returned. However, applying filter to other fields of similar type (albeit shorter) returns data. Is the difference that orderno is a key? However I get the same...
  7. smartglass

    Setting a date, excluding weekends

    Hi there: I have a database that reports on production batches, with a specified batch date. Some batches cannot be made on the date specified so I want to reschedule forwards by 1 day those that are not complete. However I need to exclude weekends and bank holidays. I am using a separate...
  8. smartglass

    Table In use Error

    Thanks, DW...that did it!
  9. smartglass

    Table In use Error

    Hi there: I am getting a 'Table in use. The table may already be opened exclusively ' error when I run an application. I use queries to get data from Oracle then load a second form from the tables that result. Running this second form generates the error. However, when running VFP itself, not...
  10. smartglass

    Changing Data Types

    Thanks to you both for your help. I have applied both methods - and copying the whole lot out to text and back again. In the end I have gone foe Bystanders approach; I need two passes to convert a memo field to anumber but it works just fine. Thanks again.
  11. smartglass

    Logging into Oracle

    Thank you very much; it works perfectly now. We were logging in up to 9 times with each click - one for every query! I was curious when you suggested that logging in once may be securer...does this mean that I could have written it such that only the first login was required, then the password...
  12. smartglass

    Changing Data Types

    Hi there: I am trying to bring together 2 completely disparate databases into one. The data is essentially similar but the data types are different; thus 'order number' is an integer in one and text in another. I am pulling the data from one into a paradox table, ready for import into the other...
  13. smartglass

    Logging into Oracle

    Hi there: I have a button on a form that interrogates an oracle database several times, in the form of queries. Each time I am required to log in manually. Is there any way of writing code that logs the user in automatically? I found this: method pushButton(var eventInfo Event) var q Query dbSQL...
  14. smartglass

    sql; selecting strings from combolists

    Hi: I have a MySql table 'customer' containing 2 columns: code (integer) and name (String). I want users to find details about the customer by calling from the drop down comboBox, but if the combo box is a list of names the SELECT query returns a SQL error; if the combobox comprises codes then...
  15. smartglass

    php array

    Hi: I am trying to create a drop down list using a 'SELECT DISTINCT' from a table to give me available customers; and then pass the selected customer to a second page that allows me to view the details (address, phone, etc) of that customer. Am I right in thinking with the second page carrying a...
See more

Part and Inventory Search

Back
Top