SQL Query Access 2000 MDB file from delphi
Posted on 2011-03-09
i have a very strange problem querying a certain column within an access database. i can query any other table fine without issues but this one in specific is getting a pain.
my query is as follows
SELECT Scale.ScaleType, Scale.Sequence, Scale.size FROM Scale ORDER BY Scale.ScaleType
this will error on me but if i go into the mdb and double click the column name size and rename it to test. and retry my query
SELECT Scale.ScaleType, Scale.Sequence, Scale.test FROM Scale ORDER BY Scale.ScaleType
This will output the correct data without issue. i then rename it back to size and query again and it errors. unfortunatly i need to keep it as the sale column name because there is a retail system running off it and my querys are external for another purpose so the changes to the DB are easier said then done.
Scaletype = Number
Sequence = Number
Size = text