Search found 371 matches
- Tue Apr 10, 2018 3:04 pm
- Forum: Announcements
- Topic: Rel version 3.012 now available!
- Replies: 0
- Views: 29189
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 ...
- Mon Apr 09, 2018 6:00 am
- Forum: Report a Bug
- Topic: Problem with ALTER TYPE_OF
- Replies: 5
- Views: 15591
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;
- Sun Apr 08, 2018 4:24 pm
- Forum: Report a Bug
- Topic: Problem with ALTER TYPE_OF
- Replies: 5
- Views: 15591
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)...
- Sun Apr 08, 2018 4:12 pm
- Forum: Language Issues
- Topic: Option to limit type violation to only the type
- Replies: 1
- Views: 10209
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...
- Wed Mar 28, 2018 9:19 am
- Forum: Report a Bug
- Topic: Old database treated as a new one
- Replies: 1
- Views: 10310
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.
- Wed Mar 28, 2018 9:11 am
- Forum: Report a Bug
- Topic: Problem using code to access external data
- Replies: 1
- Views: 22124
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" ...
- Sun Mar 04, 2018 9:26 am
- Forum: Language Issues
- Topic: Aditional operator functionality
- Replies: 2
- Views: 10355
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...
- Mon Feb 12, 2018 2:38 pm
- Forum: Getting Started
- Topic: Export CSV from command line
- Replies: 3
- Views: 26090
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...
- Thu Feb 08, 2018 7:00 pm
- Forum: Report a Bug
- Topic: Copied text stays in clipboard when it shouldn't
- Replies: 1
- Views: 10089
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...
- 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: 13843
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 {...}
- Mon Jan 29, 2018 6:42 pm
- Forum: Language Issues
- Topic: TYPE inheritance implications
- Replies: 6
- Views: 19427
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 ...
- Fri Jan 26, 2018 11:59 am
- Forum: Announcements
- Topic: Rel version 3.011 now available!
- Replies: 0
- Views: 28248
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...
- Fri Jan 19, 2018 6:10 pm
- Forum: Report a Bug
- Topic: Unable to find most specific common supertype
- Replies: 4
- Views: 13326
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 ...
- Thu Jan 18, 2018 11:29 pm
- Forum: Report a Bug
- Topic: Unable to find most specific common supertype
- Replies: 4
- Views: 13326
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!
I tried inserting the problem tuple into the Province relvar and it works.
Thanks!
- Thu Jan 18, 2018 11:24 pm
- Forum: Report a Bug
- Topic: Incorrect display of a tuple with RVAs
- Replies: 4
- Views: 15136
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!
Thanks!