Help

I have been working with this query but it isnt returning the header rows for me. I can't understand it. Here is a simple SQL that I am running........it returns the acct number, however, it doesn't return the header "Account Number". I posted this before but I can't seem to get this to work.....Any more insight would greatly be appreciated.

	Code:
	Dim MySql,string set MySql,"SELECT AC_BI.aCCOUNT_NUMBER FROM AC_BI WHERE (AC_BI.ACCOUNT_NUMBER='10640003')"

thanks in advance

Where do you expect to see the header "Account Number", which by the way is not a data record?

In SQL i see the following

Account Number (this is the header)
12345678 (this is the data)

In case if you are exporting the results to a file and whant "Account Number" appear in the first line, use this query

	Code:
	Dim MySql,string set MySql,"SELECT 'Account Number' UNION ALL SELECT AC_BI.aCCOUNT_NUMBER FROM AC_BI WHERE (AC_BI.ACCOUNT_NUMBER='10640003')"

Last edited by SysOp on Wed Aug 08, 2007 4:18 pm; edited 1 time in total

OK, I'll try that.

When I add the "Union All" statement in my SQL, it gives me an error.

Here is the error:

	Quote:
	An error occurred while executing automation script. line 26:SQLSTATE=37000 [cache odbc][State: 3700][Native Code 1] [SQL Code: <1>: <Invalid>]

Is this because I am working in a cache database?

I thought you are doing MySQL. I'm not familiar with Cache. Please check with your database manual what's the right syntax for the UNION operator.