Re: trouble with standalone valentina
Robert, Valentina is not my main expertise but Ruslan is very friendly and always help! :-) He probably can help you! Cheers andre On 8/29/07, Robert Mann [EMAIL PROTECTED] wrote: The _customKeyVSCR is working properly this is later used to check paypal payment which is working, The problem is getting the information into the valentina database in development mode it goes in but when I build a standalone it does not? -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Andre Garzia Sent: Wednesday, August 29, 2007 12:19 PM To: How to use Revolution Subject: Re: trouble with standalone valentina Hello Robert, this may sound naive. But instead of using this stack try to use the real name of the stack. The stack you think is the default might not be the default one so you may been accessing the property of some other stack which is empty. try using something like: if the _customKeyVSCR of this stack is empty then answer current stack is the short name of this stack end if if it is the correct stack, then check is the custompropertyset is the right one. You may be accessing the right stack all along but trying with a wrong property set being the current one. If the problem still persists, run your routine that saves the VSCR key and then open the *troublesome* stack in the IDE and check if the value is being saved. Chances are if you're acessing it right but there's no value that the save routine is wrong. HTH andre On 8/29/07, Eric Chatonet [EMAIL PROTECTED] wrote: Hi Rob, Le 29 août 07 à 01:03, Robert Mann a écrit : My application works fine in development mode but when I build the standalone and test that database does not seem to get updated? Databases are not my field but reading your script I saw: set the _customKeyVSCR of this stack to _key Could it be simply related to the fact that a standalone can't be saved? Then the _customKeyVSCR is always empty when relaunching. Hope this helps. Not sure ;-) Best regards from Paris, Eric Chatonet. Plugins and tutorials for Revolution: http://www.sosmartsoftware.com/ Email: [EMAIL PROTECTED]/ ___ use-revolution mailing list use-revolution@lists.runrev.com Please visit this url to subscribe, unsubscribe and manage your subscription preferences: http://lists.runrev.com/mailman/listinfo/use-revolution ___ use-revolution mailing list use-revolution@lists.runrev.com Please visit this url to subscribe, unsubscribe and manage your subscription preferences: http://lists.runrev.com/mailman/listinfo/use-revolution ___ use-revolution mailing list use-revolution@lists.runrev.com Please visit this url to subscribe, unsubscribe and manage your subscription preferences: http://lists.runrev.com/mailman/listinfo/use-revolution ___ use-revolution mailing list use-revolution@lists.runrev.com Please visit this url to subscribe, unsubscribe and manage your subscription preferences: http://lists.runrev.com/mailman/listinfo/use-revolution
trouble with standalone valentina
My application works fine in development mode but when I build the
standalone and test that database does not seem to get updated?
When the user opens the app it checks to see that they have registered if
they have it opens if not they have to click a register button, when they do
it sends then to a online rev app to complete the registration after they
complete it will log the new registration number in the online database
(mysql) and there local database (valentina), this work fine in development
mode but not the standalone. With the standalone it completes the
registration and as lone as you do not close the app it continues to see tha
t it is registered but as soon as you close and reopen then app it ask the
user to register again, so not sure what is going on, check the local
database and it is empty but the online has the registration number in it,
Below is the script that I am using not sure how to test this it works every
time in development mode just not as a standalone?
Thanks
rob
global dbID2, guserIDnum, gbase, dbID, gusername, gpassword, greg
ON mouseUp
put into fld _status
IF the optionkey is down THEN
edit the script of me
exit mouseup
END IF
put fld username into gusername_#
put fld password into tpassword
put md5digest(tpassword) into tMD5
get binarydecode (H*,tMD5,tlogin_passwd)
put Select uid from wt_users Where wt_users.name='gusername' AND
wt_users.password='tlogin_passwd' AND wt_users.active='Y' AND
wt_users.banned='N'; into theSQL
put revqueryDatabase (dbID2, theSQL) into curID2
IF curID2 is not a number THEN
answer Please enter the correct login information
break
ELSE
put revDatabaseColumnNamed(curID2,uid) into guserIDnum
-- put guserIDnum into fld userID
END IF
revCloseCursor curID2
MAKE REGISTRATION KEY _#
put urlencode(makekey()) into _key
set the _customKeyVSCR of this stack to _key
put Select * from registration Where
registration.userId=guserIDnum; into theSQL
put revqueryDatabase (dbID2, theSQL) into curID2
put revqueryDatabase (dbID, theSQL) into curID
IF curID2 is a number AND curID is a number THEN
put revDatabaseColumnNamed (curID2, greg) into gbase2
put revDatabaseColumnNamed (curID, greg) into gbase
IF gbase is empty THEN
put UPDATE registration set greg='_key' where
userid='guserIdnum' into theSQL
revExecuteSQL dbID, theSQL
put it into terror
ELSE IF gbase is N THEN
put UPDATE registration set greg='_key' where
userid='guserIdnum' into theSQL
revExecuteSQL dbID, theSQL
put it into terror
END IF
IF gbase2 is empty THEN
put UPDATE registration set greg='_key' where
userid='guserIdnum' into theSQL
revExecuteSQL dbID2, theSQL
put it into terror2
ELSE IF gbase2 is N THEN
put UPDATE registration set greg='_key' where
userid='guserIdnum' into theSQL
revExecuteSQL dbID2, theSQL
put it into terror2
END IF
put SELECT greg from registration where
registration.userID='guseridnum' into theSQL
put revquerydatabase (dbID2, theSQL) into curID2
put revQueryDatabase (dbID, theSQL) into curID
put revdatabaseColumnNamed (curId2, greg) into treg
put revDatabaseColumnNamed (curID, greg) into treg2
--check to make sure that reg number is in both database
IF matchtext (treg,_key) AND matchtext(treg2,_key) THEN
put Registration Complete into fld _status
put into fld username
put into fld password
put into treg
put into treg2
put into greg
open card springcalc of stack springcalc
show stack springcalc
close stack Registration
revclosecursor curID
revclosecursor curID2
revclosedatabase dbID2
close stack reg_stack
ELSE
put error during registration into fld _status
END IF
END IF
END mouseUp
___
use-revolution mailing list
use-revolution@lists.runrev.com
Please visit this url to subscribe, unsubscribe and manage your subscription
preferences:
http://lists.runrev.com/mailman/listinfo/use-revolution
Re: trouble with standalone valentina
Hi Rob, Le 29 août 07 à 01:03, Robert Mann a écrit : My application works fine in development mode but when I build the standalone and test that database does not seem to get updated? Databases are not my field but reading your script I saw: set the _customKeyVSCR of this stack to _key Could it be simply related to the fact that a standalone can't be saved? Then the _customKeyVSCR is always empty when relaunching. Hope this helps. Not sure ;-) Best regards from Paris, Eric Chatonet. Plugins and tutorials for Revolution: http://www.sosmartsoftware.com/ Email: [EMAIL PROTECTED]/ ___ use-revolution mailing list use-revolution@lists.runrev.com Please visit this url to subscribe, unsubscribe and manage your subscription preferences: http://lists.runrev.com/mailman/listinfo/use-revolution
RE: trouble with standalone valentina
Thanks eric, but the script that does the update of both databases is on the web so it is not compiled into a application -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Eric Chatonet Sent: Wednesday, August 29, 2007 11:26 AM To: How to use Revolution Subject: Re: trouble with standalone valentina Hi Rob, Le 29 août 07 à 01:03, Robert Mann a écrit : My application works fine in development mode but when I build the standalone and test that database does not seem to get updated? Databases are not my field but reading your script I saw: set the _customKeyVSCR of this stack to _key Could it be simply related to the fact that a standalone can't be saved? Then the _customKeyVSCR is always empty when relaunching. Hope this helps. Not sure ;-) Best regards from Paris, Eric Chatonet. Plugins and tutorials for Revolution: http://www.sosmartsoftware.com/ Email: [EMAIL PROTECTED]/ ___ use-revolution mailing list use-revolution@lists.runrev.com Please visit this url to subscribe, unsubscribe and manage your subscription preferences: http://lists.runrev.com/mailman/listinfo/use-revolution ___ use-revolution mailing list use-revolution@lists.runrev.com Please visit this url to subscribe, unsubscribe and manage your subscription preferences: http://lists.runrev.com/mailman/listinfo/use-revolution
Re: trouble with standalone valentina
Hello Robert, this may sound naive. But instead of using this stack try to use the real name of the stack. The stack you think is the default might not be the default one so you may been accessing the property of some other stack which is empty. try using something like: if the _customKeyVSCR of this stack is empty then answer current stack is the short name of this stack end if if it is the correct stack, then check is the custompropertyset is the right one. You may be accessing the right stack all along but trying with a wrong property set being the current one. If the problem still persists, run your routine that saves the VSCR key and then open the *troublesome* stack in the IDE and check if the value is being saved. Chances are if you're acessing it right but there's no value that the save routine is wrong. HTH andre On 8/29/07, Eric Chatonet [EMAIL PROTECTED] wrote: Hi Rob, Le 29 août 07 à 01:03, Robert Mann a écrit : My application works fine in development mode but when I build the standalone and test that database does not seem to get updated? Databases are not my field but reading your script I saw: set the _customKeyVSCR of this stack to _key Could it be simply related to the fact that a standalone can't be saved? Then the _customKeyVSCR is always empty when relaunching. Hope this helps. Not sure ;-) Best regards from Paris, Eric Chatonet. Plugins and tutorials for Revolution: http://www.sosmartsoftware.com/ Email: [EMAIL PROTECTED]/ ___ use-revolution mailing list use-revolution@lists.runrev.com Please visit this url to subscribe, unsubscribe and manage your subscription preferences: http://lists.runrev.com/mailman/listinfo/use-revolution ___ use-revolution mailing list use-revolution@lists.runrev.com Please visit this url to subscribe, unsubscribe and manage your subscription preferences: http://lists.runrev.com/mailman/listinfo/use-revolution
RE: trouble with standalone valentina
The _customKeyVSCR is working properly this is later used to check paypal payment which is working, The problem is getting the information into the valentina database in development mode it goes in but when I build a standalone it does not? -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Andre Garzia Sent: Wednesday, August 29, 2007 12:19 PM To: How to use Revolution Subject: Re: trouble with standalone valentina Hello Robert, this may sound naive. But instead of using this stack try to use the real name of the stack. The stack you think is the default might not be the default one so you may been accessing the property of some other stack which is empty. try using something like: if the _customKeyVSCR of this stack is empty then answer current stack is the short name of this stack end if if it is the correct stack, then check is the custompropertyset is the right one. You may be accessing the right stack all along but trying with a wrong property set being the current one. If the problem still persists, run your routine that saves the VSCR key and then open the *troublesome* stack in the IDE and check if the value is being saved. Chances are if you're acessing it right but there's no value that the save routine is wrong. HTH andre On 8/29/07, Eric Chatonet [EMAIL PROTECTED] wrote: Hi Rob, Le 29 août 07 à 01:03, Robert Mann a écrit : My application works fine in development mode but when I build the standalone and test that database does not seem to get updated? Databases are not my field but reading your script I saw: set the _customKeyVSCR of this stack to _key Could it be simply related to the fact that a standalone can't be saved? Then the _customKeyVSCR is always empty when relaunching. Hope this helps. Not sure ;-) Best regards from Paris, Eric Chatonet. Plugins and tutorials for Revolution: http://www.sosmartsoftware.com/ Email: [EMAIL PROTECTED]/ ___ use-revolution mailing list use-revolution@lists.runrev.com Please visit this url to subscribe, unsubscribe and manage your subscription preferences: http://lists.runrev.com/mailman/listinfo/use-revolution ___ use-revolution mailing list use-revolution@lists.runrev.com Please visit this url to subscribe, unsubscribe and manage your subscription preferences: http://lists.runrev.com/mailman/listinfo/use-revolution ___ use-revolution mailing list use-revolution@lists.runrev.com Please visit this url to subscribe, unsubscribe and manage your subscription preferences: http://lists.runrev.com/mailman/listinfo/use-revolution
