On Wed, January 20, 2010 2:14 pm, Devon McCormick wrote:
> Bill - try
> 9!:7 '+++++++++|-'
> to reset the box characters to ASCII equivalents before running your
> example.
Thanks, Devon.
Here goes again.
Here's the successful example:
9!:7 '+++++++++|-'
require 'data/jdb'
testf=: Open_jdb_ jpath '~temp/jdbtest'
Drop__testf 'tests'
testd=: Create__testf 'tests'
testd=: Open__testf 'tests'
testt2=: Create__testd 'id2'
InsertCols__testd 'id2'; 0 : 0
zeroth int
first varchar
second varchar
third varchar
)
ShowCols__testd 'id2'
+-----+------+-------+------+------+---------+
|table|column|type |unique|parent|parentkey|
+-----+------+-------+------+------+---------+
|id2 |zeroth|int |0 | | |
|id2 |first |varchar|0 | | |
|id2 |second|varchar|0 | | |
|id2 |third |varchar|0 | | |
+-----+------+-------+------+------+---------+
Insert__testd 'id2';<1;'a';'b';'c'
Reads__testd 'from id2'
+------+-----+------+-----+
|zeroth|first|second|third|
+------+-----+------+-----+
|1 |a |b |c |
+------+-----+------+-----+
Insert__testd 'id2';<1;'a1';'b1';'c1'
Reads__testd 'from id2'
+------+-----+------+-----+
|zeroth|first|second|third|
+------+-----+------+-----+
|1 |a |b |c |
|1 |a1 |b1 |c1 |
+------+-----+------+-----+
Insert__testd 'id2';<1;'abc';'def';'ghi'
Reads__testd 'from id2'
+------+-----+------+-----+
|zeroth|first|second|third|
+------+-----+------+-----+
|1 |a |b |c |
|1 |a1 |b1 |c1 |
|1 |abc |def |ghi |
+------+-----+------+-----+
Here's the unsuccessful example:
9!:7 '+++++++++|-'
clear''
require 'data/jdb'
testf=: Open_jdb_ jpath '~temp/jdbtest'
Drop__testf 'tests'
testd=: Create__testf 'tests'
testd=: Open__testf 'tests'
testt1=: Create__testd 'id1'
InsertCols__testd 'id1'; 0 : 0
first varchar
second varchar
third varchar
)
ShowCols__testd 'id1'
+-----+------+-------+------+------+---------+
|table|column|type |unique|parent|parentkey|
+-----+------+-------+------+------+---------+
|id1 |first |varchar|0 | | |
|id1 |second|varchar|0 | | |
|id1 |third |varchar|0 | | |
+-----+------+-------+------+------+---------+
Insert__testd 'id1';<'a';'b';'c'
Reads__testd 'from id1'
+-----+------+-----+
|first|second|third|
+-----+------+-----+
|a |b |c |
+-----+------+-----+
Insert__testd 'id1';<'a1';'b1';'c1'
|assertion failure: validate
| 1=#~.(#@".)&>'active';Tcolmap
I'm struggling to see the difference besides the fact that the first one
starts with a column of integers and that only the first one works. I
fully expect someone to point out a typo rather than a problem, but I
don't see it.
Thoughts?
Bill
> Regards,
>
> Devon
>
> On Wed, Jan 20, 2010 at 4:28 PM, Bill Harris <
> [email protected]> wrote:
>
>> It looks okay when it leaves here.
>>
>> I'll see if I can figure out what's changed in the encoding before I
>> simply resend this. I'm seeing lots of "─" and the like instead
>> of
>> box characters, and I presume you are, too.
>>
>> ...
>
>
>
>
> --
> Devon McCormick, CFA
> ^me^ at acm.
> org is my
> preferred e-mail
> ----------------------------------------------------------------------
> For information about J forums see http://www.jsoftware.com/forums.htm
>
----------------------------------------------------------------------
For information about J forums see http://www.jsoftware.com/forums.htm
