Problem with Select & List command in 4.1.4.19 release

[senthil kumar]

Hi ,

 

I am facing some problem with Select & List command in 4.1.4.19 release.

 

First I sort the table with out any condition, it is listed all data.

 

SORT FBNK.BASIC.INTEREST ONLY              PAGE    1 16:51:31  06 DEC 2006

 

@ID................

 

1ATS20001025

1AUD20001025

1BEF20001025

1CAD20001025

 

--------------------------------------

 

Step1: When I executed the below query, it is not selecting any data.

 

jsh t24dev1 ~ -->SELECT FBNK.BASIC.INTEREST LIKE 1AUD...

 

 No Records selected

 

jsh t24dev1 ~ -->

 

-----------------------------------------

 

jsh t24dev1 ~ -->LIST FBNK.BASIC.INTEREST LIKE 1AUD...

 

LIST FBNK.BASIC.INTEREST LIKE 1AUD...      

 

 0 Records Listed

 

------------------------------------

 

Step2 : when execute the below query, it has selected the data.

 

LIST FBNK.BASIC.INTEREST LIKE 1USD... ONLY

@ID................

 

1USD20010105

1USD20001222

1USD20001025

 

 3 Records Listed

 

We feel the problem is, in Jbase select or List command it is not recognising the character "A". Can anybody advise me.

--
yours
M.Senthilkumar

[Ian Perkins]

Hi

Try using standard Pick syntax...

LIST FBNK.BASIC.INTEREST EQ '1A]'

This will work but doesn't explain the problem with the dotdotdot
implementation within jbase which actually happens with any file
containing keys matching '1N0N"A"0X'

Out of interest, does anyone here who is NOT a Globus user have an
implementation of LIKE in their VOC/MD?

[john lambert]

The problem here is that LIKE assumes a pattern match. 1A is treated as a pattern match and the rest are treated as literals.
This appallingly bad syntax is supported for Universe compatibility and is another example where almost any string has to be treated as valid even though the jQL compiler could easily point out your error if the syntax was more rigidly defined.

John Lambert

[Jim Idle]

You are not using the patterns correctly.

 

1A is being taken to mean 1 Alpha character, then as UD means nothing it is used as a literal as is also the case with 1U. The problem is that Prime/Universe syntax for such things is completely ambiguous and just happens to try and make something out of whatever it gets.

 

The query you want is:

 

SELECT FBNK.BASIC.INTEREST LIKE “’1AUD’...”

 

Tip: Always use quotes, leaving them out is an ill thought out idea (nothing to do with jBASE).

 

Jim

 

 

---

line-break'>

--
No virus found in this incoming message.
Checked by AVG Free Edition.
Version: 7.5.432 / Virus Database: 268.15.9/573 - Release Date: 12/5/2006 4:07 PM

--
No virus found in this outgoing message.
Checked by AVG Free Edition.
Version: 7.5.432 / Virus Database: 268.15.9/573 - Release Date: 12/5/2006 4:07 PM

[Jim Idle]

See previous post. There is nothing wrong with the LIKE implementation, but the spec of the original LIKE stuff (or rather the fact that it does not throw out junk specs).

Jim

Hi

LIST FBNK.BASIC.INTEREST EQ '1A]'

[T.Turkington]

Am curious if anyone has a vim syntax file for Pickbasic that they're
willing to share. I tried the basic.vim in the distribution but it appears
to be handling "\" incorrectly (thinks the second quote is being
escaped...). Looked to see if perhaps there was such an animal on the jbase
"shared software library", but found that that site apparently is no longer
functioning (have advised webm...@jbase.com).

Tom

[Gary Calvin]

I did a syntax and indent file for jBASE BASIC and put them on the Vim website. You can find them here: http://www.vim.org/scripts/script_search_results.php?keywords=jbase&script_type=&order_by=rating&direction=descending&search=search

Not really Pick BASIC, though, because they are case sensitive.

-Gary-

[Emery A Grantier]

I had others in this group share both syntax and indent files with me,
and here they are...

I have attached several files, including these two:

Vim: "vimrc"
+- vim62: "scripts.vim" & "filetype.vim"
+- indent: "mvbasic.vim" & jbase.vim (first set)
+- syntax: "mvbasic.vim" & jbase.vim (second set)

I use the "mvbasic" syntax and indent files. Each file goes in the
folders shown above. I have had trouble getting the auto file type
detect to work with the network shares we have, which is why there are
lots of commented lines and hard coded things in the scripts.

If anyone could help me over the hump getting the file type detection to
work I could have a more flexible solution.

Deschutes County Information Technology
Emery Grantier, Senior Programmer Analyst
14 NW Kearney
Bend OR 97701

Help Desk (541) 617-4759
Voice & voice mail (541) 388-6543
Fax, with cover sheet! (541) 317-3180
Working hours *EMERGENCY* pager 330-3001 or ePage

emery_g...@co.deschutes.or.us

"Everything should be made as simple as possible, but no simpler."

-----Original Message-----
From: jB...@googlegroups.com [mailto:jB...@googlegroups.com] On Behalf

[T.Turkington]

You are a champ.  Thanks.

 

Tom

[Gary Calvin]

Since we're talking about vim, I've often thought it would be nice to have a wrapper program (maybe called VIM) that would allow using vim on items in hashed files. The wrapper would have to:

    * READU the item
    * write it out to some tmp directory
    * invoke vim on it
    * when vim is done, read it back from the tmp directory
    * WRITE it back to the original file
    * delete it from the tmp directory

All that is not difficult to implement, but it would also need to:

    * detect if a SELECTLIST is active and deal with it

Also not too hard, but here's the sticky point:

    * receive some sort of exit condition from vim that would allow you to kill the active SELECTLIST -- analogous to JED's "exk"

That last bit is something I've never figured out how to do, so I've never done the rest of it. And without that little piece, it seems like I still need JED for hashed file items, and if I have to know JED, I may as well use it for source too, even though I generally like vim better.

-Gary-

gvim -d \\monroe\mBP\*** \\mom\BP,DEV\***



gvim -d \\mom\SO.OUCR\HIDTA_999991_20061130110547.xml \\mom\SO.OUCR\HIDTA_999991_20061130113103.xml

[Steve Bush]

A dumb "Continue to next item?" prompt in the wrapper, post-vim, wouldn't be too obnoxious.

---

From: jB...@googlegroups.com [mailto:jB...@googlegroups.com] On Behalf Of Gary Calvin
Sent: 06 December 2006 23:42

To: jB...@googlegroups.com
Subject: Re: .vim for Pickbasic

[T.Turkington]

This is basically what I've been doing (PickBasic written), but have been using 'xvi' (old dos implementation of vi...).  I don't bother to use READU as I generally only use it on a development system (personal PC) and on files that are under Perforce/SCCS control.  Generally, it handles select lists by editing each item individually, and prompts between items as to whether I should edit it with Y/N/Quit options.  The main limitation is the ability to only edit one item at a time.  I'd share, but doubt that it would work for anyone else as is, as it uses a number of other personal files/processes (i.e.:  has log file for logging edits/calls to interface with Perforce via other PickBasic routines, etc.)

 

I was basically looking at converting some of this logic to .NET and doing 'remote' edits of client items via JRCS which brought me to vim.  Unfortunately, as these edits would be asyncronous READU probably wouldn't help; basically I'm thinking I'll need to keep some sort of check out/in log where I keep a copy of the original item that I compare to the server's current version before checking my updates back in.

 

Tom

-----Original Message-----
From: jB...@googlegroups.com [mailto:jB...@googlegroups.com]On Behalf Of Gary Calvin
Sent: Wednesday, December 06, 2006 11:42 AM
To: jB...@googlegroups.com
Subject: Re: .vim for Pickbasic

[Ed Clark]

You may not be able to get an exit condition from vim, but after each return from vim you could check if the item had changed, and prompt to quit. You could also try passing all the files in the list to vim on one command line and use vim commands to switch between the files as desired--though I guess the command line could get too long pretty quickly on some systems.

 

universe for unix has a program that launches VI for hashed and non-hashed items. I can't find it on my windows install, but I'm pretty sure it was in APP.PROGS and named VI or UV.VI. I don't think it handled bailing out of a list though. I have a similar program that I use to launch a windows editor from universe/undiata/cache in windows--also doesn't do lists though :(

-----Original Message-----
From: jB...@googlegroups.com [mailto:jB...@googlegroups.com] On Behalf Of Gary Calvin
Sent: Wednesday, December 06, 2006 2:42 PM
To: jB...@googlegroups.com
Subject: Re: .vim for Pickbasic

[Charlie Noah]

Ed,

I found an old copy of UV.VI in our obsolete file. It is marked

Module UV.VI.B Version 3.3.1.2 Date 10/16/95

with the latest GTAR date of 10-19-94, and 1 mod made here at Inland.

I probably shouldn't post it here, but if it accidentally got attached
to an email to anyone in the group, well, oops...

Regards,
Charlie Noah
Inland Truck Parts

Ed Clark wrote:
> You may not be able to get an exit condition from vim, but after each
> return from vim you could check if the item had changed, and prompt to
> quit. You could also try passing all the files in the list to vim on one
> command line and use vim commands to switch between the files as
> desired--though I guess the command line could get too long pretty
> quickly on some systems.
>
> universe for unix has a program that launches VI for hashed and
> non-hashed items. I can't find it on my windows install, but I'm pretty
> sure it was in APP.PROGS and named VI or UV.VI. I don't think it handled
> bailing out of a list though. I have a similar program that I use to
> launch a windows editor from universe/undiata/cache in windows--also
> doesn't do lists though :(
>
> -----Original Message-----

> *From:* jB...@googlegroups.com [mailto:jB...@googlegroups.com] *On
> Behalf Of *Gary Calvin
> *Sent:* Wednesday, December 06, 2006 2:42 PM
> *To:* jB...@googlegroups.com
> *Subject:* Re: .vim for Pickbasic

>
> Since we're talking about vim, I've often thought it would be nice
> to have a wrapper program (maybe called VIM) that would allow using
> vim on items in hashed files. The wrapper would have to:
>
> * READU the item
> * write it out to some tmp directory
> * invoke vim on it
> * when vim is done, read it back from the tmp directory
> * WRITE it back to the original file
> * delete it from the tmp directory
>
> All that is not difficult to implement, but it would also need to:
>
> * detect if a SELECTLIST is active and deal with it
>
> Also not too hard, but here's the sticky point:
>
> * receive some sort of exit condition from vim that would allow
> you to kill the active SELECTLIST -- analogous to JED's "exk"
>
> That last bit is something I've never figured out how to do, so I've
> never done the rest of it. And without that little piece, it seems
> like I still need JED for hashed file items, and if I have to know
> JED, I may as well use it for source too, even though I generally
> like vim better.
>
> -Gary-
>
>

> On 12/6/06, *Emery A Grantier* <Emery_G...@co.deschutes.or.us

> <mailto:emery_g...@co.deschutes.or.us>

>
> "Everything should be made as simple as possible, but no simpler."
>
> -----Original Message-----
> From: jB...@googlegroups.com <mailto:jB...@googlegroups.com>
> [mailto: jB...@googlegroups.com <mailto:jB...@googlegroups.com>]
> On Behalf
> Of T.Turkington
> Sent: Wednesday, December 06, 2006 9:59 AM
> To: jB...@googlegroups.com <mailto:jB...@googlegroups.com>
> Subject: .vim for Pickbasic
>
>
> Am curious if anyone has a vim syntax file for Pickbasic that
> they're
> willing to share. I tried the basic.vim in the distribution but it
> appears
> to be handling "\" incorrectly (thinks the second quote is being
> escaped...). Looked to see if perhaps there was such an animal
> on the
> jbase
> "shared software library", but found that that site apparently is no
> longer
> functioning (have advised webm...@jbase.com

> <mailto:webm...@jbase.com>).

[Ed Clark]

That sounds like it :) I've got a very modified version that I tried to get
working on windows without much success--although it might work with the
cygwin version of vim in a telnet session, but not much luck with windows
editors, because I never managed to get universe to start a windows program
synchronously.

> -----Original Message-----
> From: jB...@googlegroups.com [mailto:jB...@googlegroups.com]
> On Behalf Of Charlie Noah
> Sent: Wednesday, December 06, 2006 3:57 PM
> To: jB...@googlegroups.com
> Subject: Re: .vim for Pickbasic
>
>
>

[Jim Idle]

You could always download Cache and use the developers studio ;-)

Jim

-----Original Message-----
From: jB...@googlegroups.com [mailto:jB...@googlegroups.com] On Behalf Of T.Turkington
Sent: Wednesday, December 06, 2006 9:59 AM
To: jB...@googlegroups.com

Subject: .vim for Pickbasic

Tom

[Tony G]

What Tom describes for doing edits of remote items is possible with a freeware (not open source) utility I wrote called MVExec.  It uses mv.NET as the conduit into jBASE.  Software and README are here:

http:// remove.this.partNebula-RnD.com/freeware/

Even the optimistic locking technique that Tom describes can easily be implemented with this.  The interface requires mv.NET which can be installed for a free 30 day evaluation.  Contact me for details.  After that, a single mv.NET runtime license is very inexpensive and can be used for a lot of other things.  See my blog article on Outllook Appointments from MV as an example:

http:// remove.this.tooNebula-RnD.com/blog/

A similar interface can be used for moving data between jBASE/T24 and relational, XML import/export, and all kinds of other applications.

 

D3 has 'vi' available from the command-line and it does what was described earlier, copying data to a temp dir, editing, then writing back to an MV file - as as a model I can verify that it works, and of course would work as well for vim.

 

Tony Gravagno

Nebula Research and Development

TG@ always.remove.this.partNebula-RnD.com

---

From:  T.Turkington

I was basically looking at converting some of this logic to .NET and doing 'remote' edits of client items via JRCS which brought me to vim.  Unfortunately, as these edits would be asyncronous READU probably wouldn't help; basically I'm thinking I'll need to keep some sort of check out/in log where I keep a copy of the original item that I compare to the server's current version before checking my updates back in.

 

Tom