Recent content by smartglass

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!

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

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!

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

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

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

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

Thanks, DW...that did it!

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

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.

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

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

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

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

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