Ummm, be careful in giving away too much with hidden fields. It's generally bad form to expose sql anywhere on the client side. Too many folks, like me, who 'view source' to see what I can see. Without the proper precautions, I could submit a form with an entirely different where clause that...
TextPad for windows
nedit for *nix
Both have syntax highlighting (with the appropriate syntax files). No running or debugging, however. Light, fast, just was a text editor should be/do.
Thanks for all the great tips - including other threads. You all are a helpful bunch.
So, I need a reality check. After playing with GP and swimming in the data, I've narrowed my targets to the following listed below.
We've decided to show account history (recent invoices and payments) in...
You'll want to think about recursion - a function that can call itself.
Your regular expression is doing its job in finding exactly what you are looking for, but as you noticed, it works in a linear fashion, not in an embedded fashion.
You might want to think about finding the first if, and...
Okay, got my dev install and am now poking around the Report Writer and the Table resource definitions.
There seems to be a general naming convention to the tables - other than SOP, RM, etc. Can someone point me to a FAQ explaining the table names (the numbering)?
I'll be searching for posted...
In our case, we won't be producing the invoices and statements using Crystal Reports. We want to query the data and cache it in separate database - the one supporting our customer portal - and control presentation via our front end (java web app).
I get my dev install of GP today. Can't wait...
Thanks for the pointers so far.
The Report Writer is high on my list to go investigate - waiting for my dev install so I don't bug our finance folks too much. Will the Report Writer show me the actual table names? Or will it show me a logical name for the tables that I will need to translate...
Some more info..
.. we will be using a consultant to set up a development install of our GP application. However, she is more of a configurator and not an integrator, which means she isn't really familiar with the schema.
I do have access to the schema and have begun to recon the data. Google...
Greetings.
I've been asked to spend some time with our poor, neglected finance department. They've been using GP for a while, but nothing more than the standard product. (GP 7.2 on SQL Server. Soon to be 7.5, or 8.0 if they feel comfortable with the changes.)
We're interested in selecting...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.