Page 1 of 1
dependence GUI and database?
Posted: Thu Nov 11, 2021 11:31 am
by kitz
Hi!
Maybe a silly question, but I am not sure about this:
1. If I move from VO to X# a program with VO GUI and SQLClasses then I have to use still VO GUI and VOSQLclasses to avoid major changes.
Correct?
2. Is there a way to use .net dataset with VO GUI? Or do I have move to winforms or wpf to be able to use datasets?
BR Kurt
dependence GUI and database?
Posted: Thu Nov 11, 2021 5:00 pm
by Chris
Hi Kurt,
You can use anything you want in .Net, but the main problem is that if your code is using the standard classes and methods from the VO SDK, then of course you cannot "simply" move to .Net classes, which have different method names etc, without adjusting your code. An option would be to write a wrapper class though, which "translates" one system to the other...
dependence GUI and database?
Posted: Thu Nov 11, 2021 9:26 pm
by robert
Kurt,
kitz wrote:Hi!
Maybe a silly question, but I am not sure about this:
1. If I move from VO to X# a program with VO GUI and SQLClasses then I have to use still VO GUI and VOSQLclasses to avoid major changes.
Correct?
2. Is there a way to use .net dataset with VO GUI? Or do I have move to winforms or wpf to be able to use datasets?
BR Kurt
1) Yes
2) We are working on an RDD that will take an Ado.Net datatable/ dataset as data source. The RDD will also allow you to write back data to the SQL backend. You can use that with VO GUI Windows.
Robert
dependence GUI and database?
Posted: Fri Nov 12, 2021 12:06 pm
by kitz
Hello Robert,
sounds good!
BR Kurt
dependence GUI and database?
Posted: Sat Nov 13, 2021 6:46 am
by info@task.si
Hi Robert !
RDD in X# for ADO.net ? Do you have any time frame ?
Will this RDD working like VO2Ado ( defining AdoRecordSet ......, using skip() for record moving etc.) ?
TIA, Andrej
dependence GUI and database?
Posted: Sat Nov 13, 2021 9:30 am
by wriedmann
dependence GUI and database?
Posted: Sat Nov 13, 2021 11:18 am
by info@task.si
Thanks Wolfgang. I forgot it , unless I read those articles in August.
This means long term schedule (Xanthi) , I suppose in a one year ....
Best regards to all, Andrej
dependence GUI and database?
Posted: Sat Nov 13, 2021 3:47 pm
by wriedmann
Hi Andrej,
personally I think we will see the first usable code in a few months - of course faster for FoX members.
Personally yesterday I have ordered an ADS license for my second largest customer (my largest customer is using ADS for years now), because I think a migration of his large DBF based application to a SQL based database is a lot of work for me (I'm using many functionalities of positional databases like DBFs).
Wolfgang
dependence GUI and database?
Posted: Tue Nov 30, 2021 12:21 pm
by Stavros Spanos
Hello to everybody.
I use VOSQLclasses to my migrated VO2XS projects, but it seems to have a problem with this approach.
For example the following sample Code
Code: Select all
oConn := SqlConnection{ }
oConn:Connect( myDataSource, myUsername, myPassword )
generates a
Login Timeout expired error from the ODBC SQL Server Driver.
Of course the same code establish a connection to the Database using the DataSource, at Visual Objects.
I Checked the platform target (is x86).
This code is tested at the latest XSharp Cahors 2.9a as well as the previous XSharp Cahors 2.8c.
My IDE is Visual Studio 2017