Page 1 of 1
Data missing from result set
Posted: Fri May 20, 2005 3:10 pm
by timgale2
I am using RRSQL to get a quick look at a table in my MS SQL database. The table name is Alias. It has 3 fields. The 3rd field is also called Alias (Alias.Alias......) For some reason, fields 1 & 2 show up just fine in the resultset and the report. "Alias" is just blank. Using another reporting tool, I have been able to confirm that the data exists. Also, the application has a simple query tool that shows the data does exist.____I^m thinking that maybe "alias" is a reserved word that requires a trick. Or, maybe the field name being the same as the table name is odd.
=> RE: Data missing from result set
Posted: Fri May 20, 2005 4:16 pm
by kfleming
Is the missing field a different data type from the ones that do display?____Kathleen__R&R Support
==> RE: Data missing from result set
Posted: Fri May 20, 2005 4:23 pm
by timgale2
AHA!____The status bar (?) on the bottom edge of the RR window shows some information when one field or another is clicked within the report.____Field1 is Alias.ID: (Numeric)(DB:Int)__Field2 is Alias.ItemID: (Numeric)(DB:Int)__Field3 is Alias.Alias: (Character)(DB: code 32767)____What^s code 32767?
===> RE: Data missing from result set
Posted: Sun May 22, 2005 8:48 am
by kfleming
If this is MS SQL Server then the field may be an NCHAR or an NVARCHAR. To see these you need to use the DataDirect SQL Server ODBC driver rather than the Microsoft driver.____Kathleen__R&R Support