|
Clarion Pgmr wanting to use WebDev20 |
Iniciado por Kevin Erskine, 02,sep. 2016 20:40 - 6 respuestas |
| |
| | | |
|
| |
Publicado el 02,septiembre 2016 - 20:40 |
I have used Clarion since version 1 and continue to use it (v10) and have made a good living from it.
I need to start a new project that needs to be web based and since Clarion has not stepped up to the plate with much (I know H5 is trying to be released) I would like to use WebDev.
Are there any Clarion developers who have done WebDev projects that could give me some tips? I have done the tutorials.
I have owned WebDev etc since v16, but really not used it.
I think I would have to use the TopSpeed ODBC driver since we have lots of data that must be shared with desktops and existing systems. Any known issues?
Thanks for any help\suggestions. Anyone have something written up on this and willing to share?
Please feel free to email me directly.
Thanks; Kevin Erskine KErskine@Software-By-Ragazzi.com www.Software-By-Ragazzi.com Queen Creek, AZ, USA |
| |
| |
| | | |
|
| | |
| |
Publicado el 03,septiembre 2016 - 16:49 |
Hello Kevin:
A small contribution ... I was or am clarion programmer, I say this because I hardly use clarion, PCSoft have been using products from version 12. I have a client still in clarion and tps (uuffff). I only tests from windev through odbc and functions, including processes such as Insert or Update. But as I mention I tested only I'm thinking of doing some things from webdev or windev, together with tps and clarion.
Excuse my English, I use the google traslator.
regards Victor
--- El software de antivirus Avast ha analizado este correo electrónico en busca de virus. https://www.avast.com/antivirus |
| |
| |
| | | |
|
| | |
| |
Publicado el 07,septiembre 2016 - 01:15 |
Victor;
Thanks for your reply.
Kevin Erskine www.Software-By-Ragazzi.com Queen Creek, AZ, USA "Victor Hugo Pereyra" wrote in message news:201695cde0ed3d3ef822e1c93b9ac969d3a0@news.pcsoft.fr...
Hello Kevin:
A small contribution ... I was or am clarion programmer, I say this because I hardly use clarion, PCSoft have been using products from version 12. I have a client still in clarion and tps (uuffff). I only tests from windev through odbc and functions, including processes such as Insert or Update. But as I mention I tested only I'm thinking of doing some things from webdev or windev, together with tps and clarion.
Excuse my English, I use the google traslator.
regards Victor
--- El software de antivirus Avast ha analizado este correo electrónico en busca de virus. https://www.avast.com/antivirus |
| |
| |
| | | |
|
| | |
| |
Publicado el 18,octubre 2016 - 10:25 |
Hi Kevin.
I am in the exact same boat as yourself. CW10 is my main stream dev platform.
I purchased the Windev Trio of products a year or so, when v0 came out. Since been working through different scenarios in which I need to use any or all of these products. Of course, difficult through lack of familiarity and outside any comfort zone there is for CW. But, perhaps like yourself, feel SV is really falling behind sad to say.
Last few days I have been trying to work out what to do about all the TPS data that needs to be accessed, either for conversion to an alternative or left in place and maintained in place via ODBC.
I am experiencing a major issue using ODBC from WD EXE to access the topspeed files, and hope mentioning it here may provide a comment from someone in finding a resolution. Understandably, not everyone works with Topspeed files and so there doesn't appear to be a great deal that can be offered at this point, and why would there be.
Nevertheless, for me, this is a real issue that is prohibitive. I am unable to confirm if the following issue is limited to just my dev environment. If you wouldn't mind spending the time, perhaps you and I could come up with something, as it sound like you have similar tools at hand as I except for an earlier version of WD (maybe there is something in that). Either way, make sure you don't experience the same issue in your dev environment.
I am using: Windows 10 Pro 64-bit; WinDev 21; Topspeed ODBC driver version 5.09; I have 2 TPS files defined for the purpose of testing this issue with TS ODBC.
The first file has 20 fields defined, the first string(24) to hold a UUID and the remaining 19 defined as string(2). The first field is keyed as the primary.
The second file has 21 fields defined, the first string(24) to hold a UUID and the remaining 20 defined as string(2). The first field is keyed as the primary.
I used a CW10 app to create the files and added one record in each to ensure access.
In WinDev 21, I created an analysis, a connection to the files via OLEDB etc. Both file structures were read correctly. (Note: At this stage, I did not choose to preview the file structure being read in).
I created a 32-bit windows WinDev project and, using the analysis, created RAD window tables which accessed the 2 TPS files. Testing each table in the WinDev environment, the first TPS file having 20 fields defined, opened ok; the second, with 21 fields defined, did not and subsequently produced an error.
If you were to remove the 21st field from the second files definition, making it now 20 columns, and go through the process again, the second file now opens ok too. It appears the issue is hinged on a limit of having 20 fields defined in the structure.
I mentioned in a note above that I did not choose to preview either of the files whose structure was being imported. The same issue can be experienced even there, although the import of the structure still appears to be generated correctly. I.E. the 20 column TPS file can be previewed, but the 21 column TPS file generates an error when reviewed.
Hope this helps, and more so, hope the cause of the issue can be found and resolved if you are able to help.
Regards Mike R
On 3/09/2016 2:40 AM, Kevin Erskine wrote:
I have used Clarion since version 1 and continue to use it (v10) and have made a good living from it. I need to start a new project that needs to be web based and since Clarion has not stepped up to the plate with much (I know H5 is trying to be released) I would like to use WebDev. Are there any Clarion developers who have done WebDev projects that could give me some tips? I have done the tutorials. I have owned WebDev etc since v16, but really not used it. I think I would have to use the TopSpeed ODBC driver since we have lots of data that must be shared with desktops and existing systems. Any known issues? Thanks for any help\suggestions. Anyone have something written up on this and willing to share? Please feel free to email me directly. Thanks; Kevin Erskine KErskine@Software-By-Ragazzi.com www.Software-By-Ragazzi.com Queen Creek, AZ, USA |
| |
| |
| | | |
|
| | |
| |
Publicado el 26,octubre 2016 - 19:39 |
Mike;
Thanks for your input.
Email me at KErskine@Software-By-Ragazzi.com and we can continue this.
I need to begin testing alternatives by end of year so I can do some with you until then.
Kevin
Kevin Erskine www.Software-By-Ragazzi.com Queen Creek, AZ, USA "mike rusling" wrote in message news:20163a6f52ec020c6851b7cefbaf1cb603ab@news.pcsoft.fr...
Hi Kevin.
I am in the exact same boat as yourself. CW10 is my main stream dev platform.
I purchased the Windev Trio of products a year or so, when v0 came out. Since been working through different scenarios in which I need to use any or all of these products. Of course, difficult through lack of familiarity and outside any comfort zone there is for CW. But, perhaps like yourself, feel SV is really falling behind sad to say.
Last few days I have been trying to work out what to do about all the TPS data that needs to be accessed, either for conversion to an alternative or left in place and maintained in place via ODBC.
I am experiencing a major issue using ODBC from WD EXE to access the topspeed files, and hope mentioning it here may provide a comment from someone in finding a resolution. Understandably, not everyone works with Topspeed files and so there doesn't appear to be a great deal that can be offered at this point, and why would there be.
Nevertheless, for me, this is a real issue that is prohibitive. I am unable to confirm if the following issue is limited to just my dev environment. If you wouldn't mind spending the time, perhaps you and I could come up with something, as it sound like you have similar tools at hand as I except for an earlier version of WD (maybe there is something in that). Either way, make sure you don't experience the same issue in your dev environment.
I am using: Windows 10 Pro 64-bit; WinDev 21; Topspeed ODBC driver version 5.09; I have 2 TPS files defined for the purpose of testing this issue with TS ODBC.
The first file has 20 fields defined, the first string(24) to hold a UUID and the remaining 19 defined as string(2). The first field is keyed as the primary.
The second file has 21 fields defined, the first string(24) to hold a UUID and the remaining 20 defined as string(2). The first field is keyed as the primary.
I used a CW10 app to create the files and added one record in each to ensure access.
In WinDev 21, I created an analysis, a connection to the files via OLEDB etc. Both file structures were read correctly. (Note: At this stage, I did not choose to preview the file structure being read in).
I created a 32-bit windows WinDev project and, using the analysis, created RAD window tables which accessed the 2 TPS files. Testing each table in the WinDev environment, the first TPS file having 20 fields defined, opened ok; the second, with 21 fields defined, did not and subsequently produced an error.
If you were to remove the 21st field from the second files definition, making it now 20 columns, and go through the process again, the second file now opens ok too. It appears the issue is hinged on a limit of having 20 fields defined in the structure.
I mentioned in a note above that I did not choose to preview either of the files whose structure was being imported. The same issue can be experienced even there, although the import of the structure still appears to be generated correctly. I.E. the 20 column TPS file can be previewed, but the 21 column TPS file generates an error when reviewed.
Hope this helps, and more so, hope the cause of the issue can be found and resolved if you are able to help.
Regards Mike R
On 3/09/2016 2:40 AM, Kevin Erskine wrote:
I have used Clarion since version 1 and continue to use it (v10) and have made a good living from it. I need to start a new project that needs to be web based and since Clarion has not stepped up to the plate with much (I know H5 is trying to be released) I would like to use WebDev. Are there any Clarion developers who have done WebDev projects that could give me some tips? I have done the tutorials. I have owned WebDev etc since v16, but really not used it. I think I would have to use the TopSpeed ODBC driver since we have lots of data that must be shared with desktops and existing systems. Any known issues? Thanks for any help\suggestions. Anyone have something written up on this and willing to share? Please feel free to email me directly. Thanks; Kevin Erskine KErskine@Software-By-Ragazzi.com www.Software-By-Ragazzi.com Queen Creek, AZ, USA |
| |
| |
| | | |
|
| | |
| |
Publicado el 27,octubre 2016 - 15:00 |
Hello
The test I did and I worked for consultation perform this type of connection and consults.
CN is Data Source TableDeleteAll(TABLE_tps) HourGlass() bCON is boolean = HExecuteSQLQuery(CN,MyConnection2,hQueryWithoutCorrection,"SELECT * FROM LIBRO ") // where FECALT >={d'2016-01-01'} IF bCON = True THEN BuildBrowsingTable(TABLE_tps,CN,taFillTable) END
HourGlass(False)
HourGlass (False)
and to update the tables do classes where relizar charge of the insert, delete or update with SQL statements and never use the HXXXX.
Example Class
Structure is STBancoST CodBan is string of 4 Descrip is string of 20 EMP is string of 2 PLANCTA is string of 11 Type is string of 1 ACTIVE is string of 1 END
BancoClass is a Class Inherits from STDatos
GLOBAL ArrRec is array of STBancoST Rec is dynamic STBancoST
END
PROCEDURE Constructor ()
PROCEDURE Destroyer ()
PROCEDURE BuildStatement (ArgRec is STBancoST, ArgType)
SQlinstruccion is string
Upper SWITCH (ArgType) CASE "INSERT" SQlinstruccion = [ INSERT INTO BANKS (CodBan, Descrip, EMP, PlanCta, Type, ACTIVE) Values ( '% 1', '% 2', '% 3', '% 4', '% 5', '% 6') ] SQlinstruccion = StringBuild (SQlinstruccion, ArgRec.CodBan, ArgRec.Descrip, ArgRec.EMP, ArgRec.PLANCTA, ArgRec.Tipo, ArgRec.ACTIVO) ExecSQL (SQlinstruccion)
ArrayAdd (ArrRec, ArgRec) FetchData () CASE "UPDATE" SQlinstruccion = [ UPDATE BANKS SET CodBan = '% 1' Descrip = '% 2' EMP = '% 3' PlanCta = '% 4' Type = '% 5', ACTIVE = '% 6' CodBan WHERE LIKE '% 7' ] SQlinstruccion = StringBuild (SQlinstruccion, ArgRec.CodBan, ArgRec.Descrip, ArgRec.EMP, ArgRec.PLANCTA, ArgRec.Tipo, ArgRec.ACTIVO, ArgRec.CodBan) ExecSQL (SQlinstruccion) nNDX is int = ArraySeek (ArrRec, asLinearFirst, "CodBan" ArgRec.CodBan) IF nNDX> 0 THEN Rec = ArrRec [nNDX] Rec <= ArgRec
END // ArrayAdd (ArrRec, ArgRec) CASE "DELETE" SQlinstruccion = [ DELETE FROM BANKS CodBan WHERE LIKE '% 1' ] SQlinstruccion = StringBuild (SQlinstruccion, ArgRec.CodBan) ExecSQL (SQlinstruccion) ArrayAdd (ArrRec, ArgRec) FetchData () OTHER CASE
END
PROCEDURE FetchData () dsFetch is Data Source nNDX is int = 0
SqlConsulta is string = [ select * from banks ]
IF HExecuteSQLQuery (dsFetch, MyConnection2, hQueryWithoutCorrection + hNoBind, SqlConsulta) THEN FileToArray (ArrRec, dsFetch)
ELSE Error (StringBuild (SqlConsulta) + "" + HErrorInfo ()) END
Friends this is just my humble collaboration, I hope you find it useful.
Excuse my English, I use the google translator
Victor Argentina
--- El software de antivirus Avast ha analizado este correo electrónico en busca de virus. https://www.avast.com/antivirus |
| |
| |
| | | |
|
| | |
| |
Publicado el 28,noviembre 2016 - 00:45 |
A small contribution to Clarion programmers wanting to really step up into WD:
I used Clarion for almost 10 years, and 5 year ago I started with WD never going back to TPS or ODBC
If you really need your old data then export your TPS to Excel files, do a simple import process in WD and use the data in HFSQL tables or other SQl and start doing things the WD way, you must forget about TPS. |
| |
| |
| | | |
|
| | | | |
| | |
|