Large sql string error in view builder

This public forum is for user-to-user discussions of PHPMaker. Note that this is not support forum.
Post Reply
vuongduongquoc
User
Posts: 133

Large sql string error in view builder

Post by vuongduongquoc »

I have a view with more than 40 columns. So the query string is very long, about 7000 characters. So the view builder cannot display it when i want to alter the view. I use note plus++ to view the project file (pmp) but in this file the query string was cut to 3972 characters. Please help how can i fix this error?
Thanks


mobhar
User
Posts: 11660

Post by mobhar »

Did you use Custom View? If so, try Database View instead of Custom View.


arbei
User
Posts: 9286

Post by arbei »

You should break your SQL into multiple lines.


vuongduongquoc
User
Posts: 133

Post by vuongduongquoc »

I use both Database view and Custom Views and the query is breaked into many lines also. But when i alter the query, it is query fomat is broken. It's changed to only 1 line query and the query string in project file (Pmp) is shorten and loss the end part. But the view is still working. Mabe it's re-load from database.


Post Reply