Okay, thanks. For some reason I had it in my brain that this wasn't safe or bad form or something. Just me being paranoid I suppose.

I've found the answer. I couldn't bind to a TEXT field. Instead I needed to repeatedly call SQLGetData():

retcode = SQLPrepare(hstmt, L"SELECT theField FROM theTable WHERE thatOtherField= ?", SQL_NTS);

SQLINTEGER...

I'll give that a shot, thanks!

I figured it out. I need to wrap the CREATE PROCEDURE in an exec():

exec('CREATE PROCEDURE IsLNameUnique

@LName varchar(32)

AS

IF EXISTS (SELECT LName FROM Characters WHERE LName =...

Figured out a T-SQL way to do it: http://www.sqlservercentral.com/Forums/Topic861880-338-1.aspx

Found this which I should be able to adapt nicely from Experts Exchange:

-- check to see if we need to remove server, because we create it dynamically

if exists (select *...

That's a correct assumption and it works perfectly, thank you very much! With the inclusion of a where clause I can even pick the text for a particular W,X...

I've kind of found an answer. Since I was going to use it for a report anyway here's what I did and it works:

The data source is of type...

I was kinda hoping for a solution that didn't involve installing more software. Any other ideas?

Does this give you what you want?

select cast(convert(varchar(10),getdate(),101)+' 02:00AM' as DateTime)

Okay, so long as I wasn't missing an easier way to do it. Thanks!

Garadin, you're a genius! That was my whole problem. QuoteHrs.Item was all ints so when I imported it from Access it should have been a varchar, but was...

SELECT Distinct Tools.UUCBIM, cast(Tools.JOBNOF as varchar(12)), Tools.FITEMF, Tools.ITDSC, Tools.ENGNO, Tools.ITDSC06, Tools.ESTHRS01, Tools.TOTHRS01, Prog.PROCDE, Tools.OPSTCF03

FROM

PRDQRYXA.ERNI.PRDQRYXA.TOOLQRYOUT as Tools inner join

MAPDBA.ERNI.MAPDBA.PROGRM as Prog on Tools.UUCBIM=Prog.PROCDE INNER JOIN

QuoteHrs on...

Here's my super awesome cheaty way to do this easily. I wrote an FTP batch file

that FTPs into the AS400 and runs the query with:

quote rcmd runqqry qry(lib/qry)

The...

Okay, so I cheated and made the gantt chart a subreport. So each record of the master report now has it's own little chart, supposedly. I now get...