Search results for query: *

Thanks for the detailed explanation of keys Olaf. I understand that I would still need to check for uniqueness of the NCODE value if I used this field as a candidate key and had a separate computer-generated value as the primary key field on this table, so I don't see any real benefit in...

Thanks Griff. I see your solution emulates the PACK command but means that there is no new file creation and renaming to worry about. I think this would be a good solution and, thinking about it, this is basically what I do when I restore from a backup file. I will certainly look at this an...

Hi Guys I had a call from a user experiencing this error yesterday. He is still using an earlier program of ours that was superseded three years ago. That program hasn't been updated by us for three years and he confirmed he has been able to delete records, which would include the PACK command...

Thanks Dave, Mike and Olaf. Many thanks for your advice and suggestions. I had already come to realise, over the last few weeks, that a regular PACK was not best practice and that Dave's and Olaf's approach, when adding a record, of using SET DELETED OFF then searching for the primary key...

Over the last few weeks I have started receiving reports of errors from users of our software. I normally write code that follows the deletion of a record from a table with a PACK command to permanently remove the deleted record. Some users are now reporting that following deletion of a record...

Many thanks to Mike Lewis for his very prompt reply (you can't see it as this posting has been moved between forums and his reply has been lost). I have tried using the Microsoft Internet Transfer Control and it works like a charm! All I had to do was add it to a form as an ActiveX Control (OLE...

I need help on how to get started with sending and receiving calls from VFP9 to an API located on the Internet without an IE browser window opening. This is the URL I need to send and receive for: http://api2.fastsms.co.uk/api/api.php I need to be able to capture the numeric value returned...

Thanks for that Mike, and for the interesting historiacl nugget! Here I was for all these years thinking a date was a date! I think my best bet is to apply some validation to date entry, limiting the earliest date a user can enter. Most dates used are going to be within the last 10 years or so...

Thanks for that Olaf. I suspected it was something to do with a Windows setting. I do use SYSFORMAT ON so that my application uses whatever currency and date formats are already set up in Windows. I will try recompiling the application with SYSFORMAT OFF and see if the problem still occurs for...

Has anyone else come across a problem with dates in Windows XP? Although I find my VFP application runs fine and accepts any date under Windows 2000 I have a couple of users who run under Winsows XP and a date earlier that 01/01/1601 (?) will not display and causes strange effects in grids such...

Thanks for the info Malcolm. I will check out the products you mention. John

Thanks foxdbs. I am currently evaluating SEE4FP from http://www.marshallsoft.com. The package appears to be exactly what I need and I was impressed that all the demo programs supplied worked! I will also follow-up on your suggestion of JMail. John

Dear All I have just read Craig's reply after posting mine. According to the Wiki link this size limitation appears to be just a problem with Outlook Express so I can forget about that problem as OE will not be used in the finished product. John

Mike I am working on being able to get the codes/values into the correct format before deciding on what to use to send the email. For testing purposes I am using ShellExecute with Outlook Express. The following code works perfectly: lcBody= "" FOR i= 1 TO 3 lcBody= lcBody + Scode +"="+...

I am using VFP to produce the body of an email message from a table. The table contains 2 columns, a code and a value. Examples might be: Scode Svalue 1000 1234 1001 5678 1002 Apple I am producing the formatted body along the following lines: lcBody= "" FOR i= 1 TO 3 lcBody= lcBody...

Thanks to Mike Gagnon for his comments. I wish I had the time to develop this part of the application myself but I have too many other coding jobs to do! Plus which I would prefer to be able to rely on someone else who has expertise in this field. Thanks to Mike Lewis for the links: I will look...

Thanks Mike. The reason I don't want to use Outlook/Outlook Express is that the finished application must be a standalone one and must not be dependant on what email program the user has installed. Furthermore, the emails sent from my application must be sent straight away and not rely on the...

I need email functions, for use within a VFP 8 application, as follows: 1. Send email from VFP where the body of the email is generated from VFP and can run to several hundred short lines consisting of codes/values. 2. Retrieve emails sent from a specific email address. Having received them...

Thanks for that WGCS. I will look into the ISX approach as you suggest. John

I have a user experiencing problems with a VFP application on Windows XP Pro. The app was installed by an administrator but is being used by a user who does not have admin privileges. The app creates a directory on the local machine and a free table within that directory. It appears that the...