If this is your first visit, be sure to
check out the FAQ by clicking the
link above. You may have to register
before you can post: click the register link above to proceed. To start viewing messages,
select the forum that you want to visit from the selection below.

Another Showstopper Bug: Field Names Truncated by Code Generator

09-06-2014, 05:25 PM

Further to highlighting an old bug that has not been fixed, http://www.scriptcase.net/forum/show...ug-still-there , I see that the bug has now gotten worse! WHereas previously (in SC7) I was able to alias the field name to get out of trouble, this seems no longer possible.

This is the key part of the SQL, known to be working in MySQL Workbench and PHPmyadmin, in the grid:

Code:

SELECT
Allocations.ID AS AllocID,
AllocSectionIndex.ID AS SectionID,
AllocAreas.name AS AreaName,
AllocPortions.name AS PortionName,
AllocRows.Name AS RowName,

Comment

Hi,
I've tried all that and more. It's just annoying that under SC7 I can alias the field name and the code generates without errors.

I have established it only does this in grids, not forms. Also VIEWS can overcome the problem, including in SC8. However, I need this application to work with MS_ACCESS. My understanding is that MS_ACCESS views (QUERIES) are either not supported or don't work.