TheMexican

Member

Last active 5 years ago

  1. 5 years ago
    Wed Jul 11 03:35:25 2018
    TheMexican started the conversation MySQL Text Field as Null.

    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.

  2. Sat Jul 7 23:48:16 2018
    TheMexican posted in Alert() not showing.

    Lol, thanks, I somehow missed that!

  3. Sat Jul 7 18:21:37 2018
    TheMexican started the conversation Alert() not showing.

    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?

  4. Sat Jul 7 01:37:32 2018
    TheMexican started the conversation Application crashes with key Combination.

    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.

  5. Sat Jul 7 01:25:31 2018
    TheMexican posted in TableView Refresh.

    Thank you, I am learning more and more :)

  6. Mon Jul 2 16:32:24 2018

    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.

  7. Sun Jul 1 22:25:48 2018
    TheMexican started the conversation Bar Chart Column Names.

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

  8. Sun Jul 1 17:45:28 2018
    TheMexican posted in TableView Refresh.

    @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?

  9. Sun Jun 24 18:18:45 2018
    TheMexican started the conversation Recordset Autocomplete.

    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.

  10. Sun Jun 24 17:54:50 2018
    TheMexican posted in TableView Refresh.

    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.

View more