Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations SkipVought on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  • Users: dougscrm
  • Order by date
  1. dougscrm

    xp_gmNewRecID missing

    On the GoldMine Install CD there is an installer for the stored procedures. I can't remember how they refer to it. I think they called it Business Logic.
  2. dougscrm

    Multiple email domains - on behalf of

    When you say set up everyone using Internet email do you mean that you are doing this with Exchange or do you mean with an ISP hosted POP3 mailboxes? Thanks
  3. dougscrm

    Multiple email domains - on behalf of

    I gather from your research that you were unable to find a simpler way to eliminate the "on behalf of". I suspected as much because the client has made a lot of noise hoping the people who set up the exchange server could change this and nothing has happened for weeks.
  4. dougscrm

    xp_gmNewRecID missing

    There is a separate install for the stored procedures. Here is a page that you can download them from courtesy of Richard Young of Prior Analytics: http://www.prior-analytics.com/downloads/utilities.html Look for gmsprocs.zip
  5. dougscrm

    Multiple email domains - on behalf of

    marcs41 replied to an earlier message that I accidentally posted to Exchange 2000 but it was moved - perhaps to an Outlook 2003 forum. I looked up his replies to similiar messages and found this: <<The mailbox HAS to be openened within the Account settings of Exchange: Open another Mailbox...
  6. dougscrm

    Multiple email domains - on behalf of

    I have a client who emails from three businesses. They recently migrated from 3 pop accounts to an inhouse Exchange Server 2003. The integrator who set up their Exchange 2003 server has it set up so when the user sends emails from their main business email account the email is sent from...
  7. dougscrm

    BDE Error byexecution of Filters/Group

    I would only run SQL Server 2000 SP3 on Windows Server 2003. SQL Server 6.5 is pretty cranky even running on NT 4. Doug Steinschneider DCS Group LLC Fairfield, CT 203.256.2344 www.dcsgroupllc.com
  8. dougscrm

    Crystal Reports only includes &quot;Next Actions&quot; in report

    Did you check the Group rather than Record in the same menu. You can filter at the group level also. Doug Steinschneider DCS Group LLC Fairfield, CT 203.256.2344 www.dcsgroupllc.com
  9. dougscrm

    Crystal Reports only includes &quot;Next Actions&quot; in report

    I would go to Pull down menu Report>>Edit Selection Formula>>Record. You will get a window that will most likely show this: {ContHist.RECTYPE} = "T" and possibly other selection criteria. Rather than including all rectypes you will probably want set the report to select a subset of them. Doug...
  10. dougscrm

    GM 6.0 (SQL) Where are user names stored

    Both GoldMine dBase and SQL hold the user data in a dBase file called users.dbf in the root GoldMine directory. Doug Steinschneider DCS Group LLC Fairfield, CT 203.256.2344 www.dcsgroupllc.com
  11. dougscrm

    GM on MSSQL performance/optimization/suggestions

    I would setup a SQL query: SELECT company ,contact ,zip ,accountno FROM contact1 WHERE key1 = 'X' AND key2 = 'Y' ORDER BY zip You can then build a group on this sql query if you need to operate on it inside GoldMine. SQL queries like this execute in under a second for 100k contacts. As...
  12. dougscrm

    Convert SQL Server 2000 database back to version 7

    I found that there is no easy way. One possible way if you had to go back is to create an empty sql7 database and use DTS to migrate the objects.
  13. dougscrm

    Convert SQL Server 2000 database back to version 7

    A database was customized in SQL Server 2000. A SQL Server 7 user can't upgrade to SQL Server 2000 but wants to use the database. Does anyone know how to convert the database back to version 7? It is a database for a commercial package that is quite elaborate and wouldn't not be worth converting...
  14. dougscrm

    Update child records

    Created a test parent and child database and found that my code works there - The problem was very strange pk-fk combination with case sensitive and upper ascii characters included. The primary key is a substring of the foreign key (foreign key is longer so that it can double as a record...
  15. dougscrm

    Update child records

    I've used Set Relation to relate a parent to child and I'm attempting to update all child records with a value from the parent record. I can get it to update the first of the child records for each parent but if there is more than one child record those don't get updated. Here's the code GO...

Part and Inventory Search

Back
Top