Crash When Editing Query Data

[TGKnIght]

Execute a select statement that joins two or more tables. (( Make sure that you actually explicitly call the fields you want in the select… using * will not reproduce the error ))

ie (SELECT a.field1, b.field2 FROM a, b WHERE a.id = b.aid) NOT (SELECT * FROM a, b where a.id = b.aid)

Drop down the box that lets you select which table you want to edit data in.

Select a table.

Edit any cell of data for that table.

Click “Save Changes”… Silent crash.

[peterlaursen]

not reproducable here.

can you post the create statements and a query?

[TGKnIght]

Am I getting all these problems because I'm running Windows XP? Or is it because my DB is on Windows Server 2003? What test environment do you have? It makes no sense that you guys can never reproduce my errors..

You guys keep asking for test data… I'm telling you this error occurs on ANY database I have (Yes I have more than one) Anyway, I spent the time to make up some dummy tables for you, since I cannot provide my data from work anyway. The error occurs with these tables just the same as any other tables in any other DB that I need to manage.

PS It would make sense if you guys allowed files with a .sql extension to be uploaded to the message board, no?

Code:

select t1.id, t1.Desc1, t1.Desc2, t2.Desc3, t2.Desc4
from table1 t1, table2 t2
where t1.id = t2.Table1ID

[peterlaursen]

Ok … reproduced now.

For instance if you have a column named 'Id' (uppercase I) and use 'id' (lowercase i) in the query, it is reproducable. We will fix in RC1 probably later today.

[Author]

Posts