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

Brian

If VCafe is using display width, rather than DatabaseMetaData.getColumns()
then it will almost certainly return the wrong width. InstantDB keeps track
of the current max size of any string in a column and uses this, together
with the column name to gauge the display width.

The only way you'll be able to fool VCafe is to add a record of the
appropriate width and then modify your SQL to explicitly ignore it in the
results sets.

Regards

Peter Hearty
Lutris Technologies UK Ltd.
-----Original Message-----
From: Brian Sanchez <bsanchez@ara.com>
To: instantdb@enhydra.org <instantdb@enhydra.org>
Date: 22 June 2000 22:07
Subject: InstantDB: InstantDB and VisualCafe 4.0


>
> I am developing an InstantDB application using VisualCafe Expert
>Edition 4.0a.  Using their wizard interface I created a very simple
>application that connects to the "tester" table in the InstantDB
>examples.  (for reference I have attached the SQL text below)
>
>When I run my application, I get errors complaining that "maximum width
>size for column 3 is: 5"
>After a thorough survey of the Symantec code, it looks to me like
>VisualCafe is looking at the column display size in the column meta
>data.
>
>So is there a way to influence the column display size that InstantDB
>reports?  Has anyone else run into this problem?
>
> Thanks,
> Brian Sanchez
> bsanchez@ara.com
>
>
>The table SQL text is:
>
>e CREATE TABLE tester (
> id int PRIMARY KEY,
> fullName CHAR(30),
> email CHAR(60),
> login CHAR(8),
> password CHAR(20) );
>e INSERT INTO tester VALUES (1,"Alice","Alice@isp","Alice","Alice");
>e INSERT INTO tester VALUES (2,"Bob","Bob@isp","Bob","Bob");
>...
>---------------------------------------------------------------------------
--
>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.