En cours

Convert Delphi code to a SQL function

This job is to create a SQL function that could be used with Advantage database server

Such as

Update MyTable Set UpcCode=SCAN_RESOLVE(UpcCode);


Select ScanResolve(UpcCode) UpcCode, Descritpion, … From MyTable;


A lot of times we need to compare in SQL statements 2 fields both are UPC code however one would be lets say 2+code the other one would be code+9 and it should be considered a match (21234567890=12345678909)

As of now we accomplish this with Delphi code and would like to transfer this to a SQL function

All the Rules are data driven from a table and should remain like this, we constantly add rules to the list

I would give you a link to an excel file of all the rules and the Delphi code we currently use

All info in Excel file resides in a table named BcHandle and SQL function should refer to that as well so that future additions will work in Delphi and SQL simultaneously

Inquire for the link

Include the term Blue Magic in your post

Compétences : Delphi, SQL

Concernant le client :
( 81 commentaires ) Brooklyn, United States

Nº du projet : #14707891