MB Yes I always have PK.
This lot was from a Revenue & Customs PDF. It consisted of test data for next years Tax & National Insurance. My job was to feed the data through my system & check I got the same figure. Thus the object of the exercise was to have duplicated tables, without PKs I copied the data from the PDF & pasted it into Calc. Open Office Calc allowed me to parse it in using the '£' as my separator. I then saved it as a DBF & used it in VFP. Some of the figures were negative and unfortunately HMRC put the minus sign in front of the £. This resulted in the previous column being negative. It was rather like saying the answer to the previous question in a quiz. Andrew Stirling 01250 874580 http://www.calcpay.co.uk HMRC Accredited UK payroll program MB Software Solutions General Account wrote: > Andrew Stirling wrote: Thanks Mike No PK so did SCAN then selectOther > then COMPOBJ then a skip It was so fast I changed some records to ensure > it was doing its job properly. > > > > YIKES! You're having to rely on physical location in the table then? > > In your future, ALWAYS make sure there's a PK!!! > > > > [excessive quoting removed by server] _______________________________________________ Post Messages to: [email protected] Subscription Maintenance: http://leafe.com/mailman/listinfo/profox OT-free version of this list: http://leafe.com/mailman/listinfo/profoxtech Searchable Archive: http://leafe.com/archives/search/profox This message: http://leafe.com/archives/byMID/profox/[EMAIL PROTECTED] ** All postings, unless explicitly stated otherwise, are the opinions of the author, and do not constitute legal or medical advice. This statement is added to the messages for those lawyers who are too stupid to see the obvious.
