|
| Clarion Pgmr wanting to use WebDev20 |
| Débuté par Kevin Erskine, 02 sep. 2016 20:40 - 6 réponses |
| |
| | | |
|
| |
Posté le 02 septembre 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 |
| |
| |
| | | |
|
| | |
| |
Posté le 03 septembre 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 |
| |
| |
| | | |
|
| | |
| |
Posté le 07 septembre 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 |
| |
| |
| | | |
|
| | |
| |
Posté le 18 octobre 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 |
| |
| |
| | | |
|
| | |
| |
Posté le 26 octobre 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 |
| |
| |
| | | |
|
| | |
| |
Posté le 27 octobre 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 |
| |
| |
| | | |
|
| | |
| |
Posté le 28 novembre 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. |
| |
| |
| | | |
|
| | | | |
| | |
|