Page 1 of 1
Before getting into LiveCode
Posted: Tue Mar 19, 2013 6:46 pm
by 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
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
Re: Before getting into LiveCode
Posted: Tue Mar 19, 2013 8:07 pm
by jamsk
Curry Kenworthy was working on a LiveCode tool to work with excel spreadsheets. Try him at info (at) curryk (dot )com
Re: Before getting into LiveCode
Posted: Tue Mar 19, 2013 8:44 pm
by 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.
Re: Before getting into LiveCode
Posted: Wed Mar 20, 2013 12:37 am
by 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
Re: Before getting into LiveCode
Posted: Wed Mar 20, 2013 2:44 am
by 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
Re: Before getting into LiveCode
Posted: Wed Mar 20, 2013 5:34 am
by 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
Re: Before getting into LiveCode
Posted: Wed Mar 20, 2013 11:55 am
by 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.
Re: Before getting into LiveCode
Posted: Sun Mar 24, 2013 1:33 am
by 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