Recent content by ProNetGroup

Sweet - that last message about connecing the clientid from contacts rather than calls appears to have solved part of my problem. Yippie!!! Hopefully it solved lots, but I am going to look into it in more detail tomorrow morning. Thanks so much!!! Eubanks

Okay, first of all I will admit that I never ended up trying your way in the command box in FoxPro like you had suggested. I was actually trying your code in a program that was written by someone other than myself. Basically, I just type in the SQL, and can hit different buttons to execute...

Thanks for the advice...I have been trying to work with it but without too much luck. Do I just write these three separate select statements one after the other? I have never written more than one select statement in a SQL statement before...I am merely a rookie. Also, I am getting this...

Okay, I have been reading over the last post about creating a view of contacts and clients using the xref table and also using a cursor to extract the latest call and temporarily store it to use it in a report. The concepts presented make sense to me, but I was wondering if anyone had any ideas...

The purpose of using the GROUP BY was to only get the last call entered...I did a GROUP BY on the contact's name because otherwise it would (originally at least) act like the same person, for instance, Bob Smith, was actually two different people and list it twice with two different calls. So...

This is very true about my GROUP BY field - what I was doing before was pulling the contact name straight from the calls table, which will certainly only pull contacts that already have calls. So what I did was grab all of the contact information, including name, from the contacts file (where...

Please Help! I am running the latest version of Microsoft Visual FoxPro, and am having difficulties creating a SQL statement. I am trying to create a report that lists all of our contacts in the database, and includes the last call to that person, if one exists. Basically, I have a table of...

Well, we installed VFP7.0 onto our TS computer in the home office. Is this what you are saying is not supported by TS? But the run-time is?

A couple other questions for you, Redsz: 1. What versions of FoxPro and TS are you running? 2. How long have you been using FoxPro thru TS? Thanks!

Okay, so are you talking about the run-time version of your system, or the full version. I have not had any problems yet with the run-time. It was the full version that I was having problems with. When I first had my shortcut to the full version, the Target in the shortcut was...

Does anyone out there know whether or not Visual FoxPro is compatible with Terminal Server? I have read on Microsoft's website that it has not been tested and is not guaranteed, but it didn't sound like it was totally uncompatible. Any help would be appreciated! Thanks! Eubanks

Thanks for all the advice!!! I basically just wanted to make sure that VFP was a superior product, instead of just assuming that it was. With all that said, I have enough information about each application to decide which would work better for our company. If we choose VFP, then I now feel...

Completely understood about the "it depends" part. But what I hear you saying is that there is nothing particularly wrong with VFP, right? It is just not the most common database application that MS offers b/c Access is. Also, I have a pretty good understanding of programming Access...

I was just wondering if some kind soul could give me some advice as to whether or not my company should use Access or Visual FoxPro. I know that there are several considerations that must be taken into account, but basically I wanted to know if Visual FoxPro is a good, solid application and if...

Without pasting all my code, does anyone know why this error comes up when trying to quit Word? Run-time Error '-2147417848 (80010108)': Automation Error The object invoked has disconnected from its clients. Through VBA, I am running a routine that opens a mail merge template and populates...