Hi all !
Thanks a lot. It's working now with your help!
Search found 18 matches
- Sat Jan 30, 2016 5:59 pm
- Forum: Getting Started with LiveCode - Complete Beginners
- Topic: navigate between forms/stacks
- Replies: 4
- Views: 3429
- 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...
- 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...
- 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...
- 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...
- 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...
- 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...
- 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
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
- 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...
- 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...
- 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:...
- 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!
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!
- 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...
- 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...
- 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 ...