Free GUI Editor for Pick and U2
Martin Scholl
Feeling frustrated and embarrassed over the Line editor that Pick and U2
offer, I wrote a GUI editor with syntax highlighting and all the advantages
of GUI.
It allows connections to several machines, accounts, flavours
simultaneously. You can cust and paste between UniVerse and Pick if you so
desire.
You can compile out of the editor and see your compiler messages. It uses
the D3class library (ODBC only).
I had it mainly geared towards U2, but recently I ported it to D3.
It is free and open source using VB.
Downloads of source and program at www.martinscholl.com
And as always, I welcome anybody who wants to contribute to the UniEditor.
Have fun
Martin Scholl
Scholl Consulting Group, Inc.
301-924-5537 Tel
301-570-0139 Fax
msc...@martinscholl.com
www.SchollConsulting.com
Ed Sheehan
them, none lived up to their promise, yours included (I was hoping number
seven would bring me luck):
Database: D3NT 7.2.0
Account Name: SHEEHAN
User Name: SHEEHAN
Pasword: (none)
Connection: localhost
Database type: D3
I get "unable to connect to Pick database."
Thoughts:
There is no help screen. There are no readme's. No tips.
There is no way to delete connection profiles. The above error message is
like being stopped in a car at the side of the road, and the dashboard light
reads, "Stopped in a car at the side of the road."
I tried four different versions of these connection profiles, experimenting
with settings and IP Addresses vs. Names, all with the same result.
You're not ready for prime time. Don't feel bad. Pick programmers are
notoriously bad at making Windows apps. I guess we expect people to "go
through a learning curve" in order to use applications, whereas Windows
programmers (usually) take care of their target audience as though they
expected stuff to work without a hitch.
Ed
"Martin Scholl" <msc...@comcast.net> wrote in message
news:Ir2i8.142982$pN4.6...@bin8.nnrp.aus1.giganews.com...
Patrick Latimer
but if, target audience = users
Maybe they should get what thet deserve once and a while.
Patrick, <;=)
P.S. It is Friday Ed, don't sugar coat so much.
Ed Sheehan wrote:
> I'm always up for a new editor, although, having downloaded at least six of
> them, none lived up to their promise, yours included (I was hoping number
> seven would bring me luck):
> <snip>
> You're not ready for prime time. Don't feel bad. Pick programmers are
> notoriously bad at making Windows apps. I guess we expect people to "go
> through a learning curve" in order to use applications, whereas Windows
> programmers (usually) take care of their target audience as though they
> expected stuff to work without a hitch.
>
> Ed
> <snip>
Martin Scholl
What have you done recently for the community?
And on a technical note: Have you defined a DNS with the name SHEEHAN?
Martin
"Ed Sheehan" <NOed...@xmission.com> wrote in message
news:a6aq9a$nao$1...@terabinaries.xmission.com...
Fred Tuttle
Am I glad that Ed asked the question before I did! Now I don't feel so
stupid. I have to admit I had the same frustratration. It looks like it may
be a helpful tool but not everyone knows how to spell DNS let alone use it.
I would recommend a brief setup guide so that everyone who wants to try it
out can have a positive experience and say what a neat product it is and
what a net guy Martin Scholl is for his great contribution.
BTW I've seen a lot of responses made by Ed helping people out from the
basics to very tricky stuff. And, I have to admit that sometimes his humor
has me laughing to the point of tears.
My hat's off to both of you!
Fred
"Martin Scholl" <msc...@comcast.net> wrote in message
news:Qr6i8.149574$7a1.12...@bin5.nnrp.aus1.giganews.com...
Martin Scholl
For Pick:
You need to have a D3 ODBC client installed. This comes with D3 or can be
downloaded from the RD ftp site.
After you install it, you need to configure a DSN "data source name" in
the windows control panel "32bitODBC" with this D3 ODBC driver. It comes
with help to tell you how to configure it.
Once you have this DSN done, you can enter the DSN name in my product.
The DSN asks you to specify an account. That is fine. UniEditor overwrites
the account information from the DSN with the one that you specify in the
Connection.
If you don't get the connection done, try to do it with Access or other
tools. It can be frustrating, especially for folks who have never played
with ODBC and Pick API.
For U2.
you need UniObjects licensed on your machine. I just heard that for version
9.5 and above of UniVerse it is free now and your VAR should be able to give
you a free license code.
Martin
Ed Sheehan
Not even a ping reply. Does anyone know of an alternative site to d/l the
ODBC stuff?
I guess the ODBC client/server stuff comes with the D3 cd, but not with the
16MB 7.1 NT download off the ftp site.
Ed
"Martin Scholl" <msc...@comcast.net> wrote in message
news:7q7i8.381864$eS3.28...@bin3.nnrp.aus1.giganews.com...
Ed Sheehan
"Martin Scholl" <msc...@comcast.net> wrote in message
news:7q7i8.381864$eS3.28...@bin3.nnrp.aus1.giganews.com...
> Short User Guide:
>
> For Pick:
> You need to have a D3 ODBC client installed. This comes with D3 or can be
> downloaded from the RD ftp site.
After a long time, the ftp site came up. I downloaded the ODBC client.
> After you install it, you need to configure a DSN "data source name" in
> the windows control panel "32bitODBC" with this D3 ODBC driver. It comes
> with help to tell you how to configure it.
I installed it, then went to control panel, Administrative Tools, Data
Sources (ODBC) - I'm on Win2K - and added the D3 ODBC User Data Source name
of Ezra.
> Once you have this DSN done, you can enter the DSN name in my product.
Do you mean the DSN name should go into the "Connection Name" field? Windows
calls it the "User Data Source name." I put "Ezra" there. I hope that's whan
you meant.
> The DSN asks you to specify an account. That is fine. UniEditor overwrites
> the account information from the DSN with the one that you specify in the
> Connection.
I'm not sure what "That is fine." means. I put 'sheehan' there. "Sheehan" is
an account name I set up on D3. I set up a user name of "sheehan" also. If
by "account" you mean "Pick Account Name," it might be more clear to label
it that way. Just a suggestion.
Then, for host name, I put in "STATION2" This is the same name that you see
in the D3 File Manager under "Servers." It can also be found when you
right-click "My Computer," choose "Properties," then select the Network
Identification" tab. There you'll see "Full computer name:" with "station2"
specified.
> If you don't get the connection done, try to do it with Access or other
> tools. It can be frustrating, especially for folks who have never played
> with ODBC and Pick API.
<snip>
I wonder if there is a sure-fire way to connect with your program, or do I
just "noodle around" and hope for the best?
By the way, at one point I chose File, New and got the editor screen. I
typed some code to see the pretty colors, then chose Tools, Format. Bad
move. It came up with:
"Run time error '13'
Type Mismatch
...then closed the program and I lost all the code. Very nasty if you've
been typing long!
If the correct procedure for getting me connected to D3 is a tough solve for
you, may I suggest you spend more time with your product, so as to document
the right steps. After all, if your editor is good, (and I have no way of
knowing for sure), it would be a shame for people to discard it merely for
lack of the ability to get it connected.
To answer your earlier question, "What have you done recently for the
community?"
I have spent more than 2 hours playing with your publicly-announced
application, finding at least one bug, and perhaps some areas that could
stand some improvement. I believe I've given you some valuable feedback,
which is more than your program gave to me.
I mean you no disrespect. But you must know that these are exactly the kind
of problems that drive potential customers away from otherwise well-written
programs.
And again, in my experience this is absolutely typical for Pick IDE's or
syntax-highlighting editors. I don't know why.
I wonder if using ODBC is better than just installing a client/host program
in a Pick account, as wIntegrate does, and use that to transmit and receive
data to and from the editor. No Uniobjects, no ODBC, just a well written and
controlled program which would run everywhere.
Just a suggestion...
Ed
Martin Scholl
that is synonymous with your first name.
Martin
"Ed Sheehan" <NOed...@xmission.com> wrote in message
news:a6boml$1be$1...@terabinaries.xmission.com...
Ed Sheehan
Ed
"Martin Scholl" <msc...@comcast.net> wrote in message
news:rZoi8.158845$7a1.13...@bin5.nnrp.aus1.giganews.com...
> Ed, to spare yourself grief, you might be better served to use the editor,
> that is synonymous with your first name.
> Martin
<snip>
Dan Sheehan
I am 17, and the son of Ed Sheehan, and I am well versed in the ways
of windows apps, ODBC, and many networking services. I have my CNA,
CCNA, and I am currently studying to get my MCSE. I may not know much
about programming, but I know a poorly written program when I see one.
Here's a few things I noticed.
Your program says "connection name" twice, and I was never really sure
what to put where. Maybe some clarification, or a help screen to
define what each field is asking for.
When trying to format some code (tools/format) we get an error message
saying "not implemented". What does that mean? what part of what is
not implemented, and how do we implement it?
When trying to save, the fields are again confusing. Both seemed to
say the same thing with different words, and I didn't know what to put
where. And when I clicked on an account to save it to, it asked me for
a User name and password. After entering a username, I get the famous
error message "could not connect to pick database".
I learned almost everything I know about windows from the help screen,
but all yours says is "about". I would suggest maybe clarifying the
fields that are asking for something, so that I know what to type
where. Also set up a help file. It shouldn't be too much work, and it
will help circulation of your product a hundred fold.
Thank you.
Dan Sheehan
"Martin Scholl" <msc...@comcast.net> wrote in message news:<rZoi8.158845$7a1.13...@bin5.nnrp.aus1.giganews.com>...
Patrick Latimer
Dan Sheehan wrote:
> Mr. Scholl
> I am 17, and the son of Ed Sheehan, and I am well versed in the ways
> of windows apps, ODBC, and many networking services. I have my CNA,
> CCNA, and I am currently studying to get my MCSE
> <snip>
Stay away from the *Dark Side* (M$) young Dan. The Force is
strong in your family <g> Use it for the power of the good (MV).
My 2, Patrick
P.S Does Pick still have certifications? How about U2? JES.?
Ed Sheehan
the poor employment opportunities in MV. What would a good MS Access
programmer make? I say bring back the Commodore 64. :-)
Ed
"Patrick Latimer" <lati...@earthlink.com> wrote in message
news:3C8A79C6...@earthlink.com...
vhf nut
I downloaded the editor and managed to get it working ok. I would however
suggest the following.
1) Add some help for those that get a bit stuck.
2) Allow the connection profiles to be edited.
3) If you have a very large file then the file selctor flickers like mad
whilst its being updated, perhaps a background update would be better?
4) If you try and format a new program it crashes.
I would be happy to do some of the development if you wish.
Alex
"Martin Scholl" <msc...@comcast.net> wrote in message
news:Ir2i8.142982$pN4.6...@bin8.nnrp.aus1.giganews.com...
"Martin Scholl" <msc...@comcast.net> wrote in message
news:Ir2i8.142982$pN4.6...@bin8.nnrp.aus1.giganews.com...
Martin Scholl
That's much more the input that I hoped for, thanks.
Please feel free to change the source code, and feed it back to me.
1.)I postponed the help file because it is a lot of work. So I convinced
myself to wait until I have all the features down correctly. But I realize
that it is necessary.
2.) Editing Connection profiles: I agree. Maybe right-clicking on them and a
menu comes up with Edit and delete, or if you press "delete" a dialogbox
confirming your decision to delete.
3.) File selector flickering: Maybe disabling the tree control while the
update is happening and then enabling it again after the select list is done
might do.
4.) Format really works only on UniVerse. UniVerse has a Basic program that
formats source code. I realized the problem after I released the program.
Even UniData does not have "Format". The best thing to do would be to write
a VB program to do the formatting. Or maybe there is free code floating on
the internet to do this? This is really the biggest piece of work that is
left to do. i just don't have the time right now. If you, Alex or anybody
else could contribute to this, I think everybody would appreciate it.
5.) There was another problem with the "Save As" functionality. I fixed
that today and posted an update. 0.9.5 .
6.) jBase support is still needed.
Martin
"vhf nut" <alex.gr...@btinternet.com> wrote in message
news:a6dvor$jvl$1...@helle.btinternet.com...
Martin Scholl
charge, gratis, open source
UniEditor increased my own productivity and I want to share it with other
people who are in the same or a similar environment.
I publish the code so others can see how I program in Visual Basic against a
multi-value database. I had sofar 350 downloads, I received bug reports,
suggestions, testimonies from happy users and offers to help.
Why do I have to be confronted with:
...I know a poorly written program when I see one
..You're not ready for prime time.
...Stay out of marketing.
If you notice problems, tell me and I try to fix them. I don't write perfect
code. Though it gets better once users give me feedback
If you snoop around in the source and come up with better ways, more power
to you. I'd like to know about it.
Open Source is a philosophy very contrary to Windows and Microsoft. Open
Source is about sharing your knowledge and deriving joy and satisfaction
from seeing an idea flourish through the combined effort of many.
Martin
"Dan Sheehan" <fredbobj...@hotmail.com> wrote in message
news:b26ad8df.02030...@posting.google.com...
Ed Sheehan
telling people, who in good faith ask for help and point out weaknesses, to
stay away from your product with the implication that they're just not
bright enough to figure it out, doesn't seem to me to be, "...about sharing
your knowledge and deriving joy and satisfaction from seeing an idea
flourish through the combined effort of many."
On the contrary, it seems like it's about vanity and the inability to take
suggestions like a grown up.
I should have said, "Your _program_ is not ready for prime time." Now I
think maybe I had it right after all.
Ed
"Martin Scholl" <msc...@comcast.net> wrote in message
news:Nzyi8.14952$hO6.1...@bin4.nnrp.aus1.giganews.com...
> The product is free, the source code is available. It is a gift. Free, no
> charge, gratis, open source
> UniEditor increased my own productivity and I want to share it with other
> people who are in the same or a similar environment.
> I publish the code so others can see how I program in Visual Basic against
a
> multi-value database. I had sofar 350 downloads, I received bug reports,
> suggestions, testimonies from happy users and offers to help.
> Why do I have to be confronted with:
> ...I know a poorly written program when I see one
> ..You're not ready for prime time.
> ...Stay out of marketing.
>
>
> If you notice problems, tell me and I try to fix them. I don't write
perfect
> code. Though it gets better once users give me feedback
> If you snoop around in the source and come up with better ways, more power
> to you. I'd like to know about it.
>
> Open Source is a philosophy very contrary to Windows and Microsoft. Open
> Source is about sharing your knowledge and deriving joy and satisfaction
> from seeing an idea flourish through the combined effort of many.
>
> Martin
<snip>
Mark Rathbun
>4.) Format really works only on UniVerse. UniVerse has a Basic program that
>formats source code. I realized the problem after I released the program.
>Even UniData does not have "Format". The best thing to do would be to write
>a VB program to do the formatting. Or maybe there is free code floating on
>the internet to do this? This is really the biggest piece of work that is
>left to do. i just don't have the time right now. If you, Alex or anybody
>else could contribute to this, I think everybody would appreciate it.
If you are interested, I can dig up an old Unidata/Adds program
formatter. It was pretty generic and should work with most Pick Basic.
The only thing that would have to be worked on would be the input
buffer mods to get the program and file name where it resides.
Let me know. I'm no longer in the Pick market, but have tons of source
code for utilities like this that I wrote. It would be nice to see
someone use it.
Mark
Martin Scholl
I changed a few things over the weekend.
1) The flicker when opening files with many programs is gone
2) Connections are editable, deletable by right-clicking on the connection
3) Program doesn't crash anymore when trying to format non-UniVerse code
Sorry, no help yet
Martin
"Martin Scholl" <msc...@comcast.net> wrote in message
news:Ir2i8.142982$pN4.6...@bin8.nnrp.aus1.giganews.com...
Dave
"Is it just me, or is this guy obsessed with being negative ("It will
take time, but
the dinosours will eventually lose).
>Maybe in several years we will all be storing data very differently. If it's better,
>then that's a positive development. But Tristan wants there to be a loser in all
>this, and seems congested with the thought ("...its a newsgroup, expect pointless
>debate...").
Tristan, take a Dristan.
Ed"
(from a previous thread)
I think your criticism of Martin's work is pretty rich. He clearly
said that it is a free piece of software to do what you want with it.
If you are incabable of using it , DON'T !
Perhaps a Commodore 64 is more your style.
Jeff Caspari
You handled this dispute like a gentleman. In a forum where anonymity
reduces many otherwise intelligent, well-mannered people to squabbling
children I appreciate your restraint and contribution.
Jeff
Jeffrey Kaufman
Ed and Martin are both valuable assets to this group. Let's not discourage
either of them from continued participation.
Martin spent hours of his valuable time writing an editor to share with the
group. Ed could not get it to work and was a bit harsh with his evaluation
although he was trying to be constructive. I could not get it to work
either. Martin is working on enhancements. Maybe Ed can help with the
development. We all appreciate Martin's efforts.
Now shake hands and play nicely.
Just my 2 cents.
Jeff
--
Jeffrey Kaufman
Key Data Systems Group
www.keydat.com
559-432-3832
559-432-4657 fax
"Jeff Caspari" <qs...@earthlink.net> wrote in message
news:G91j8.70965$gQ.17...@news02.optonline.net...
Don Verhagen
<open source ad snipped>
> Downloads of source and program at www.martinscholl.com
> And as always, I welcome anybody who wants to contribute to the UniEditor.
Some website corrections:
1) http://www.martinscholl.com/html/databases/unidata.html page
1a) Correct the link to informix/Unidata to IBM's page (Link:
http://www-4.ibm.com/software/data/u2/unidata/ )
1b) Spelling error: independant should be spelled independent
2) http://www.martinscholl.com/html/databases/universe.html
2a) Corrent the link to informix/Universe to IBM's page (Link:
http://www-4.ibm.com/software/data/u2/universe/ )
Nothing big, just an FYI. =)
Don Verhagen
>
> Have fun
> Martin Scholl
> Scholl Consulting Group, Inc.
> 301-924-5537 Tel
> 301-570-0139 Fax
> msc...@martinscholl.com
> www.SchollConsulting.com
>
>
>
______________________________________________________________________________
Posted Via Binaries.net = SPEED+RETENTION+COMPLETION = http://www.binaries.net
Fred Finken
> ...I know a poorly written program when I see one
> ..You're not ready for prime time.
> ...Stay out of marketing.
I agree completely. Why would anyone offer to share if this is all
they would have to look forward to?
Keep up the good work and thanks for sharing.
Fred Finken
While it is true that UniData doesn't have a separate program for
formatting, the AE editor can easily be used for this purpose. Here
is a workable solution.
Save the file to be formatted in its directory with a name like
FORMAT_WORK. Invoke the AE editor for FORMAT_WORK, feed it the
commands to do the formatting and then resave the result. After
UniEditor has reloaded the formatted program, delete FORMAT_WORK.
This should be easy to implement and every bit as good as writing a
program for just this purpose.
"Martin Scholl" <msc...@comcast.net> wrote in message news:<J0yi8.14375$hO6.1...@bin4.nnrp.aus1.giganews.com>...
Don Verhagen
"Fred Finken" <fafi...@email.com> wrote in message
news:efb369d3.02031...@posting.google.com...
> >>Even UniData does not have "Format"<<
>
> While it is true that UniData doesn't have a separate program for
> formatting, the AE editor can easily be used for this purpose. Here
> is a workable solution.
>
> Save the file to be formatted in its directory with a name like
> FORMAT_WORK. Invoke the AE editor for FORMAT_WORK, feed it the
> commands to do the formatting and then resave the result. After
> UniEditor has reloaded the formatted program, delete FORMAT_WORK.
>
May I suggest use Format_[originalfile]_[recordkey] for those of use in
multiple user shops. =) Nothing like formatting your work as getting someone
else's work.
Example: File: BP Record: TESTPROG
Temporary Formatting File would be: FORMAT_BP_TESTPROG
Just a side note to Fred's suggestion.
Thanks,
Don Verhagen
> This should be easy to implement and every bit as good as writing a
> program for just this purpose.
______________________________________________________________________________
paul wells
> Alex,
> That's much more the input that I hoped for, thanks.
> Please feel free to change the source code, and feed it back to me.
>
for discussion or emailed to you?
Martin Scholl
Please send them to me also directly.
You can post them on the list, but it is better when they come into my mail
box.
BTW: I am nearly done with a formatting subroutine. Mark Rathburn
contributed a Basic routine that I adapted for VB.
I should release a new version tomorrow 3/13
Maritn
"paul wells" <de...@alienbigcats.com> wrote in message
news:669ac511.02031...@posting.google.com...
dougie
useful tool. My application is running on Unidata and when I attempt to
save the amended program, your editor is adding a LF character (Char
013) onto the end of each line. The UNIBASIC compiler does not like this
- can you tell me if I need to amend some setting. Thanks
--
Posted via dBforums
http://dbforums.com
Martin Scholl
"dougie" <mem...@dbforums.com> wrote in message
news:3c8f4261$1...@spamkiller.newsgroups.com...
dougie
> @spamkiller.newsgroups.com...
> > Martin, I have downloaded your unieditor and I think this could be
> > useful tool. My application is running on Unidata and when I
> > attempt to save the amended program, your editor is adding a LF
> > character (Char
> > 013) onto the end of each line. The UNIBASIC compiler does not like
> > this
> > - can you tell me if I need to amend some setting. Thanks
> >
> >
> >
> > --
Any joy Martin ?