Who's Online Now
0 registered members (), 3 guests, and 11 spiders.
Key: Admin, Global Mod, Mod
Newest Members
rdeshab, samba, kkshahbaaz, dpf6jbez9, hcmconfig
1293 Registered Users
Recent Posts
Retrieving Balances using SQL
by CT. 04/12/19 11:01 AM
IR35 Legislation
by CT. 04/12/19 11:00 AM
Help > Diagnostics > Examine
by CT. 26/11/19 12:25 PM
Top Posters(30 Days)
delboy 7
CT 6
SBi 1
Popular Topics(Views)
488,453 PAYE RTI
58,999 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,113
CT Offline
CT  Offline

****

Joined: Mar 2005
Posts: 2,113
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,113
CT Offline
CT  Offline

****

Joined: Mar 2005
Posts: 2,113
[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,113
CT Offline
CT  Offline

****

Joined: Mar 2005
Posts: 2,113
[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,306
delboy Offline
The Grand Daddy
delboy  Offline
The Grand Daddy
*****

Joined: Mar 2005
Posts: 1,306
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,113
CT Offline
CT  Offline

****

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


CT

Moderated by  Administrator, CT 

Forum Statistics
Forums60
Topics2,226
Posts12,024
Members1,294
Most Online195
Nov 16th, 2019
Today's Birthdays
No Birthdays
Recent vacancies
Top Posters(All Time)
CT 2,113
delboy 1,306
bcooper 1,291
paulgos 439
SBi 427
pat 254
Gus 252
vkumar 223
December
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.655s Queries: 15 (0.008s) Memory: 2.8078 MB (Peak: 3.0031 MB) Zlib disabled. Server Time: 2019-12-12 23:50:50 UTC