|
|
| If I were doing this I would look at importing one cal into the other using BR7. Then dedupe based on recid to get rid of dupes. Keep the first or last record depending on which you feel is the best. |
|
|
|
|
The user group names are in LOOKUP.
select * from lookup
where fieldname like 'MSPUSERGRP%'
Group memberships are stored in the user's encrypted security fields (where the passwords are stored ... |
|
|
|
|
workstations and get the DBNETLib error that it can't connect to SQL Database.
Could I be getting this error because of licensing?? my offsite server shows a Undocked license.
Not that I have e ... |
|
|
|
|
| With Office 365 there's more than one install type. One of them has components on the local machine, which is what GoldMine Link requires. GoldMine won't work with the cloud Office 365. I'm afraid I d ... |
|
|
|
|
| I have a programmer who is making a call to GoldMine and loading the gm7s32.dll file, and the connection attempt gets no return for perhaps 5 minutes, after which it gets a return of -4. This doesn't ... |
|
|
|
|
Hi Dexter, how's business these days? Any new development going on with DBX?
Paul |
|
|
|
|
| Could it be that there's a HUGE number of files in the [S:\GoldMine\Mailbox\Attach-2016] folder? |
|
|
|
|
| Interesting. I know that Albert has a copy of that somewhere. Is the documentation online or with the package? |
|
|
|
|
Every build.
Just created this accountno using 2015.1
B5112420816(*)G;CD'J
Easy enough to test. Create a new contact named "D'Jay Smith" |
|
|
|
|
Any luck with Webharvest yet? I thought about giving it a shot, but balked when I saw I'd need to install Java.  |
|
|
|
|
Have a client asking about this. I always assumed that FR would add an INI setting to prevent single quotes in accountno, but have never seen one come along.
My questions
1) Anyone know of a way ... |
|
|
|
|
| The only way around this that I know of is to keep a consistent attachment location. For instance, I always keep a secondary hard drive as the I: drive, where there's a CLIENTS folder. In that is a fo ... |
|
|
|
|
Hey, I think I got it!
select c1.accountno from CONTACT1 c1 where
(select top 1 userid from CONTHIST ch where ch.ACCOUNTNO = c1.ACCOUNTNO
order by ONDATE desc, ONTIME desc, recid desc) = ... |
|
|
|
|
| Thanks Doug, looks promising. Will give it a shot and report back. |
|
|
|
|
| Having a brain cramp on this one for some reason. Looking to write a WHERE portion for a SQL query to find all contacts where the newest history record on the contact is by a particular user... say, ... |
|
|
| Page 1 of 9 |
Goto page 1, 2, 3, 4, 5, 6, 7, 8, 9 Next
All times are GMT - 7 Hours |
Brought to you by Castell Computers, Doug Castell, Admin
Powered by phpBB © 2001-2004 phpBB Group
Theme created by Vjacheslav Trushkin
|
