September 3rd, 2001, 03:55 AM
|
|
Junior Member
|
|
Join Date: May 2001
Location: Horhsam
Posts: 4
Time spent in forums: < 1 sec
Reputation Power: 0
|
|
SHOW COLUMNS statement not working .. HELP
Help !
I am trying to build a TREE in VB of a MySQL Database.
So far I can get the Database Names by sing the SQL statement "SHOW DATABASES".
From there I can show the tables in the selected database by using the SQL statement "SHOW Tables"
It all goes a bit pear shapred from there. When I then use the "SHOW COLUMNS FROM [TableName]" or the "SHOW COLUMNS FROM [TableName] from [DatabaseName]" I get an error:
Data provider or other service returned an E_FAIL status
With an error number -2147467259
I would be very greatful is anyone can shed some light on this as I am pulling my hair out at the moment !
It only seems to happen if the NULL setting of a field is set to YES. if the table has no fields with this property it works ok .... Weird !
Last edited by imperatec : September 3rd, 2001 at 03:58 AM.
|
Dev Shed Forums Sponsor:
Del.icio.us
Digg
Google
Spurl
Blink
Furl
Simpy
Y! MyWeb
Linear Mode
