Geoff,

I'm afraid that the interesting things don't include naming columns
using reserved words (or manipulating such columns). In general, I just
ignore the column - I've replaced it with YR, but it still sits in the
table and apparently TwwIBOTable tries an update with ALL the columns.

What is really frustrating is the lack of documentation: for example
does the insSQL property allow me to specify the SQL statement used to
insert? If so, is the syntax "standard:"
INSERT INTO TABLE (COL1, COL2, ..., LASTCOL)
VALUES (:COL1, :COL2, ..., :LASTCOL)

Also, how do you "master/detail?" Do the links need to be FOREIGN KEYS?
or simply Indexed columns??

etc. etc.

I am an experience prgrammer and experienced with SQL, but this
conversion to IBO is an ADVENTURE! It seems to be worth the learning
curve, but I am nowhere near the feeling of competance.

thanks,

ed


Geoff Worboys wrote:

>
> > The usual sytax doesn't work in this case because "Year" no
> > matter how you deal with it is a reserved word.
>
> Are you saying that you tried it and it failed - even with the double
> quotes? Double quotes are supposed to let you do interesting things
> like use reserved words (I thought).
>
> Geoff Worboys
> Telesis Computing
>
>
>
> Your use of Yahoo! Groups is subject to http://docs.yahoo.com/info/terms/