Search found 371 matches

by Dave
Tue Apr 10, 2018 3:04 pm
Forum: Announcements
Topic: Rel version 3.012 now available!
Replies: 0
Views: 23354

Rel version 3.012 now available!

This release of Rel , an implementation of Date & Darwen’s Tutorial D database language, improves the user interface and fixes some bugs. The following enhancements have been made: – Rel DBMS: Now provides -q command-line option to disable startup/shutdown information messages. This is intended ...
by Dave
Mon Apr 09, 2018 6:00 am
Forum: Report a Bug
Topic: Problem with ALTER TYPE_OF
Replies: 5
Views: 13218

Re: Problem with ALTER TYPE_OF

Try this:

Code: Select all

OPERATOR INTEGER(v CHAR) RETURNS INTEGER;
	RETURN CAST_AS_INTEGER(SUBSTRING(v, 1, LENGTH(v) - 1));
END OPERATOR;
by Dave
Sun Apr 08, 2018 4:24 pm
Forum: Report a Bug
Topic: Problem with ALTER TYPE_OF
Replies: 5
Views: 13218

Re: Problem with ALTER TYPE_OF

... Now try to apply the following changes to above relation: Change from character to integer: ALTER VAR T1 TYPE_OF B TO INTEGER; Returns: ERROR: RS0278: No run-time invocation targets found for INTEGER(CHARACTER) ... This isn't actually a bug, except to the extent that my poor (read: nonexistent)...
by Dave
Sun Apr 08, 2018 4:12 pm
Forum: Language Issues
Topic: Option to limit type violation to only the type
Replies: 1
Views: 8321

Re: Option to limit type violation to only the type

Interesting -- I'd never thought of these messages as being too much information. Rather, I'd sometimes thought they didn't provide enough information, as they provide just enough to be unambiguous. Any less detail, and there'd be some risk of ambiguity. Unfortunately, unambiguous error messages are...
by Dave
Wed Mar 28, 2018 9:19 am
Forum: Report a Bug
Topic: Old database treated as a new one
Replies: 1
Views: 8346

Re: Old database treated as a new one

If you click the "Install Rev" button on the Welcome screen, it will create various additional relvars to support Rel functionality including the visual query language (aka Rev), command history, etc., plus it will provide a checkbox on the Welcome screen to turn off the Welcome screen.
by Dave
Wed Mar 28, 2018 9:11 am
Forum: Report a Bug
Topic: Problem using code to access external data
Replies: 1
Views: 17573

Re: Problem using code to access external data

This VAR declaration to access data in sql server 2016 worked as expected in Rel v3.004 but does not work with v3.010 or v3.011: VAR TEST4 EXTERNAL JDBC "jdbc:jtds:sqlserver://localhost:1433;databaseName=JUDYDB1,**,********,TEST1"; It returns the error: ERROR: Encountered "VAR" ...
by Dave
Sun Mar 04, 2018 9:26 am
Forum: Language Issues
Topic: Aditional operator functionality
Replies: 2
Views: 8426

Re: Aditional operator functionality

You could define something similar to CAST_AS_CHARACTER(OPERATOR) by retrieving the operator's source code (I assume it's the source code that would be returned by CAST_AS_CHARACTER?) from the sys.Operators relvar. You can perhaps achieve something akin to CAST_AS_OPERATOR(CHARACTER) by using EXECUT...
by Dave
Mon Feb 12, 2018 2:38 pm
Forum: Getting Started
Topic: Export CSV from command line
Replies: 3
Views: 20331

Re: Export CSV from command line

Does the RelDBMS command line tool support CSV as well? Not directly, no. You could create a script named, say, S_TO_CSV.rel with the following contents: FOR S ORDER(ASC SNAME); WRITELN S# || "," || SNAME || "," || STATUS || "," || CITY; END FOR; Then invoke it with so...
by Dave
Thu Feb 08, 2018 7:00 pm
Forum: Report a Bug
Topic: Copied text stays in clipboard when it shouldn't
Replies: 1
Views: 8095

Re: Copied text stays in clipboard when it shouldn't

A very odd error! I've tried copying and pasting within Rel -- which works as expected -- and then copying and pasting within Visual Studio, Notepad, and Notepad++ whilst Rel runs in the background, which also all work as expected. What application are you pasting to? Perhaps there's some odd intera...
by Dave
Thu Feb 08, 2018 6:45 pm
Forum: Report a Bug
Topic: Column heads for RVAs not treated right when names only selected
Replies: 3
Views: 11771

Re: Column heads for RVAs not treated right when names only selected

This appears to be correct, or at least how it's intended to display. The type of the RVA is shown graphically, rather than being written out as RELATION {...}
by Dave
Mon Jan 29, 2018 6:42 pm
Forum: Language Issues
Topic: TYPE inheritance implications
Replies: 6
Views: 16992

Re: TYPE inheritance implications

I know what Rel will do with the definitions of A and B, but how they should be considered within the TTM model I'm not sure I can answer. Hopefully, Hugh will see this and can answer. Alternatively, as this is more of a TTM question than a Rel question, perhaps it's worth asking on the email-based ...
by Dave
Fri Jan 26, 2018 11:59 am
Forum: Announcements
Topic: Rel version 3.011 now available!
Replies: 0
Views: 22527

Rel version 3.011 now available!

This release of Rel , an implementation of Date & Darwen's Tutorial D database language, improves the user interface and fixes some bugs. The following enhancements have been made: - Rel UI: Opening a relvar in Edit mode now positions the cursor in the blank row at the bottom, ready to enter a n...
by Dave
Fri Jan 19, 2018 6:10 pm
Forum: Report a Bug
Topic: Unable to find most specific common supertype
Replies: 4
Views: 11241

Re: Unable to find most specific common supertype

That's helpful, and I'll try to provide a better solution. It's actually a limitation in how I've implemented the type inference, but it should be a semantic error rather than the fatal error it is now. At a minimum, I'll update it to be a semantic error in the next release. The solution/workaround ...
by Dave
Thu Jan 18, 2018 11:29 pm
Forum: Report a Bug
Topic: Unable to find most specific common supertype
Replies: 4
Views: 11241

Re: Unable to find most specific common supertype

Could you post the expression or statement that causes the error?

I tried inserting the problem tuple into the Province relvar and it works.

Thanks!
by Dave
Thu Jan 18, 2018 11:24 pm
Forum: Report a Bug
Topic: Incorrect display of a tuple with RVAs
Replies: 4
Views: 12983

Re: Incorrect display of a tuple with RVAs

Can you post a relation literal that exhibits this problem? E.g., turn "Display enhanced output" off and paste the result into a post.

Thanks!