Re: Inclusions issue when building standalones

2025-05-27 Thread jbv via use-livecode
: how does auto-detection of inclusions work ? Does it analyze the structure of the stacks, or does it scan the scripts for commands relative to libraries ? Best, Le 2025-05-24 09:13, jbv via use-livecode a écrit : Hi list, I am trying to update a stack created with LC 9.6.9 using LiveCode

Inclusions issue when building standalones

2025-05-24 Thread jbv via use-livecode
Hi list, I am trying to update a stack created with LC 9.6.9 using LiveCode Community 9.6.3 . This stack uses various libraries : dialogs, xml, zip, internet, table, datagrid... In the IDE everything works as expected. The problem begins with inclusions when I try to build standalones : - if I c

Issue with png images in group and "mouseup" detection

2025-04-19 Thread jbv via use-livecode
Hi list, I have a group containing several fields and 2 images, and these images are of png format with some transparent areas. I need to detect "mouseup" events on these elements with a "on mouseup" handler in the group script. When I click on the transparent area of each image, "mouseup" is det

Datagrid again

2025-04-04 Thread jbv via use-livecode
Hi list, One more question : is there a way to hide the top row of a datagrid when no column names need to be displayed ? I tried set the dgProp["columns"] of group "DataGrid 1" to empty but it displays "col1. col2. etc" by default. Thanks you in advance. jbv _

Re: Question about messages

2025-03-17 Thread jbv via use-livecode
Le 2025-03-17 10:01, Alex Tweedly via use-livecode a écrit : That sounds quite likely. If handler1 is running continuously, then other messages will not happen. I'd suggest putting various    wait for 0 seconds with messages inside the running loops of handler1, in order that pending messages

Re: Question about messages

2025-03-17 Thread jbv via use-livecode
Le 2025-03-17 09:27, Craig Newman via use-livecode a écrit : If you place a simple one-liner in “more stuff”, like “put random(99) into msg” does that work? Another words, is it something in your own “more stuff” that is the problem? Craig, It stops working. It seems like messages aren't sen

Question about messages

2025-03-17 Thread jbv via use-livecode
Hi list, Here's what I am trying to do : on opencard send "handler1" to me with messages end opencard on handler1 send "handler2" to me in 200 millisec -- more stuff end handler1 on handler2 if condition then send "handler2" to me in 200 millisec end if end handler2 The i

Another Datagrid question

2025-03-16 Thread jbv via use-livecode
Hi list, Is there anything specific to consider/include about datagrids when building a standalone, like inclusions ? When I look at the inclusions list in the "standalone settings" dialog, I see "Datagrid" but I thought that selecting "search for required inclusions when saving the standalone" w

Re: ChatGPT for LC scripting

2025-03-07 Thread jbv via use-livecode
Le 2025-03-06 19:04, Bob Sneidar via use-livecode a écrit : Your supposition is incorrect. We are not ALL using these gadgets. I for one never will. I for one use these tools only for things I am not familiar with, like python scripts for instance, with the risk of using pieces of code I don't

Re: Datagrid question

2025-03-04 Thread jbv via use-livecode
Le 2025-03-04 13:07, Klaus major-k via use-livecode a écrit : ... set the dgProp["sort by column"] of group "your DG here..." to empty ... Well, actually it doesn't work as expected : the columns aren't sorted when filled with data, but users can still click on column headers and sort the data.

Re: Datagrid question

2025-03-04 Thread jbv via use-livecode
Le 2025-03-04 13:07, Klaus major-k via use-livecode a écrit : ... set the dgProp["sort by column"] of group "your DG here..." to empty ... :-) I tried : set the dgProp["sort by column"] of group "your DG here..." to false Thank you. jbv ___ use-live

Re: Datagrid question

2025-03-04 Thread jbv via use-livecode
Le 2025-03-03 16:05, Bob Sneidar via use-livecode a écrit : What you are looking for is dgProp [“column widths”] which takes a comma delimited list. The API for datagrid properties is here: https://lessons.livecode.com/m/datagrid/l/7343-data-grid-properties Bob S Thank you, that works. New

Datagrid question

2025-03-03 Thread jbv via use-livecode
Hi list, I have a datagrid with dgStyle as "table". I have populated the columns and the dgText. Now I need to adjust the width of each column by script : put "100,120,150" into Lw set the dgColumnWidths of group "DataGrid 1" to Lw But nothing changes when running the above commands. What am I

Re: This AI stuff is taking off and I see next to nothing from LC

2025-02-19 Thread jbv via use-livecode
Hi, I am doing a lot of things as a hobbyist with LC and IA, either locally or on a vps with ollama, and also with the OpenAI API. That includes embedding, vision, syntaxic trees of sentences, etc. A few days ago, I have posted on this forum the code I use to interact with ollama via curl reques

Closing a tab in a browser widget

2025-02-11 Thread jbv via use-livecode
Hi list, Is it possible to close a tab of a website displayed inside a browser widget ? I am on Mac and I know this can be done using AppleScript, but is there an LC-only solution ? Thank you in advance. jbv ___ use-livecode mailing list use-livecode@

Re: Best way to base64encode a jpeg file ?

2025-02-06 Thread jbv via use-livecode
Hi Monte, It works ! Thank you very much ! jbv Le 2025-02-05 04:35, Monte Goulding via use-livecode a écrit : Hi jbv Here is my code for base64 encoding : put URL ("file:" & "myfile.jpg") into timagedata Use `binfile:` here instead of `file:` so the engine doesn’t treat the data as nativ

Re: Best way to base64encode a jpeg file ?

2025-02-05 Thread jbv via use-livecode
Richard & Mark, Thank you both for your suggestions. I actually made some progress, as there were 2 different issues : 1- the syntax of the multimodal json curl must be {"type" : "image_url", "image_url" : {"url": "data:image/jpeg;base64,{_BASE64_}"}} instead of {"type" : "image_url", "i

Re: Best way to base64encode a jpeg file ?

2025-02-04 Thread jbv via use-livecode
I am stuck. No matter what I try, I always get the same error : "url" field must be a base64 encoded image So I'm back to my very first question : how to base64encode a jpeg file in LC to be used in a regular multimodal json curl request... Le 2025-02-03 19:00, Richard Gaskin via use-livecode

Re: Best way to base64encode a jpeg file ?

2025-02-03 Thread jbv via use-livecode
Le 2025-02-03 11:07, Bob Sneidar via use-livecode a écrit : I heard that the base64encode puts a carriage return at a certain interval of characters (not sure how many). Bob S Yes, that's true, but even when I removed the returns it didn't work. __

Interacting locally with LC and AI models

2025-02-03 Thread jbv via use-livecode
Hi list, Someone asked me privately, so I thought that maybe others would be interested in a simple way to interact between LC and AI models locally on their machine. The method uses Ollama, which is available for Mac, Win and Linux : https://ollama.com 1- Download and install Ollama (plenty of

Re: Best way to base64encode a jpeg file ?

2025-02-03 Thread jbv via use-livecode
Le 2025-02-02 21:10, Richard Gaskin via use-livecode a écrit : jbv wrote: I need to base64encode a serie of jpeg files to include the code in a curl request. What is the best way to do that ? Depends. What's on the receiving end, and what options does it support? Actually, my question w

Best way to base64encode a jpeg file ?

2025-02-02 Thread jbv via use-livecode
Hi list, I need to base64encode a serie of jpeg files to include the code in a curl request. What is the best way to do that ? Do I need to import each file into an image control and base64encode the "text" of the image ? Thank you, jbv ___ use-liveco

LC and embedding

2025-01-23 Thread jbv via use-livecode
Hi again list, Has anyone tried to do text embedding from LC on a CPU-only device ? Thank you in advance. jbv ___ use-livecode mailing list use-livecode@lists.runrev.com Please visit this url to subscribe, unsubscribe and manage your subscription pre

Re: Azure or AWS ?

2025-01-23 Thread jbv via use-livecode
For the record, I tried to register at Azure to test their free offer, but the registration includes a tel.# validation that doesn't work... So I tried AWS for their free offer, registration went fine, but their free offer doesn't include GPU usage. So now I am trying Google Colab. Regarding Appw

Azure or AWS ?

2025-01-18 Thread jbv via use-livecode
Hi list, I have a small LC desktop app that sends requests via curl to ollama and some AI models. Everything runs fine on my Mac and now I would like to try to move it to the cloud, but I'm not sure which platform to choose. I have read a few blogs like this one : https://www.shiksha.com/online-c

Re: Problem with the shell command with a local server

2024-12-30 Thread jbv via use-livecode
xt" }' Le 2024-12-30 13:06, Mark Wieder a écrit : On 12/30/24 08:13, jbv via use-livecode wrote: Because of that I can't parse the json and I get an error with JsonImport. What am I doing wrong ? How can I fix it ? A couple of curl commandline options to try: 1. use the --si

Re: Problem with the shell command with a local server

2024-12-30 Thread jbv via use-livecode
s producing the erroneous third line, you may have to test the range of each line. Bob S On Dec 30, 2024, at 8:13 AM, jbv via use-livecode wrote: Hi list, Long story short : I am using LM Studio as a local server to send requests to an LLM model. I use the shell command in LC 9.6 with cur

Problem with the shell command on a local server

2024-12-30 Thread jbv via use-livecode
Hi list, Long story short : I am using LM Studio as a local server to send requests to an LLM model. I use the shell command in LC 9.6 with curl on MacOS Sequoia 15.1.1. The request looks like that : curl http://127.0.0.1:1234/v1/embeddings \ -H "Content-Type: application/json" \ -d '{

Problem with the shell command with a local server

2024-12-30 Thread jbv via use-livecode
Hi list, Long story short : I am using LM Studio as a local server to send requests to an LLM model. I use the shell command in LC 9.6 with curl on MacOS Sequoia 15.1.1. The request looks like that : curl http://127.0.0.1:1234/v1/embeddings \ -H "Content-Type: application/json" \ -d '{

HTMLtext and selectedChunk

2024-11-07 Thread jbv via use-livecode
Hi list, I have a field with a HTMLtext as follows : abc def xyz the content of the field displays like that : abc def xyz with "def" in italic. Now I select "def" ; the selectedChunk returns char 5 to 7 of field x Question : how can I know for certain that the selection is in italic ?

Re: How to determine if a text file is UTF8 ?

2024-10-29 Thread jbv via use-livecode
Thank you all for your answers, and especially Mark for posting some code that I will try immediately. ___ use-livecode mailing list use-livecode@lists.runrev.com Please visit this url to subscribe, unsubscribe and manage your subscription preferences:

How to determine if a text file is UTF8 ?

2024-10-29 Thread jbv via use-livecode
Hi list, How to determine if a text file is UTF8 or just plain ASCII ? In other words, how to know if one should use open file myfile.txt for UTF8 read or open file myfile.txt for read Thank you. jbv ___ use-livecode mailing list use-livecode@list

Scrollbar color

2024-10-19 Thread jbv via use-livecode
Hi list, Is there a possibility to set a custom color to a regular scrollbar ? I guess the answer is no, since I haven't found anything in the doc. I also guess that the only solution is to build a custom scrollbar. My problem is that the scrollbar looks ok on Mac, but on Windows it's 100% black.

Re: DOM innerHTML equivalent ?

2024-10-17 Thread jbv via use-livecode
Le 2024-10-17 09:47, Brian Milby via use-livecode a écrit : If you can use a group there may be something. If you make a shared group you can place it on another card and remove it from the current card. Then to restore you would place it again to the current card. Not sure how speed would b

DOM innerHTML equivalent ?

2024-10-16 Thread jbv via use-livecode
Hi list, Is there a way to catch all controls on a card (for instance) with all their properties and values, and store them in a variable, like innerHML for a DOM element, and have all these controls displayed later very fast and in one go ? I hope I made myself clear. I tried several things, li

SVG question

2024-09-30 Thread jbv via use-livecode
Hi list, I have checked many LC lessons and forum topics available online, but I still can't figure out the answer to my question : is there a way to import into an svg widget an svg file that contains elements different than paths, like rects, text, circle, etc. ? Thank you in advance. jbv ___

Resetting ids

2024-09-27 Thread jbv via use-livecode
Hi list, I have a script that creates various controls on the fly and then groups some of them for a rather sophisticated layout. As I had to make many tests, modify my script many times and save the stack each time, the ids of the controls now reach astronomical values (above 40). Is there a

Re: Cropping invisible images

2024-09-25 Thread jbv via use-livecode
Sorry for the multiple messages, but I found the solution to my problem : after resizing an image, it seems necessary to update its imagedata before cropping it : put width of img 1 into w put height of img 1 into h put w/h into tratio set width of img 1 to 150 set height of i

Re: Cropping invisible images

2024-09-25 Thread jbv via use-livecode
Thank you for your replies. One more question : what happens to the imagedata when an image is resized ? For instance : put width of img 1 into w put height of img 1 into h put w/h into tratio set width of img 1 to 150 set height of img 1 to 150/tratio And then when you crop the im

Re: Cropping invisible images

2024-09-24 Thread jbv via use-livecode
Actually, it looks like the "crop" function doesn't work on images with transparencies, or it outputs weird results... Le 2024-09-24 11:16, jbv via use-livecode a écrit : Hi list, When cropping an invisible image, what happens to the imagedata? I might be wrong, but it looks lik

Cropping invisible images

2024-09-24 Thread jbv via use-livecode
Hi list, When cropping an invisible image, what happens to the imagedata? I might be wrong, but it looks like the imagedata isn't modified accordingly... Best, jbv ___ use-livecode mailing list use-livecode@lists.runrev.com Please visit this url to su

Re: Strange...

2024-08-28 Thread jbv via use-livecode
Le 2024-08-28 13:52, Klaus major-k via use-livecode a écrit : should suffice for a simple addressbook app. :-) yep, but not for processing any kind of raw data... ___ use-livecode mailing list use-livecode@lists.runrev.com Please visit this url to

Strange...

2024-08-28 Thread jbv via use-livecode
("936,474" is within "777,50,1424,1") -> true ("936,474" is within "777,50,1424,10") -> false LC 9.6.9 on Mac OSX 10.15 ___ use-livecode mailing list use-livecode@lists.runrev.com Please visit this url to subscribe, unsubscribe and manage your

How to check if a group contains a specific control ?

2024-08-23 Thread jbv via use-livecode
Hi list, Is there a quick way to check if a group contains a specific control, something like : if there is a fld "xyz" in grp "abc" of this cd I tried many things but it always generates an error. So far, the only way I can think of is to maintain a custom prop for each group, featuring a strin

Re: Annual price

2024-08-09 Thread jbv via use-livecode
Le 2024-08-09 12:24, Bob Sneidar via use-livecode a écrit : Jeeze can we just please stop with the criticisms?? Bob S Apart from criticism, it could be a nice option, especially for hobbyists, to be able to pay a Classic license monthly, just like LC hosting, or other development software

Re: By popular demand - Extend access to LC Classic IDEs BEYOND 2027!

2024-08-02 Thread jbv via use-livecode
what we can do. You have an open ticket in support. You have not as yet told me that the new pricing is unaffordable for you. Best Regards, Heather Heather Laine Customer Services Manager LiveCode Ltd www.livecode.com On 2 Aug 2024, at 16:13, jbv via use-livecode wrote: Same here. I

Re: By popular demand - Extend access to LC Classic IDEs BEYOND 2027!

2024-08-02 Thread jbv via use-livecode
Le 2024-08-02 11:17, Bob Sneidar via use-livecode a écrit : You cannot mean that you want him to go bankrupt Of course not, but neither me or my clients want to go bankrupt. My clients have already paid for the deployment of their apps and they are also paying when some cosmetic changes need to

Re: By popular demand - Extend access to LC Classic IDEs BEYOND 2027!

2024-08-02 Thread jbv via use-livecode
Same here. I have been into hypertalk since the 1st version of HC. I have 2 desktop apps for 2 different clients that I maintain, and in each one the part developed with LC Classic is just a front end for sending requests to the server and displaying the incoming data. In both cases 80% of the

Re: Livecode Future

2024-07-31 Thread jbv via use-livecode
I checked the cost of the licensing options and a very disappointing thing is that if I choose "Native" for instance, as far as I understand, I can deploy for all platforms. But in my situation I only need MacOS and Windows. So I have the feeling that I will ask my clients to pay for stuff they do

Re: Livecode Future

2024-07-31 Thread jbv via use-livecode
I checked the cost of the licensing options and a very disappointing thing is that if I choose "Native" for instance, as da ___ use-livecode mailing list use-livecode@lists.runrev.com Please visit this url to subscribe, unsubscribe and manage your subsc

Re: Lockscreen and progress bar

2024-07-26 Thread jbv via use-livecode
Basically my script takes a list of images, checks the imagedata of every image for possible white areas at the top, bottom, left or right, crops the image if necessary, resizes the image and groups it with fields created on the fly with text data from an xml file. When I simply lock the screen a

Re: Lockscreen and progress bar

2024-07-26 Thread jbv via use-livecode
Actually I forgot that I had a "lock screen" at the very beginning of my script. And successive "lock screen" cumulate. Therefore the following sequence doesn't update the screen layout : lock screen .. lock screen .. unlock screen lock screen Funny how I can get stalled with very

Re: Lockscreen and progress bar

2024-07-26 Thread jbv via use-livecode
and hide the thingy when the loop is done? From: use-livecode on behalf of jbv via use-livecode Date: Friday, 26 July 2024 at 4:44 PM To: How to use LiveCode Cc: j...@souslelogo.com Subject: Lockscreen and progress bar Hi list, I have a main loop that does a lot of things, like resizin

Lockscreen and progress bar

2024-07-25 Thread jbv via use-livecode
Hi list, I have a main loop that does a lot of things, like resizing images, precessing imagedata, creating fields and groups, etc. On top of the loop I have added "lock screen" to speed things up, and also because I don't want users to see what is going on, only the final layout when the loop is

Re: crop image

2024-07-25 Thread jbv via use-livecode
Hi Mark, Yes, it helped a lot. Many thanks. jbv Le 2024-07-25 05:41, Mark Waddingham via use-livecode a écrit : On 2024-07-23 14:23, jbv via use-livecode wrote: Hi list, I have the following script : create image put number of imgs into ni put id of img ni into tid set filename of img

Re: Livecode Future

2024-07-24 Thread jbv via use-livecode
Hi list, I am a bit lost as I am trying to figure out how I fit in the new license plans. I have built a couple of desktop apps years ago for 2 different clients who use them in their business, with less than 20 users in total. These apps make intensive use of LC server and I also have 2 LC-hosti

Re: crop image

2024-07-23 Thread jbv via use-livecode
Please check mu second post on the same topic. For the first one, I pressed "send" by mistake before finishing to write it. Thanks. ___ use-livecode mailing list use-livecode@lists.runrev.com Please visit this url to subscribe, unsubscribe and manage y

crop image

2024-07-23 Thread jbv via use-livecode
Hi list, I have the following script : create image put number of imgs into ni put id of img ni into tid set filename of img id tid to myFile put imageData of img id tid into pimage -- many lines for imagedata analysis crop image id tid to rect trect I get this error : crop: object is no

crop image

2024-07-23 Thread jbv via use-livecode
Hi list, I have the following script : create image put number of imgs into ni add 1 to Nflds put id of img ni into tid put imageData of img ___ use-livecode mailing list use-livecode@lists.runrev.com Please visit this url to subscribe, unsubscrib

Problem with hierarchical menu

2024-07-08 Thread jbv via use-livecode
Hi list, I have a pulldown menu button with a hierarchical menu on 4 levels. Level 1 features 35 options, and each option can have submenus on 1, 2 or 3 sub-levels. On Mac everything works fine : users can navigate through all options and sub-options with the mouse down like in any menu. But on W

Re: Printing to pdf

2024-06-21 Thread jbv via use-livecode
Nevermind, I found the solution : I modified the printScale property. Best ___ 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/mai

Printing to pdf

2024-06-21 Thread jbv via use-livecode
Hi list, I have a stack with several cards 750 x 1000px. I am trying to print these cards as pdf, but according to this lesson https://lessons.livecode.com/m/4071/l/29177-how-to-create-pdfs-using-livecode the stack size should be 575 x 800 to fit a A4 document ratio. Is it possible to "force" the

Re: Copying groups

2024-06-21 Thread jbv via use-livecode
, Panos -- On Fri, 21 Jun 2024 at 14:16, jbv via use-livecode < use-livecode@lists.runrev.com> wrote: Hi list, I have a single card stack containing several groups, each group containing several fields and images. I need to copy these groups to a substack. I use : copy grp tname of cd 1 o

Copying groups

2024-06-21 Thread jbv via use-livecode
Hi list, I have a single card stack containing several groups, each group containing several fields and images. I need to copy these groups to a substack. I use : copy grp tname of cd 1 of this stack to cd 1 of stack myTarget The weird thing is that all groups are copied, but the text content of

Different borders for a group

2024-06-13 Thread jbv via use-livecode
Hi list, Is there a way to have different border widths and colors for the top and the bottom of a group ? Or should I include graphic lines inside the group ? Thank you in advance. jbv ___ use-livecode mailing list use-livecode@lists.runrev.com Pleas

Hierarchical submenus in option menu buttons

2024-05-31 Thread jbv via use-livecode
Hi list, I am trying to create a hierarchical submenu in an option menu button with LC 9.6. I have found this solution that seems to work only with pulldown buttons : https://use-livecode.runrev.narkive.com/cBfAjix2/cascading-menu I also found this LC lesson that suggests to use polylists : ht

Groups id #

2024-05-25 Thread jbv via use-livecode
Hi list, I have a script that creates groups on the fly with the command "group". These groups contain various flds and imgs. Can I always assume that the group with the highest id # is the last one created ? Thanks, jbv ___ use-livecode mailing list u

Saving data in standalone

2024-05-16 Thread jbv via use-livecode
Hi list, I am working on an app for a client who will use it as a standalone. Basically users will be able to import data such as images, text and even html from various sources. All these data will self organize in different groups that the user will be able to select, move around and organise in

Re: Code translation anyone ?

2024-03-15 Thread jbv via use-livecode
Le 2024-03-15 12:28, Christer Pyyhtiä via use-livecode a écrit : Have you tried OpenAi or Gemini? Once just for fun tried asking OpenAI to create a structure for a problem using LiveCode, and the result was acceptable giving a coarse structure for the solving the problem. Yes, I have tried Ch

Re: Code translation anyone ?

2024-03-15 Thread jbv via use-livecode
One detail I forgot in my question : code translation using ChatGPT or any other AI. Thanks, jbv Le 2024-03-15 10:36, jbv via use-livecode a écrit : Hi list, Has anyone tried to translate code from 1 version to another, or from 1 language to another ? Like from php 5 to php 8, or from php to

Code translation anyone ?

2024-03-15 Thread jbv via use-livecode
Hi list, Has anyone tried to translate code from 1 version to another, or from 1 language to another ? Like from php 5 to php 8, or from php to LC ? My question concerns mainly server scripts. Thanks, jbv ___ use-livecode mailing list use-livecode@lis

Best way to lock a whole mySQL table ?

2024-01-07 Thread jbv via use-livecode
Hi list, I have a mySQL table with over a million rows and I would like to lock the data so that no inserts nor updates are possible, only reads via select commands. I have read the doc as well as numerous blogs, and as far as I understand, the following command LOCK TABLES myTable WRITE; locks th

Re: Top things you are waiting for ....

2023-11-12 Thread jbv via use-livecode
Hi, My top priority : "rev" libraries (revXML, revZIP, perhaps others) to be fully Unicode compatible. I do a lot of stuff with LC server, and for the moment, my only choice is to use php instead for some tasks. Le 2023-11-11 17:43, Tom Glod via use-livecode a écrit : Hey everyone Just a mar

Re: revXML and UTF-8

2023-09-17 Thread jbv via use-livecode
ds for not being Unicode compatible (at least none I know of). In my opinion, bugs with no work-around should be among LC's higher priorities for bug fixes. On 9/17/2023 8:32 AM, jbv via use-livecode wrote: Hi list, I have a text file encoded in UTF-8. Each line of the file is an xml n

revXML and UTF-8

2023-09-17 Thread jbv via use-livecode
Hi list, I have a text file encoded in UTF-8. Each line of the file is an xml node with several sub-nodes and attributes. I have a loop in LC that reads lines one by one and creates an xml tree with revXMLCreateTree. The goal is to parse each line and extract some data. The problem is that, whe

Re: LC server, on-rev and time zones

2023-09-06 Thread jbv via use-livecode
o true €put the time ?> Am 06.09.2023 um 15:22 schrieb jbv via use-livecode : Hi list, How do you handle different time zones in server scripts ? For example, I and my clients are in Europe, so dates and times need to be consistent with the local time zone. But on-rev servers are located in t

LC server, on-rev and time zones

2023-09-06 Thread jbv via use-livecode
Hi list, How do you handle different time zones in server scripts ? For example, I and my clients are in Europe, so dates and times need to be consistent with the local time zone. But on-rev servers are located in the US East coast, so there is presently a 6 hours difference. Furthermore, switchi

Re: [semi OT] mySQL question

2023-05-12 Thread jbv via use-livecode
@sonsothunder.com Website: https://www.sonsothunder.com On May 11, 2023, at 9:55 AM, jbv via use-livecode wrote: Hi list, This is a question for mySQL experts, which I am not. I have a table of individuals. I have another table of companies. Many individuals have worked in more than 1 company

[semi OT] mySQL question

2023-05-11 Thread jbv via use-livecode
Hi list, This is a question for mySQL experts, which I am not. I have a table of individuals. I have another table of companies. Many individuals have worked in more than 1 company with different jobs descriptions. I need to build my DB so that, with single requests, I can get a list of either

mySQL and primary key

2023-04-29 Thread jbv via use-livecode
Hi list, I have a mySQL table with 1350 entries that weights almost 20 Gb. I need to create a primary key on the "id" column. I have tried in phpMyAdmin as well as in a script with "ALTER TABLE myTable ADD PRIMARY KEY(id)", but each time I get a "504 Gateway Timeout" error, and no index is cr

Re: revXML and UTF8

2023-04-10 Thread jbv via use-livecode
dictionary. Text from or to a file needs to be decoded or encoded since LC 7. On 4/10/2023 4:07 AM, jbv via use-livecode wrote: Hi list, I have an xml file with lots of non-western characters (greek, arabic, japanese...). I need to convert these data into sql requests to insert into a DB. For each

revXML and UTF8

2023-04-10 Thread jbv via use-livecode
Hi list, I have an xml file with lots of non-western characters (greek, arabic, japanese...). I need to convert these data into sql requests to insert into a DB. For each node, I need to pick only some attributes, so I wrote a script that : - opens the file as utf8 - processes each node - writes

Re: How to split a large xml file

2023-04-02 Thread jbv via use-livecode
a champ in opening them and scrolling through them easily. Kee Nethery On Apr 1, 2023, at 5:17 AM, jbv via use-livecode wrote: Hi list, I have a 75Go xml file that I need to process, and therefore need to split it into smaller files. I tried to do that with LC, reading successive chunks of 5

How to split a large xml file

2023-04-01 Thread jbv via use-livecode
Hi list, I have a 75Go xml file that I need to process, and therefore need to split it into smaller files. I tried to do that with LC, reading successive chunks of 5 lines with an endless loop and save them in successive files, but it crashes LC (9.6.9 on OSX 10.15) every time before finishin

Livecode / MariaDB UTF8 charset

2023-03-15 Thread jbv via use-livecode
Hi list, I am struggling to configure the charset of a mySQL/MariaDB table on my Livecode Hosting account. I have a huge number of utf8 files containing names in various alphabets (european, cyrillic, japanese, chinese, arabic...) and I need to insert each name as a separate entry in the table. W

Re: I need to fetch some text from a WP website, but need to login first

2023-03-01 Thread jbv via use-livecode
Hello, The WP REST API can be really slow and therefore painful to use. I recently had to make changes in a couple of WP websites and found it much easier to write data straight into the DB. jbv Le 2023-02-28 18:57, pere xavier Rossello via use-livecode a écrit : Hi. The easy way to do this i

Re: Livecode Hosting

2023-02-28 Thread jbv via use-livecode
fast. So in case you have to deal with the european GDPR you have to use a provider that hosts in the EU. Am 28.02.2023 um 12:44 schrieb jbv via use-livecode : Hello, I just had a look at their offer, and it really looks interesting, especially the possibility to choose the location of your s

Re: Livecode Hosting

2023-02-28 Thread jbv via use-livecode
Hello, I just had a look at their offer, and it really looks interesting, especially the possibility to choose the location of your server (Europe, usa...). But what about their technical support ? On-rev tech support quality is hard to beat... Thanks. jbv Le 2023-02-28 05:33, Georges Malamoud

Re: Training the AI to write better LiveCode

2023-01-22 Thread jbv via use-livecode
https://www.vice.com/en/article/bvm3k5/github-users-file-a-class-action-lawsuit-against-microsoft-for-training-an-ai-tool-with-their-code ___ use-livecode mailing list use-livecode@lists.runrev.com Please visit this url to subscribe, unsubscribe and man

Re: Training the AI to write better LiveCode

2023-01-21 Thread jbv via use-livecode
https://www.vice.com/en/article/wxn3kw/openai-used-kenyan-workers-making-dollar2-an-hour-to-filter-traumatic-content-from-chatgpt ___ use-livecode mailing list use-livecode@lists.runrev.com Please visit this url to subscribe, unsubscribe and manage your

Re: .mov files in a standalone on Windows

2023-01-08 Thread jbv via use-livecode
r on Windows LC 9.6.8 uses). See https://github.com/Nevcairiel/LAVFilters/ On 1/8/2023 1:53 PM, jbv via use-livecode wrote: Hi list, I am using LC 9.6.8 on Mac. I have a couple of .mov files that I want to include in a stack that will end up as a standalone running on windows. I haven't done th

.mov files in a standalone on Windows

2023-01-08 Thread jbv via use-livecode
Hi list, I am using LC 9.6.8 on Mac. I have a couple of .mov files that I want to include in a stack that will end up as a standalone running on windows. I haven't done that in years. What is the best way to proceed, to be sure that each video and its sound track will play fine on windows ? BTW a

Just curious...

2022-12-28 Thread jbv via use-livecode
Hi list, I'm having a look at the Activity Monitor on my iMac 27" running MacOS 10.15.7. I have LC 9.6.8 IDE open with a rather simple stack waiting for a button to be clicked. When I check the "Energy" tag of the Activity Monitor, and more specifically the "Energy Impact", it shows a variation b

Re: Lock screen and animated gif

2022-12-20 Thread jbv via use-livecode
Thanks for the offer, but actually things are a bit more complicated and include several steps : 1- the user selects different options on a modal stack 2- the user clicks a "search" button 3- various calculations are made client side according to the selections and some data already in the main st

Re: Lock screen and animated gif

2022-12-20 Thread jbv via use-livecode
Le 2022-12-20 08:19, Brian Milby via use-livecode a écrit : Could you make changes to htmlText in a variable and then assign all at once back to the field? I thought of that, but it makes other parts of the script more complicated. Finally I will chose a different strategy : instead of an ani

Re: Lock screen and animated gif

2022-12-20 Thread jbv via use-livecode
Do you mean "lock screen without messages" ? Doesn't work... Le 2022-12-20 07:27, Richmond Mathewson via use-livecode a écrit : Try 'without messages'. On Tue, 20 Dec 2022, 13:26 jbv via use-livecode, < use-livecode@lists.runrev.com> wrote: Hi list, I have a sc

Lock screen and animated gif

2022-12-20 Thread jbv via use-livecode
Hi list, I have a script that modifies line by line the color and textstyle of some words in a field that can be up to 500 lines long. I am using "lock screen" to speed up things. But at the same time I have a spinning animated gif to tell end users to wait until the modification is done. The prob

Re: itemoffset & wholematches

2022-11-15 Thread jbv via use-livecode
Again guys, thank you for your suggestions. But finally I gave up using itemoffset and worked with arrays instead, which is much much faster : my script processes the 6 variables in less than 15 secs. ___ use-livecode mailing list use-livecode@list

Re: itemoffset & wholematches

2022-11-15 Thread jbv via use-livecode
Hi guys, Thank you all for your answers. Actually I thought that some "hierarchy"remained (items inside lines) when using itemoffset, but obviously I was wrong. I have about 6 variables to check, so I need my script to be as fast as possible. I use "replace CR with TAB & CR & TAB in ...", but

itemoffset & wholematches

2022-11-14 Thread jbv via use-livecode
Hi list, I have a variable with a content of 3 lines as follows : 1 sombre brunprofond 2 flouincertain 3 inexploré mystérieux inconnu The separator between words is tab. I want to check if a certain word is among the items as a whole. The following script r

  1   2   3   >