>I have created a Sql Server Object
CreateObject('SQLDMO.SQLServer') Every thing is working great except for when we do a ExecutewithResult function I write it to a text file. but I want to import it into a table. I can't figure out how to tell what the decimal and length is for data types number or floats or integers. The
numericpercision and numericscale allways returns 0, the length returns 8 but I think that is how much space it uses to store the info - Like integers use up 4. We are using SQL 7.0 has any one done this before?
The SQL Distributed Management Objects really weren't meant for submitting queries to the server. It was designed to allow remote administration of the server. ADO is the perferred COM interface for submitting queries.
-Mike