Search Results

Hi all, I'd like to receive help on how to properly combine record locking and insert in... add a new record in table2 but at the same time prevent concurrent inserts by users because table2...
link: displayed/inserted but I designed (in my mind) the DB as a central repository for a few apps...
link: Should I concern about two different apps that makes use of the same DB? Only if you want to use the...
link: I think that your code is correct. Assuming that it is only your program that modifies the databas...

Perfect, thanks Erel. Am now able to save records in my MySQL table with no errors. Incase someone is also wondering about ExecuteBatch if when inserting several records and their is an error, all records will fail, it will return tru only if all items within an array have been inserted, very...
link: ("Mno_Number")) and in my jRDC I have sql.insert_reading=INSERT INTO ewa.reading (Conn_No...
link: As DBCommand = CreateCommand("insert_meter_readings", Name) ...

Have you tried? dtaCellular.Text Hi I went o all the fields and they worked correctly except the ...
link: Pls, could you edit the subject thread adding ?...
link: months ago. I have a registration page with textfields which i want to insert into my remote Mysql...
link: My usual practice is to include the column names inside the query like: INSERT INTO User_Table...

the column thre even though I'm not going to pass any value? I mean like this sql.insert_record=INSERT...It is not really related to RDC. You can add NULL to the SQL command. But at that point is not...
link: insert a new record to the table using RDC. So in my config.properties I have the following sql...
link: It is not really related to RDC. You can add NULL to the SQL command....
link: at the Table "CountRecordsCustomers " and it has two columns "SalonId" and...

.b4x.com/android/forum/threads/b4j-mysql-api-server-key-token-and-b4x-user-login-apps.126081/ 94106... simple PHP with mysql_query function. I have later updated the 2nd sample with mysqli since mysql... are welcome to extend it to become a production ready and more powerful app. For example, In my real app... out how to do it. The answer is in this forum and the Internet. In my previous code snippet, I use... model for the e-hailing app or "Student" and "Courses" models to my e-learning app. ...

I cannot insert any records in the MySQL table. Below is the simple PHP connection script and I have attached my very simple B4A project. When a button is clicked the record should be saved. I hope...
link: UPDATE statement The PHP code should support INSERT and UPDATE statements. Which error do you get...
link: hc As HttpClient Dim Q_SELECT, Q_UPDATE As Int, Q_INSERT Q_SELECT = 1 Q_UPDATE = 2 ...
link: Which error do you get?...

Seems like we need a DBM function Select SQLtype Case SQLite ' bound brackets Case MSSQL ' bound single quotes Case MySQL '...
link: Works like a charm, thanks for that. Also the Delete record had the same brackets....
link: Return "`" & f & "`" 'use for MySql End Sub Eventually...
link: Will test in the morning, thanks for that. Will check all areas and play....

Updates: Latest B4XPages user login client apps (using B4J server): https://www.b4x.com/android/forum/threads/project-template-user-login-client-b4x.161914/ 105281 Finally I would like to share my B4J API server written in B4J. Compare to my previous PHP API, this API server implements user access token to authorize user to consume the API. SQL.zip - SQL script to create necessary database and tables in MySQL server. jAPI.zip - Source code for server app (B4J). B4A.zip - Source code...

This is not really related to B4A. You should search on internet : https://stackoverflow.com/questions/3634984/insert-if-not-exists-else-update Have a look here if you don't know how to use SQL in B4X : https://www.b4x.com/android/forum/threads/sql-tutorial.6736/#content...
link: Hi, I am trying to insert list of records from MYSQL database to SQLite. I did it with this code...
link: you will need to do it in your own loop and use a select statement to see if that record/product...

Thanks warwound..that idea let me to the solution. The log showed nothing from my mobile.. The problem was, drum roll please, I had forgotten to initialize the HttpClient..usually this throws...
link: Do you have access to the webserver? Can you look through the server logs to see if your app requ...
link: Ok, I'm a :sign0104: at PHP and HTML.. I'm attempting to insert records into a mySQL table...
link: Nothing is returning which is strange. I'll take a look at HttpUtils..Just thought with just a s...