Member
Last active 5 years ago
I believe there is a bug when reading a text field in a Mysql or MariaDB database field.
To recreate the bug do the following:
Create a Mysql table with a text type field
Create a new Database in Creo with a new query and try to read the field, it comes as null
Let me know if you need more details.
Maybe it has to do with the Encoding used in the MySQL table.
Lol, thanks, I somehow missed that!
I have the following code in the DidFinish() event of a query:
var msgLogin Alert("Access Denied", "Invalid Username or Password"); if (qryLogin.rowCount > 0) { App.LoggedUser = Login.txtUsername.text; Main.open(); Login.close(); } else { Console.write("Invalid User"); msgLogin.show(); //This is not showing }
the msgLogin.show(); doesn't show but the Console.write() is working so I know the else statement is being reached.
Any ideas?
This combination of characters crashes the Creo app: "\\
Here are the steps to reproduce it:
Create a window
on the WillShow event of the window change the title to something else so lets write the following code:
Self.title = "\\
When you type the following character combination on any event "\\ the app crashes. If you open the App again after the crash, if you navigate to the same event, the Creo App will continue to crash and won't be able to fix the event code.
Thank you, I am learning more and more :)
I don't think that is possible. The only way I know is to double click on the Chart and use the Excel-like grid.
I have a chart that is getting its data from the Built-In Datagrid. The data shows fine except the column names will not.
How can I show the column Names?
On the Inspector under "Labels Column" I have "A", but it still shows 1,2,3,4 on the Chart.
Please Advise.
Thanks!!
@andrea , I did as indicated and I am having the same issues as before, now the execute statement won't add the new Patient and the table will not refresh.
I am attaching my project so you can take a look.
This is a temporary MariaDB database with a temporary password with fake data, so I don't mind anybody seeing it.
Please advise as to what I am doing wrong?
Looking at your lets Cook Nav, there is some code Window2.WillShow event
var sql = "SELECT * FROM Recipe WHERE rowid=\(self.identifier)"; var rs = Recipes.select(sql); self.NavigationItem1.title = rs.name; TextView1.text = rs.instructions; ImageView1.image = rs.image; View1.preparation = rs.preparation_time; View1.cooking = rs.cooking_time; View1.difficulty = rs.difficulty;
Are there any plans on making autocomplete on Instantiated Objects via code?
It would be nice if when we type rs. Creo will identified rs as a Recordset and then let you autocomplete.
I tried the Tableview reload method and it still doesn't show the new entry.
I have query (Recordset) that performs the Insert into the Mysql.
On the DidFinish event of the recordset I put the following:
wndPatients.tblPatients.reload(true); //This is the main Window that shows all of the patients
When I go back to the Patients table, the new entry doesn't show. But it is in the database.
If you want I can send project since it has no real data.