[Mono-bugs] [Bug 61405][Nor] Changed - odbcDataAdapter.Fill( dataSet ) doesn't work

[bugzilla-daemon@bugzilla.ximian.com]

Please do not reply to this email- if you want to comment on the bug, go to the
URL shown below and enter your comments there.

Changed by gory@alphasoft-bg.com.

http://bugzilla.ximian.com/show_bug.cgi?id=61405

--- shadow/61405	2004-07-29 06:14:22.000000000 -0400
+++ shadow/61405.tmp.4677	2004-08-03 03:47:05.000000000 -0400
@@ -58,6 +58,54 @@
 Hello
   Can you please give a sample testcase, the database table dump,
 and also details of the database, odbc driver, mono version.
 
 Thanks
 Uma
+
+------- Additional Comments From gory@alphasoft-bg.com  2004-08-03 03:47 -------
+Sorry for a late response, i was on vacation.
+
+odbc manager libiodbc-3.51.2
+database Sybase SQLAnywhere 8.0.1
+Slackware 10.0 (kernel 2.6.7)
+mono build from cvs
+
+--- dbschema
+
+CREATE TABLE "tariff"
+(
+"trf_sid" integer NOT NULL,
+"trf_level" smallint NULL,
+"trf_pred_level" integer NULL,
+"trf_code" varchar(10) NOT NULL,
+"trf_name" varchar(250) NOT NULL,
+"trf_column1" numeric(4,1) NULL,
+"trf_column2" numeric(4,1) NULL,
+"trf_currency" integer NULL,
+"trf_measure" integer NULL,
+"trf_exp_date" date NULL,
+"trf_sd_column1" smallint NULL,
+"trf_sd_column2" smallint NULL,
+"trf_beg_date" date NOT NULL,
+PRIMARY KEY ("trf_sid")
+)
+--- load data
+LOAD TABLE "Alpha_DBA"."tariff"
+FROM 'C:\\work\\datadbs\\unload\\208.dat'
+FORMAT 'ASCII'
+QUOTES ON ESCAPES ON STRIP OFF
+CHECK CONSTRAINTS OFF
+DELIMITED BY ','
+--- some data from unload\208.dat
+1,0,,'01',****,0,,2,,,,,1997/01/01 00:00
+2,0,,'02','****',,,,,,,,1997/01/01 00:00
+3,0,,'03','****',,,,,,,,1997/01/01 00:00
+
+--- Select command
+ odbcSelectCommand1.CommandText =
+   "SELECT trf_sid, trf_level, trf_pred_level, trf_code, trim
+(trf_name) AS trf_name
+    FROM tariff
+    WHERE (trf_sid = 1)"
+
+