Recent content by DrunkenEngineer

I need to build a menu showing all the unique entries in a certain table field. The table lists part vendors, and I need to create a simple listing of all the vendors we deal with, but the table can have 100-200 parts all manufactured by the same vendor, therefore appearing in the table 100-200...

ARGH I can't beleive I didn't think of that :) I guess Oracle and MS process their operations differently... ANyways, thanks for the help!

Here's the query: Select PlotSetName, QPR_ORIG_USER, NUM_PAGES, QPR_QUEUE, QPR_HOST, NAME, title1, title2, title3, issue, vehgrp, vehicle, notes, supersededBy, A13PlotSets.iPlotSetID, iSheetID, iDirectoryName From A13PlotSets, A13Sheets WHERE A13PlotSets.iPlotSetID = A13Sheets.iPlotSetID AND...

That method doesn't return any rows at all... its very unusual using the title1 LIKE <blah> OR title 2 LIKE.... etc what happens is that when it returns all the rows, it somehow inserts the query into ALL the entries, even though it only exists in one... For example, I'll query on...

That's what I've tried, and its still returning almost all the lines in the database even though there's only 1 entry with my specific query.. quite unusual!

I'm trying to do a concurrent search through a database, and I'm running into a roadblock... I'm building a search page using Intergraph's Digital Print Room software, and we're trying to import data from an old Dbase dataset.. because this old dbase set could only handle 27 characters per...