I have the latest versions of XIDE and xSharp installed (No vulcan). Created a new project "Standard VO MDI" -> I assume I need Vulcan installed? I get the following Compiler messsage:
Compiling native resources for MdiApp1...
Failed running RC.EXE
Next I started a project XSharp. Tried to get a dbserver installed with an existing db-file. Import does not work and also to rename dbserver1 is not possible. Looks like I am doing something wrong. Or do I need Vulcan installed?
Next try: Started VS Community 2015 with a new xSharp project. Compiling & running works. Where and how do I link db-files? Do i need to connect through odbc adapter?
Maybe I am still attached to the "Look & Feel" of VO and the easy use of dbserver. Is there something like a VO "South Sea" example?
- the VO runtime including the macrocompiler and the RDDs are "in the work", actually in development
- even if they are finished, the X# group cannot give you a X# version of the VO libraries (they are copyrighted by CA), and only if you have the sources of theses class libraries you will be able to recompile them with X#
Personally, I would recommend to start freshly with X# without DBserver, maybe using SQLite or another SQL server like Firebird. Or do you have to maintain VO applications?
For new applications, consider DBF to be a dead end (this is a confession from a DBF fan like me).
Yes, at this moment in order to use dbfs, you need the vulcan runtime dlls. No need to install vulcan, it's only the vulcan runtime dlls that are needed. This restriction will be removed later in the year, when we release the x# runtime.
Regarding the SDK libraries (which you need in order to use high-level classes like DBServer), we are writing a tool that reads the SDK code from your existing VO (any version) installation in the folder \CAVOxx\VOLIB and converts it into a x# project. This tool is 90% complete right now, we should be able to release it in the coming weeks.
Regarding the XIDE issues you found (thanks for reporting them!) :
- The error about rc.exe is a bug, fortunately very easy to fix, will do that for the next ver.
- About Import/Export in the DBServer editor, I had forgotten about them, will enable them in the next ver
- To rename the DBServer, you need to go to the Properties window and change the name of the dbserver there (in the "Name" property which appears first in the list). After saving your changes, everything should be updated with the new name
If this is a home / personal project then I would recommend you use Microsoft SQL Server Express - its a FREE full version of their standard server app.
The reason for doing this is that there are many more working samples to copy and use.
This includes my own eNotes and the "ClickStart" eNotes I write.
I would reserve SQLite for small platforms - I used it for WinRT tablets and Windows phone. But with a desktop / laptop (and even powerful Surface tablets) the Express version of SQL Server is the way to go.
I believe my Cologne samples just work out of the box with the Express install. Or they di a few weeks back ;-0)
started C# with SQL lite then trying to use Access db as the Backend. I think I am doing something really wrong. I do not even get a simple Master-Detail to work (w/Delete, Append). I think I need to get first the SQL fundamentals digestet. As I have a little bit of time this might be the way to go.
Where do i find your example? Could locate it in the "Download" area.
personally I like DBFs very much, but unfortunately their time is over, thanks to some caching features in the Windows networking.
ADS works very well, and if it was cheaper, I would use it everywhere.
In my new project I use a SQLite database as local storage, and I have implemented a feature to keep the structure uptodate (if a field is missing in the table, it is added automatically at the program start).
In asking why, why, why ... you are probably correct in your answer. Meaning if you are not bringing any 'history', or 'legacy' stuff with you from the past, and you are to use SQL, then C# is a perfectly good language and solution for you, I like it a lot myself.
BUT - you will not have the support of a knowledgeable community, I know, I had a lonely 3 years or so Googling my way to the mastery of the curly braces.
I can help you get going with SQL and X#, but you have to be committed, as I don't like wasting my time If you are coming new to both .NET and X#, as well as new to SQL, then I will help, if you can assure me you won't change your mind after a short while. There will be a big learning curve but it is worth it - I did exactly the same years ago with Vulcan, and I am more than glad that I did.
The BEST advice I can give is to use SQL Server Express, as it is FREE and most suitable, and will even support 2 or 3 users I seem to recall. The tools to support 'Express' are all built into Visual Studio. And I have notes and examples to support such a start and approach. You can always go to 'Lite' when you know more about lots of things. But start with Express.
You will also need a suitable data base file, which once again I can provide - the flavour will be SQL Server, and it works with full and express versions.
If you are interested in this way of approaching your learning, then say so, and I will tell you more about the next step and send you a suitable and compatible DB file.
Here is the 'Stock' system open in VS 2017 :-
Now you will see that we have a database file open and are querying it using the VS environment and tools. Yet we have done nothing as yet with an X# coded app. We need to remember at all times that SQL servers are disconnected data sources. So you can work on the data, tables and more, without a coded program / app. Just use the tools in VS.
If you wish to go further then I will sort out a data file, and you can then try to start using 'L2S' which means "Linq to SQL". This is the easiest way into SQL use, when you have a provided data base.
wow, what should I say. I am more or less finished with my little VO Project (maybe another 2 weeks or so). Initially I tried to do it with C# then VB using SQL express and Access. I finally gave up.
I think I can go back to my initial thought to use .net and use my "VO project" and write it in xSharp with SQLExpress as Backend. In other words: Yes, I am committed to learn. But you need to understand: I am not a Hardcore programmer evenso I studied Computer Science back in the 80ies. Oh boy, I am thaaat old.
Alright, I will give you a little bit more time to reconsider your offer. If you still believe there is hope let's start in May.
I am up for it if you are [and others can follow along as well, there are many who should try out SQL - Frank !?]
You will do it if you keep going through each of the stages required. You don't need to be a rocket scientist to do SQL with X# - BUT - it is not a quick and trivial 'Hello world' situation. We can make things easier for both you and me by choosing the right software apps and tools. Many things have now gotten a lot easier.
When I went through this personal 'upgrade' stage some years back, I had Geoff Schaller guide me and he was down under in Australia. Somehow I made it. From starting to try and install SQL Server, to getting some simple data output from a Vulcan program took me a solid four weeks effort That is true!
Now then, don't panic, we can do a lot better these days, we have better software tools, better SQL related technology, and the Microsoft downloads / installs are vastly better / improved. Oh! and I know up front just what few code lines are required in an app based on X# syntax and code. Back then I had to adapt a VB text book example (which actually contained printed errors).
So we HAVE to do better than back then !!!
Oh! and I forgot to mention that I also have my "ClickStartTSQL" eNotes which is an in-depth study of SQL Server in many ways, so we will not be short of help and support.
Forget Access and any other database which was not made in MS SQL Server (MSSS). And for now, if you have some time spare, check that you have a successful download and install of the latest SQL Server 'Express' version.
Here is the web link I found and studied for what was on offer :-
I have to say that I have changed my mind and think that you ought to choose the Developer version - it is also FREE, and thinking back it was how Geoff got me started. It will probably be more like 100% compatible in every way with stuff I can help you with. Please give it a go :-
It is NOT a problem if you have already downloaded and installed 'Express' - all these versions of SQL Server happily live side-by-side. And more so now than ever. So just do it.
Have you also downloaded and fully installed the 'Community' version of Visual Studio 2017 ? If not then that is another useful task to complete prior to my support.
This is a journey you (and anyone following along) will enjoy - it gives great satisfaction, and I was a DBF man "as keen as the rest of them"
Yes, I know, but its the only way to win when it comes to SQL.
School is "a controlled learning environment" - oh! and I am a teacher
If I had not followed Geoff's advice for a few weeks, I would not have made it. He was/is a good teacher and delivered interesting conference sessions too.
Once we get an installed (Community) version of VS 'seeing' the instance of the SQL Server in the relevant panes (windows), then we can move on to which database to use. It would be better to start with an already made data file, and use the existing tables within it. I will work on one to send you.
Making a new SQL database (many tables) is just another big step up, that we don't need right at the start - but there are now tools to help us do this from .NET and our X# code, when we are ready.
Just maybe an idea. I know you a MS-SQL[Server] fan, however not everybody is (I am PostgreSQL) addicted..
I think maybe a good idea when you address SQL, would be to explain the similarity of the ADO.NET classes.
They all implement DbConnection/DbCommand/DbDataAdapter and it might be good to also cover ConfigurationManager.AppSettings and how connectionstrings and DbProviderFactories work. Might be good as an advance section to also cover Application.exe.config to provide a "database" agnostic interface to your preferred RDBMS. Quite easy then to change the backend database without the need to have RDBMS specific Application versions.
Quite easy then to have a MS-Access, SQLLite, SQLServer, Sybase, Oracle, PostgreSQL, MySQL database and with a config change let the programme connect to it.
George, South Africa
Yes, when I get to adding the section on SQL to the new 'full' X# eNotes then I will certainly call on your knowledge and expertise to flesh out this section.
For Michael starting however, MSSS seems a good place to start - if not exactly easy, it is likely to be easier than many other approaches.
By the way I don't usually do 'fan' stuff - I like to evaluate the good and the bad (oh! and the ugly) in most things. I don't start out by hating (or loving) Microsoft, as some friends do!!
I got into MSSS simply because I had a good paying customer who used version 2005 with SAGE. This is also how I got to using Visual Studio and Reporting Services so much as well. Paid OK ;-0)
One thing I COULD be a fan of however, is Entity Framework 6 and beyond, as it gets the standard developer away from the necessities of ADO.NET - and that I am glad to be relieved of, ADO.NET that is. Yes, I know it is used under the cover - BUT - that is not my concern. "LINQ to SQL" and "LINQ to Entity" make life so, So, SO, much better for ordinary code designer / creators.
How about YOU writing the SQL section for the X# notes ? You could do all the parts I don't cover when I do the Microsoft flavour, and EF6.
Is there any other section you are keen (desperate?) to contribute ??