>- see footer for list info -< Dear All, I am working with a program called InPS Vision (a medical system which uses FoxPro DBF files at the back end).
Have hit a problem in that the client wants automated export of information which in itself is not a problem and I have received help from this group in deciding the best way to do it. However, in some tables the patient is referenced with a PAT_ID (in this case equal to 9925), where as in other tables they are referenced using the MASTER_ID of 02P5. I have been trying to find (in amongst the hundred odd tables) a table which links 9925 to 02P5, then some bright spark highlighted the following: "02P5 is 9925 and both are numbers! 02P5 uses 'base64' arithmetic and is case sensitive thus 02p5 = 11589 the sequence is 0-9 ? @ A-Z a-z for the numbers 0-63" The problem is, I need to be able to run dynamic queries against the DB and don’t see a way to get to 9925 from 02P5 or vice versa, I have played with ToBase64 but to no avail. Any Ideas????? Lee Fortnam _______________________________________________ For details on ALL mailing lists and for joining or leaving lists, go to http://list.cfdeveloper.co.uk/mailman/listinfo -- CFDeveloper Sponsors:- >- Hosting provided by www.cfmxhosting.co.uk -< >- Forum provided by www.fusetalk.com -< >- DHTML Menus provided by www.APYCOM.com -< >- Lists hosted by www.Gradwell.com -< >- CFdeveloper is run by Russ Michaels, feel free to volunteer your help -<
