Recent changes to bugs

#17 Create Tables Script has invalid DDL for MySQL 5

2021-09-17T08:58:33.903000Z

A hack that may work is The Sql is stored in

Windows: C:\Program Files\RecordEdit\Generic\SQL\Create_RecordEdit.Sql
Linux: <home>/RecordEdit/Generic/SQL/Create_RecordEdit.Sql</home>

So it can be updated.

In the RecordEditor lib directory there is a bat / shell script runGenericInstall.bat/sh that will run the installer again

RecordEditor lib directory: C:\Program Files\RecordEdit\Generic\lib
or <home>/RecordEdit/Generic/lib/</home>

#17 Create Tables Script has invalid DDL for MySQL 5

2021-09-17T05:01:17.461000Z

assigned_to: Bruce Martin

#17 Create Tables Script has invalid DDL for MySQL 5

2021-09-17T04:59:22.188000Z

Will do

Create Tables Script has invalid DDL for MySQL 5

2021-09-17T02:52:40Z

CREATE TABLE TBL_RFS_FIELDSELECTION
(
RECORDID integer,
CHILD_KEY smallint,
FIELD_NO smallint,
BOOLEAN_OPERATOR smallint,
FIELD_NAME varchar,
OPERATOR char(2),
FIELD_VALUE varchar
)
;
** Error: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ' OPERATOR char(2), FIELD_VALUE varchar )' at line 1

Solution: Add field limits:
CREATE TABLE TBL_RFS_FIELDSELECTION
(
RECORDID integer,
CHILD_KEY smallint,
FIELD_NO smallint,
BOOLEAN_OPERATOR smallint,
FIELD_NAME varchar(255),
OPERATOR char(2),
FIELD_VALUE varchar(255)
);

Create Tables Script has invalid DDL for MySQL 5

2021-09-17T02:52:40Z

Ticket 17 has been modified: Create Tables Script has invalid DDL for MySQL 5
Edited By: Bruce Martin (bruce_a_martin)
Owner updated: None => 'bruce_a_martin'

#16 Trailing delimiters (";") vanishing in a record with delimited fields

2020-11-13T21:59:38.550000Z

I checked it now. With the x-basic parser it works as expected.
Thank you again.
Joerg

#16 Trailing delimiters (";") vanishing in a record with delimited fields

2020-11-12T12:54:29.936000Z

Thank you very much I will check it today.
Best regards
Joerg

#16 Trailing delimiters (";") vanishing in a record with delimited fields

2020-11-12T04:02:31.566000Z

The parser option might solve your problem. The basic parser will drop trailing field separators. Other parsers you could try are

X Basic - Delimiter for all fields - if there are 10 fields, will put in 9 field separators
X Basic - Delimiter for all fields + 1 - if there are 10 fields, will put in 10 field separators

#16 Trailing delimiters (";") vanishing in a record with delimited fields

2020-11-11T22:17:39.410000Z

Forget: I used the USB Version 0.97g and also test the newest with the same result.

Trailing delimiters (";") vanishing in a record with delimited fields

2020-11-11T22:13:23.513000Z

Have a racrord with delimited fields (no quotes) and extended basic parser is select in the record description. Some fields at the end are empty, e,g,: AA;BB;CC;;;
If I now insert one character maybe BB -> BBB save it and look in a texteditor I see: AA;BBB;CC;;
If I repeat it, the next delimiter is gone.
If I write a character in the last empy field save it, delete the character and save again, the delimiters are all back in the stored file.
This is persistent. It seems it's a problem with the buffer alocation.