I'm having an issue that is 100% consistent for me but Selwyn has been unable to reproduce. In either of the most recent stable Builds - 8356 and 8368, a subset of the column names in a table are being converted to lower case when I create a list from a MariaDB database, both with and without using the list genie. Along with this quirk, then writing to these controls using the {dialog.object}.setValue command will not consistently flag the row as dirty, hence it won't save data being written to those controls.
I'm running on Windows 10, Home Edition on a somewhat older laptop, but this issue is brand new. I update Windows every day and the laptop has passed all Lenovo diagnostics without any hardware issues being flagged. All drivers are up to date as well.
If I could impose, can anyone try this on their machine and let me know if this is just my issue or if it's more pervasive?
Here's the CREATE TABLE line for the SQL table:
CREATE TABLE test_data(Object_Rec_Num bigint UNSIGNED AUTO_INCREMENT PRIMARY KEY, Affiliate_ID nvarchar(200), Acct_ID nvarchar(55), Job_ID nvarchar(200), Record_ID nvarchar(45),
Object_ID nvarchar(45), Image_ID nvarchar(45), Object_Date datetime, Object_User nvarchar(85), Object_Type nvarchar(50), Object_Title nvarchar(200), Object_Description nvarchar(2000),
Object_Status nvarchar(200), Object_Data_0 nvarchar(200), Object_Data_1 nvarchar(200), Object_Data_2 nvarchar(200));
Within Alpha, the test project is a mobile app with a panel navigator, one panel and I then create the list within the panel. From the Genie, I identify the connection string, select "fields from table", pick the test_data table as the target, use select all fields, have a Detail View and Disconnected Operation checked.
On my platform, Object_Data_0, Object_Data_1 and Object_Data_2 are all converted to lower case: object_data_0 etc. Within the list control genie, the SQL statements to create the list all reflect the correct case, but then these 3 controls are converted in the list creation and then the {dialog.object}.setValue gets flaky. Note that directly typing into these controls sets the row dirty, it's just the setValue command that doesn't do so.
If you do try this, please let me know your OS environment and if you experience the same issue.
Thanks much!
Joe
I'm running on Windows 10, Home Edition on a somewhat older laptop, but this issue is brand new. I update Windows every day and the laptop has passed all Lenovo diagnostics without any hardware issues being flagged. All drivers are up to date as well.
If I could impose, can anyone try this on their machine and let me know if this is just my issue or if it's more pervasive?
Here's the CREATE TABLE line for the SQL table:
CREATE TABLE test_data(Object_Rec_Num bigint UNSIGNED AUTO_INCREMENT PRIMARY KEY, Affiliate_ID nvarchar(200), Acct_ID nvarchar(55), Job_ID nvarchar(200), Record_ID nvarchar(45),
Object_ID nvarchar(45), Image_ID nvarchar(45), Object_Date datetime, Object_User nvarchar(85), Object_Type nvarchar(50), Object_Title nvarchar(200), Object_Description nvarchar(2000),
Object_Status nvarchar(200), Object_Data_0 nvarchar(200), Object_Data_1 nvarchar(200), Object_Data_2 nvarchar(200));
Within Alpha, the test project is a mobile app with a panel navigator, one panel and I then create the list within the panel. From the Genie, I identify the connection string, select "fields from table", pick the test_data table as the target, use select all fields, have a Detail View and Disconnected Operation checked.
On my platform, Object_Data_0, Object_Data_1 and Object_Data_2 are all converted to lower case: object_data_0 etc. Within the list control genie, the SQL statements to create the list all reflect the correct case, but then these 3 controls are converted in the list creation and then the {dialog.object}.setValue gets flaky. Note that directly typing into these controls sets the row dirty, it's just the setValue command that doesn't do so.
If you do try this, please let me know your OS environment and if you experience the same issue.
Thanks much!
Joe
Comment