Search found 15 matches

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

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: 26646

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 ...
by mcbroh
Tue Aug 04, 2015 7:42 am
Forum: Databases
Topic: DataBase Cursor
Replies: 25
Views: 26646

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: 26646

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 ...
by mcbroh
Mon Jan 19, 2015 8:14 pm
Forum: Databases
Topic: set caseSensitive to true
Replies: 6
Views: 6535

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: 6535

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: 6535

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: 6535

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 ...
by mcbroh
Thu Jan 15, 2015 5:52 am
Forum: Databases
Topic: Webservice.
Replies: 10
Views: 16499

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: 10088

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: 16499

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

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: 7408

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: 7408

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

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