TOPIC:

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

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...

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

Hello Robert,
sounds good!
BR Kurt

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

Hi Andrej,
please look here for more informations:
www.xsharp.eu/articles/what-s-cooking
and here:
github.com/X-Sharp/XSharpPublic/issues/766
github.com/X-Sharp/XSharpPublic/issues/768
Wolfgang

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

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

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 Codegenerates 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