Recent content by williamkremer

Symantec is a pain in the IIS.. In the Norton control panel there is a Personal Firewall tab and you can go in there and open a port for certain programs. In the Windows control panel, select Windows Firewall and there are settings in there too. You want to open a port and have GS configured to...

Does the creation of the transfer set also hang then fail? Also, you might want to check your firewall settings on the GoldSync server and make sure that an opening exists (exceptions tab, change scope and open a port) to allow communication to occur. You're right too that you have plenty of...

Wizard -- you get a star for that gem of info above. and Connie, it sounds like your disk really IS full. Creating a transfer set can use a lot of resources. And, wow, you're using GoldMine CE on dBase. Have you, like, stomped on your manager's foot yet, and said something like, Oops sorry, but...

The one that is using sa for the default login -- Change that. Create a new login in SQL Server for both databases. Create a master user in GM and set the default database to your production database with the same login info. When you configure ODBC settings (system DSN) use the SQL Server...

Wellllll..... You can, sorta. The fields tab is the place where custom screens appear -- like duplicates of the ones all the way on the right if you chose to give the the tab a "tab Name" in the custom screen properties dialog. If no tab name, (only a Screen name) no screen appears in that group...

They are linked like this SELECT c1.contact as Main, cs.Contact Subs from contact1 c1 join contsupp cs on (c1.accountno = cs.accountno) where cs.rectype = 'C' order by c1.contact "You cannot hold a torch to another man's path without brightening your own" Best regards, Bill

Are you using SQL or dBase? If you have it on SQL you can look first at your duplicates like this: select count(*) as HowMany, Company, SomeSecondField from contact1 group by Company, SomeSecondField having count(*) > 1 order by Company, SomeSecondField "You cannot hold a torch to another...

Select cs.contsupref as Email, c1.contact as name from contsupp cs join contact1 c1 on (c1.accountno = cs.accountno) where cs.contsupref = 'email@email.com' "You cannot hold a torch to another man's path without brightening your own" Best regards, Bill

I don't know about you guys, but I think letting users add/modify user-def fields is a problem waiting to happen. It's bad enough when users start adding f2 values with reckless abandon, but adding the fields... Too many potential problems. What about things like custom views associated with...

Bingo! Thank you very much! "You cannot hold a torch to another man's path without brightening your own" Best regards, Bill

I'm running a trace on a server to monitor which databases on the server are being used currently. In my trace columns I have DatabaseName and DatabaseID. Wouldn't you know, the databasename column remains empty throughout but databaseID column is populated by numbers (8, 2, 15, etc) When I run...

Coalesce? Works like Case? Geez..... And why not use 'where link1 is not null and link2 is not null and link3 is not null' ? "You cannot hold a torch to another man's path without brightening your own" Best regards, Bill

And you jbenson! "You cannot hold a torch to another man's path without brightening your own" Best regards, Bill

Denis, wouldn't that just truncate off the 2 digits to the right of the decimal? Or will it shift the decimal? And, what will happen to 12.34 if it is cast as int? This: 1234 or this: 12 You are a great teacher, and george and vongrunt and sqlsister, SQLbill and many others. You are...

If your table is not too large, you may want to view the duplicate entries first before deleting: select count(*) as Dupes, FieldWithDupes, OneOtherField from My_table group by FieldWithDupes, OneOtherField having count(*) > 1 order by FieldWithDupes, OneOtherField "You cannot hold a torch...