Who's Online Now
0 registered members (), 7 guests, and 1 spider.
Key: Admin, Global Mod, Mod
Newest Members
hcmconfig, Christine, BBH, vjnanda, NickyB
1289 Registered Users
Recent Posts
Top Posters(30 Days)
Popular Topics(Views)
483,551 PAYE RTI
58,000 HR_PF.K RUP4
Previous Thread
Next Thread
Print Thread
Rate This Thread
#299 - 25/05/05 05:08 PM Janet and John Debug Formula compilation errors  
Joined: Mar 2005
Posts: 2,103
CT Offline
CT  Offline

****

Joined: Mar 2005
Posts: 2,103
Had this come up today and it reminded me of a J&J that was floating about some years ago but was then lost in the mists of time... . .Trying to compile a large-ish formula you then get the infamous 'some screwup at line <X> column <Y>' message but how to easily find the actual line that the line no relates to? . .Well copy the text of the formula to an Excel spreadsheet and hey-ho the line-numbers are there for you! . .Hey hey it's J&J...


CT
#300 - 26/05/05 03:40 PM Re: Janet and John Debug Formula compilation errors  
Joined: Mar 2005
Posts: 21
lfarrar Offline
regular
lfarrar  Offline
regular

Joined: Mar 2005
Posts: 21
Mr T . .Another less exciting option is to shove a wierdo character (picture of Baz perhaps <grin>) in the text and iterate it around until you can work out the problem. . .In an additional granny-sucks-eggs style comment don't be tempted to correct it in your favourite MS product as when you copy it back in you may well find that your lovingly crafted single quotes morph into slightly different single quotes that cause compliation errors. . .Leon

#301 - 26/05/05 07:27 PM Re: Janet and John Debug Formula compilation errors  
Joined: Mar 2005
Posts: 2,103
CT Offline
CT  Offline

****

Joined: Mar 2005
Posts: 2,103
[quote:de4bd040ac]don't be tempted to correct it in your favourite MS product as when you copy it back in you may well find that your lovingly crafted single quotes morph into slightly different single quotes that cause compliation errors[/quote:de4bd040ac] .Indeed young man which is the very thing that caused the problem in the first place... our friends here in Worthy Down are wont to hold formula text files as Word docs - which aside from its party trick with single quotes also enjoys messing about with hyphens (that's minus signs to you)


CT
#302 - 01/06/05 03:04 PM Re: Janet and John Debug Formula compilation errors  
Joined: Mar 2005
Posts: 223
vkumar Offline
claiming squatters rights
vkumar  Offline
claiming squatters rights
*****

Joined: Mar 2005
Posts: 223
Fullers Brewery West London
Clive . .You might want to have a look at this link that I stumbled upon recently . .http://www.opayra.be/products.htm . .2 supposedly bleeding edge products . .PAYROLL PUSHER & FAST FORMULA FACTORY . Is this guy serious?

#303 - 01/06/05 07:50 PM Re: Janet and John Debug Formula compilation errors  
Joined: Mar 2005
Posts: 2,103
CT Offline
CT  Offline

****

Joined: Mar 2005
Posts: 2,103
[quote:57b3fd5eef]PAYROLL PUSHER & FAST FORMULA FACTORY . Is this guy serious?[/quote:57b3fd5eef] . Bless :roll:


CT
#304 - 02/06/05 06:20 AM Re: Janet and John Debug Formula compilation errors  
Joined: Mar 2005
Posts: 1,291
bcooper Offline
bcooper  Offline

*****

Joined: Mar 2005
Posts: 1,291
Earth, Europe, England, here
The Payroll Pusher sounds like a cut-down version of the toolkit that has been developed here at ***. .I say cut down because here we can migrate the entire configuration between environments almost seamlessly. . .As you say CT 'bless' <img src="/ubbthreads/images/graemlins/smile.gif" alt="" />

#305 - 02/06/05 06:42 AM Re: Janet and John Debug Formula compilation errors  
Joined: Mar 2005
Posts: 56
andy.fisher Offline
andy.fisher  Offline


Joined: Mar 2005
Posts: 56
Winchester
There is also another product called AID from Blue Dun. They also claim that a funcky could do data migrations with this as well.

#306 - 02/06/05 08:21 AM Re: Janet and John Debug Formula compilation errors  
Joined: Mar 2005
Posts: 1,291
bcooper Offline
bcooper  Offline

*****

Joined: Mar 2005
Posts: 1,291
Earth, Europe, England, here
I know we are steering off-thread with this... .This product was assessed here at *** and was deemed not suitable and not used. .I believe Blue Dun is the company run/owned/managed by a chap called Mike Proctor (in case any of you have come across it or him). .I can't go into any more detail about this without treading into dangerous territory but am happy to discuss via PM/email if anyone wants to.

#307 - 03/06/05 06:51 PM Re: Janet and John Debug Formula compilation errors  
Joined: Mar 2005
Posts: 1,297
delboy Offline
The Grand Daddy
delboy  Offline
The Grand Daddy
*****

Joined: Mar 2005
Posts: 1,297
Somewhere in South of England
Are you sure you don't mean Blue Nun (hic!)

#308 - 03/06/05 08:14 PM Re: Janet and John Debug Formula compilation errors  
Joined: Mar 2005
Posts: 2,103
CT Offline
CT  Offline

****

Joined: Mar 2005
Posts: 2,103
You really are in Buffalo Joe's! Do the lawnmower.... 8)


CT

Moderated by  Administrator, CT 

Forum Statistics
Forums60
Topics2,221
Posts11,997
Members1,289
Most Online90
Mar 5th, 2017
Today's Birthdays
truddock (51)
Recent vacancies
Top Posters(All Time)
CT 2,103
delboy 1,297
bcooper 1,291
paulgos 436
SBi 426
pat 254
Gus 252
vkumar 223
August
S M T W T F S
1 2 3
4 5 6 7 8 9 10
11 12 13 14 15 16 17
18 19 20 21 22 23 24
25 26 27 28 29 30 31
Powered by UBB.threads™ PHP Forum Software 7.6.0
Page Time: 0.021s Queries: 15 (0.005s) Memory: 2.8060 MB (Peak: 3.0001 MB) Zlib disabled. Server Time: 2019-08-20 22:24:05 UTC