Smarter EPDM Drop Lists Using SQL

EmailFacebookLinkedInTwitterShare

Out of the box SOLIDWORKS Enterprise PDM gives you the ability to populate your drop lists based on SQL query results. I use this functionality all the time to give my users a list of qualified suppliers from a purchasing database, lists of users in a specified group, choices of product type, etc. The limitation is that these queries are all based off of constant values. These queries are run by the EPDM server on a predefined interval, and the results are […]

Read More

Group Members for your Datacard

EmailFacebookLinkedInTwitterShare

You’ve designed the perfect folder datacard for your SOLIDWORKS Enterprise PDM setup. It is a great little folder card listing project due date, description and even have a nice little droplist for your users to pick the proper project manager. But wait! You’ve noticed there is no way to get a list of just your project managers! What’s a girl to do?! The solution is easy with Engineering Data Specialist Man! Create a new list, make it a SQL query and […]

Read More

SQL – Convert to Hex

EmailFacebookLinkedInTwitterShare

Often times when getting really down and dirty with SOLIDWORKS Enterprise PDM, I need to know a document’s ID value in hex format. Back in the old days [yesterday] I would do a SQL query on the document’s table and then manually calculate the hexadecimal value. However I found a SQL function that will do the conversion for me: CONVERT(varbinary,<value>) Cool eh? Thus a SQL statement like this: SELECT DocumentID, CONVERT(varbinary,DocumentID) as IDHex, Filename FROM Documents where Filename like ‘Big Tuna%’ […]

Read More

Babysitting SQL

EmailFacebookLinkedInTwitterShare

In the world of SOLIDWORKS Enterprise PDM administration, maintaining the Enterprise systems is really pretty easy. You need to add/remove users (assuming the HR department bothers to tell you when they hire someone) and ensure you have good reliable backups. But don’t forget Enterprise’s playmate – SQL. SQL is that one kid who was hard to babysit for. Sure he was good when you were watching him, but if you left him alone for too long you would catch him […]

Read More

There’s an object for that

EmailFacebookLinkedInTwitterShare

When writing custom code for your SOLIDWORKS Enterprise PDM system, have you been tempted to connect directly to the Enterprise database tables? You certainly could. The database isn’t encrypted and when you first start out it is easy to get the information you need with a simple SQL query. Don’t. There’s an object for that. Everything you need from the database: BOMs, history, users, variables, searches,  … has an associated object in the API. It may take a little while […]

Read More

HOWTO: Kill SQL

EmailFacebookLinkedInTwitterShare

Looking for a quick way to kill your SQL engine and bring your SOLIDWORKS Enterprise PDM system to a screeching halt? I just got a support call from an Enterprise customer who was complaining they could not connect to the database. Tried restarting SQL, the service stopped – good…but then I could not start back up again – bad. Rebooted the server, the service still laid there dead. –worser than bad! Next, tried to do a SQL repair install – […]

Read More

SQL 2008 PreRelease

EmailFacebookLinkedInTwitterShare

Had a little scare yesterday and since misery loves company I thought I would share it with you. Yesterday I received an email with this image: These are the file properties of the Microsoft SQL 2008 install that comes with SOLIDWORKS Enterprise PDM. Look closely, it says that it is a prerelease! Yikes! Using a prerelease for production data? I’ve done some checking and this SQL build (also known as 10.0.1600.22) is a a RTM build. [Reference] I have no […]

Read More

Are you sure you are backed up?

EmailFacebookLinkedInTwitterShare

I just got off of the phone with a SW Enteprise PDM administrator. I was getting ready to change some database settings and decided to make a backup of their database first. (Better safe than sorry, especially with someone else’s data!) I while making the backup I noticed there were no other backups in existence. Turns out for the past two years this company has not made a single database backup!! The IT guys assumed the Engineering department was making […]

Read More