Search found 367 matches

by Dave
Wed Mar 28, 2018 9:19 am
Forum: Report a Bug
Topic: Old database treated as a new one
Replies: 1
Views: 1193

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: 921

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" at line 12, column 1...
by Dave
Sun Mar 04, 2018 9:26 am
Forum: Language Issues
Topic: Aditional operator functionality
Replies: 2
Views: 1347

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: 2588

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 something like... ./RelDBMS < S_...
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: 999

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: 1830

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: 2657

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: 1769

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 new t...
by Dave
Fri Jan 19, 2018 6:10 pm
Forum: Report a Bug
Topic: Unable to find most specific common supertype
Replies: 4
Views: 1382

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: 1382

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: 1901

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!
by Dave
Thu Jan 18, 2018 11:22 pm
Forum: Report a Bug
Topic: Column heads for RVAs not treated right when names only selected
Replies: 3
Views: 1830

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

Can you post a paste of a relation literal that exhibits this problem, such as the relation below with "Display enhanced output" turned off?

That will help me see exactly what's going on.

So far, I've not been able to duplicate this.
by Dave
Thu Jan 18, 2018 11:15 pm
Forum: Report a Bug
Topic: edit functions greyed out mysteriously
Replies: 3
Views: 1703

Re: edit functions greyed out mysteriously

This is helpful -- it should allow me to track down what's causing it.
by Dave
Thu Jan 18, 2018 11:13 pm
Forum: Report a Bug
Topic: Input nonappearance in output pane
Replies: 1
Views: 944

Re: Input nonappearance in output pane

Try checking "Preferences | Command line | Use an alternative output display to try to fix output problems." The standard output is actually hooking into the default Web browser. Depending on the version and type of default Web browser, it sometimes breaks, and the alternative output display will ge...
by Dave
Sun Jan 14, 2018 9:50 am
Forum: Report a Bug
Topic: Rev query problems
Replies: 5
Views: 2092

Re: Rev query problems

Excellent. :-)