I am using a parameterised update command instead of an SQL command because I have long character fields captured in a form that I need to store to Visual FoxPro variable length memo fields that can exceed 255 characters which in turn will break the SQL command. This has been working fine if I...
I want to add a button to my web page so that when a visitor clicks it it will automatically add an appointment in Microsoft Outlook. I see that I can do this by creating a vcalendar text file similar to the one below and simply hyperlinking it so that when the visit clicks and chooses 'Open' to...
Hi, we have been running a Windows server for some time and sending email via CDOSYS quite happily from our ASP application with copies going to customers and copies coming to ourselves. This used to work fine but for some reason recently the copies to ourselves, ie to mailboxes at the same...
I am receiving the following error intermittently from my application
The connection cannot be used to perform this operation. It is either closed or invalid in this context
I cannot replicate this. I have an error handler running (to email me details of any errors that occur in a user...
I have a script which generates emails from a web page during an ordering process. The script is part of a function where parameters such as the from address, to address, subject and message body are passed to the function to generate the CDONTS email. I have about 12 customers using this...
Until recently my VFP9 application used both F1 and ? WhatsThis help quite successfully on all Windows platforms. My main F1 help was a CHM file and my whatsthis help was a HLP file. Recently, however, I upgraded to Vista and of course discovered that Microsoft are now making HLP help obsolete -...
I need to help to implement an error handler in ASP that will be able to identify and close open database resources - can anybody help?
My background is Microsoft Visual FoxPro programming for the Windows desktop, however, I have a small application written in ASP on a website that uses...
I was using ASP to update a VFP table using ODBC drivers and everything worked fine until I upgrade to use OLE DB VFP drivers instead. Now I receiving the error message at the addnew command
Current Recordset does not support updating. This may be a limitation of the provider, or of the...
I have been approached by a client to amend my application to allow it to read data embedded on cards to determine whether or not the card holder is permitted to go any further with transactions. The card will allow the holder to book onto activities if their card registers privileges for those...
I think I may have got a little left behind here. I have been trying to implement my app on some new web sites recently and I think it is not working because VFP ODBC drivers are no longer supported in the latest operating systems in favour of OLE DB technology. Can anyone confirm that my...
I am updating a database with details entered into a text area on an ASP web form using the following syntax
Set topicsrs = Server.CreateObject( "ADODB.Recordset" )
topicsrs.ActiveConnection = Con
sqlString = "insert into mbtopics (ctopicref, mmessage) values ('" & lctopicref & "','" &...
I am receiving a 'this operation cannot be completed because of dialog or database engine failures' on a PC here and a customer PC when I use automation to mailmerge between my VFP9 app and Word 2003. I have also seen it once before on a system running my app despite the fact the app is running...
I have a class for edit boxes used throughout my app. Whilst in edit mode the foreground color of this class and all other form object classes is switched to black and then once the record is saved and is protected again it is switched to grey. This makes it very visible when you are or are not...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.