error 78 on MSSQL table 1

[RobertoMexicali]

Hi,

I have this problem: we have an aplication running with MSSql, when the user try to add a record it sends the following error:
"This record already change by another station. Changes will be shoeing now. Error (Invalid Number Of Parameters (78))"

we press ok and then show another error message:

"Error (Invalid Number of Parameters (78)) trying to access record on DBO.CHEQUES. Back to previous window"

press ok again and then the update form is showed and the user can work and save the record normally, i made tests booth running with local database and running on local network and it runs fine, the problem is only with that particular client and with that process only (we have the same aplication running with other clients and none of theme have have these errors.

any tips?

thanks

 

[ShankarJ]

Hi Roberto,

I think that this is an unresolved problem in Clarion. What version of Clarion are you using? The solution is to issue a BRWn.ResetFromFile() after BRWn.ResetFromView() parent call.

Regards

 

[RobertoMexicali]

Hi ShankarJ, thanks for the answer, i already found the problem, there was a code routine previous to call the update, just move the routine to another place.

I noticed that you're very good in the use of clarion, got another question for you: do you know WinDev? we are thinking in change from clarion to windev, we know that gonna be star from the begining again, but aparently windev had many advantages, if you know it, whats your opinion of WinDev?

thanks again for answering, regards

 

[ShankarJ]

Hi Roberto,

I have not used WinDev although I tried their demo a long time back. Here are some very recent excerpts from people using both WinDev & Clarion ::

Hyrum Tatton
------------
You must be using a different WinDev / WebDev than I am.
This only works if:
1- Your winDev project using only that subset of WLanguage commands that
are available in WebDev.
2- You have a french friend who can help you read the occasional error
message that didn't get translated.
3- You are willing to pay the $400+ cost of a WebDev server for EACH
server you plan to deploy on, even if the server is an xp box in the front
office and the web is designed as an intranet.

WinDev/WebDev are excellent products but in my opinion there is much to the
REST of the STORY.

Such as:
1- WinDev/WebDev don't compile the generate interpreted p-Code.
2- The don't generate a .NET program they only generate a .NET assembly
(Pcode read by a .NET stub)
2- To deploy WebDev you need a WebDev server license for EACH and EVERY
deployment (about $400 per deployment)
3- To use Native Access MSSQL Server you need a server license for EACH and
EVERY deployment (about $2000 per deployment) You can use ADO DB to
access MSSQL.

We are using WinDev on one large project, I love the IDE and the Language
syntax, but we have serious issues with the things NO ONE mentioned before
I Purchased the product.

Right now I'm fed up with everyone:
1- Softvelocity who won't let me know that is going on with clarion7 and
..NET
2- PcSoft for generating slick advertising that leaves out several very
EXPENSIVE points when asking me to buy.
3- Microsoft for not providing the tools I really need to run on their
platform.
4- Apple for making the MAC look so good but not run my software in native
mode on their intel processor.

Art Bonds - Reply
-----------------
You are new to the WinDev/WebDev world, and I know sometimes it is difficult
for a new user to catch on to a new technology and understand it's inner
workings and why things are like they are in such a short time. Being a
more experienced Wx user I'll attempt to help you understand a few of your
issues, as most are the result of you not knowing the product.

> You must be using a different WinDev / WebDev than I am.
> This only works if:
> 1- Your winDev project using only that subset of WLanguage commands that
> are available in WebDev.

I would have thought this would be rather obvious. Wx created products are
not confined to running strictly on one platform. You can create product
that run on the desktop (Win32 and Win64), internet, mobile, PHP, Linux and
JAVA platforms, uses native access, ODBC and OLE-DB data access. It should
be obvious that certain technologies only work on certain platforms. Don't
axe me why, is jus dat way. If Wx only included those WLanguage commands
that work on ALL platforms with ALL the data access types, then we wouldn't
have AJAX, would we?

Fortunately Wx doesn't limit our WLanguage commands and that gives us
additional functionality beyond just the common ones. I'd say this is a
plus for us developers, not a negative. And although pretty much all the
common core commands (structures, data access, etc) are shared between
platforms, there will always be commands that pertain to one platform, and
it is always going to be the developers responsibility to verify all
commands in his program are portable to whatever platform he wants to
convert to, whether it's Internet or LINUX or PHP.

> 2- You have a french friend who can help you read the occasional error
> message that didn't get translated.

Or Google Translator. And trust me, Google is far cheaper than any of my
French friends... <g> I remember this conversation btw you and a number
of devs on the WD Forum. There is very little French that has not been
translated, and like they said it's no more than a minor annoyance
considering what you get in the product.

> 3- You are willing to pay the $400+ cost of a WebDev server for EACH
> server you plan to deploy on, even if the server is an xp box in the front
> office and the web is designed as an intranet.

Yup. And remember that is for each physical box (server), not per web site.
A Deployment Server will handle multiple web sites housed on the same
server.

> WinDev/WebDev are excellent products but in my opinion there is much to
> the
> REST of the STORY.
>
> Such as:
> 1- WinDev/WebDev don't compile the generate interpreted p-Code.

Rectified in version 12 with the new Just in Time compiler. I would have
assumed you would have known this is an already outdated complaint (like
saying Clarion does note have true threading), it's in the whats new in WD12
brochure.

> 2- The don't generate a .NET program they only generate a .NET assembly
> (Pcode read by a .NET stub)

I'll have to defer to your knowledge, I have never had the need to use this
functionality. But as always the $64,000 question is: Does it work?

> 2- To deploy WebDev you need a WebDev server license for EACH and EVERY
> deployment (about $400 per deployment)

You had it correct above in 3 (maybe by mistake?), however you blew it here,
and I'll attribute it to new user lack of knowledge of the product.

First, if you use the WB Deployment Server it's on a per SERVER box basis.
Mutiple web sites are deployed on each server, bringing the cost per
deployment down significantly.

Second, you can compile to PHP and NOT use nor have to pay for the WB
Deployment Server at all (again, verify the WLanguage commands you are using
are compatable with PHP). But if you don't know the advantages of using the
Deployment Server then just ask on the Forum.

You really should buy the WinDevCon2007 WebDev DVD. You'd understand all of
this better. It's worth the $110.

> 3- To use Native Access MSSQL Server you need a server license for EACH
> and
> EVERY deployment (about $2000 per deployment)

Again, wrong. Again I've got to attribute to new user lack of product
knowledge... it is rather confusing.

First, the price is around $1050 (no "new user" excuse for getting the price
wrong Hyrum... it's right on the PCSoft website...).

Second, Native Access are on a per SERVER box (like the Deployment Server),
and you can have multiple MSSQL/Oracle/etc database deployments on each box.

Third, (like you allude to), you don't need a Native Access module to access
MSSQL, Oracle, etc, just use the ODBC driver. It's FREE.

> We are using WinDev on one large project, I love the IDE and the Language
> syntax, but we have serious issues with the things NO ONE mentioned before
> I Purchased the product.

I note you asked quite a few pre-purchase questions on the WD Forum before
purchasing. While the folks there are helpful and answered to the best of
their knowledge (much like the folks on these NG's), no one there is
clarivoyant. Nor is anyone anywhere going to answer your question then go
completely off topic and say "and oh BTW, here are 50 other things you
haven't asked about".

I hope you would have taken time to read the rest of the posts dating back
over half a decade... there are many rants about almost everything to do
with Wx products (we are not censored), so I have no doubt the "serious
issues" were probably already discussed (including the Deployment Server...
I found messages on this subject all the way back to the beginning of the
Forum in 2000).

> Right now I'm fed up with everyone:
> 1- Softvelocity who won't let me know that is going on with clarion7 and
> ..NET
> 2- PcSoft for generating slick advertising that leaves out several very
> EXPENSIVE points when asking me to buy.
> 3- Microsoft for not providing the tools I really need to run on their
> platform.
> 4- Apple for making the MAC look so good but not run my software in
> native
> mode on their intel processor.

Couldn't agree more, and I can easily add to that list.

Regards

 

[RobertoMexicali]

Well ShankarJ, i think here at the office we all have the sames doubts about windev, especially with the extra costs for application servers and native access, and the answers given for people who's selling us WD are the same Art Bonds said, is a fact that we're going to buy WD, we're gonna start with little aplications in web and mobile to work with our clarion application and after that maybe we'll start to migrate the rest to WD, in a few months we'll be able to tell about our experiences

thans for your posts, see you on the next thread

 

[ShankarJ]

Hi Roberto,

why don't you evaluate Alpha 5 v9 Platinum from

http://www.alphasoftware.com

as well? The only downside is the runtime licensing but you can always pass that on to the customer. Both Alpha 5 & WinDev have trial versions and you can play with both before you purchase.

Regards