Search found 15 matches

by mcbroh
Thu Aug 06, 2015 6:41 pm
Forum: Databases
Topic: DataBase Cursor
Replies: 25
Views: 15640

Re: DataBase Cursor

Thanks... got it fixed now :)
by mcbroh
Wed Aug 05, 2015 2:12 pm
Forum: Databases
Topic: DataBase Cursor
Replies: 25
Views: 15640

Re: DataBase Cursor

Hi Klaus and Pete, The problem with the data grid form is i am trying to display 3 record(Columns) from dbCursor but then the data grid becomes blank. when i turn one of the record to a comment, the two record appear on the data grid. set the text of field "joketext" of me to pDataArray["joketext"] ...
by mcbroh
Tue Aug 04, 2015 7:42 am
Forum: Databases
Topic: DataBase Cursor
Replies: 25
Views: 15640

Re: DataBase Cursor

Hi Pete,

Thanks aload, so far so good. the records are displayed on the data grid as they should. just trying to figure out how to get them into a form now.

Regards
by mcbroh
Mon Aug 03, 2015 4:45 pm
Forum: Databases
Topic: DataBase Cursor
Replies: 25
Views: 15640

Re: DataBase Cursor

hello, i want to make a data grid form which should get get multiple datas from database and set them in a form. i tried a lesson on runrev website but keep getting a function error. I would be glad if someone could look into the script an help me out. on mouseUp ## Connect to the database put "mysq...
by mcbroh
Mon Jan 19, 2015 8:14 pm
Forum: Databases
Topic: set caseSensitive to true
Replies: 6
Views: 4515

Re: set caseSensitive to true

hello Axwald,

thanks for your input.
i figured it out now. i can not check case sensitiv directly from within the Database. i have to put the info first into a variable on app and then case sensitive can work.

Thanks
by mcbroh
Sat Jan 17, 2015 4:54 pm
Forum: Databases
Topic: set caseSensitive to true
Replies: 6
Views: 4515

Re: set caseSensitive to true

Thanks Klaus,

would keep cracking my head out :(
by mcbroh
Sat Jan 17, 2015 3:50 pm
Forum: Databases
Topic: set caseSensitive to true
Replies: 6
Views: 4515

Re: set caseSensitive to true

Hi Klause,

An example... on database (xaYj1E2)
when i type (xayj1e2) am expecting it to answer wrong code. but it just accepts it :(

Regards
mcbroh
by mcbroh
Sat Jan 17, 2015 2:51 pm
Forum: Databases
Topic: set caseSensitive to true
Replies: 6
Views: 4515

set caseSensitive to true

on getPoint global gConnectionID, gPoint, gUser set the caseSensitive to true if field id 1098 is empty then answer "Please enter code first." exit getPoint else put field id 1098 into tCodes end if put "codes" into tTableCodes put "share" into tTableName put "SELECT Points FROM "&tTableCodes&" WHER...
by mcbroh
Thu Jan 15, 2015 5:52 am
Forum: Databases
Topic: Webservice.
Replies: 10
Views: 10631

Re: Webservice.

Hi Jacque and Sefro,

Thanks you so much for the tip. Now playing around with webservices, will give it some shot and home I get a big smile afterwards :)
by mcbroh
Wed Jan 14, 2015 4:43 pm
Forum: Databases
Topic: Database for one app
Replies: 11
Views: 7018

Re: Database for one app

Hello Aebki,

I do think your database location should be online, and depending on the database interaction.

Am sure you will get more information regarding this though.

Regards
Mcbroh
by mcbroh
Wed Jan 14, 2015 8:45 am
Forum: Databases
Topic: Webservice.
Replies: 10
Views: 10631

Webservice.

Hi all, I am 90% finished with my livecode app, but i feel i need to have a web service to make the connection secure. 1. Is there anybody who is good with web service that is willing to create the script for me (with a minimal price of :) ) 2. how can i clear a local variable? i am trying to subtra...
by mcbroh
Fri Jan 09, 2015 11:52 pm
Forum: Databases
Topic: inserting, deleting and updating DB on push of one button
Replies: 6
Views: 5444

Re: inserting, deleting and updating DB on push of one butto

Thanks Pete.

Problem solved.

//mcbroh
by mcbroh
Fri Jan 09, 2015 10:06 pm
Forum: Databases
Topic: inserting, deleting and updating DB on push of one button
Replies: 6
Views: 5444

Re: inserting, deleting and updating DB on push of one butto

Hi Pete,

thanks for your advice, I have implemented the changes and it WORKS as i expected, but as a newbie, can you write me example of the BEGIN command, COMMIT and rollback ?
Hope it's not too much of a prob :)

Thanks.
Mcbroh
by mcbroh
Fri Jan 09, 2015 12:53 pm
Forum: Databases
Topic: inserting, deleting and updating DB on push of one button
Replies: 6
Views: 5444

Re: inserting, deleting and updating DB on push of one butto

Hi Klaus, i have done that before just above the script global gConnectionID, gPoints, gUsername on openStack send "openCard" to me in 110 millisecs put urlEncode("-----") into gAddress put urlEncode("-----") into gName put urlEncode("---") into gUserName put urlEncode("-----") into gPassword put re...
by mcbroh
Fri Jan 09, 2015 7:06 am
Forum: Databases
Topic: inserting, deleting and updating DB on push of one button
Replies: 6
Views: 5444

inserting, deleting and updating DB on push of one button

Skärmavbild 2015-01-09 kl. 06.59.07.png Skärmavbild 2015-01-09 kl. 06.58.08.png Hi all, I have a mobile app that is been made, but my headache has been based on the fact that i want the user to enter a code, if the code is in database, the point assigned with the code is added to users point, code ...

Go to advanced search