Hans Hagen <[EMAIL PROTECTED]> writes: > As part of context-on-demand support i'm looking into / playing with > interfacing to (my)sql (from xfdf to start with). I wonder if it is > possible to use patterns for field names? Say that i have v_1 > ... v_20, is it possible to select v_5..v_10?
I suggest a course data base design would be useful here :-) Nope, this is not possible and for very good reasons. Array constructs are not done with additional fields, but with another table. I would also suggest using Firebird (InterBase) or PostgreSQL instead of mysql. For people new to data base design, the book "Semantic Data Modeling" or "Database ontwerp" from J.H. ter Bekke are excellent readings. It discusses the Xplain data definition and data retrieval language. If you stick for 100% to this language, you cannot make a mistake in your data base design (as long as you try out not only the data definition, but also the data retrieval part: the data retrieval part helps you to quickly find errors in your design, just like Hans detected with his example). My tool xplain2sql (http://www.pobox.com/~berend/xplain2sql) can translate Xplain to SQL, including mysql, InterBase and PostgreSQL. At least this tool saves you a lot of typing. -- Groetjes, Berend. (-:
