MS SQL Strange Problem

rbuser

Using MS Sql (MS Sql ODBC data access to remote MS SQL Server over TCPIP).
All of the tables are recignized just fine except one. In that table I have
10 fields but on 3 fields are recognized by DADE. Even if I hand edit the
SQL Query I am still returned only those 3 fields.
I've tried evrything I know of to get the roduct to recognize the other
fields (open/closing table/database, copying/renaming the table) and NOTHING
seems to work.
The fields that it's not recognizing are VARCHAR and DATETIME fields so no
weird datatypes or anything. I'm the creator/owner of the tables so no
column restrictions are in place. I can access the fields in Delphi, ASP,
.NET, iwSQL, ACCESS and probably anything else.
Please help, this is driving me CRAZY!

digitalmetaphors

What version of RB are you using? Try using RB 7.02 if you aren't already.
You can test with the trial edition 7.02 downloadable from our website.


Cheers,

Jim Bennett
Digital Metaphors