Search results for query: *

Hi I've got a VFP7 front end which talks to Microsoft SQL Server 2005. I use sqlexec to pass queries to the database in order to produce report information. Most of the time, this is fine, however, on occassion, sqlexec will return -1, and the results cursor is not created. If I run the...

Hi I'm trying to replicate the 'freeze panes' feature available on Microsoft Excel for a standard foxpro grid control. Unfortunately, the only way I can see to do this is to use the 'split', or 'partition' properties. Now, the problem with this solution is that all of the columns are still...

Hi I have a client running Novell 4.11, which is running my software. Now, one of the users has a very low access level, and is therefore only given (read only) access to a certain file in the data directory of my program, in order to run a report. However, as part of the month-end...

Hey Guys,I'm hoping that somebody else has come across this. I'm using ADO 2.6 to write/read into / out of a Visual 7 database from Visual Fox 7. However, on occasions, I receive the messsage : "oledb provider for microsoft visual foxpro : too many variables". Now, all I am doing is...

Hi, I'm using table buffering on a fox table. If, in the buffer, I insert a record, then delete this record and then do a tableupdate(), the deleted record is inserted into the database. This is fine and what I would expect. However, I have a stored procedure tied to a DELETE trigger for the...

Hi I'm automating Outlook 97 from foxpro using createobject("outlook.application "). I am adding items into the contacts folder containing email addresses. My problem is that although the contacts are added, they cannot be seen in the address book, and the check names feature, when...

Hi I don't know if anybody has come across this (or maybe I'm just daft, but I did not find any mention of this in MSDN), but I was building up a control source for a text box in code, and I accidentally included it in brackets, so my control source in affect was somthing like...

Hi Has anybody had experience with animated GIF files in Visual Foxpro. I have used the internet explorer control to point to a GIF file, but this takes a lot of formatting to look correct, I would prefer a tidier method (like using an ocx control where I simply set a picture property,etc)...

Hi I am experiencing speed problems when using MTS, Foxpro and ADO. Essentially, what I am doing is creating middle tier business logic as VFP dll's, enlisting them in transactions, and reading / entering information in SQL Server 7.0 using ADO 2.6. The problem that I experience, is that, when...

Hi I was wondering if anybody had come across this before: I have a transaction setup in MTS (components written in visual foxpro), and call a method of one of the components which kicks it all off. I have found however, that if I call a DCOM exe (on the server) from my client, which in turn...

Hi, I am trying to access details from the Exchange Global Address List, without much success. This is an example of what I am doing: looutlook = createobject('outlook.application') lonamespace = loooutlook.getNameSpace('mapi') loaddressList = ; lonameSpace.addressLists('Global Address List')...

Hi, I hope somebody out there may be able to offer me some advice. My problem is thus: I have written a program to take advantage of remote automation and therefore run code on the server. On all my test machines (which consist of NT Servers and Workstations), the code works fine. However...

Hi, I am trying to access a database for a customer of mine who has lost their usernames and passwords. Now, I was wondering if anybody new how to extract this information, or is it impossible, and will my customer have to start again...? Thanks in advance..

I was wondering if their are any known problems when using Delphi to connect to Microsoft SQL Server 7.0 as my Delphi application is locking up after approximately five minutes of use? Help would be much appreciated.

Hi all, I have a problem using RDS. I setup the control to look at an ODBC data connection that I have defined (it does not matter if it is SQL, Fox, Access, etc), but upon issueing the 'refresh' method, I get the following errors: OLE ID DISPATCH EXCEPTION CODE 0 FROM RDSSERVER.DATAFACTORY...