LiveCode Forums.

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

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

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

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

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

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

Hey,
well thats a translation mistake I made sorry.
In my original script its german.

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

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

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

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.

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

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

Thanks to both of you =)

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