InstantDB Project
About InstantDB
Project Mail Lists
Short History
Reporting Bugs
Screen Shots
3rd Party Examples
FAQs

Software
Downloads
Documentation
CVS Repositories
Roadmap
License

About Enhydra.org
Who We Are
News, Articles & Events
Getting Involved
Contact Us

Community
Demos
Contributions
Resources
Case Studies
On The Edge! -NEW-
Commercial Vendors


[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

RE: InstantDB: Reserved word issue


Title: RE: InstantDB: Reserved word issue

Create a view in SQLServer

create view myview as select name, text as ttext, value, listposition from mytable

now use the view in the import statement


Hope this helps
Eivind Skildheim
Software Developer
Motive Communications, Inc
Austin, TX USA


-----Original Message-----
From: william graham [mailto:wwg@tscnet.com]
Sent: Tuesday, November 07, 2000 1:34 PM
To: instantDB@enhydra.org
Subject: Re: InstantDB: Reserved word issue


Once again, I'd wait a bit to see if anyone else has other ideas; there
are some great people on the list, including Peter Hearty, who wrote the
thing ...   ;->

Regards,
Bill G.

Jason Amy wrote:
>
> Yes, the schema is coming from a SQLServer db.  The column is:
>
> [SelectOption]
> Col1=Name  varchar 50
> Col2=Text  varchar 30
> Col3=Value  varchar 50
> Col4=ListPosition  int 4
>
> I was afraid that you'd say I'd have to change the SQLServer schema = DOH!  ;)
>
> Thanks bill!
>
> william graham wrote:
>
> > Hi, Jason --
> >
> > The problem is that TEXT in InstantDB is a synonym for the binary
> > datatype ( see
> > http://instantdb.enhydra.org/software/documentation/types.html ).
> >
> > As far as turning this off, I'm not sure there's a way (anyone else?).
> > There is a strictLiterals parm in the db properties, but that prevents
> > literals from being interpreted as numerics or as column names.
> >
> > Is this schema coming from a SQLServer db?  If so, I'm a bit surprised,
> > since TEXT is a datatype name in SQLServer as well ...
> >
> > Unless someone on the list has a better idea (which they very well
> > may!!), IMHO the column name needs to be changed: hopefully this won't
> > wreak havoc with existing code!
> >
> > Regards,
> > Bill Graham
> >
> > > I am wondering if there is a way to 'turn off' this error checking (I
> > > didn't see Text as a keyword in my SQL 92 book), or will I have to
> > > change "Text" to something else?
> > >
> > > Thanks.
> > >
> > > PS: InstantDB is really a blast to work with!
> > >
> > >
> > >
> > >
> > >
> > -----------------------------------------------------------------------------
> > To unsubscribe from this mailing list, send email to majordomo@enhydra.org
> > with the text "unsubscribe instantdb" in the body of the email.
> > If you have other questions regarding this mailing list, send email to
> > the list admin at owner-instantdb@enhydra.org.
>
> -----------------------------------------------------------------------------
> To unsubscribe from this mailing list, send email to majordomo@enhydra.org
> with the text "unsubscribe instantdb" in the body of the email.
> If you have other questions regarding this mailing list, send email to
> the list admin at owner-instantdb@enhydra.org.
-----------------------------------------------------------------------------
To unsubscribe from this mailing list, send email to majordomo@enhydra.org
with the text "unsubscribe instantdb" in the body of the email.
If you have other questions regarding this mailing list, send email to
the list admin at owner-instantdb@enhydra.org.