LiveCode Forums.

Hi Bangkok, I realised that I have a problem with the repeat loop. I changes the script and still encounter the same problem. I don't know where i go wrong, here's the new script: Global gConnectionID on mouseUp databaseConnect put the dgData of group "DataGrid1" into tData put the dgIndexes of grou...

Hi Bangkok, After amending to "answer error "There was a problem adding the record to the database:" & cr & tSQL I encountered this error message: There was a problem adding the record to the database: Insert into test (ln, desc) values (:1, :2) I am not sure what caused the probelm. Please help. Th...

Hi, I hope some expert could help me with the problem below. Thanks a lot if you could help. I am new to Livecode DataGrid and I am exploring how to insert data in the DataGrid to MYSQl database. I encountered the following error message: You have an error in your SQL syntax check the manual that co...

Hi Klaus & Simon,

I changed the script of the combo box using the on mouseUp function instead of on menuPick function. The data was populated into the combo box now.

Thanks all for your help.

Hi Klaus, tData is definitely not empty, otherwise I wouldn't be able to push the data into the combo box using the push button. The script I showed you earlier is the object script for the combo box button, is this the right place to put this script? I am not sure what you mean by script for the op...

Hi Klaus, As suggested, I changed the codes to put tData into button "a1ComboBox". When I clicked on the down arrow on the combo box nothing appear but when I created a Push Button and put the same script into the on mouseUp function I can pushed the data into the combo box. Strange why it doesn't w...

Hi Klaus, Here's my new script: on menuPick pItemName global gConnectionID if gConnectionID is not a number then answer error "Please connect to the database first." exit to top end if -- construct the SQL (this selects all the data from the specified table) put "a1" into tTableName -- set this to t...

Hi Bangkok & Simon,

Thanks for your reply. I have tried all the methods you've mentioned above, it still doesn't populate the data into the combo box.

Do I need to make any changes to the Object Inspector (Basic Properties)?

Is there anything wrong with my script?

Regards,
Janet Tan.

Hi, I need help with the script below. I couldn't get MySQL data into the combo box. I am not sure whether the problem lies with "put tData into button "button id 1010" I tested by creating a pushup button to populate tData into a text field, No problem I can see all the data ("put tData into text "...

Hi, I am trying to use Amazon Web Service (relational database service(RDS) : MySQL), I need help on how to connect to Amazon RDS. I have no problem connecting to my localhost using the following connection parameters: put "localhost" into tDatabaseAddress put "dbname" into tDatabaseName put "dbuser...

Thanks all for your input and suggestions. Bangkok suggestions work for me.

Thank you bangkok, you save my day. I got it right now. It is actually the ' ' that causes the problem. 2 tips : -it might be better to avoid syntax with parameters. Instead of put "UPDATE " & tTableName & " SET (" & tFields & ") = VALUES(:1,:2) WHERE " & user_id &" =" & tuser_id & " "into tSQL revE...

Hi, I struggle with the MySQL update syntax for the whole day but still couldn't find a solution. I hope some expert could help me with the UPDATE syntax. put "personal_info" into tTableName put "user_addr1", "user_addr2" into tFields put field "fld_piUserID" into tuser_id put field "fld_addr1" into...

Hi,

I need help on how to incorporate / integrate the Paypal payment button in Livecode. Paypal provide the script for the button but how can I make it work, like all other e-commerce system, when a user click on the button, it will send them to the Paypal login page.

Thanks for your help.

Thanks very much to Klaus and Dixie. The codes you provide are very useful, exactly what I am looking for.
I am new to LiveCode and have a lot to learn from you guys.