Re: DataGrid question...

2020-03-24 Thread Pi Digital via use-livecode
Oh. Cool. I did not know you could do that! Can it do widgets (for svgs) and 
checkboxes too?

Sean Cole
Pi Digital


> On 25 Mar 2020, at 03:56, Mark Wieder via use-livecode 
>  wrote:
> 
> On 3/24/20 6:43 PM, Pi Digital via use-livecode wrote:
>> The only issue with using a field is you are limited to character data 
>> presentation only. You can’t put inline images, widgets, checkboxes, etc.
> 
> Now that's just patently not true. No problem with images:
> Set the imagesource of char x of field y of this card to tImageID
> 
> -- 
> Mark Wieder
> ahsoftw...@gmail.com
> 
> ___
> use-livecode mailing list
> use-livecode@lists.runrev.com
> Please visit this url to subscribe, unsubscribe and manage your subscription 
> preferences:
> http://lists.runrev.com/mailman/listinfo/use-livecode
___
use-livecode mailing list
use-livecode@lists.runrev.com
Please visit this url to subscribe, unsubscribe and manage your subscription 
preferences:
http://lists.runrev.com/mailman/listinfo/use-livecode


Re: DataGrid question...

2020-03-24 Thread Mark Wieder via use-livecode

On 3/24/20 6:43 PM, Pi Digital via use-livecode wrote:

The only issue with using a field is you are limited to character data 
presentation only. You can’t put inline images, widgets, checkboxes, etc.


Now that's just patently not true. No problem with images:
Set the imagesource of char x of field y of this card to tImageID

--
 Mark Wieder
 ahsoftw...@gmail.com

___
use-livecode mailing list
use-livecode@lists.runrev.com
Please visit this url to subscribe, unsubscribe and manage your subscription 
preferences:
http://lists.runrev.com/mailman/listinfo/use-livecode


Re: DataGrid question...

2020-03-24 Thread Pi Digital via use-livecode
The only issue with using a field is you are limited to character data 
presentation only. You can’t put inline images, widgets, checkboxes, etc. 

For HTML5 deployment I’ve ended up reinventing the wheel with a DataGridV3. 
I’ve gradually even made it quite generic in code so that it handles whatever 
data type and layout I throw at it. Still WIP. I should add in row and column 
freezes. At the moment it only vscrolls, so maybe when I add in hscroll 
functionality. 

I was Just saying to someone else, we need ‘someone’ fluent in LCB to create a 
DG widget. Allowing for customisation is the hard part. 

Sean Cole
Pi Digital Productions Ltd


eMail Ts & Cs

> Not here. When all I need is a list I just use a list field.  Now that LC's 
> field supports independent column alignment I haven't needed a DG for 
> anything but forms.
> 
> Parse out the first col with a "split by column", drop it into a control on 
> the left, and you're good to go.
> 
___
use-livecode mailing list
use-livecode@lists.runrev.com
Please visit this url to subscribe, unsubscribe and manage your subscription 
preferences:
http://lists.runrev.com/mailman/listinfo/use-livecode


Re: DataGrid question...

2020-03-24 Thread Richard Gaskin via use-livecode

Paul Dupuis wrote:

> Has anyone come up with a way to configure a DataGrid (LC9) so that
> the left most column remains visible when the other columns are
> scrolled horizontally?
>
> Or is the only way to to do this is to have a separate field to the
> left of the DataGrid that holds the left column?
>
> Anyone solved this already?

Not here. When all I need is a list I just use a list field.  Now that 
LC's field supports independent column alignment I haven't needed a DG 
for anything but forms.


Parse out the first col with a "split by column", drop it into a control 
on the left, and you're good to go.


--
 Richard Gaskin
 Fourth World Systems
 Software Design and Development for the Desktop, Mobile, and the Web
 
 ambassa...@fourthworld.comhttp://www.FourthWorld.com


___
use-livecode mailing list
use-livecode@lists.runrev.com
Please visit this url to subscribe, unsubscribe and manage your subscription 
preferences:
http://lists.runrev.com/mailman/listinfo/use-livecode


Re: Getting HTML5 going

2020-03-24 Thread William Prothero via use-livecode
Sean:
You are performing a noble task. After a hiatus, I’m back working on an 
educational app teaching plate tectonics. When I think of pitfalls of 
distributing an actual app, I fondly look at web distribution, like I used to 
be able to do with Director in shockwave. Anyway, I’d gladly pay well for the 
“How To” book that I hope will come out of your efforts.
Best,
Bill

William A. Prothero
https://earthlearningsolutions.org

> On Mar 23, 2020, at 5:57 PM, Pi Digital via use-livecode 
>  wrote:
> 
> Bill
> 
> I get what you mean by both quirky and the need for other skills. I’m 
> gradually going through the code to remove the quirkiness but I’m doing this 
> while also trying to develop the solution for our clients. In the process I 
> will also either eliminate the need for learning the ‘other skills’ or at the 
> very least minimise it to a set of relatively easy steps. What I’ve achieved 
> in about a year on and off is evidence that it is capable once the ‘caveats‘ 
> get ironed out. Watch this space. 
> 
> Sean Cole
> Pi Digital
> 
> 
>> On 23 Mar 2020, at 21:57, William Prothero via use-livecode 
>>  wrote:
>> 
>> Sean:
>> It looks really nice If HTML5 deployment didn’t look so quirky and require 
>> such a variety of other than livecode skills, I’d give it a try. I hope it 
>> will mature before I get too old to care.
>> Bill
>> 
>> William A. Prothero
>> https://earthlearningsolutions.org
>> 
>> 
>> 
>> ___
>> use-livecode mailing list
>> use-livecode@lists.runrev.com
>> Please visit this url to subscribe, unsubscribe and manage your subscription 
>> preferences:
>> http://lists.runrev.com/mailman/listinfo/use-livecode
> ___
> use-livecode mailing list
> use-livecode@lists.runrev.com
> Please visit this url to subscribe, unsubscribe and manage your subscription 
> preferences:
> http://lists.runrev.com/mailman/listinfo/use-livecode


___
use-livecode mailing list
use-livecode@lists.runrev.com
Please visit this url to subscribe, unsubscribe and manage your subscription 
preferences:
http://lists.runrev.com/mailman/listinfo/use-livecode


Re: DataGrid question...

2020-03-24 Thread dunbarx--- via use-livecode
I am with Bob on this.
Oftentimes, just out of stubbornness, I will try to create a "native" solution 
to some problem. Native here means that I try to force, bend, cajole, whatever, 
the built-in functionality of LC to make an effect the way I want it. The 
stubbornness comes from trying to be as lean a possible.
All that when, say, one more field placed in the right spot, and acting nicely 
will do the same thing. And usually with far less management and with far 
smaller scripts.
I am trying to get better.
Craig


-Original Message-
From: Bob Sneidar via use-livecode 
To: How to use LiveCode 
Cc: Bob Sneidar 
Sent: Tue, Mar 24, 2020 5:21 pm
Subject: Re: DataGrid question...

I did something along these lines some time ago. I needed check boxes to the 
left of a data grid that scrolled with the grid but remained visible.

Yes your idea of a second object that scrolls with the data grid is the way to 
go. There is a message that gets sent to a data grid called scrollBarDrag. Trap 
for that then scroll your other object accordingly.

Bob S


On Mar 24, 2020, at 2:12 PM, Paul Dupuis via use-livecode 
mailto:use-livecode@lists.runrev.com>> wrote:

Has anyone come up with a way to configure a DataGrid (LC9) so that the left 
most column remains visible when the other columns are scrolled horizontally?

Or is the only way to to do this is to have a separate field to the left of the 
DataGrid that holds the left column?

Anyone solved this already?

___
use-livecode mailing list
use-livecode@lists.runrev.com
Please visit this url to subscribe, unsubscribe and manage your subscription 
preferences:
http://lists.runrev.com/mailman/listinfo/use-livecode
___
use-livecode mailing list
use-livecode@lists.runrev.com
Please visit this url to subscribe, unsubscribe and manage your subscription 
preferences:
http://lists.runrev.com/mailman/listinfo/use-livecode


Re: Using ODBC to connect to a MSSQL database

2020-03-24 Thread Bob Sneidar via use-livecode
NVM I was able to connect using revOpenDatabase(). Now my trouble is getting 
sqlYoga to make the connection, but I am close. 

> On Mar 24, 2020, at 4:39 PM, Bob Sneidar  wrote:
> 
> Hi all. 
> 
> I read in a thread a long while ago that someone was currently connecting to 
> a MSSQL database via ODBC. Reading the dictionary, MSSQL is NOT one of the 
> types of databases revOpenDatabase() can communicate with. I am right on the 
> verge of creating an ODBC agent, but have hit this snag. 
> 
> Is anyone actually communicating with a MSSQL database via ODBC? 
> 
> Bob S
> 


___
use-livecode mailing list
use-livecode@lists.runrev.com
Please visit this url to subscribe, unsubscribe and manage your subscription 
preferences:
http://lists.runrev.com/mailman/listinfo/use-livecode


Using ODBC to connect to a MSSQL database

2020-03-24 Thread Bob Sneidar via use-livecode
Hi all. 

I read in a thread a long while ago that someone was currently connecting to a 
MSSQL database via ODBC. Reading the dictionary, MSSQL is NOT one of the types 
of databases revOpenDatabase() can communicate with. I am right on the verge of 
creating an ODBC agent, but have hit this snag. 

Is anyone actually communicating with a MSSQL database via ODBC? 

Bob S


___
use-livecode mailing list
use-livecode@lists.runrev.com
Please visit this url to subscribe, unsubscribe and manage your subscription 
preferences:
http://lists.runrev.com/mailman/listinfo/use-livecode


Re: DataGrid question...

2020-03-24 Thread Bob Sneidar via use-livecode
I did something along these lines some time ago. I needed check boxes to the 
left of a data grid that scrolled with the grid but remained visible.

Yes your idea of a second object that scrolls with the data grid is the way to 
go. There is a message that gets sent to a data grid called scrollBarDrag. Trap 
for that then scroll your other object accordingly.

Bob S


On Mar 24, 2020, at 2:12 PM, Paul Dupuis via use-livecode 
mailto:use-livecode@lists.runrev.com>> wrote:

Has anyone come up with a way to configure a DataGrid (LC9) so that the left 
most column remains visible when the other columns are scrolled horizontally?

Or is the only way to to do this is to have a separate field to the left of the 
DataGrid that holds the left column?

Anyone solved this already?

___
use-livecode mailing list
use-livecode@lists.runrev.com
Please visit this url to subscribe, unsubscribe and manage your subscription 
preferences:
http://lists.runrev.com/mailman/listinfo/use-livecode


DataGrid question...

2020-03-24 Thread Paul Dupuis via use-livecode
Has anyone come up with a way to configure a DataGrid (LC9) so that the 
left most column remains visible when the other columns are scrolled 
horizontally?


Or is the only way to to do this is to have a separate field to the left 
of the DataGrid that holds the left column?


Anyone solved this already?


___
use-livecode mailing list
use-livecode@lists.runrev.com
Please visit this url to subscribe, unsubscribe and manage your subscription 
preferences:
http://lists.runrev.com/mailman/listinfo/use-livecode


LiveCodeShare brief planned outage

2020-03-24 Thread Heather Laine via use-livecode
Dear List Folks,

LiveCodeShare is about to be offline for an hour or so while it makes it final 
move to our new server, having been repaired and updated to run on the 64bit 
OS. Once this is completed, this should be the final time it has to move, and 
it should resolve an observed problem with uploading large files it has 
suffered from for a month or two.

Thank you for your patience, and don't worry, LiveCodeShare will be back with 
us shortly.

Best Regards,

Heather

Heather Laine
Customer Services Manager
LiveCode Ltd
www.livecode.com




___
use-livecode mailing list
use-livecode@lists.runrev.com
Please visit this url to subscribe, unsubscribe and manage your subscription 
preferences:
http://lists.runrev.com/mailman/listinfo/use-livecode