So what are libraries?
They are nothing but a collection of subroutines that somebody else has
written.
And what do you do if you can't find a function in your library that
does exactly what you need?
You write your own, right?
And by the time you have found the right function in your library
Amen Rob.
T-SQL bites. So I write CLR Sprocs or do the heavy lifting in C# and
then call very minimal Sprocs.
On Wed, Jul 13, 2011 at 9:25 PM, Rob Sobers rsob...@gmail.com wrote:
I have to heartily disagree that U2 has a sophisticated business rules
engine. U2 Basic is such a limited
I think the power of Databasic can be (and is certainl seen as) the problem
- esp if you are from a computer science background, yes it is more powerful
than t-sql and other languages that 'sit inside the DB' but it is nowhere
near as powerful as a full language like c#, java etc.
In other
READUO is just READ (keep an original copy of the record, to detect
changes), at the end of your code perform the write. If you want to detect,
and remediate any changes someone else made, read the record again, compare it
to the original record (before the record was updated) and remediate
Because it is just 2 lines of code anyway so why bother
-Original Message-
From: u2-users-boun...@listserver.u2ug.org
[mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Tony Gravagno
Sent: 13 July 2011 23:46
To: u2-users@listserver.u2ug.org
Subject: Re: [U2] Record Locks - How
WELL - optimistic lock testing is WAY more than 2 lines of code! You have
to have a 'structure' to 'store' the original data image in, then on the
write, check that image against a current version (that you DID hard lock)
and if the same, write, if not fail. If you can do that in 2 lines of
On 14/07/11 13:40, David Wolverton wrote:
Perhaps a more interesting example might be -- what if your business model
would make it more efficient to move one of the files 'off world' to a SQL
store on another machine?? If you 'called' a subroutine to do your reads
and writes, those could
Yes, and my point is that in the U2/UniBasic ecosystem, those collections of
subroutines are not readily available anywhere.
What if you want to use a web service that emits JSON? Is it going to take
you 3 lines of code and 5 minutes to write a JSON parser? And what about
serialization,
David, For your last point regarding accessing data from multiple places. -
i have done just that and a number of programmers use it to access data
that can be u2, sql, xml or csv in source - all with an open, read, write
call, and it is made easier with some nice equates so it all looks kind of
Code:-
Read rec from fil,id else rec=''
rec.checksum = checksum(rec)
... logic ...
* write data back
Readu tmp from fil,id else tmp=''
If checksum(tmp) = rec.checksum THEN
Write rec on fil,id
Else
Release fil,id
Go do whatever it is you now need to do
END
So maybe 3 or
Rob:
This is the U2 list. The developers on this list... like, live, and breathe
U2. U2 is a legacy database for in which, over decades, companies have
invested in mega-mountains of code. I find it galling when newbies so often
expect companies to instantly bail on their colossal stake.
Is
I setup a table of tables after I opened sequential files and I
started running into very strange results until I realized that
with sequential files, you can't really distribute FCB the same
way, as the offset pointer is stored in that FCB. You have to
save it back to the table when
U2 has an easy learning curve ..? What? MV is a completely foreign
concept to most people and I'd wager a large number of DBAs. There is
no conceivable way that installing U2, setting up a database, developing
an application and presenting it using a technology that's not a
dinosaur can be
_
From: Jackie Burhans
Sent: Thursday, July 14, 2011 8:55 AM
To: Daniel McGrath; Dave Peters
Cc: Vinnie Smith
Subject: RE: Post
Very thorough response. Minor edits below in red. One suggested cut noted like
this {xxx}
One question--can you and Dave
Not the snake - the language ;)
At u2u two (or was it 3) years ago a guy from ibm demo'ed some gci code he
did so you could call any python code from your databasic. He said if there
was interest it could be incorporated into u2, and said at the least he
could release the gci code he did -
Ah, early morning. Obviously I missed some clean up... Sorry all
-Original Message-
From: u2-users-boun...@listserver.u2ug.org
[mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Daniel McGrath
Sent: Thursday, July 14, 2011 9:04 AM
To: U2 Users List (u2-users@listserver.u2ug.org)
Strange I was reading this article on sharding
(http://technoroy.blogspot.com/2008/07/shard-database-design.html) and I
starting thinking as I read. We can do this in UniBasic using UniVerse and
distributed files, what's the big deal. Granted I may not be as up on this as
some of the
If Rocket asked you what you want, what would you say
1. make the site publically available, stop hiding information and
ancillary tools (like whatever your new redback replacement is) behind
maintenance/registration. Make these available publically
2. Offer a semi-crippled version of U2 that is
You were given many reasons and dismissed them all with nothing more
than a shrug.
Apparently, now you believe you've made your point. Good for you.
Amazing as it may sound, on a list full of people who are U2 developers
you're going to find people who use U2 because we're experts in it, and
1. Do you mean U2DevZone? You should see an article on that next week in the
U2 News Flash--you are subscribed, right? If not, go to: http://goo.gl/G1uem
2. Please email us at u2as...@rs.com with more info on what you are thinking
of. We are doing some work in this area. Or you can post here.
Symeon:
Man...my modified optimistic update subroutine is at least 35 lines of
code; which doesn't take into account managing the checksum variable. :-(
Bill
- Original Message -
*From:* syme...@gmail.com
*To:*
There once was a list called Community
Posters avoid it with impunity
It makes a spectacular day
To see the moderator say
This thread is no good
In this neighborhood
You have the right to be silent
Don't accelerate my retirement
Please move this to the Community List
Let this discussion cease and
I am seriously interested in language bindings as well. Specifically
serverside.
On Jul 14, 2011 11:08 AM, Symeon Breen syme...@gmail.com wrote:
Not the snake - the language ;)
At u2u two (or was it 3) years ago a guy from ibm demo'ed some gci code he
did so you could call any python code
Yeah. We had good experience using that functionality at a prior shop.
Wish they would come to Unidata.
On Jul 14, 2011 11:10 AM, Jerry Banker jpb-u...@hotmail.com wrote:
Strange I was reading this article on sharding (
http://technoroy.blogspot.com/2008/07/shard-database-design.html) and I
Logging, unittesting,
On Jul 14, 2011 10:12 AM, Rob Sobers rsob...@gmail.com wrote:
Yes, and my point is that in the U2/UniBasic ecosystem, those collections
of
subroutines are not readily available anywhere.
What if you want to use a web service that emits JSON? Is it going to take
you 3
Jeff:
...and to us it's as easy as pie to develop in this environment. When
Pick first came out the people who built the hundreds of business
applications were business people, not techno-geeks, who somehow think
C# is the be-all and end-all of computer languages. This should say it
all.
I've missed this discussion because I've been busy designing a website and
app for a client.
This being the real world, the site will eventually - of course - be
delivered using SQL Server and C#, with the front end using AJAX calls to
JSON services delivered through WCF. Which will no doubt take
Brian
I tried a few times today and I am unable to get to the website there...
Oops! Google Chrome could not find www.brianleach.co.uk
--Bill
___
U2-Users mailing list
U2-Users@listserver.u2ug.org
http://listserver.u2ug.org/mailman/listinfo/u2-users
I don't even know what JSON is supposed to be good for, so why would I
want to use a web service that emits it?
I don't have a need for a JSON parser, so why should I write one?
And what if I don't need serialization, compression and PDF generation?
Well, I have tools for generating PDFs, but
Bill
That's weird, it's up and I can see it (Chrome, FF, IE)
Looks crap, but that's the old cobblers shoes story .. one day I'll get time
to rewrite it.grin
Brian
-Original Message-
From: u2-users-boun...@listserver.u2ug.org
[mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of
JSON is just another data exchange format like, csv, xml, etc.
The main advantage is that it is arguably better at passing name, valued
pairs of data (like Pick/MV in DataBASIC), than xml, etc.
It can also arguably make writing AJAX (i.e. FAST data entry web forms),
somewhat easier (with
Javascript inherently works with JSON regardless of any library used.
It is a fantastic serialisation of data that should be embraced in the MV
world. It fits very well in fact, it handles any level of array nesting so
can manage the 3 (or 4 inc @tm) levels of MV data, it is schemaless and
weakly
Symeon says
Javascript inherently works with JSON regardless of any library used.
It is a fantastic serialisation of data that should be embraced in the
MV
world. It fits very well in fact, it handles any level of array nesting
so
can manage the 3 (or 4 inc @tm) levels of MV data, it is
I'm going to attempt to explain one scenario why the per seat licensing
won't win you any new customers...
Lets say, I'm a smaller company (or a bigger company for that matter), and
all I want to do is build my application for the web.
(I do not want to use terminal sessions for anything)
OR
I'm
From: Symeon Breen
rec.checksum = checksum(rec)
If checksum(tmp) = rec.checksum THEN
Symeon, there's no doubt that coding optimistically is easy, but
in addition to requiring a custom statebag you also need to
manage timeouts. Wol and others have commented on some of the
nuances here.
From: Tom Whitmore
Personally, optimistic locking is not an ideal
method for performing updates. I know that is the way
many DBs work but that doesn't make it right.
Uh, but that IS the way that every web-based application on the
planet works. C'mon now. Arguing the way things work is
Jake Holt wrote:
U2 has an easy learning curve ..? What? MV is a
completely foreign concept to most people and I'd
wager a large number of DBAs. There is no conceivable
way that installing U2, setting up a database,
developing an application and presenting it using a
technology that's
From: Bob Wyatt
Let this discussion cease and desist
Bob, I've been wondering if and when moderation would kick in,
but I think overall, the flurry of discussion has been very
positive and mostly on-topic. Perhaps the moderation should bend
away from cease and disist toward please focus on
1. Do you mean U2DevZone? You should see an article on that next week in
the
U2 News Flash--you are subscribed, right? If not, go to:
http://goo.gl/G1uem
**
I mean products like DataVu, Web DE and VisualStudio add ins. At least
offer scaled down solutions for public use (like the watered down
If I have the following dynamic array: TEST
1this
2is
3a
4mv ] test
field 1 = part1
field2 = part2
field3 = part3
field4 = part4
I could make XML as
TEST
part1this/part1
part2is/part2
part3a/part3
part4 vm=1mv/part4
part4 vm=2test/part4
/TEST
I'm confused on how this serializes
Att 4 can be encoded on its own and stored within the parent Jon record. I
am on my phone so pls don't make me key data structures. B-)
On Jul 14, 2011 5:32 PM, George Gallen ggal...@wyanokegroup.com wrote:
If I have the following dynamic array: TEST
1this
2is
3a
4mv ] test
field 1 =
Doh. Autocorrect got me. I meant json record.
Take a look at json.org
That XML example is but one may to model that record.
On Jul 14, 2011 5:36 PM, Steve Romanow slestak...@gmail.com wrote:
___
U2-Users mailing list
U2-Users@listserver.u2ug.org
George:
We have been using JSON for many years now with our Web integration on
Universe and Unidata. This is how your JSON string could look:
{TEST : {
part1 : this,
part2 : is,
part3 : a,
part4 : [mv],[test]
}}
Regards,
Doug
www.u2logic.com
U2WebLink middleware for U2
On Thu,
I developed a new application in U2 and I sell it. I am not a dinosaur.
What has been raised is technical comparisons, but if you are developing
software to sell you need to think commercial advantages. For instances, I
never sell to IT, I sell to business decision makers, technology means
Hi Brian:
Microsoft now has a plug-in for Eclipse see
http://msdn.microsoft.com/en-us/library/gg413285.aspx. Eclipse just
released version 3.7 around June 22nd and they have had a million plus
downloads. They released 62 projects with over 46 million lines of code
see
When i look at an eclipse application I see 80% ui that is not relevant to
the task at hand. I agree that it and most every app implemented with it
are trash.
On Jul 14, 2011 6:11 PM, Doug Averch dave...@gmail.com wrote:
Hi Brian:
Microsoft now has a plug-in for Eclipse see
When looking at an Eclipse app, it might be a good idea to put sunglasses on
first... maybe some special optical apparatus.
There is...
O Rocket's BDT
O u2Logic's xLR8
O Adobe Flex Builder
O Adobe ColdFusion Builder 2
O Hundreds of Others
Even a blind
At the risk of correcting Doug, if this is your input:
TEST
part1this/part1
part2is/part2
part3a/part3
part4 vm=1mv/part4
part4 vm=2test/part4
/TEST
...in JSON there could be represented a few different ways. It could be as
simple as:
[this,is,a,[mv,test]]
Or as complex as:
A couple recent comments got my attention. As time permits
(ROFL) I've been working on a new MV-independent ODBC interface
which provides a high level of SQL-92 compliance. I thought
people in this developer base were pretty happy with the built-in
capabilities for U2. Is that not the case?
Yea...and wouldn't it be nice of the TO.DELIM keyword in UniQuery worked!
Bill
- Original Message -
*From:* charles_shaf...@ntn-bower.com
*To:* U2 Users List u2-users@listserver.u2ug.org
*Date:* 7/14/2011 2:18 PM
Not a fan of any of them. Slow, clunky. BDT, are you kidding. I'll use
edlin first.
On Jul 14, 2011 6:24 PM, Bill Brutzman bi...@hkmetalcraft.com wrote:
When looking at an Eclipse app, it might be a good idea to put sunglasses
on first... maybe some special optical apparatus.
There is...
O
David, what you're touching on here is one of the fundamental
differences between MV and relational: We use BASIC within the
engine to manage Referential Integrity (RI) and provide business
rules. Simultaneously, our RI is contained in the business
rules, not at the DBMS level. They use other
Tony,
I appreciate your comments and opinion...
I subscribe to the list for the technical exchange of ideas, and it is my
understanding that this is why this particular list exists.
u2-users: Technical Discussions related to the U2 product family. Use this
list to ask the community for
In fairness, I don't think anyone is trolling. I think it's healthy to
question the technical merits of the platforms you use and compare them to
alternatives.
A community that shouts go away trolls! we like it here! whenever someone
asks an uneasy question is probably one I don't belong in.
I
I have been mildly trolling. I'll stop.
On Jul 14, 2011 7:15 PM, Rob Sobers rsob...@gmail.com wrote:
In fairness, I don't think anyone is trolling. I think it's healthy to
question the technical merits of the platforms you use and compare them to
alternatives.
A community that shouts go away
Hi Kevin:
I could not get you code to validate, see: http://jsonlint.com/, nor could I
get my suggestion to validate either.
Here is some real code read for Universe and this does validate. The
Contact Name is multivalued attribute.
[{IdCode:178,CusName:U2Logic,ContactName:[[David
Ah drat, I knew I should have validated before posting. That's what
confidence'll get ya.. :)
The first one was valid. The second is missing a } at the end, and the
third one should have ended in }}} instead of ]}.
Regarding this:
[{IdCode:178,CusName:U2Logic,ContactName:[[David
I can't see a reason for the nested arrays either. This validates just
fine:
[
{
IdCode: 178,
CusName: U2Logic,
ContactName: [
David Aitken,
Doug Averch,
Ed Karlo
]
}
]
On Thu, Jul 14, 2011 at 9:28 PM, Kevin King
58 matches
Mail list logo
