Before getting into LiveCode

[intermi]

Hello people, I have developed an app in Microsoft Visual Studio 2010 using NET Framework 4...

The app can manage excel files, opens them like a database using OLEDB, it also uses an Access Database, then it writes back into the excel file and things like that...
Something like (just in case, an example):

Code: Select all

Imports System.Data.OleDb

Code: Select all

sConnectionString = _
"Provider=Microsoft.ACE.OLEDB.12.0;" & _
"Data Source=" & .FileName & ";" & _
"Mode=Share Deny None;" & _
"Extended Properties=""Excel 12.0;HDR=Yes;IMEX=0;ReadOnly=0;"""

sqlExcel = "UPDATE [Sheet1$] SET COLUMN_A = 'NO' WHERE FIXED IS NULL"
        Using oledbConn As New OleDbConnection(sConnectionString)
            oledbConn.Open()
            Dim oledbComand As New OleDbCommand(sqlExcel)
            oledbComand.Connection = oledbConn
            oledbComand.ExecuteNonQuery()
        End Using

Is this possible to do with LiveCode? Of course I need to do a lot more than that, using Listviews, Textbox, Buttons, NumericUpDown, Openfiledialog, MessageBox with Yes or No Buttons... And stuff like that

The final user will need to install anything before using my app made with LiveCode in MAC or WIN? I mean something like Net Framework after building something with VS2010... Or I can send them the app and they can use it just like that it doesnt matter if it's MAC or WIN?

That's all for now, thanks
Sorry for my english

[jamsk]

Curry Kenworthy was working on a LiveCode tool to work with excel spreadsheets. Try him at info (at) curryk (dot )com

[monte]

There's currently no oledb driver for livecode. There's an odbc driver though so you should be able to do what you want but having said that I haven't done it so I'm not going to promise anything... If you can work with an odbc driver then you should be able to deliver your app without the user installing much other than office. You will want to reconsider access and maybe use valentina or sqlite because there's no access on Mac.

[matthiasr]

Actualtech http://www.actualtech.com is offering a mac os x odbc driver for Excel and Access. So no need for an access version for mac.
The customer just has to install that odbc driver. She/he does not have to add/configure a system- or user-dsn. You could
use odbc connection strings in your app to connect. There is a general site with connection strings examples here http://www.connectionstrings.com

The support of Actualtech is very helpful. If you have problems with the correct connection strings just ask them. They will provide you example strings which work with their odbc drivers.

Cheers,

Matthias

[intermi]

Thanks for the answers.

1- I've sent an email to Curry today...

2- I think I had a problem in the past with ODBC and Excel and that's why I started with OLEDB but let me try again in VS...

3- The drivers from mysql can work with LiveCode too right? I mean for Win and Mac...
MySQL -> Downloads Section -> Conector/ODBC (I can't post links)

4- What about the open source version of LiveCode? When it's coming out? Where can I sign up for it?
The pledge thing still open? I can help with the pledge or if it's closed can I get that version anyway?

EDIT: If the drivers of MySQL can work with LiveCode and Mac that would be great since they are free, Actualtech not

[Simon]

The pledge thing still open?

Kickstarter isn't still open but you can invest:
http://www.runrev.com/products/what-now
I don't know if those pledge levels still include all the perks but you can ask support@runrev.com

I can help with the pledge or if it's closed can I get that version anyway?

The open source version will be available soon (sometime this month).

Simon

[matthiasr]

intermi,

3- The drivers from mysql can work with LiveCode too right? I mean for Win and Mac...
MySQL -> Downloads Section -> Conector/ODBC (I can't post links)

LiveCode has built-in support for mySQL. You do not need ODBC drivers to connect to MySQL with Livecode.

[wilstrand]

Hi Intermi!

I have just released rGrid which is a spread sheet inspired grid control.
rGrid is open source so you can use the code as you wish for non commercial projects.
I have been working together with Curry so rGrid has an import.xlsx function built in using Currys spreadLib.
Maybe rGrid could be part of a soultion for you. And for me, in this stage of development, all feedback would be very valuable!
There is a dictonary and a collection of demo scripts that I hope shows what can be done and how to do it.
You can download the latest version from http://www.tapirsoft.com

With my best regards

Mats Wilstrand