Search found 18 matches

by Nibor
Fri Jan 11, 2013 8:35 am
Forum: Getting Started with LiveCode - Complete Beginners
Topic: Some kind of start menu
Replies: 4
Views: 3258

Re: Some kind of start menu

Hi,
well.. I'm not that experienced with LC
it's a part of my education and I should take a look into it.
Yeah it should be a standalone at the end.


regards

Nibor
by Nibor
Thu Jan 10, 2013 3:33 pm
Forum: Getting Started with LiveCode - Complete Beginners
Topic: Some kind of start menu
Replies: 4
Views: 3258

Re: Some kind of start menu

Hi, I guess it will be a pretty simple menu with maybe a few textfields and buttons. I should be a kind of login window for a database. At the moment it's hardcoded and only I can connect to my own database, but I want to change it so that when you start this tool for the very first time it will ask...
by Nibor
Thu Jan 10, 2013 9:00 am
Forum: Getting Started with LiveCode - Complete Beginners
Topic: Some kind of start menu
Replies: 4
Views: 3258

Some kind of start menu

Hi there,
I would like to create some kind of start menu for my tool.
The menu should popup just once after the very first start. In this menu
I want to give the user some design specific options.

Can someone please explaine me how to create such a menu ?


regards

Nibor
by Nibor
Fri Dec 14, 2012 9:19 am
Forum: Getting Started with LiveCode - Complete Beginners
Topic: Progressbar
Replies: 1
Views: 2299

Progressbar

Hey guys, I would like to combine my progressbar or just the standard progressbar with my button that searches for any sql servers connected with my pc. Because this action will take about 30sec I want to show the user a progressbar. Can anyone help me with the code and how to connect it ? regards N...
by Nibor
Tue Dec 11, 2012 3:13 pm
Forum: Getting Started with LiveCode - Complete Beginners
Topic: Update Data in a Database
Replies: 10
Views: 5947

Re: Update Data in a Database

Hey Klaus,
yeah hashBytes is a sql command to encode your stuff and SHA1 is a way you want to encode it with.
SHA stands for secure hash algorithm.
It's quite similar to MD5


regards

Nibor
by Nibor
Tue Dec 11, 2012 2:49 pm
Forum: Getting Started with LiveCode - Complete Beginners
Topic: Update Data in a Database
Replies: 10
Views: 5947

Re: Update Data in a Database

Hey,
a colleague just found the problem.

put "UPDATE [Tablename] SET Passwort=hashBytes('SHA1'," & "'" & vPW & "')" && "Where UserID=" & "'" & vID & "'" into vSQL

it was just the missing decode part I mentioned before :wink:
hashBytes('SHA1',....)



regards

Nibor
by Nibor
Tue Dec 11, 2012 2:16 pm
Forum: Getting Started with LiveCode - Complete Beginners
Topic: Update Data in a Database
Replies: 10
Views: 5947

Re: Update Data in a Database

Hey,
well thats a translation mistake I made sorry.
In my original script its german.
by Nibor
Tue Dec 11, 2012 1:44 pm
Forum: Getting Started with LiveCode - Complete Beginners
Topic: Update Data in a Database
Replies: 10
Views: 5947

Re: Update Data in a Database

Hey,
yeah of course "Tablename" is just a placeholder :)
thats the code at the moment still not updating :(

put "UPDATE [Tablename]] SET Password=" & "'" & vPW & "'" && "Where UserID=" & "'" & vID & "'" into vSQL

regards
Nibor
by Nibor
Tue Dec 11, 2012 12:18 pm
Forum: Getting Started with LiveCode - Complete Beginners
Topic: Update Data in a Database
Replies: 10
Views: 5947

Re: Update Data in a Database

Hey thanks for the quick answer. I changed my code like you said it. The problem is still there, in my database is still the old password. The code looks like this global gDB on mouseUp if field "fipw" = empty then focus field "fipw" answer "You have to put a password first to continue." exit to top...
by Nibor
Tue Dec 11, 2012 11:31 am
Forum: Getting Started with LiveCode - Complete Beginners
Topic: Update Data in a Database
Replies: 10
Views: 5947

Update Data in a Database

Hey guys, I would like to create a button which can update the data in a mssql database. Let's say I have a column in my database called "Password" and person x lost his password and I want to reset it with this button. I have a field in my programm called "fipw" in this field the person can write h...
by Nibor
Fri Dec 07, 2012 1:55 pm
Forum: Getting Started with LiveCode - Complete Beginners
Topic: Delete in mssql via Datagrid
Replies: 3
Views: 2548

Re: Delete in mssql via Datagrid

Hey,
about the "doesn't work" sorry. I was talkin 'bout that it doesn't delete the entry
in my database or the datagrid.

Thank you very much =)
now everything is fine with the delete button.
by Nibor
Fri Dec 07, 2012 12:36 pm
Forum: Getting Started with LiveCode - Complete Beginners
Topic: Delete in mssql via Datagrid
Replies: 3
Views: 2548

Delete in mssql via Datagrid

Hey guys, I've a problem with deleting data from my mssql database viá a datagrid. I want to delete the hilitedline of my datagrid and refresh the view. So that I can see the updated version of it. This is my code but it doesn't work maybe someone can help me finding the mistake I made. ____________...
by Nibor
Fri Nov 30, 2012 4:45 pm
Forum: Getting Started with LiveCode - Complete Beginners
Topic: Another if question
Replies: 1
Views: 2036

Another if question

Hey guys, I've a quick question about the "if" again.. this is my code if vRS is empty or begins with "revdber" then answer "please check your username and password." && vRS exit to top else answer "connected." end if livecode says Script compile error: Error description: Expression: double binary o...
by Nibor
Fri Nov 30, 2012 11:24 am
Forum: Getting Started with LiveCode - Complete Beginners
Topic: Question about " if "
Replies: 4
Views: 3345

Re: Question about " if "

Thanks to both of you =)
by Nibor
Fri Nov 30, 2012 9:41 am
Forum: Getting Started with LiveCode - Complete Beginners
Topic: Question about " if "
Replies: 4
Views: 3345

Question about " if "

Hi guys, can somebody please give me a hint what could be wrong in this short code ? if the field "username" is item 3 of group "dguser" in stack "usergroup" then if the field "password" is item 3 of group "dguser" in stack "usergroup" then close this stack go to stack "entry" end if end if LiveCode...