Re: [SQL] Access Update error: solution.

2010-05-21 Thread Torsten Lange
I think I also found one useful switch. In the ODBC-driver's setting there is one "extra" or so field, where 4 possible values can be entered: 0x0, 0x1, 0x2... If I remember right with 0x2 the driver mimics an SQL-Server auto increment, which Access acknowledges. However, does anyone knows go

Re: [SQL] pivot-like transformation

2004-06-21 Thread Torsten Lange
Joe Conway schrieb: Torsten Lange wrote: Hello, I have a table with measurement values and columns like this: analyses(id, sample_id, parameter[temperatur...], value, unit[?C...], error) With PL/PgSQL at the end I want try to perform a pivot-like arrangement of these

[SQL] pivot-like transformation

2004-06-20 Thread Torsten Lange
Hello, I have a table with measurement values and columns like this: analyses(id, sample_id, parameter[temperatur...], value, unit[°C...], error) With PL/PgSQL at the end I want try to perform a pivot-like arrangement of these data: sample_id|Temperature [°C]|pa