Hi! I made a query like: str_q = "desc mytable;" calling ado, and writing to an excel sheet the Field, Type, Null, etc... Everithing is ok, while the rsADO.Movenext find a record, where the default value is NULL. /My Test table is below./ So, the first record like this is a1. At here i've got an error message: "Data provider, or other service returned an E_FAIL status" Can anybody explain me, how can i read all of my records from this recordset, instead of change all my columns to not null ??? Thx
Vaso mysql> desc test; +----------+----------------------+------+-----+---------+-------+ | Field | Type | Null | Key | Default | Extra | +----------+----------------------+------+-----+---------+-------+ | kerdezo | int(11) unsigned | | | 0 | | | instruk | smallint(6) unsigned | | | 0 | | | sorszam | smallint(6) unsigned | | | 0 | | | ev | smallint(6) unsigned | | | 0 | | | ho | smallint(6) unsigned | | | 0 | | | nap | smallint(6) | | | 0 | | | hanyperc | tinyint(4) unsigned | | | 0 | | | a1 | tinyint(4) unsigned | YES | | NULL | | | u1 | tinyint(4) unsigned | YES | | NULL | | | v6 | tinyint(4) unsigned | YES | | NULL | | | o1 | tinyint(4) unsigned | YES | | NULL | | | o2 | tinyint(4) unsigned | YES | | NULL | | | k4 | tinyint(4) unsigned | YES | | NULL | | | k5 | tinyint(4) unsigned | YES | | NULL | | | k6 | tinyint(4) unsigned | YES | | NULL | | | k7 | tinyint(4) unsigned | YES | | NULL | | | k8 | tinyint(4) unsigned | YES | | NULL | | | wave | tinyint(4) unsigned | | | 0 | | | testdemo | tinyint(4) unsigned | | | 0 | | +----------+----------------------+------+-----+---------+-------+ 19 rows in set (0.00 sec) --------------------------------------------------------------------- Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php