Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations Rhinorhino on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

E_FAIL status on field names

Status
Not open for further replies.

tty0

Programmer
Joined
Nov 13, 2002
Messages
108
Location
GB
Hi there,

I have a problem, well actually I had one until I did it a different way. But i still don't understand why this was giving me a fail:

.adodatconQueryBuilder.RecordSource = "describe memberlist"
.adodatconQueryBuilder.Refresh

For i = 1 To 22
.cboQueryBuilderFields.AddItem (.adodatconQueryBuilder.Recordset(0))
.lstQueryBuilderAvailableFieldNames.AddItem (.adodatconQueryBuilder.Recordset(0))
.adodatconQueryBuilder.Recordset.MoveNext
Next i

The db is Mysql with 22 fields, one of them a primary key. no matter how I set the fields, varchar, tinyint etc I still got this error:

"data provider or other service returned an E_FAIL status"



'mi casa es su casa'
]-=tty0=-[
ICQ:82621399
 
By any chance does you proc return a calculated field that doesn't have an alias?

e.g.

Create Proc abc
as
select col1 + col3 from table

and not


Create Proc abc
as
select col1 + col3 as col1andcol2 from table
 
it has no alias as its simply "describe tablename"

obviously the next bst thig to do which i have done is open the tbale and enumerate all the field names, but I thought you could pass an SQL query through like the one above. then all the fieldnames are in the first col of the returned set.

'mi casa es su casa'
]-=tty0=-[
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top