LiveCode Forums

Hi Bernd, here's my stack i used xamp (mysql) as my database zigzag (database) please download xampp and import this file thanks https://www.apachefriends.org/download.html I have not the slightest idea how to test this. I installed XAMPP downloaded stack and database. Trying to open the stack it a...

Klaus wrote: ↑

Thu Jun 13, 2024 9:51 am

Looks like this is an EMPTY database!?

Hi Klaus,

I tried to make a sqlite database but original i used xampp mysql as my database i already posted the file need to install xampp and import the file.

Hi Bernd,

here's my stack

i used xamp (mysql) as my database

zigzag (database) please download xampp and import this file thanks
https://www.apachefriends.org/download.html

Hi lemodizon, based from your example your sql-qry has comma but mine has no comma i guess thats why it doesn't display properly I looked at your sql-query and see the the column delimiter is set to tab and the line delimiter is set to return. You should be able to use the code I provided without "...

Hi stam,

Thanks for the explanation I will try it thanks again i appreciate your help guys.

I would argue that instead of using this method, use a database cursor and add the columns to the keys of an array. I do this regularly - due to a month of near-daily on-calls, there is not chance for me to get any coding done, but can post an example of what I do at some point when I have time (pr...

Hi lemodizon, based from your example your sql-qry has comma but mine has no comma i guess thats why it doesn't display properly I looked at your sql-query and see the the column delimiter is set to tab and the line delimiter is set to return. You should be able to use the code I provided without "...

Hi Bernd, this is the sql-qry output from my data sql-qry.png I will revise my code hope i can get it right. thanks based from your example your sql-qry has comma but mine has no comma i guess thats why it doesn't display properly sql.png here is the format from the db that should display to the pol...

Hi Bernd, This is my revised code based from the suggested code you've given to me. #################################################################### function SQLStatement global gConnectionID,gPrjID local tSQLStatement, tlist , set the itemDelimiter to tab put "SELECT cpsn, vps FROM tblartistpro...

hi Bernd,

thanks for the explanation.

hello everyone, I was able to get the records from the database using xamp mysql and display it to the polygrid. unfortunately the records displayed scattered in my polygrid. please help me how to arrange here's my code function SQLStatement global gConnectionID,gPrjID local tSQLStatement, tlist put...

Hi lemodizon, There is tsvData for the polygrid, you can set and get tsvData of a polygrid. The first line is the column headers. That is one way to get at your data, here it seems to be the easiest way. on mouseUp put the tsvData of widget "pgDetails" into tData set the itemDelimiter to tab repeat...

Hi everyone, I want to get the datas from my polygrid the item 1 and item 2 and save it to my database. [img polyfrid_repeat.png ][/img] I tried to run my code but it only get the data the one is highlited from my polygrid put the hilitedline of widget "pgDetails" of stack "ArtistOutputSheet" into t...

Hi Lemondizon, I changed the script to make it a bit clearer and it calculates the days to the next 10th and 25th of month from today. I assume you want both results. It should be easier now to adapt the script if needed. on mouseUp put the short date into tConvertDate put tConvertDate into fld "Cu...

Hi Bernd, Thanks for helping me out. This is my first time to use the date and time in livecode kinda little bit confuse in converting. I tried your code it works. but when i tried to put the cut-off days i noticed if i adjusted the date manually for example if the current date is 6/9/24 it will pro...