Search found 49 matches

by steved
Sun Aug 09, 2015 2:42 am
Forum: Discussion
Topic: Rel ttm update material
Replies: 6
Views: 5793

Re: Rel ttm update material

If the Excel export turns out to work well (I'm still working on it), I'll include it in the orthcoming update.
Here's really hoping it works well and can be included in the forthcoming update. Please give all this new material your best shot :D

steve
by steved
Wed Aug 05, 2015 10:10 pm
Forum: Discussion
Topic: Rel ttm update material
Replies: 6
Views: 5793

Re: Rel ttm update material

Do you mean exporting data from a Rel relvar to a table in another DBMS?
hello,

That is exactly what I had in mind but unfortunately didn't express clearly. It would be awesome if not only we could "pull" data put "push" it as well. Your thoughts?

thanks,
steve
by steved
Wed Aug 05, 2015 1:00 am
Forum: Discussion
Topic: Rel ttm update material
Replies: 6
Views: 5793

Re: Rel ttm update material

TTM projects tend to be quite focused on types, type systems and typeful programming, and converting anything more sophisticated than canonical primitives (strings, ints, etc.) is complex. Excellent point. Can you tell us at this point if storing a Rel relvar in another dbms will depend on whether ...
by steved
Mon Aug 03, 2015 5:58 am
Forum: Discussion
Topic: Rel ttm update material
Replies: 6
Views: 5793

Rel ttm update material

Hello, [TTM] TTM and the Information Principle (was Re: [TTM] Definition of Relational Completeness) Dave Voorhis <dave@armchair.mb.ca> JULY 25 wrote: TYPE TypeInfo UNION; TYPE Scalar IS {TypeInfo POSSREP {TypeName CHAR}}; TYPE TupleHeading IS {TypeInfo POSSREP {Attributes RELATION {AttrName CHAR, A...
by steved
Tue May 26, 2015 3:14 am
Forum: Report a Bug
Topic: Integer anomaly
Replies: 3
Views: 4660

Re: Integer anomaly

//Type the digits 01234567 and execute. //You should see: //1234567 //Now type 012345678 //You should see: //ERROR: Encountered "8" at line 1, column 9. //Type 081234567 //You should see: //ERROR: Encountered "81234567" at line 1, column 2. //Now try: EXECUTE "WRITELN " || '01234567' || ";"; //You ...
by steved
Mon May 25, 2015 3:21 am
Forum: Report a Bug
Topic: Integer anomaly
Replies: 3
Views: 4660

Integer anomaly

Hi,

Code: Select all

//Try this in DBrowser.
VAR K INT;
VAR H CHAR;
DO K:=0 TO 8;
BEGIN;
H:=H || K;
WRITELN H;
EXECUTE "WRITELN " || H || ";";
END;
END DO;

//Now this.
VAR K INT;
VAR H CHAR;
DO K:=0 TO 9;
BEGIN;
IF K<>8 THEN
H:=H || K;
END IF;
WRITELN H;
EXECUTE "WRITELN " || H || ";";
END;
END DO;
thanks,
steve
by steved
Sat Mar 14, 2015 12:15 am
Forum: Rel Examples
Topic: Ex1: TYPE definitions
Replies: 1
Views: 3550

Re: Ex1: TYPE definitions

Hi,

I'm just starting to explore user defined types in Rel. I found these
examples helpful.

thanks,
steve
by steved
Tue Jan 13, 2015 7:08 am
Forum: Discussion
Topic: SQL databases
Replies: 3
Views: 3991

Re: SQL databases

hi,

Any guesstimate when this will be available? Will be a significant step forward.

steve
by steved
Tue Jan 13, 2015 4:46 am
Forum: Language Issues
Topic: Key (violation) on a RVA
Replies: 1
Views: 2411

Key (violation) on a RVA

Given T1:
VAR T1 PRIVATE REL{A INT,B REL{C INT,D CHAR}}KEY{A};

This makes sense to me. Not sure it makes sense in TTM:)
VAR T1 PRIVATE REL{A INT,B REL{C INT,D CHAR}KEY{C}}KEY{A};

Would be kinda neat to have available and avoid defining additional
relvar(s) and/or involving GROUP/UNGROUP.

steve
by steved
Tue Jan 13, 2015 3:28 am
Forum: Discussion
Topic: Parameter relvar question
Replies: 9
Views: 5922

Re: Parameter relvar question

hello, Unfortunately ill health prevented me from continuing this topic in a much more timely manner. But better late than never. So permit me to do what users do: make a request. The benefits that come from the combination of being able to update relvar parameters and the use of dynamic code (EXECU...
by steved
Fri Aug 29, 2014 5:19 pm
Forum: Discussion
Topic: Parameter relvar question
Replies: 9
Views: 5922

Re: Parameter relvar question

Hi, If I understand you correctly you think updates, what I called propagation, is an error. Please tell me I'm wrong:(:). The whole point of my posts was to illustrate that updates(propagation) is a great benefit to programmers. I want to pass data between between underlying relvars and operator sc...
by steved
Thu Aug 28, 2014 2:14 am
Forum: Discussion
Topic: Parameter relvar question
Replies: 9
Views: 5922

Re: Parameter relvar question

Hi, There is no issue(s) with a private relvar. VAR A BASE REL{X CHAR}KEY{X}; OPERATOR P1(B REL{X CHAR}); BEGIN; VAR F PRIVATE REL SAME_HEADING_AS(A)KEY{X}; INSERT B REL{TUP{X "A"},TUP{X "B"}}; F:=B; WRITELN "B AFTER 1ST INSERT ";WRITELN B; WRITELN "COUNT(B): ";WRITELN COUNT(B); WRITELN "F AFTER 1ST...
by steved
Sun Aug 24, 2014 3:47 am
Forum: Discussion
Topic: Parameter relvar question
Replies: 9
Views: 5922

Re: Parameter relvar question

Hi, Here's another issue with a relvar parameter and a DELETE. This operator mimics logic in a much larger program. After a DELETE COUNT() seems to be in question. VAR A BASE REL{X CHAR}KEY{X}; OPERATOR P1(B REL{X CHAR}); BEGIN; INSERT B REL{TUP{X "A"},TUP{X "B"}}; WRITELN "B AFTER 1ST INSERT ";WRIT...
by steved
Fri Aug 22, 2014 10:40 pm
Forum: Discussion
Topic: Parameter relvar question
Replies: 9
Views: 5922

Parameter relvar question

Hi, Operator P0 works as expected. VAR A BASE REL{X CHAR}KEY{X}; OPERATOR P0(B REL{X CHAR}); BEGIN; INSERT B REL{TUP{X "E"}}; WRITELN B; WRITELN COUNT(B); DELETE B; END; END OPERATOR; A:=REL{TUP{X "D"}}; CALL P0(A); DROP OPERATOR P0(REL{X CHAR}); Operator P1 causes error. Could you please explain th...
by steved
Mon Aug 11, 2014 8:49 pm
Forum: Discussion
Topic: SQL databases
Replies: 3
Views: 3991

SQL databases

Hi,
Can you give us a heads up as far as which sql database(s) we can expect to use to create relvars.

thanks,