Search found 18 matches

by jlspereira
Sat Jan 30, 2016 5:59 pm
Forum: Getting Started with LiveCode - Complete Beginners
Topic: navigate between forms/stacks
Replies: 4
Views: 3429

Re: navigate between forms/stacks

Hi all !

Thanks a lot. It's working now with your help! :D
by jlspereira
Fri Jan 29, 2016 11:29 pm
Forum: Databases
Topic: store a file in a BLOB / LONGBLOB(MySQL)
Replies: 1
Views: 2736

store a file in a BLOB / LONGBLOB(MySQL)

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...
by jlspereira
Thu Jan 14, 2016 12:46 pm
Forum: Getting Started with LiveCode - Complete Beginners
Topic: navigate between forms/stacks
Replies: 4
Views: 3429

navigate between forms/stacks

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...
by jlspereira
Sat Mar 22, 2014 4:52 pm
Forum: Talking LiveCode
Topic: Data Grid desaligns presentation of MySQL records
Replies: 13
Views: 7421

Re: Data Grid desaligns presentation of MySQL records

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...
by jlspereira
Sat Mar 22, 2014 10:59 am
Forum: Talking LiveCode
Topic: Data Grid desaligns presentation of MySQL records
Replies: 13
Views: 7421

Re: Data Grid desaligns presentation of MySQL records

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...
by jlspereira
Fri Mar 21, 2014 9:18 am
Forum: Talking LiveCode
Topic: Data Grid desaligns presentation of MySQL records
Replies: 13
Views: 7421

Re: Data Grid desaligns presentation of MySQL records

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...
by jlspereira
Thu Mar 20, 2014 10:12 am
Forum: Talking LiveCode
Topic: Data Grid desaligns presentation of MySQL records
Replies: 13
Views: 7421

Re: Data Grid desaligns presentation of MySQL records

oops... missed the second screenshot...
by jlspereira
Thu Mar 20, 2014 10:10 am
Forum: Talking LiveCode
Topic: Data Grid desaligns presentation of MySQL records
Replies: 13
Views: 7421

Re: Data Grid desaligns presentation of MySQL records

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
by jlspereira
Wed Mar 19, 2014 11:30 pm
Forum: Talking LiveCode
Topic: Data Grid desaligns presentation of MySQL records
Replies: 13
Views: 7421

Re: Data Grid desaligns presentation of MySQL records

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...
by jlspereira
Wed Mar 19, 2014 9:50 pm
Forum: Talking LiveCode
Topic: Data Grid desaligns presentation of MySQL records
Replies: 13
Views: 7421

Re: Data Grid desaligns presentation of MySQL records

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...
by jlspereira
Wed Mar 19, 2014 8:39 pm
Forum: Talking LiveCode
Topic: Data Grid desaligns presentation of MySQL records
Replies: 13
Views: 7421

Data Grid desaligns presentation of MySQL records

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:...
by jlspereira
Wed Mar 19, 2014 10:18 am
Forum: Data Grid Helper
Topic: Data Grid sort with accented characters
Replies: 4
Views: 9216

Re: Data Grid sort with accented characters

One additional but probably important thing:

you may notice that in all screenshots a sort of a border (rectangle) shows inside the grid. I don't know how it appeared there and what to do to suppress it!
by jlspereira
Wed Mar 19, 2014 10:16 am
Forum: Data Grid Helper
Topic: Data Grid sort with accented characters
Replies: 4
Views: 9216

Re: Data Grid sort with accented characters

Thanks a lot for the help. But behaviour was kept. I.e., the problem remains and it is not a sort problem. There must be something really wrong with my grid. I reckon that I must go to another forum. Can you please point me to the correct forum? As it can be seen in the below screenshots, when the d...
by jlspereira
Tue Mar 18, 2014 7:48 pm
Forum: Data Grid Helper
Topic: Data Grid sort with accented characters
Replies: 4
Views: 9216

Data Grid sort with accented characters

I am a newbie using the Data Grid object to show records in a MySQL database. The Data Grid is showing: a) sort order of a name field is not consistent in some cases. E.g. a "Sábado" comes after "Suleiman" and it should be the opposite. b) at a certain point the row data starts to be unaligned. By g...
by jlspereira
Tue Mar 18, 2014 3:04 pm
Forum: Databases
Topic: Charset problem on grid after successful SQL SELECT
Replies: 5
Views: 4633

Re: Charset problem on grid after successful SQL SELECT

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 ...

Go to advanced search