Unable to save member

[yepadoos]

I am unable to save a member in Vscode. I am getting the following error and messages in the Code for Ibmi console.

[worksofliam]

@yepadoos Is this every member or a specific one? More detail please.

• How many lines of code?
• OS version?
• SQL enabled/disabled?
• Source dates on/off?

[yepadoos]

Not every member just this specific one. Enable SQL not checked, Enable Source Dates is checked.

[yepadoos]

Lines of code 3027, OS V7R3M0

[worksofliam]

1.7.8 is out which will solve this problem!

[worksofliam]

@chrjorgensen I wonder if the addition of the code that does the hex conversion has had an impact on large sources because it has made our SQL longer.

[chrjorgensen]

@worksofliam You're error seems to come from the readonly function implemented in PR #1075?
Or is it just the error message, that includes the readonly reference?

[worksofliam]

It's coming from the just below the line of code I linked to. I am debugging and it seems the insert query is too large for insert into ..., which is what the sliceUp fixed previously, but didn't account for those extra translate characters!

edit: pr incoming

[chrjorgensen]

I get this error when I try to open a member without any rows:

[worksofliam]

@chrjorgensen I also fixed that bug in my PR.

[chrjorgensen]

Yeah, saw that - after my error report... 😆