Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Format Select SQL statements
Message
From
12/06/2013 11:54:22
Joel Leach
Memorial Business Systems, Inc.
Tennessee, United States
 
 
To
All
General information
Forum:
Visual FoxPro
Category:
Coding, syntax & commands
Title:
Format Select SQL statements
Environment versions
Visual FoxPro:
VFP 9 SP2
OS:
Windows 7
Network:
Windows 2008 Server
Database:
Visual FoxPro
Application:
Desktop
Miscellaneous
Thread ID:
01576132
Message ID:
01576132
Views:
70
I'm using a modified version of GenDBC to create a textual representation of DBCs for source control diffs. For views, GenDBC puts the entire SQL statement on one line, making diffs less useful. I want to split it on to multiple lines so it is easier to see where changes were made. I wrote some simple code to do this, but it is not great. I know about BeautifyX, but it is a little heavy for my needs. I'd rather have someting I can put right in GenDBC.prg or one external prg. What about right-click View SQL when modifying a view. Is the code that formats the SQL something we have access to?
Joel Leach
Microsoft Certified Professional
Blog: http://www.joelleach.net
Next
Reply
Map
View

Click here to load this message in the networking platform