Re: def-view-class and memo fields

Nick Levine wrote:

> I am connecting to an Access database via odbc. I want to use
> view-classes, as they're just right for this application.
>
> What is the appropriate value for :type in a slot description,
> corresponding to a "memo" field? I've had to resort to (string 10000)
> but that feels really hacky.

Can't you just use STRING?

I've connected to Access databases (including memo fields) through ODBC
a couple of times, but with Paul Meurer's SQL-ODBC plus a couple of hacks of my own, not with Lispworks' ODBC mapping.

If you can't just specify STRING, you have to find a way to specify
a mapping from Lisp's string type to Access memo fields and vice versa.
IIRC, in the Access version of SQL, memo fields are called LONGTEXT.

I hope this helps.

Arthur Lemmens