dependence GUI and database?

kitz · Post by **kitz** » Thu Nov 11, 2021 11:31 am

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

Chris · Post by **Chris** » Thu Nov 11, 2021 5:00 pm

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

robert · Post by **robert** » Thu Nov 11, 2021 9:26 pm

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

kitz · Post by **kitz** » Fri Nov 12, 2021 12:06 pm

Hello Robert,
sounds good!
BR Kurt

info@task.si · Post by **info@task.si** » Sat Nov 13, 2021 6:46 am

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

wriedmann · Post by **wriedmann** » Sat Nov 13, 2021 9:30 am

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

info@task.si · Post by **info@task.si** » Sat Nov 13, 2021 11:18 am

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

wriedmann · Post by **wriedmann** » Sat Nov 13, 2021 3:47 pm

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

Stavros Spanos · Post by **Stavros Spanos** » Tue Nov 30, 2021 12:21 pm

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

Main menu