Search results for query: *

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

Hi: I have been tasked with creating a barcode from numbers.An example element is qty where a qty of 5 should read 005 within the string. My cunning plan was to add 1000 to the qty, export to csv as string, then reimport, 'somehow' trimming off the leading 1. But I am tying myself in knots here...

Thank you very much, Mike. However I am on VFP8 and all I can find refers to updating with a fixed value. I will look at SCAN - but the table is quite big. I have run a 'changeto' query in Paradox but this does not convert to SQL. I have read a few SQL and VFP manuals but without any joy. Maybe...

Hi: I use VFP to create a stand alone database of sales orders from a SQL database. I append new sales orders from SQL each day. My problem is that as sales order records in SQL are closed, then I need to close them in the VFP database, too (ie set the Field value 'Status' from 'O' to 'C'...

Hi there: I am trying to write a VFP routine that pulls from MSSQL orders processed today. Is there any way of defining 'today' as a default parameter in the view? Also the parameters I use for a similar process elsewhere prompt for a date - which is American style MM/DD/YY. Is it possible for...

Hi there: I am trying to add a button to a purchase requisition form that picks up data from vfp, loads it into Word and emails the doc via Outlook to Purchase clerk for placing with supplier. however I get an intermittent error as above, with text 'the server threw an exception'. I hate...