LiveCode Forums.

Hi all !

Thanks a lot. It's working now with your help!

Hi I am implementing a database application in livecode and I need to sore, in the database, som "special" files that are later to be retrieved to be either downloaded of, in some case, viewed. The files, themselves will be in standard formats, mostly images / PDF / MP3 / videos (short ones). how do...

hello. I am a real newbie to Livecode, coming from MS/Access. In my application I need to have a number of forms, that show different views of the backbone database. In ms/access it is quite easy: you just design a master form and program a button that enables you to jump to a specific form, opening...

So if I do understand well, the LiveCode statement: put revDataFromQuery("|","$",gConnectionID,tSQL) into tData is stating: run the sql statement on tSQL, putting all results in the tData variable and, by the, way, separate records with "I" and fields with "$" (or vice-versa). then clean the whole m...

thanks a lot for your extraordinary help. I I got the message "You have to work and investigate a little bit by yourself...". Of course you are absolutely right and that is what I am trying to do. On my defense pleas acknowledge that I am a 61 years' old rookie. I did start programming in 1970 at th...

sorry for this late reply. yesterdau was a full day of meetings out of office.... anyway, now the code is: on mouseUp     -- check the global connection ID to make sure we have a database connection   global gConnectionID     if gConnectionID is not a number then         answer error "Please connect...

oops... missed the second screenshot...

Collation should be the one you are mentioning: itf-8_general_ci.

Nevertheless... still getting an error on the syntax. I took 2 screenshots to show you. The syntax looks alright but it still does not work...

Kindesg regards

joao

I think we are getting really close. still... now I am getting a totally different error. The SQL syntax. My code, now, corrected after your suggestions: on mouseUp     -- check the global connection ID to make sure we have a database connection   global gConnectionID     if gConnectionID is not a n...

Hi - about the sort order you are absolutely right and I'll program that a bit later on (on the SQL), so I am totally forgetting about the issue. Please excuse me for insisting on it; the rationale was only that the data grid already contains the specific functionality and it looked a very convenien...

I have a very simple MySQL database with a single table. To present the records I use the data Grid component. On the MySQL workbench they are perfectly presented. In the Data Grid I have a weird presentation of some of the records, a situation that can be seen in the below and can be summarised as:...

Nope... The data grid itself sorts out if I click on the column. I must go through the data grid (anyway I started with your suggestion but it failed when re-sorting) Thanks for the help because the crucial problem is now solved by you. The reason to put the code at open stack was to make sure that ...

Gee! Thanks! It works perfectly! Please let me know it I am interpreting in the right manner what you suggested: 1. create an object (aka a button) that will contain the predefined behaviour of another object, in this case, a grid (my grid name is "DataT") 2. point in the grid object (DataT) the sta...

Ok. I'll try do do it immediatly.

I am starting to use LiveCode with MySQL. My database has a single table (it's a begin), containing textfields. My computer is a Mac and I am coming from Windows and MS/Access. To transport the database, I exported the final join as a single table on CSV format and imported it to MySQL. The table co...