N/odbc

reigel

I had changed from Attain 3.70 to exe 4.00 also for ODBC.
Now I had the problem, that a field in a table with absolute FieldNo greater than 255 can not be selected.
The answer form the development was, that this will not be a bug but a feature because the .performance will be better if they make this.
Did anyone have a problem like this and perhaps had found a way for a workarround

DenSter

You can extend a table by creating a new table with a one to one relationship. For instance say you want to store big BLOBs for Items, and you want to keep them in separate tables to keep the Item table from growing too much. You add a table with the Item Number as the primary key of the new table and any other fields you need, and you set the table relationship of that field to the Item No. field.