On my mobile app in new user registration, I have an XBasic callback that inserts a row into MSSQL when a new user registers. Every now and then when a new user registers, a blank row is inserted then a real row is insert. By a blank row, I mean, it inserts a row without the username(email address). On the registration panel card in the username textbox, I have validation to make sure that the username is a email address. Any ideas why it inserts a row without the username(blank row) sometimes? Should I move from an XBasic callback to a stored procedure for user registration in inserting data into MSSQL?
-
-
Re: User Registration With XBasic Callback Inserts Blank Row Every Now And Then
Alpha version / build?
In your XBasic callback, end the function before the SQL Insert takes place and instead send back a message that you're coming from the callback.
Now fire up your app, run your process, shut down the app, open it again, run the process, put the app into background etc, etc. In other words, test it thoroughly to see where that XBasic function is running.
In your XBasic function... are you not testing for a valid username value? If not, you should be... since it's critical to any application. Your function shouldn't perform an insert complete without it, and your table shouldn't create a new record without it. Those are 2 items within your control which should be in place.
Find out if the XBasic callback is happening by itself. I currently have an app in 5221 where the onDialogInitialize is being run twice upon startup. It can't be... but it is. Also, some control "click" events are being run twice. It's Alpha just being a bit of a mess, and I cannot see why any of it is happening... so I've had to code around it.
Another catch is to make your table username not null. If an insert is attempted without a username it'll fail and you can send back a message. -
Re: User Registration With XBasic Callback Inserts Blank Row Every Now And Then
It is version 12.4.4.5 Build 4491. With what you said about making username not null. The username in the table is already set to not null, so not sure how that insert is succeeding anyway?Comment
-
Re: User Registration With XBasic Callback Inserts Blank Row Every Now And Then
Is the username of the record null or an empty string?Comment
-
Re: User Registration With XBasic Callback Inserts Blank Row Every Now And Then
When I query the table I just see a blank field but it would have to be an empty string to get inserted, correct?Comment
-
Re: User Registration With XBasic Callback Inserts Blank Row Every Now And Then
With the sql tools I use, when I open the table... (Null) shows up for a null value and nothing shows for an empty string.
I would think username would have to be an empty string to get inserted.Comment
-
Re: User Registration With XBasic Callback Inserts Blank Row Every Now And Then
Do you think doing a XBasic callback that would pass the username to a stored procedure would work better, or try to check in the xbasic function I have now to see if username is an empty string?Comment
-
Re: User Registration With XBasic Callback Inserts Blank Row Every Now And Then
Post up the Xbasic Code and let us have a look.Alex Collier
"The spread of computers and the Internet will put jobs in two categories. People who tell computers what to do, and people who are told by computers what to do"
AA Builds from 5221_5152 to Pre-releases >> Deploying to IIS in AWSComment
-
Re: User Registration With XBasic Callback Inserts Blank Row Every Now And Then
Just check your username. However, the ajax callback shouldn't even be happening if you have an empty username. Client-side validation is only good if you're in the field and get out... then it fires. If you never enter the control, it never fires... which means you always need to run the client-side validation in code before executing the callback.
If you allow your callback to run without first checking your username value, then that's the issue. You should still check in in the XBasic function... but... you should never allow leave the client with an empty username. Why bother going all the way to the server... with an empty username... just to check the username... and return have done nothing. Waste of a trip.Comment
-
Re: User Registration With XBasic Callback Inserts Blank Row Every Now And Then
I changed some sequence of the code and that could be the issue. I am checking to see if a username exists first before run other code to create a new user. I had some code that ran to insert username even if the username doesnt exist by assigning a variable to equal an empty string if the username doesnt exist. I guess it was running sometimes to insert that empty string. I will see if it cures the problem. One other issue. After the new user registers it leaves the username in that panel card, how do I clear that information out? I tried using {dialog.object}.resetForm('false'); in the client side event but that doesnt seem to clear it.Comment
Comment