Clarion Magazine has moved!

Francisco,

Around the time I wrote the article I ran into some issues with Clarion# and the then-current release of Microsoft's MVC framework. I ended up switching to C# to resolve those issues, and had to rework the templates substantially.

In the end I'm not sure that a template-based approach was significantly more productive, given the difficulty of representing multi-tier applications inside the Clarion APP model.

There are any number of good tools out there for web development - much depends on the kind of coding you like to do. If I had to do another web app today, I'd probably go with Microsoft MVC and C# again, but I wouldn't try to force it down an AppGen path.

Hope that helps,

Dave

Hello David, I can not find your next articles on this subject. something changed?, what aproach you recommend for a web application under apache? what do you think about clarion php?, thanks

Only took me an hour or so to modify the code so it would save all the attachments in the inbox. Helped a lot!

Hello Joe, did you receive my tables definitions? I send them last week but I did it with the private to the editor option.

Hi Francisco,

You can send me the table definition, and I will have a look at it for you. You should not have to skip opening files on forms, there is something else happening. If you can send the clarion table definition, and the create script for the same table in your SQL data (your database manager should be able to create the script for you), I can have a look and compare the two.

Joe.

Hello Joe thanks for your help and I am sorry for my delay on this reply, I can not solve my problem yet, the first thing I did was to double check the field types and I think they are correct. I turn on the driver trace tool and I can see that my app crash when closing the file or table. So what I did is suppress the line that close the file and the problem disappears everything seems to work fine, but I do not know if I am doing worng, I know that there are more open that close on this file and this is not a right solution. Do you want me to send to you my file definitions? or something else? thanks again....

Hello Bjarne, could you show an example of the use of stored procedures and lookups in unrelated tables under this tab. Thanks

Hello Steve, I have some code in the askpreview -before parent call-to complement a report with other stuff, it works well as long there are records to process, but sometimes I need to print the complement even if there is no records on the proccess/report view, so based on this article I copy some of the openreport parent code right after the parent call. Now the complement code executes -twice I do not know why- but any way no print out. Here is the code I extract, I add the condition so the report goes on when no records on the process/report view, help please.

IF RETURNVALUE<>0 RETURNVALUE=0 SELF.OpenFailed = 0 IF ~SELF.Report&amp;=NULL OPEN(SELF.Report) IF ~SELF.Attribute &amp;= NULL SELF.Attribute.Init(SELF.Report) END IF ~SELF.Preview &amp;= NULL SELF.Report{PROP:Preview} = SELF.PreviewQueue.FileName END . END

The first thing is would do is put in a message statement to display the value of ObjDesktop returned to ensure it is a valid object starting with ` character followed by numbers. Once that is correct comes another hurdle.

I'm not familar with the open office com object model but from what I can see on line the last parameter of loadComponentFromURL is a safe array. Clarion Ole control as of version 6 did not support safe arrays. I have not used clarion since version 6 so if there have been any improvements to the clarion ole control, I would not know about them. The only hope of getting that call to work with the clarion ole control unless improved, is if the safe array parameter is marked as Opt in OLEVIEW indicating it can be omitted.

If not omitable or you need to pass info with it and if the clarion ole control still does not support safe arrays in what ever version of clarion you are using, you will have to switch to early binding and use StdCom instead of the clarion OLE control or use late binding without by calling IDispach methods manually. One of my articles did cover safe arrays with early binding but I do not remember which. perhaps you can search for safe arrays to find it.

You can contact me directly at jkane@satx.rr.com but I'm not sure how much I can help you as I dont have clarion installed any where at present.

i am trying to open OpenOffice via clarion 6.3 using the following code:-

objServiceManager Long

objDesktop CString (64)

objDocument CString (64)

Code

objServiceManager = Create(0,Create:Ole) objServiceManager{Prop:ReportException} = True objServiceManager{Prop:Create} = 'com.sun.star.ServiceManager' objDesktop = objServiceManager{'createInstance("com.sun.star.frame.Desktop")'}

objDocument = objServiceManager{objDesktop &amp; 'loadComponentFromURL("private:factory/scalc", "_blank", 0, Noargs())'}

just to open the open office calc and i want to send data to cell by cell. i can do easily with capesoft office inside and softmaster template for excel.

however, i couldnt do it for open office. also, i have read your article about Handling COM and i did check OLEVIEW for openoffice and i couldnt find any lead that is similar to your explanation. i know your example about outlook but i was looking for something similar. or is it i am getting whole thing wrong? if yes, please let me know which article in clarionmag that i should read.

i have read all your COM articles and downloaded the StdComCl

Hi Francisco,

MS-SQL (and other flavours of SQL) require some specific file structure that TPS files do not. For example; do you have a unique identifier? I typically use a LONG (integer) for an ID; but there are several forms of UID. It should be added as an 'additional sort field' if it's not the key you are using on your browse.

Also, double check field types. It sounds like a possible mismatched field type; but without seeing more detail; it's very difficult to know exactly what's happening.

Joe.

Hello Joe, I need help with ms-sql I have an odd problem with my application(clarion 6.3) I started with this problem when I call a procedure(let's say X) from a form or a window as you know clarion open the files that will be use in that procedure but when the ok button is pressed the aplication crashes. After some tests I found that if I force the procedure X not open the files the problem disapears. I have been careful on the whole application doing this. But when working with relarion tree browses this trick does not work; I think because this templete use several times the access:filex.usefile() procedure. The file i/o operations are fine but the problem is when killing the procedure closing the files. I never had this problem with tps files. Any tip?

The download link has changed - click here.

Dave

Francisco,

There were never enough requests to add support for the external report writer so, no, that support does not exist. However, I am getting ready to add support for the C7/8 external report writer so while my head is in that mode I'll take a better look at adding C6 support also.

If you have any specific questions please send an email and we'll discuss them. tech@LodestarSoftware.com

Hello David, Will this product work for the report writer?, I am using clarion 6.3

Can you post the way that can i use in Multi DLL application ? Sincerely Marcelo Martinez

BTW, if you succeed, you need to set the OpenMode back to what it was. Must be safe.

As to your current issue, the newsgroups would be a much better place to ask; more eyes and brains and experience there.

Thanks for you answer Steve, I solve my problem partially (because I think clarion treats super tps files different than regular ones speaking with this matter of open exclusive mode). Any way I have another problem I am starting to work with ms-sql and my application crashes on some forms (just when I press the Ok or Cancel button) I have noticed that open or access files has something to do with it, I have minimized the problem opening files as minimum as posible on one thread, so I am tempted to use your solution on this article, or do you think I need something else?

Hello Ben,

How can I get access to the windows metafiles from a RW report?, I am doing this from the repot template inside my app-using the embeds- but I have no idea how to get them from the report writer, thanks

Francisco, when you do this sort of thing, changing the open mode at runtime, you must check for errors immediately after trying to open the file.

If the file is open elsewhere in the app, this is exactly what should happen. If you cannot open in the new mode, I would Message() the user and exit the proc.