From: Jeff Urlwin [mailto:[EMAIL PROTECTED]
Doug said: >> Actually the two other databases I've tried return '0E0'. > Have you tried using do() instead of prepare/execute? That does work, but the utility I'm using just executes arbitrary SQL, (so I can execute SQL from within Vim), and so the program doesn't know in advance whether it's a select which needs subsequent fetching, or an update/insert/delete, or what. So I check NUM_OF_FIELDS to decide whether to fetch or not. When I do a 'CREATE VIEW' on MSSQL, the view gets created ok, but then the program dies on the NUM_OF_FIELDS check. > What were the other two databases? Informix and Gupta SQLBase, both through ODBC. Another funny thing is that a 'DROP VIEW ...' works ok in all three databases, returning 'OEO' for NUM_OF_FIELDS. -Douglas Wilson
